APPS.INV_LABEL_PVT3 dependencies on RCV_SHIPMENT_HEADERS

Line 401: rcv_shipment_headers rsh,

397: , lpn.subinventory_code, lpn.locator_id
398: , rsh.shipment_header_id
399: , rsl.po_line_location_id
400: from wms_license_plate_numbers lpn,
401: rcv_shipment_headers rsh,
402: rcv_shipment_lines rsl
403: where lpn.source_name = rsh.shipment_num
404: AND lpn.lpn_context = 7
405: AND rsl.shipment_header_id = rsh.shipment_header_id

Line 416: rcv_shipment_headers rsh,

412: , lpn.subinventory_code, lpn.locator_id
413: , rsh.shipment_header_id
414: , rsl.po_line_location_id
415: from wms_license_plate_numbers lpn,
416: rcv_shipment_headers rsh,
417: rcv_shipment_lines rsl
418: where lpn.source_name = rsh.shipment_num
419: AND lpn.lpn_context = 7
420: AND rsl.shipment_header_id = rsh.shipment_header_id

Line 431: rcv_shipment_headers rsh,

427: , lpn.subinventory_code, lpn.locator_id
428: , rsh.shipment_header_id
429: , rsl.po_line_location_id
430: from wms_license_plate_numbers lpn,
431: rcv_shipment_headers rsh,
432: rcv_shipment_lines rsl
433: where lpn.source_name = rsh.shipment_num
434: AND lpn.lpn_context = 7
435: AND rsl.shipment_header_id = rsh.shipment_header_id

Line 442: , rcv_shipment_headers rsh

438: AND rsh.asn_type = 'ASN'
439: ) all_lpn
440: , po_headers_all pha
441: , po_lines_all pol
442: , rcv_shipment_headers rsh
443: , po_line_locations_all pll
444: WHERE pha.po_header_id(+) = all_lpn.po_header_id
445: AND rsh.shipment_header_id(+) = all_lpn.shipment_header_id
446: AND pol.po_line_id (+) = all_lpn.po_line_id

Line 631: FROM rcv_shipment_headers

627: l_rcv_isp_header.bill_of_lading, l_rcv_isp_header.waybill_airbill_num,
628: l_rcv_isp_header.packing_slip,
629: l_rcv_isp_header.packaging_code, l_rcv_isp_header.special_handling_code,
630: l_rcv_isp_header.receipt_num, l_rcv_isp_header.comments
631: FROM rcv_shipment_headers
632: WHERE shipment_header_id = p_transaction_id;
633:
634: FOR v_asn_lpn IN c_asn_lpn LOOP
635: l_rcv_lpn_table(i).lpn_id := v_asn_lpn.lpn_id;