You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Query to get the Serial Number of Shipment number for PO in Cloud

Received Response
70
Views
1
Comments

Need to find the serial number used in shipment for purchase order when we pass shipment number.

select 

rsl.line_num,

rsh.shipment_num,

poh.segment1 as po_number,

pol.item_description,

esi.item_number,

isn.serial_number,

isn.attribute_category

from 

rcv_shipment_headers rsh,

rcv_shipment_lines rsl,

po_headers_all poh,

po_lines_all pol,

egp_system_items esi,

inv_serial_numbers isn

where 

rsh.shipment_header_id = rsl.shipment_header_id

and rsl.po_header_id = poh.po_header_id

and poh.po_header_id = pol.po_header_id 

and rsl.po_line_id = pol.po_line_id

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!