APPS.INV_LABEL_PVT5 dependencies on RCV_SHIPMENT_LINES

Line 425: , rcv_shipment_lines rsl

421: ) all_lpn
422: , po_headers_all pha
423: , po_lines_all pol
424: , rcv_shipment_headers rsh
425: , rcv_shipment_lines rsl
426: -- MOAC : changed po_line_locations to po_line_locations_all
427: , po_line_locations_all pll
428: , po_vendors pov
429: -- , hr_locations_all hrl1

Line 622: rcv_shipment_lines rsl

618: , rsl.comments
619: , rsl.vendor_item_num
620: from wms_license_plate_numbers lpn,
621: rcv_shipment_headers rsh,
622: rcv_shipment_lines rsl
623: where lpn.source_name = rsh.shipment_num
624: AND lpn.lpn_context = 7
625: AND rsl.shipment_header_id = rsh.shipment_header_id
626: and rsh.shipment_header_id = p_transaction_id

Line 644: rcv_shipment_lines rsl

640: , rsl.comments
641: , rsl.vendor_item_num
642: from wms_license_plate_numbers lpn,
643: rcv_shipment_headers rsh,
644: rcv_shipment_lines rsl
645: where lpn.source_name = rsh.shipment_num
646: AND lpn.lpn_context = 7
647: AND rsl.shipment_header_id = rsh.shipment_header_id
648: and rsl.asn_lpn_id = lpn.lpn_id

Line 666: rcv_shipment_lines rsl

662: , rsl.comments
663: , rsl.vendor_item_num
664: from wms_license_plate_numbers lpn,
665: rcv_shipment_headers rsh,
666: rcv_shipment_lines rsl
667: where lpn.source_name = rsh.shipment_num
668: AND lpn.lpn_context = 7
669: AND rsl.shipment_header_id = rsh.shipment_header_id
670: and rsh.shipment_header_id = p_transaction_id

Line 1511: (select shipment_header_id from rcv_shipment_lines

1507: packaging_code, special_handling_code,
1508: receipt_num, comments
1509: FROM rcv_shipment_headers
1510: WHERE shipment_header_id IN
1511: (select shipment_header_id from rcv_shipment_lines
1512: where asn_lpn_id = p_lpn_id);
1513:
1514: -- Next retrieve details of all distinct LPNs associated with this shipment
1515: