[Home] [Help]
358: , rti.DEPARTMENT_CODE
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
440: , rti.DEPARTMENT_CODE
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
540: , rti.item_description item_description
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
694: * and rt_deliver.transaction_type = 'DELIVER') rt2
695: * , mtl_transaction_lot_numbers mtln -- Added as part of Bug# 4186856
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
880: , rt.routing_header_id routing_header_id --bug 4916450
881: FROM rcv_transactions rt
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
1051: , rt.routing_header_id --bug 4916450
1052: FROM rcv_transactions rt
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