APPS.PO_EMAIL_GENERATE dependencies on PO_VENDORS

Line 2616: l_vendor_desc PO_VENDORS.VENDOR_NAME%TYPE;

2612: l_ship_to_region2 FND_LOOKUP_VALUES.MEANING%TYPE;
2613: l_ship_to_region3 FND_LOOKUP_VALUES.MEANING%TYPE;
2614: -- EMAILPO FPH END--
2615:
2616: l_vendor_desc PO_VENDORS.VENDOR_NAME%TYPE;
2617: l_vendor_add1 PO_VENDOR_SITES.ADDRESS_LINE1%TYPE;
2618: l_vendor_add2 PO_VENDOR_SITES.ADDRESS_LINE2%TYPE;
2619: l_vendor_add3 PO_VENDOR_SITES.ADDRESS_LINE3%TYPE;
2620: l_vendor_city PO_VENDOR_SITES.CITY%TYPE;

Line 2669: l_vendor_num PO_VENDORS.SEGMENT1%TYPE;

2665: l_vendor_contact_id NUMBER;
2666: --EMAILPO FPH--
2667: l_vendor_contact_name varchar2(200) := '';
2668: l_vendor_phone VARCHAR2(100);
2669: l_vendor_num PO_VENDORS.SEGMENT1%TYPE;
2670:
2671: l_dummy_count NUMBER := 0;
2672: l_ship_to_string VARCHAR2(500) := '';
2673: l_ship_to_count NUMBER := 0;

Line 3834: from po_vendor_sites pvs, po_vendors pov

3830:
3831:
3832: begin
3833: select nvl(pvs.customer_num, pov.customer_num) into l_customer_acct_num
3834: from po_vendor_sites pvs, po_vendors pov
3835: where pvs.vendor_site_id = l_vendor_site_id
3836: and pov.vendor_id = l_vendor_id;
3837: exception
3838: when others then

Line 3844: from po_vendors pov

3840: end;
3841: begin
3842: select segment1, vendor_name
3843: into l_vendor_num, l_vendor_desc
3844: from po_vendors pov
3845: where pov.vendor_id = l_vendor_id;
3846: exception
3847: when others then
3848: l_vendor_num := '';