APPS.INV_LABEL_PVT2 dependencies on PO_LINES_ALL

Line 141: FROM rcv_transactions_interface rti, mtl_serial_numbers msn, po_lines_all pol, wms_lpn_contents wlc, po_headers_all pha

137: , rti.vendor_id
138: , rti.vendor_site_id
139: , rti.oe_order_header_id --Bug 4582954
140: , rti.oe_order_line_id --Bug 4582954
141: FROM rcv_transactions_interface rti, mtl_serial_numbers msn, po_lines_all pol, wms_lpn_contents wlc, po_headers_all pha
142: WHERE wlc.parent_lpn_id = rti.lpn_id
143: AND pol.po_line_id(+) = rti.po_line_id
144: AND pha.po_header_id(+) = rti.po_header_id
145: AND msn.lpn_id = rti.lpn_id

Line 189: FROM rcv_transactions rt, rcv_serials_supply rss, po_lines_all pol

185: , rt.vendor_site_id
186: , rt.uom_code
187: , rt.oe_order_header_id --Bug 4582954
188: , rt.oe_order_line_id --Bug 4582954
189: FROM rcv_transactions rt, rcv_serials_supply rss, po_lines_all pol
190: -- , po_distributions_all pod --Commented as part of Bug# 3586116
191: , po_headers_all pha, rcv_shipment_lines rsl
192: , wms_license_plate_numbers wlpn -- Bug 3836623
193: WHERE rss.transaction_id = rt.transaction_id

Line 240: , po_lines_all pol

236: FROM rcv_transactions rt
237: , mtl_transaction_lot_numbers mtln
238: , mtl_unit_transactions mut
239: -- , po_distributions_all pod --Commented as part of Bug# 3586116
240: , po_lines_all pol
241: , po_headers_all pha
242: , rcv_shipment_lines rsl
243: , wms_license_plate_numbers wlpn -- Bug 3836623
244: -- Bug 4179732, can not print serial number from putaway

Line 299: , po_lines_all pol

295: , rti.oe_order_line_id --Bug 4582954
296: FROM rcv_transactions_interface rti
297: , mtl_serial_numbers_temp msnt
298: , mtl_transaction_lots_temp mtlt
299: , po_lines_all pol
300: , po_headers_all pha
301: WHERE mtlt.transaction_temp_id(+) = rti.interface_transaction_id
302: AND msnt.transaction_temp_id = NVL(mtlt.serial_transaction_temp_id, rti.interface_transaction_id)
303: AND pol.po_line_id(+) = rti.po_line_id