eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_EMAIL_GENERATE dependencies on PO_VENDOR_SITES

Line 2396: l_vendor_add1 PO_VENDOR_SITES.ADDRESS_LINE1%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;
2400: l_vendor_state PO_VENDOR_SITES.STATE%TYPE;

Line 2397: l_vendor_add2 PO_VENDOR_SITES.ADDRESS_LINE2%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;
2400: l_vendor_state PO_VENDOR_SITES.STATE%TYPE;
2401: l_vendor_zip PO_VENDOR_SITES.ZIP%TYPE;

Line 2398: l_vendor_add3 PO_VENDOR_SITES.ADDRESS_LINE3%TYPE;

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;
2400: l_vendor_state PO_VENDOR_SITES.STATE%TYPE;
2401: l_vendor_zip PO_VENDOR_SITES.ZIP%TYPE;
2402: /* Bug 2766736. Changed nls_territory to territory_short_name */

Line 2399: l_vendor_city PO_VENDOR_SITES.CITY%TYPE;

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;
2400: l_vendor_state PO_VENDOR_SITES.STATE%TYPE;
2401: l_vendor_zip PO_VENDOR_SITES.ZIP%TYPE;
2402: /* Bug 2766736. Changed nls_territory to territory_short_name */
2403: l_vendor_country FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE;

Line 2400: l_vendor_state PO_VENDOR_SITES.STATE%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;
2400: l_vendor_state PO_VENDOR_SITES.STATE%TYPE;
2401: l_vendor_zip PO_VENDOR_SITES.ZIP%TYPE;
2402: /* Bug 2766736. Changed nls_territory to territory_short_name */
2403: l_vendor_country FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE;
2404: l_vendor_site_id NUMBER;

Line 2401: l_vendor_zip PO_VENDOR_SITES.ZIP%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;
2400: l_vendor_state PO_VENDOR_SITES.STATE%TYPE;
2401: l_vendor_zip PO_VENDOR_SITES.ZIP%TYPE;
2402: /* Bug 2766736. Changed nls_territory to territory_short_name */
2403: l_vendor_country FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE;
2404: l_vendor_site_id NUMBER;
2405:

Line 2440: l_customer_acct_num PO_VENDOR_SITES.CUSTOMER_NUM%TYPE;

2436: l_freight_terms_lc PO_HEADERS_ALL.FREIGHT_TERMS_LOOKUP_CODE%TYPE;
2437: l_freight_terms_dsp PO_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
2438: l_payment_terms_id NUMBER;
2439: l_payment_terms ap_terms_val_v.name%TYPE;
2440: l_customer_acct_num PO_VENDOR_SITES.CUSTOMER_NUM%TYPE;
2441:
2442: x_orgid NUMBER;
2443:
2444: l_vendor_contact_id NUMBER;

Line 3259: from po_vendor_sites pvs , fnd_territories_vl ftv

3255: ftv.territory_short_name, zip
3256: into
3257: l_vendor_add1, l_vendor_add2, l_vendor_add3, l_vendor_city, l_vendor_state,
3258: l_vendor_country, l_vendor_zip
3259: from po_vendor_sites pvs , fnd_territories_vl ftv
3260: where
3261: ftv.territory_code(+) = nvl(pvs.country_of_origin_code, pvs.country)
3262: and vendor_site_id = l_vendor_site_id;
3263:

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