APPS.INV_LABEL_PVT1 dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 688: -- , rcv_lot_transactions rls -- Replaced rcv_lot_transactions by mtl_transaction_lot_numbers to fetch the LOT details as part of Bug# 4186856

684: , wlpn.lpn_id
685: , rt.routing_header_id routing_header_id --bug 4916450
686: FROM rcv_transactions rt
687: , rcv_lots_supply rls -- Reverted to original code as part of Bug#4516067
688: -- , rcv_lot_transactions rls -- Replaced rcv_lot_transactions by mtl_transaction_lot_numbers to fetch the LOT details as part of Bug# 4186856
689: -- Added rt2 as part of Bug# 4186856
690: -- rt2, mtln commented for Bug#4516067 to revert the changes done for Bug#4186856
691: /* , (select transaction_id
692: * from rcv_transactions rt_deliver

Line 695: * , mtl_transaction_lot_numbers mtln -- Added as part of Bug# 4186856

691: /* , (select transaction_id
692: * from rcv_transactions rt_deliver
693: * where rt_deliver.group_id = p_transaction_id
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

Line 882: , mtl_transaction_lot_numbers mtln

878: , wlpn.lpn_context
879: , wlpn.lpn_id
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

Line 1053: , mtl_transaction_lot_numbers mtln

1049: , wlpn.lpn_context
1050: , wlpn.lpn_id
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