PO, CMR and XLA joins in oracle fusion

 SELECT a.po_line_id,

       a.PO_HEADER_ID,

       a.PO_NUMBER,

       a.VENDOR_ID,

       a.VENDOR_SITE_ID,

       a.PO_LINE_LOCATION_ID

  FROM cmr_purchase_order_dtls a, cmr_rcv_events b, poz_suppliers_v c

 WHERE b.cmr_po_distribution_id = a.cmr_po_distribution_id

   AND a.vendor_id = c.vendor_id

   AND a.active_flag = 'Y'

   AND b.accounting_event_id = xla_transaction_entities.source_id_int_1