359: , rti.BOM_RESOURCE_ID
360: FROM rcv_transactions_interface rti
361: , wms_lpn_contents wlc
362: , po_lines_all pol
363: , po_headers_all pha
364: , rcv_shipment_headers rsh
365: , po_line_locations_all pll
366: , po_vendors pov
367: , hr_locations_all hrl1
441: , rti.BOM_RESOURCE_ID
442: FROM rcv_transactions_interface rti
443: , wms_lpn_contents wlc
444: , po_lines_all pol
445: , po_headers_all pha
446: , rcv_shipment_headers rsh
447: , po_line_locations_all pll
448: , po_vendors pov
449: , hr_locations_all hrl1
541: , rti.subinventory subinventory
542: , rti.locator_id locator_id
543: FROM rcv_transactions_interface rti
544: , po_lines_all pol
545: , po_headers_all pha
546: , rcv_shipment_headers rsh
547: , po_line_locations_all pll
548: , po_vendors pov
549: , hr_locations hrl1
696: */
697: , rcv_shipment_lines rsl
698: , po_lines_all pol
699: -- , po_distributions_all pod --Commented as part of Bug# 3586116
700: , po_headers_all pha
701: , rcv_shipment_headers rsh
702: , po_line_locations_all pll
703: , po_vendors pov
704: , hr_locations_all hrl1
882: , mtl_transaction_lot_numbers mtln
883: , rcv_shipment_lines rsl
884: , po_lines_all pol
885: -- , po_distributions_all pod --Commented as part of Bug# 3586116
886: , po_headers_all pha
887: , rcv_shipment_headers rsh
888: , po_line_locations pll
889: , po_vendors pov
890: , hr_locations_all hrl1
1053: , mtl_transaction_lot_numbers mtln
1054: , rcv_shipment_lines rsl
1055: , po_lines_all pol
1056: -- , po_distributions_all pod --Commented as part of Bug# 3586116
1057: , po_headers_all pha
1058: , rcv_shipment_headers rsh
1059: , po_line_locations pll
1060: , po_vendors pov
1061: , hr_locations_all hrl1
1964: l_get_org_id NUMBER;
1965: l_is_wms_org BOOLEAN;
1966: l_material_input inv_label.material_label_input_tbl;
1967: l_material_input_index NUMBER;
1968: l_purchase_order po_headers_all.segment1%TYPE;
1969: rti_material_lpn_rec rti_material_lpn_cur%ROWTYPE;
1970: rti_material_mtlt_rec rti_material_mtlt_cur%ROWTYPE;
1971: l_po_line_number NUMBER;
1972: l_quantity_ordered NUMBER;