APPS.INV_LABEL_PVT5 dependencies on PO_VENDOR_SITES_ALL

Line 208: -- MOAC : changed po_vendor_sites to po_vendor_sites_all

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

Line 209: po_vendor_sites_all pvs, per_people_f ppf

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
211: AND rti.po_header_id = pha.po_header_id(+)
212: AND rsh.shipment_header_id(+) = rti.shipment_header_id
213: AND pol.po_line_id(+) = rti.po_line_id --Added outer join, bug 4918726

Line 240: -- MOAC : changed po_vendor_sites to po_vendor_sites_all

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

Line 241: po_vendor_sites_all pvs, per_people_f ppf

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
243: AND rti.po_header_id = pha.po_header_id(+)
244: AND rsh.shipment_header_id(+) = rti.shipment_header_id
245: AND pol.po_line_id (+) = rti.po_line_id

Line 431: -- MOAC : changed po_vendor_sites to po_vendor_sites_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
432: , po_vendor_sites_all pvs
433: , per_people_f ppf
434: , wms_license_plate_numbers wlpn -- Bug 3836623
435: WHERE pha.po_header_id(+) = all_lpn.po_header_id

Line 432: , po_vendor_sites_all pvs

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
432: , po_vendor_sites_all pvs
433: , per_people_f ppf
434: , wms_license_plate_numbers wlpn -- Bug 3836623
435: WHERE pha.po_header_id(+) = all_lpn.po_header_id
436: AND rsh.shipment_header_id(+) = all_lpn.shipment_header_id

Line 682: -- MOAC : changed po_vendor_sites to po_vendor_sites_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
683: , po_vendor_sites_all pvs
684: , per_people_f ppf
685: WHERE pha.po_header_id(+) = all_lpn.po_header_id
686: AND rsh.shipment_header_id(+) = all_lpn.shipment_header_id

Line 683: , po_vendor_sites_all pvs

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
683: , po_vendor_sites_all pvs
684: , per_people_f ppf
685: WHERE pha.po_header_id(+) = all_lpn.po_header_id
686: AND rsh.shipment_header_id(+) = all_lpn.shipment_header_id
687: AND pol.po_line_id (+) = all_lpn.po_line_id