SCM5

 SQL to show receiving transactions for the Return   Order in Oracle Cloud Fusion R13

SELECT  ra_document_code       ,

        SHIPMENT_HEADER_ID     ,

        CUSTOMER_ID            ,

        RECEIPT_ADVICE_NUMBER  ,

        RA_DOCUMENT_CODE       ,

        RA_DOCUMENT_NUMBER     ,

        RA_DOO_SOURCE_SYSTEM_ID,

        HEADER_INTERFACE_ID    ,

        RA_ORIG_SYSTEM_REF

FROM    fusion.rcv_shipment_headers

WHERE   ra_document_code        = 'RMA'

        AND ra_document_number in( '&ENTER_RETURN_ORDER')

-- SQL to show Shiping transactions for the Return Order

SELECT  SHIPMENT_LINE_ID         ,

        QUANTITY_RECEIVED        ,

        QUANTITY_DELIVERED       ,

        ITEM_ID                  ,

        SHIPMENT_LINE_STATUS_CODE,

        SOURCE_DOCUMENT_CODE     ,

        RA_DOO_HEADER_NUMBER     ,

        RA_ORIG_DOO_HEADER_NUMBER

FROM    fusion.rcv_shipment_lines

WHERE   shipment_header_id IN

        (

                SELECT  SHIPMENT_HEADER_ID

                FROM    fusion.rcv_shipment_headers

                WHERE   ra_document_code        = 'RMA'

                        AND ra_document_number IN( '&ENTER_RETURN_ORDER')

        )