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!

Need Refrence columns Details of Table GL_JE_LINES

Discussion in 'Oracle Apps Technical' started by RIAZ, Jan 14, 2010.

  1. RIAZ

    RIAZ Forum Advisor

    Messages:
    54
    Likes Received:
    0
    Trophy Points:
    130
    hi,
    I want to now what is posted in Reference columns (what is posted in these columns) in GL_JE_LINES.

    I am getting different values in these reference columns but don't know what they are and how to join them with other tables.

    Any body can help ??
     
  2. mkandula

    mkandula Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    To my knowledge the reference column holds the references to how journal was created. I might be wrong in this prospect but this is what i understood once i read some document. There is another table by name gl_import_references which holds je_header_id,je_batch_id and je_line_id and then the reference column values for this combination of batch,header and line_id.
     
  3. RIAZ

    RIAZ Forum Advisor

    Messages:
    54
    Likes Received:
    0
    Trophy Points:
    130
    Thanks, I got the link from GL to AR_CASH_RECEIPTS_ALL (using sub ledger value in GL) anf furhter AR_RECEIVABLE_APPLICATIONS_ALL is the table that give me all details.