1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Help!.need to find the table that holds the document number value of the invoice payment details

Discussion in 'Oracle Financials' started by Vinz Sumampong, Nov 16, 2017.

  1. Vinz Sumampong

    Vinz Sumampong Newly Initiated

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    30
    Location:
    Cebu
    Hope Anyone knows the name of the table where these Document Num column is stored?
    see pic Below the one that highlighted in blue.

    Note these Screenshot came from the Invoice Form of Oracle R12

    I've been searching these all day but to No luck. Hope Someone Could Help me.
    upload_2017-11-16_17-17-19.png
     

    Attached Files:

  2. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    739
    Likes Received:
    145
    Trophy Points:
    830
    Location:
    Russian Federation
    Vinz,
    in oracle documentation said,that we are could use the dictonary views (aka user/all/dba_*).
    For example :
    user_tables,
    user_tab_cols
    and etc...
     
  3. Vinz Sumampong

    Vinz Sumampong Newly Initiated

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    30
    Location:
    Cebu
    Hi Sergy,

    Thanks for the Help and Tip and guess I've already found it. Thanks much:).

    Have a nice day ahead
     
    Last edited: Nov 17, 2017