Thursday, October 17, 2013

Purchase Release Concurrent Query

Purchase release concurrent program will transfer the details from OM to PO requisitions interface. The following query will verify the same:
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);

No comments:

Post a Comment