DBA Data[Home] [Help]

APPS.PO_REQCHANGEREQUESTNOTIF_PVT dependencies on PO_VENDORS

Line 3076: l_supplier_name po_vendors.vendor_name%TYPE;

3072: l_po_currency varchar2(15);
3073: l_vendor_id number;
3074: l_vendor_site_id number;
3075:
3076: l_supplier_name po_vendors.vendor_name%TYPE;
3077: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
3078: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
3079: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
3080: l_sup_city po_vendor_sites_all.city%TYPE;

Line 3363: select vendor_name into l_supplier_name from po_vendors where vendor_id = l_vendor_id;

3359: end if;
3360:
3361: end if;
3362:
3363: select vendor_name into l_supplier_name from po_vendors where vendor_id = l_vendor_id;
3364: select address_line1, address_line2, address_line3, city,state,zip
3365: into l_sup_address_line1, l_sup_address_line2, l_sup_address_line3, l_sup_city,
3366: l_sup_state,l_sup_zip
3367: from po_vendor_sites_all