APPS.PO_EMAIL_GENERATE dependencies on PO_VENDORS

Line 2395: l_vendor_desc PO_VENDORS.VENDOR_NAME%TYPE;

2391: l_ship_to_region2 FND_LOOKUP_VALUES.MEANING%TYPE;
2392: l_ship_to_region3 FND_LOOKUP_VALUES.MEANING%TYPE;
2393: -- EMAILPO FPH END--
2394:
2395: l_vendor_desc PO_VENDORS.VENDOR_NAME%TYPE;
2396: l_vendor_add1 PO_VENDOR_SITES.ADDRESS_LINE1%TYPE;
2397: l_vendor_add2 PO_VENDOR_SITES.ADDRESS_LINE2%TYPE;
2398: l_vendor_add3 PO_VENDOR_SITES.ADDRESS_LINE3%TYPE;
2399: l_vendor_city PO_VENDOR_SITES.CITY%TYPE;

Line 2448: l_vendor_num PO_VENDORS.SEGMENT1%TYPE;

2444: l_vendor_contact_id NUMBER;
2445: --EMAILPO FPH--
2446: l_vendor_contact_name varchar2(200) := '';
2447: l_vendor_phone VARCHAR2(100);
2448: l_vendor_num PO_VENDORS.SEGMENT1%TYPE;
2449:
2450: l_dummy_count NUMBER := 0;
2451: l_ship_to_string VARCHAR2(500) := '';
2452: l_ship_to_count NUMBER := 0;

Line 3376: from po_vendor_sites pvs, po_vendors pov

3372:
3373:
3374: begin
3375: select nvl(pvs.customer_num, pov.customer_num) into l_customer_acct_num
3376: from po_vendor_sites pvs, po_vendors pov
3377: where pvs.vendor_site_id = l_vendor_site_id
3378: and pov.vendor_id = l_vendor_id;
3379: exception
3380: when others then

Line 3386: from po_vendors pov

3382: end;
3383: begin
3384: select segment1, vendor_name
3385: into l_vendor_num, l_vendor_desc
3386: from po_vendors pov
3387: where pov.vendor_id = l_vendor_id;
3388: exception
3389: when others then
3390: l_vendor_num := '';