574: INTO l_vendor_party_id
575: , l_vendor_site_party_id
576: FROM
577: po_vendors pov
578: , po_vendor_sites_all povs
579: WHERE pov.vendor_id = povs.vendor_id
580: AND povs.vendor_site_id = l_vendor_site_id
581: AND povs.vendor_id = l_vendor_id;
582:
2421: l_vendor_name
2422: , l_vendor_site
2423: FROM
2424: po_vendors pov
2425: , po_vendor_sites_all povs
2426: WHERE pov.vendor_id = povs.vendor_id
2427: AND pov.vendor_id = p_vendor_id
2428: AND povs.vendor_site_id = l_vendor_site_id;
2429:
2575: vendor_id
2576: INTO
2577: l_vendor_id
2578: FROM
2579: po_vendor_sites_all
2580: WHERE vendor_site_id = l_vendor_site_id;
2581:
2582: -- INVCONV get accoutn for process organiztions from OPM setup.
2583: /*????IF INV_GMI_RSV_BRANCH.Is_Org_Process_Org(l_org_id) THEN