Return Order (RMA) Receipt Transactions.sql

SELECT
	rah.ra_document_number rma
  , ral.ra_doo_line_number
  , ral.ra_doo_fulfillment_line_number
  , rsh.receipt_num
  , ral.receipt_advice_line_number
  , ral.ra_quantity_expected
  , ral.quantity_received
  , rt.subinventory
  , rt.transaction_type
  , ral.shipment_line_status_code
FROM
	fusion.rcv_transactions     rt
  , fusion.rcv_shipment_headers rah
  , fusion.rcv_shipment_lines   ral
  , fusion.rcv_shipment_headers rsh
  , fusion.rcv_shipment_lines   rsl
WHERE
	rt.receipt_advice_header_id       = rah.shipment_header_id
	AND rt.receipt_advice_line_id     = ral.shipment_line_id
	AND rt.shipment_header_id         = rsh.shipment_header_id
	AND rt.shipment_line_id           = rsl.shipment_line_id
	AND rt.transaction_type           = 'DELIVER'
	AND ral.shipment_line_status_code = 'FULLY RECEIVED'
	AND rah.ra_document_number        = '&SOURCE_ORDER_NUMBER'
ORDER BY
	RAH.creation_date DESC