APPS.MRP_GET_PROJECT dependencies on PO_VENDOR_SITES_ALL

Line 250: v_vendor_site_code po_vendor_sites_all.vendor_site_code%type;

246: END ship_to_address;
247:
248: FUNCTION vendor_site_code(arg_org_id IN NUMBER,
249: arg_vendor_site_id IN NUMBER) return varchar2 IS
250: v_vendor_site_code po_vendor_sites_all.vendor_site_code%type;
251: BEGIN
252:
253: IF arg_vendor_site_id IS NULL THEN
254: RETURN(NULL);

Line 258: FROM po_vendor_sites_all site,

254: RETURN(NULL);
255: END IF;
256:
257: SELECT vendor_site_code INTO v_vendor_site_code
258: FROM po_vendor_sites_all site,
259: org_organization_definitions ood
260: WHERE site.vendor_site_id = arg_vendor_site_id
261: AND nvl(site.org_id,nvl(ood.operating_unit,-1)) =
262: nvl(ood.operating_unit,-1)