APPS.RCV_GAPLESS_NUMBERING dependencies on PO_VENDORS

Line 39: l_vendor_name PO_VENDORS.VENDOR_NAME%TYPE;

35: l_msg_count NUMBER;
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:

Line 90: po_vendors pv

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:
94: IF (g_asn_debug = 'Y')