APPS.INV_LABEL_PVT2 dependencies on RCV_TRANSACTIONS

Line 141: FROM rcv_transactions_interface rti, mtl_serial_numbers msn,

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

Line 192: FROM rcv_transactions rt, rcv_serials_supply rss,

188: , rt.vendor_site_id
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

Line 241: FROM rcv_transactions rt

237: , rt.vendor_site_id
238: , rt.uom_code
239: , rt.oe_order_header_id --Bug 4582954
240: , rt.oe_order_line_id --Bug 4582954
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

Line 301: FROM rcv_transactions_interface rti

297: , rti.vendor_id
298: , rti.vendor_site_id
299: , rti.oe_order_header_id --Bug 4582954
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

Line 455: -- Repaced the query with rcv_transactions.

451:
452: -- End of Flow csr
453:
454: -- Commented as part of bug fix for Bug 3472432.
455: -- Repaced the query with rcv_transactions.
456: -- To get org type.
457: -- CURSOR rti_get_org_cur IS
458: -- SELECT to_organization_id
459: -- FROM rcv_transactions_interface rti

Line 459: -- FROM rcv_transactions_interface rti

455: -- Repaced the query with rcv_transactions.
456: -- To get org type.
457: -- CURSOR rti_get_org_cur IS
458: -- SELECT to_organization_id
459: -- FROM rcv_transactions_interface rti
460: -- WHERE rti.interface_transaction_id = p_transaction_id;
461:
462: -- To get org type.
463: CURSOR rt_get_org_cur IS

Line 465: FROM rcv_transactions rt

461:
462: -- To get org type.
463: CURSOR rt_get_org_cur IS
464: SELECT organization_id
465: FROM rcv_transactions rt
466: WHERE rt.GROUP_ID = p_transaction_id;
467:
468: -- Fix For Bug: 4907062
469: -- a) Included Project Number in the cursor