Topic

    Nidhi Chhajed
    How to Join RA and RCV Tables to get Dropship Order details...
    Topic posted April 1, 2019 by Nidhi ChhajedRed Ribbon: 250+ Points, tagged BI Publisher Reports 
    57 Views, 1 Comment
    Title:
    How to Join RA and RCV Tables to get Dropship Order details in Oracle cloud R13 18b
    Content:

    Hi ,

    I am trying to create a BI report , where I want to have all receipt and AR invoice information for a DropShip Order.

    I am trying to find some link between AR invoice tables and Receipt Table.

    Can you please help me with same.

    Regards

    Nidhi...

    Comment

     

    • Yves-Chanel MACEMAGU

      Hello,

      AR table are links with SO in table : DOO_FULFILL_LINE_DETAILS, TASK_TYPE='INVOICE' and STATUS='BILLED'.
      In that table ypu will find BILLING_TRANSACTION_NUMBER , and  CUSTOMER_TRX_LINE_ID.
       

      Also , in table DOO_DOCUMENT_REFERENCES , DOC_USER_KEY is link between SO ->PO (DOC_REF_TYPE = 'DROPSHIP_PO_REFERENCE') and SO ->RCV DOC_REF_TYPE = 'DROPSHIP_REQ_REFERENCE'

      Hope it will help you or give you some ideas.

       

      Chanel