APPS.INV_LABEL_PVT2 dependencies on PO_LINES_TRX_V

Line 142: po_lines_trx_v pol, -- CLM project, bug 9403291

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,
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

Line 193: po_lines_trx_v pol -- CLM project, bug 9403291

189: , rt.uom_code
190: , rt.oe_order_header_id --Bug 4582954
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

Line 245: , po_lines_trx_v pol -- CLM project, bug 9403291

241: FROM rcv_transactions rt
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

Line 304: , po_lines_trx_v pol -- CLM project, bug 9403291

300: , rti.oe_order_line_id --Bug 4582954
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