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!

Link between AP-GL , AR-GL , CM-GL

Discussion in 'Oracle Apps Technical' started by ranade.rushi, Jan 27, 2009.

  1. ranade.rushi

    ranade.rushi Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    Pune
    Hello :welcome ,

    plz help me in finding joins(links_ between)

    AP-GL , AR-GL , CM-GL modules ..
    i am working GL module where i need this info


    Thanks in advance !!:)
     
  2. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    Hi, ranade, you have asked a very generic question. refer to this excellent document uploaded by Esha at oracle apps tables thread.
     
  3. ranjithkeral

    ranjithkeral Active Member

    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    80
    Location:
    Gurgaon
    hi ranade....

    I am giving u some Links which may help u to make Link from other tables to GL

    • When Source is Payable then reference_5 of GL_JE_LINES table is the invoice Number and reference_2 is the invoice_id and Ref3 is the check_id.
    • When Source is Purchasing then ref5 of GL_JE_LINES table represent the transaction_id of rcv_transaction
    • When Source is Inventory then check the transaction type.
    • If transaction type is Average cost update then the transaction_id of the mtl_material_transaction_id represents the transaction_id of rcv_transaction_id in rcv_transaction table.
    • If transaction_type is PO Receipt then RCV_TRANSACTION_ID in mtl_material_transaction_id reprensent the transaction_id of rcv_transaction_id in rcv_transaction table.
     
  4. apps_expert

    apps_expert Forum Expert

    Messages:
    325
    Likes Received:
    28
    Trophy Points:
    330
    Location:
    Chennai, India
    Ver good info, Thanks ranjith.
     
  5. ranjithkeral

    ranjithkeral Active Member

    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    80
    Location:
    Gurgaon
    Thanks ...


    Regards
    Ranjith.k
     
  6. VENKATESAN

    VENKATESAN Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    HI
    Any body know link between ipayment and Ar during Authorization process

    while i am place the order in OM and iStore at that time Refinfo value was optain in iby_tangible table but i am place the order in AR means Refinfo value as null so what is the reference between Ar and iPayment during authorization process replay soon.

    Thanks
    venkatesan