APPS.INV_THIRD_PARTY_STOCK_PVT dependencies on PO_VENDOR_SITES_ALL

Line 586: , po_vendor_sites_all povs

582: INTO l_vendor_party_id
583: , l_vendor_site_party_id
584: FROM
585: po_vendors pov
586: , po_vendor_sites_all povs
587: WHERE pov.vendor_id = povs.vendor_id
588: AND povs.vendor_site_id = l_vendor_site_id
589: AND povs.vendor_id = l_vendor_id;
590:

Line 834: ,(SELECT pvs.location_id from po_vendor_sites_all pvs WHERE pvs.vendor_site_id=ph.vendor_site_id) -- bug 14570035

830: , p_ship_to_organization_id
831: -- , l_vendor_site_id
832: , bill_to_location_id
833: , l_ship_from_location_id
834: ,(SELECT pvs.location_id from po_vendor_sites_all pvs WHERE pvs.vendor_site_id=ph.vendor_site_id) -- bug 14570035
835: FROM po_headers_all ph
836: WHERE ph.po_header_id = p_header_id;
837:
838: INSERT INTO ZX_ITM_DISTRIBUTIONS_GT

Line 2430: , po_vendor_sites_all povs

2426: l_vendor_name
2427: , l_vendor_site
2428: FROM
2429: po_vendors pov
2430: , po_vendor_sites_all povs
2431: WHERE pov.vendor_id = povs.vendor_id
2432: AND pov.vendor_id = p_vendor_id
2433: AND povs.vendor_site_id = l_vendor_site_id;
2434:

Line 2587: po_vendor_sites_all

2583: vendor_id
2584: INTO
2585: l_vendor_id
2586: FROM
2587: po_vendor_sites_all
2588: WHERE vendor_site_id = l_vendor_site_id;
2589:
2590: -- INVCONV get accoutn for process organiztions from OPM setup.
2591: /*????IF INV_GMI_RSV_BRANCH.Is_Org_Process_Org(l_org_id) THEN