APPS.INV_LABEL_PVT5 dependencies on PO_LINE_LOCATIONS_ALL

Line 205: -- MOAC : changed po_line_locations to po_line_locations_all

201: pvs.vendor_site_id vendor_site_id, pvs.vendor_site_code supplier_site,
202: ppf.full_name requestor, hrl1.location_code deliver_to_location,
203: hrl2.location_code location, pll.note_to_receiver note_to_receiver
204: FROM rcv_transactions_interface rti, po_headers_all pha,
205: -- MOAC : changed po_line_locations to po_line_locations_all
206: po_lines_all pol, rcv_shipment_headers rsh, po_line_locations_all pll,
207: po_vendors pov, hr_locations_all hrl1, hr_locations_all hrl2,
208: -- MOAC : changed po_vendor_sites to po_vendor_sites_all
209: po_vendor_sites_all pvs, per_people_f ppf

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

202: ppf.full_name requestor, hrl1.location_code deliver_to_location,
203: hrl2.location_code location, pll.note_to_receiver note_to_receiver
204: FROM rcv_transactions_interface rti, po_headers_all pha,
205: -- MOAC : changed po_line_locations to po_line_locations_all
206: po_lines_all pol, rcv_shipment_headers rsh, po_line_locations_all pll,
207: po_vendors pov, hr_locations_all hrl1, hr_locations_all hrl2,
208: -- MOAC : changed po_vendor_sites to po_vendor_sites_all
209: po_vendor_sites_all pvs, per_people_f ppf
210: where rti.interface_transaction_id = p_transaction_id

Line 237: -- MOAC : changed po_line_locations to po_line_locations_all

233: pvs.vendor_site_code supplier_site, ppf.full_name requestor,
234: hrl1.location_code deliver_to_location, hrl2.location_code location,
235: pll.note_to_receiver note_to_receiver
236: FROM rcv_transactions_interface rti, po_headers_all pha,
237: -- MOAC : changed po_line_locations to po_line_locations_all
238: po_lines_all pol, rcv_shipment_headers rsh, po_line_locations_all pll,
239: po_vendors pov, hr_locations_all hrl1, hr_locations_all hrl2,
240: -- MOAC : changed po_vendor_sites to po_vendor_sites_all
241: po_vendor_sites_all pvs, per_people_f ppf

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

234: hrl1.location_code deliver_to_location, hrl2.location_code location,
235: pll.note_to_receiver note_to_receiver
236: FROM rcv_transactions_interface rti, po_headers_all pha,
237: -- MOAC : changed po_line_locations to po_line_locations_all
238: po_lines_all pol, rcv_shipment_headers rsh, po_line_locations_all pll,
239: po_vendors pov, hr_locations_all hrl1, hr_locations_all hrl2,
240: -- MOAC : changed po_vendor_sites to po_vendor_sites_all
241: po_vendor_sites_all pvs, per_people_f ppf
242: where rti.interface_transaction_id = p_transaction_id

Line 426: -- MOAC : changed po_line_locations to po_line_locations_all

422: , po_headers_all pha
423: , po_lines_all pol
424: , rcv_shipment_headers rsh
425: , rcv_shipment_lines rsl
426: -- MOAC : changed po_line_locations to po_line_locations_all
427: , po_line_locations_all pll
428: , po_vendors pov
429: -- , hr_locations_all hrl1
430: -- , hr_locations_all hrl2

Line 427: , po_line_locations_all pll

423: , po_lines_all pol
424: , rcv_shipment_headers rsh
425: , rcv_shipment_lines rsl
426: -- MOAC : changed po_line_locations to po_line_locations_all
427: , po_line_locations_all pll
428: , po_vendors pov
429: -- , hr_locations_all hrl1
430: -- , hr_locations_all hrl2
431: -- MOAC : changed po_vendor_sites to po_vendor_sites_all

Line 677: -- MOAC : changed po_line_locations to po_line_locations_all

673: ) all_lpn
674: , po_headers_all pha
675: , po_lines_all pol
676: , rcv_shipment_headers rsh
677: -- MOAC : changed po_line_locations to po_line_locations_all
678: , po_line_locations_all pll
679: , po_vendors pov
680: , hr_locations_all hrl1
681: , hr_locations_all hrl2

Line 678: , po_line_locations_all pll

674: , po_headers_all pha
675: , po_lines_all pol
676: , rcv_shipment_headers rsh
677: -- MOAC : changed po_line_locations to po_line_locations_all
678: , po_line_locations_all pll
679: , po_vendors pov
680: , hr_locations_all hrl1
681: , hr_locations_all hrl2
682: -- MOAC : changed po_vendor_sites to po_vendor_sites_all