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 2617: l_vendor_add1 PO_VENDOR_SITES.ADDRESS_LINE1%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;
2621: l_vendor_state PO_VENDOR_SITES.STATE%TYPE;

Line 2618: l_vendor_add2 PO_VENDOR_SITES.ADDRESS_LINE2%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;
2621: l_vendor_state PO_VENDOR_SITES.STATE%TYPE;
2622: l_vendor_zip PO_VENDOR_SITES.ZIP%TYPE;

Line 2619: l_vendor_add3 PO_VENDOR_SITES.ADDRESS_LINE3%TYPE;

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

Line 2620: l_vendor_city PO_VENDOR_SITES.CITY%TYPE;

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;
2621: l_vendor_state PO_VENDOR_SITES.STATE%TYPE;
2622: l_vendor_zip PO_VENDOR_SITES.ZIP%TYPE;
2623: /* Bug 2766736. Changed nls_territory to territory_short_name */
2624: l_vendor_country FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE;

Line 2621: l_vendor_state PO_VENDOR_SITES.STATE%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;
2621: l_vendor_state PO_VENDOR_SITES.STATE%TYPE;
2622: l_vendor_zip PO_VENDOR_SITES.ZIP%TYPE;
2623: /* Bug 2766736. Changed nls_territory to territory_short_name */
2624: l_vendor_country FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE;
2625: l_vendor_site_id NUMBER;

Line 2622: l_vendor_zip PO_VENDOR_SITES.ZIP%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;
2621: l_vendor_state PO_VENDOR_SITES.STATE%TYPE;
2622: l_vendor_zip PO_VENDOR_SITES.ZIP%TYPE;
2623: /* Bug 2766736. Changed nls_territory to territory_short_name */
2624: l_vendor_country FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE;
2625: l_vendor_site_id NUMBER;
2626:

Line 2661: l_customer_acct_num PO_VENDOR_SITES.CUSTOMER_NUM%TYPE;

2657: l_freight_terms_lc PO_HEADERS_ALL.FREIGHT_TERMS_LOOKUP_CODE%TYPE;
2658: l_freight_terms_dsp PO_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
2659: l_payment_terms_id NUMBER;
2660: l_payment_terms ap_terms_val_v.name%TYPE;
2661: l_customer_acct_num PO_VENDOR_SITES.CUSTOMER_NUM%TYPE;
2662:
2663: l_org_id NUMBER; --
2664:
2665: l_vendor_contact_id NUMBER;

Line 3717: from po_vendor_sites pvs , fnd_territories_vl ftv

3713: ftv.territory_short_name, zip
3714: into
3715: l_vendor_add1, l_vendor_add2, l_vendor_add3, l_vendor_city, l_vendor_state,
3716: l_vendor_country, l_vendor_zip
3717: from po_vendor_sites pvs , fnd_territories_vl ftv
3718: where
3719: ftv.territory_code(+) = pvs.country --
3720: and vendor_site_id = l_vendor_site_id;
3721:

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