Get the Shipment Number based on the po header id information
PO: Get the Shipment Number based on the po header id information:-
----------------------------------------------------------------------------------
With the following query, you can find out the Shipment Number for the particular PO Order.
select distinct rsh.shipment_num from RCV_TRANSACTIONS rt,PO_LINE_LOCATIONS_ALL pll,RCV_SHIPMENT_HEADERS rsh where rt.PO_LINE_LOCATION_ID = pll.LINE_LOCATION_ID
and rt.SHIPMENT_HEADER_ID = rsh.shipment_header_id
and pll.po_header_id = 'Your PO Header ID'
You can know the po_header_id of any particular PO Order Number.
select po_header_id from po_headers_all where segment1 = 'Your PO order Number';
Source:
http://alloracletech.blogspot.com/2008/08/get-shipment-number-based-on-po-header.html