Query to find program will transfer the details from OM to PO requisitions interface

SELECT interface_source_code,

           interface_source_line_id,

           quantity,

           destination_type_code,

           transaction_id,

           process_flag,

           request_id,

           TRUNC (creation_date)

  FROM po_requisitions_interface_all

 WHERE interface_source_code = ‘ORDER ENTRY’

   AND interface_source_line_id IN (SELECT drop_ship_source_id

                                      FROM oe_drop_ship_sources

                                     WHERE header_id = &order_hdr_id

                                       AND line_id = &order_line_id);