APPS.INV_LABEL_PVT4 dependencies on PO_LINE_LOCATIONS_ALL

Line 133: -- MOAC : po_line_locations changed to po_line_locations_all

129: pvs.vendor_site_code supplier_site, ppf.full_name requestor,
130: hrl1.location_code deliver_to_location,
131: hrl2.location_code location, pll.note_to_receiver note_to_receiver
132: FROM rcv_transactions_interface rti, po_headers_all pha,
133: -- MOAC : po_line_locations changed to po_line_locations_all
134: po_lines_all pol, rcv_shipment_headers rsh, po_line_locations_all pll,
135: po_vendors pov, hr_locations_all hrl1, hr_locations_all hrl2,
136: -- MOAC : po_vendor_sites changed to po_vendor_sites_all
137: po_vendor_sites_all pvs, per_people_f ppf

Line 134: po_lines_all pol, rcv_shipment_headers rsh, po_line_locations_all pll,

130: hrl1.location_code deliver_to_location,
131: hrl2.location_code location, pll.note_to_receiver note_to_receiver
132: FROM rcv_transactions_interface rti, po_headers_all pha,
133: -- MOAC : po_line_locations changed to po_line_locations_all
134: po_lines_all pol, rcv_shipment_headers rsh, po_line_locations_all pll,
135: po_vendors pov, hr_locations_all hrl1, hr_locations_all hrl2,
136: -- MOAC : po_vendor_sites changed to po_vendor_sites_all
137: po_vendor_sites_all pvs, per_people_f ppf
138: where rti.interface_transaction_id = p_transaction_id

Line 165: -- MOAC : po_line_locations changed to po_line_locations_all

161: pvs.vendor_site_code supplier_site, ppf.full_name requestor,
162: hrl1.location_code deliver_to_location,
163: hrl2.location_code location, pll.note_to_receiver note_to_receiver
164: FROM rcv_transactions_interface rti, po_headers_all pha,
165: -- MOAC : po_line_locations changed to po_line_locations_all
166: po_lines_all pol, rcv_shipment_headers rsh, po_line_locations_all pll,
167: po_vendors pov, hr_locations_all hrl1, hr_locations_all hrl2,
168: -- MOAC : po_vendor_sites changed to po_vendor_sites_all
169: po_vendor_sites_all pvs, per_people_f ppf

Line 166: po_lines_all pol, rcv_shipment_headers rsh, po_line_locations_all pll,

162: hrl1.location_code deliver_to_location,
163: hrl2.location_code location, pll.note_to_receiver note_to_receiver
164: FROM rcv_transactions_interface rti, po_headers_all pha,
165: -- MOAC : po_line_locations changed to po_line_locations_all
166: po_lines_all pol, rcv_shipment_headers rsh, po_line_locations_all pll,
167: po_vendors pov, hr_locations_all hrl1, hr_locations_all hrl2,
168: -- MOAC : po_vendor_sites changed to po_vendor_sites_all
169: po_vendor_sites_all pvs, per_people_f ppf
170: where rti.interface_transaction_id = p_transaction_id

Line 361: -- MOAC : po_line_locations changed to po_line_locations_all

357: , po_headers_all pha
358: , po_lines_all pol
359: , rcv_shipment_headers rsh
360: , rcv_shipment_lines rsl
361: -- MOAC : po_line_locations changed to po_line_locations_all
362: , po_line_locations_all pll
363: , po_vendors pov
364: -- , hr_locations_all hrl1
365: -- , hr_locations_all hrl2

Line 362: , po_line_locations_all pll

358: , po_lines_all pol
359: , rcv_shipment_headers rsh
360: , rcv_shipment_lines rsl
361: -- MOAC : po_line_locations changed to po_line_locations_all
362: , po_line_locations_all pll
363: , po_vendors pov
364: -- , hr_locations_all hrl1
365: -- , hr_locations_all hrl2
366: -- MOAC : po_vendor_sites changed to po_vendor_sites_all

Line 993: -- MOAC : po_line_locations changed to po_line_locations_all

989: ) all_lpn
990: , po_headers_all pha
991: , po_lines_all pol
992: , rcv_shipment_headers rsh
993: -- MOAC : po_line_locations changed to po_line_locations_all
994: , po_line_locations_all pll
995: , po_vendors pov
996: , hr_locations_all hrl1
997: , hr_locations_all hrl2

Line 994: , po_line_locations_all pll

990: , po_headers_all pha
991: , po_lines_all pol
992: , rcv_shipment_headers rsh
993: -- MOAC : po_line_locations changed to po_line_locations_all
994: , po_line_locations_all pll
995: , po_vendors pov
996: , hr_locations_all hrl1
997: , hr_locations_all hrl2
998: -- MOAC : po_vendor_sites changed to po_vendor_sites_all