APPS.INV_LABEL_PVT5 dependencies on PO_VENDOR_SITES_ALL

Line 211: -- MOAC : changed po_vendor_sites to po_vendor_sites_all

207: FROM rcv_transactions_interface rti, po_headers_trx_v pha,--CLM Changes,using CLM views instead of base tables
208: -- MOAC : changed po_line_locations to po_line_locations_all
209: po_lines_trx_v pol, rcv_shipment_headers rsh, po_line_locations_trx_v pll,
210: po_vendors pov, hr_locations_all hrl1, hr_locations_all hrl2,
211: -- MOAC : changed po_vendor_sites to po_vendor_sites_all
212: po_vendor_sites_all pvs, per_people_f ppf
213: where rti.interface_transaction_id = p_transaction_id
214: AND rti.po_header_id = pha.po_header_id(+)
215: AND rsh.shipment_header_id(+) = rti.shipment_header_id

Line 212: po_vendor_sites_all pvs, per_people_f ppf

208: -- MOAC : changed po_line_locations to po_line_locations_all
209: po_lines_trx_v pol, rcv_shipment_headers rsh, po_line_locations_trx_v pll,
210: po_vendors pov, hr_locations_all hrl1, hr_locations_all hrl2,
211: -- MOAC : changed po_vendor_sites to po_vendor_sites_all
212: po_vendor_sites_all pvs, per_people_f ppf
213: where rti.interface_transaction_id = p_transaction_id
214: AND rti.po_header_id = pha.po_header_id(+)
215: AND rsh.shipment_header_id(+) = rti.shipment_header_id
216: AND pol.po_line_id(+) = rti.po_line_id --Added outer join, bug 4918726

Line 243: -- MOAC : changed po_vendor_sites to po_vendor_sites_all

239: FROM rcv_transactions_interface rti, po_headers_trx_v pha,--CLM Changes,using CLM views instead of base tables
240: -- MOAC : changed po_line_locations to po_line_locations_all
241: po_lines_trx_v pol, rcv_shipment_headers rsh, po_line_locations_trx_v pll,
242: po_vendors pov, hr_locations_all hrl1, hr_locations_all hrl2,
243: -- MOAC : changed po_vendor_sites to po_vendor_sites_all
244: po_vendor_sites_all pvs, per_people_f ppf
245: where rti.interface_transaction_id = p_transaction_id
246: AND rti.po_header_id = pha.po_header_id(+)
247: AND rsh.shipment_header_id(+) = rti.shipment_header_id

Line 244: po_vendor_sites_all pvs, per_people_f ppf

240: -- MOAC : changed po_line_locations to po_line_locations_all
241: po_lines_trx_v pol, rcv_shipment_headers rsh, po_line_locations_trx_v pll,
242: po_vendors pov, hr_locations_all hrl1, hr_locations_all hrl2,
243: -- MOAC : changed po_vendor_sites to po_vendor_sites_all
244: po_vendor_sites_all pvs, per_people_f ppf
245: where rti.interface_transaction_id = p_transaction_id
246: AND rti.po_header_id = pha.po_header_id(+)
247: AND rsh.shipment_header_id(+) = rti.shipment_header_id
248: AND pol.po_line_id (+) = rti.po_line_id

Line 434: -- MOAC : changed po_vendor_sites to po_vendor_sites_all

430: , po_line_locations_trx_v pll
431: , po_vendors pov
432: -- , hr_locations_all hrl1
433: -- , hr_locations_all hrl2
434: -- MOAC : changed po_vendor_sites to po_vendor_sites_all
435: , po_vendor_sites_all pvs
436: , per_people_f ppf
437: , wms_license_plate_numbers wlpn -- Bug 3836623
438: WHERE pha.po_header_id(+) = all_lpn.po_header_id

Line 435: , po_vendor_sites_all pvs

431: , po_vendors pov
432: -- , hr_locations_all hrl1
433: -- , hr_locations_all hrl2
434: -- MOAC : changed po_vendor_sites to po_vendor_sites_all
435: , po_vendor_sites_all pvs
436: , per_people_f ppf
437: , wms_license_plate_numbers wlpn -- Bug 3836623
438: WHERE pha.po_header_id(+) = all_lpn.po_header_id
439: AND rsh.shipment_header_id(+) = all_lpn.shipment_header_id

Line 711: -- MOAC : changed po_vendor_sites to po_vendor_sites_all

707: , po_line_locations_trx_v pll
708: , po_vendors pov
709: , hr_locations_all hrl1
710: , hr_locations_all hrl2
711: -- MOAC : changed po_vendor_sites to po_vendor_sites_all
712: , po_vendor_sites_all pvs
713: , per_people_f ppf
714: WHERE pha.po_header_id(+) = all_lpn.po_header_id
715: AND rsh.shipment_header_id(+) = all_lpn.shipment_header_id

Line 712: , po_vendor_sites_all pvs

708: , po_vendors pov
709: , hr_locations_all hrl1
710: , hr_locations_all hrl2
711: -- MOAC : changed po_vendor_sites to po_vendor_sites_all
712: , po_vendor_sites_all pvs
713: , per_people_f ppf
714: WHERE pha.po_header_id(+) = all_lpn.po_header_id
715: AND rsh.shipment_header_id(+) = all_lpn.shipment_header_id
716: AND pol.po_line_id (+) = all_lpn.po_line_id