[Home] [Help]
140: , rti.oe_order_line_id --Bug 4582954
141: FROM rcv_transactions_interface rti, mtl_serial_numbers msn,
142: po_lines_trx_v pol, -- CLM project, bug 9403291
143: wms_lpn_contents wlc,
144: po_headers_trx_v pha -- CLM project, bug 9403291
145: WHERE wlc.parent_lpn_id = rti.lpn_id
146: AND pol.po_line_id(+) = rti.po_line_id
147: AND pha.po_header_id(+) = rti.po_header_id
148: AND msn.lpn_id = rti.lpn_id
191: , rt.oe_order_line_id --Bug 4582954
192: FROM rcv_transactions rt, rcv_serials_supply rss,
193: po_lines_trx_v pol -- CLM project, bug 9403291
194: -- , po_distributions_all pod --Commented as part of Bug# 3586116
195: , po_headers_trx_v pha, -- CLM project, bug 9403291
196: rcv_shipment_lines rsl
197: , wms_license_plate_numbers wlpn -- Bug 3836623
198: WHERE rss.transaction_id = rt.transaction_id
199: AND pol.po_line_id(+) = rt.po_line_id
242: , mtl_transaction_lot_numbers mtln
243: , mtl_unit_transactions mut
244: -- , po_distributions_all pod --Commented as part of Bug# 3586116
245: , po_lines_trx_v pol -- CLM project, bug 9403291
246: , po_headers_trx_v pha -- CLM project, bug 9403291
247: , rcv_shipment_lines rsl
248: , wms_license_plate_numbers wlpn -- Bug 3836623
249: -- Bug 4179732, can not print serial number from putaway
250: -- Changed to link to MUT through MMT
301: FROM rcv_transactions_interface rti
302: , mtl_serial_numbers_temp msnt
303: , mtl_transaction_lots_temp mtlt
304: , po_lines_trx_v pol -- CLM project, bug 9403291
305: , po_headers_trx_v pha -- CLM project, bug 9403291
306: WHERE mtlt.transaction_temp_id(+) = rti.interface_transaction_id
307: AND msnt.transaction_temp_id = NVL(mtlt.serial_transaction_temp_id, rti.interface_transaction_id)
308: AND pol.po_line_id(+) = rti.po_line_id
309: AND pha.po_header_id(+) = rti.po_header_id