DBA Data[Home] [Help]

APPS.INV_LABEL_PVT4 dependencies on RCV_SHIPMENT_LINES

Line 360: , rcv_shipment_lines rsl

356: ) all_lpn
357: , po_headers_all pha
358: , po_lines_all pol
359: , rcv_shipment_headers rsh
360: , rcv_shipment_lines rsl
361: -- MOAC : po_line_locations changed to po_line_locations_all
362: , po_line_locations_all pll
363: , po_vendors pov
364: -- , hr_locations_all hrl1

Line 938: rcv_shipment_lines rsl

934: , rsl.comments
935: , rsl.vendor_item_num
936: from wms_license_plate_numbers lpn,
937: rcv_shipment_headers rsh,
938: rcv_shipment_lines rsl
939: where lpn.source_name = rsh.shipment_num
940: AND lpn.lpn_context = 7
941: AND rsl.shipment_header_id = rsh.shipment_header_id
942: and rsh.shipment_header_id = p_transaction_id

Line 960: rcv_shipment_lines rsl

956: , rsl.comments
957: , rsl.vendor_item_num
958: from wms_license_plate_numbers lpn,
959: rcv_shipment_headers rsh,
960: rcv_shipment_lines rsl
961: where lpn.source_name = rsh.shipment_num
962: AND lpn.lpn_context = 7
963: AND rsl.shipment_header_id = rsh.shipment_header_id
964: and rsl.asn_lpn_id = lpn.lpn_id

Line 982: rcv_shipment_lines rsl

978: , rsl.comments
979: , rsl.vendor_item_num
980: from wms_license_plate_numbers lpn,
981: rcv_shipment_headers rsh,
982: rcv_shipment_lines rsl
983: where lpn.source_name = rsh.shipment_num
984: AND lpn.lpn_context = 7
985: AND rsl.shipment_header_id = rsh.shipment_header_id
986: and rsh.shipment_header_id = p_transaction_id