APPS.RCV_GAPLESS_NUMBERING dependencies on PO_VENDOR_SITES_ALL

Line 40: l_vendor_site_code PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE%TYPE;

36: l_vendor_id NUMBER;
37: l_organization_name HR_ORGANIZATION_UNITS.NAME%TYPE;
38: l_organization_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
39: l_vendor_name PO_VENDORS.VENDOR_NAME%TYPE;
40: l_vendor_site_code PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE%TYPE;
41: l_org_code_name VARCHAR2(300);
42: -- End of code bugfix 5197828
43:
44: invoice_exception EXCEPTION;

Line 89: FROM po_vendor_sites_all pvs,

85: pvs.vendor_site_code
86: INTO l_vendor_id,
87: l_vendor_name,
88: l_vendor_site_code
89: FROM po_vendor_sites_all pvs,
90: po_vendors pv
91: WHERE vendor_site_id = p_vendor_site_id
92: AND pvs.vendor_id = pv.vendor_id;
93: