RCV ,CMR and XLA joins in oracle fusion

 SELECT RSH.COMMENTS

  FROM cmr_purchase_order_dtls cpod,

       cmr_rcv_events          cre,

       CMR_TRANSACTIONS        CT,

       RCV_TRANSACTIONS        RT,

       RCV_SHIPMENT_HEADERS    RSH,

       poz_suppliers_v         ps

 WHERE     cre.cmr_po_distribution_id = cpod.cmr_po_distribution_id

       AND cpod.vendor_id = ps.vendor_id

       AND cpod.active_flag = 'Y'

       AND CRE.TRANSACTION_ID = CT.TRANSACTION_ID

       AND CT.RCV_TRANSACTION_ID = RT.TRANSACTION_ID

       AND RT.SHIPMENT_HEADER_ID = RSH.SHIPMENT_HEADER_ID

       AND RSH.RECEIPT_NUM = CT.RECEIPT_NUMBER

       AND cre.accounting_event_id = xla_transaction_entities.source_id_int_1