APPS.INV_LABEL_PVT5 dependencies on RCV_SHIPMENT_LINES

Line 428: , rcv_shipment_lines rsl

424: ) all_lpn
425: , po_headers_trx_v pha--CLM Changes, using CLM views instead of base tables
426: , po_lines_trx_v pol
427: , rcv_shipment_headers rsh
428: , rcv_shipment_lines rsl
429: -- MOAC : changed po_line_locations to po_line_locations_all
430: , po_line_locations_trx_v pll
431: , po_vendors pov
432: -- , hr_locations_all hrl1

Line 651: rcv_shipment_lines rsl

647: , rsl.comments
648: , rsl.vendor_item_num
649: from wms_license_plate_numbers lpn,
650: rcv_shipment_headers rsh,
651: rcv_shipment_lines rsl
652: where lpn.source_name = rsh.shipment_num
653: AND lpn.lpn_context = 7
654: AND rsl.shipment_header_id = rsh.shipment_header_id
655: and rsh.shipment_header_id = p_transaction_id

Line 673: rcv_shipment_lines rsl

669: , rsl.comments
670: , rsl.vendor_item_num
671: from wms_license_plate_numbers lpn,
672: rcv_shipment_headers rsh,
673: rcv_shipment_lines rsl
674: where lpn.source_name = rsh.shipment_num
675: AND lpn.lpn_context = 7
676: AND rsl.shipment_header_id = rsh.shipment_header_id
677: and rsl.asn_lpn_id = lpn.lpn_id

Line 695: rcv_shipment_lines rsl

691: , rsl.comments
692: , rsl.vendor_item_num
693: from wms_license_plate_numbers lpn,
694: rcv_shipment_headers rsh,
695: rcv_shipment_lines rsl
696: where lpn.source_name = rsh.shipment_num
697: AND lpn.lpn_context = 7
698: AND rsl.shipment_header_id = rsh.shipment_header_id
699: and rsh.shipment_header_id = p_transaction_id

Line 1761: (select shipment_header_id from rcv_shipment_lines

1757: packaging_code, special_handling_code,
1758: receipt_num, comments
1759: FROM rcv_shipment_headers
1760: WHERE shipment_header_id IN
1761: (select shipment_header_id from rcv_shipment_lines
1762: where asn_lpn_id = p_lpn_id);
1763:
1764: -- Next retrieve details of all distinct LPNs associated with this shipment
1765: