APPS.INV_LABEL_PVT4 dependencies on PO_VENDOR_SITES_ALL

Line 136: -- MOAC : po_vendor_sites changed to po_vendor_sites_all

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
139: AND rti.po_header_id = pha.po_header_id(+)
140: AND rsh.shipment_header_id(+) = rti.shipment_header_id

Line 137: po_vendor_sites_all pvs, per_people_f ppf

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
139: AND rti.po_header_id = pha.po_header_id(+)
140: AND rsh.shipment_header_id(+) = rti.shipment_header_id
141: AND pol.po_line_id (+) = rti.po_line_id

Line 168: -- MOAC : po_vendor_sites changed to po_vendor_sites_all

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
171: AND rti.po_header_id = pha.po_header_id(+)
172: AND rsh.shipment_header_id(+) = rti.shipment_header_id

Line 169: po_vendor_sites_all pvs, per_people_f ppf

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
171: AND rti.po_header_id = pha.po_header_id(+)
172: AND rsh.shipment_header_id(+) = rti.shipment_header_id
173: AND pol.po_line_id (+) = rti.po_line_id

Line 366: -- MOAC : po_vendor_sites changed to po_vendor_sites_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
367: , po_vendor_sites_all pvs
368: , per_people_f ppf
369: , wms_license_plate_numbers wlpn
370: WHERE pha.po_header_id(+) = all_lpn.po_header_id

Line 367: , po_vendor_sites_all pvs

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
367: , po_vendor_sites_all pvs
368: , per_people_f ppf
369: , wms_license_plate_numbers wlpn
370: WHERE pha.po_header_id(+) = all_lpn.po_header_id
371: AND rsh.shipment_header_id(+) = all_lpn.shipment_header_id

Line 998: -- MOAC : po_vendor_sites changed to po_vendor_sites_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
999: , po_vendor_sites_all pvs
1000: , per_people_f ppf
1001: WHERE pha.po_header_id(+) = all_lpn.po_header_id
1002: AND rsh.shipment_header_id(+) = all_lpn.shipment_header_id

Line 999: , po_vendor_sites_all pvs

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
999: , po_vendor_sites_all pvs
1000: , per_people_f ppf
1001: WHERE pha.po_header_id(+) = all_lpn.po_header_id
1002: AND rsh.shipment_header_id(+) = all_lpn.shipment_header_id
1003: AND pol.po_line_id (+) = all_lpn.po_line_id