Reporting and Analytics for SCM

Get Involved. Join the Conversation.

Topic

    Nidhi Chhajed
    How to Join RA and RCV Tables to get Dropship Order details...
    Topic posted April 1, 2019 by Nidhi ChhajedBlue Ribbon: 750+ Points, tagged BI Publisher Reports 
    64 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