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_CHANGEORDERWF_PVT dependencies on PO_VENDOR_SITES_ALL

Line 1275: l_email_address po_vendor_sites_all.email_address%TYPE;

1271: /* BUG 5228026: Added the l_CommunicatePriceChange variable */
1272: l_CommunicatePriceChange varchar2(1) := 'N';
1273:
1274: --
1275: l_email_address po_vendor_sites_all.email_address%TYPE;
1276: l_email_flag VARCHAR2(1) := 'N';
1277: l_fax_flag VARCHAR2(1) := 'N';
1278: l_faxnum po_vendor_contacts.fax%TYPE;
1279: l_fax_area po_vendor_sites_all.fax_area_code%TYPE;

Line 1279: l_fax_area po_vendor_sites_all.fax_area_code%TYPE;

1275: l_email_address po_vendor_sites_all.email_address%TYPE;
1276: l_email_flag VARCHAR2(1) := 'N';
1277: l_fax_flag VARCHAR2(1) := 'N';
1278: l_faxnum po_vendor_contacts.fax%TYPE;
1279: l_fax_area po_vendor_sites_all.fax_area_code%TYPE;
1280: l_preparer_id NUMBER;
1281: l_default_method po_vendor_sites_all.supplier_notif_method%TYPE;
1282: l_doc_num po_headers_all.segment1%TYPE;
1283: l_print_flag VARCHAR2(1) := 'N';

Line 1281: l_default_method po_vendor_sites_all.supplier_notif_method%TYPE;

1277: l_fax_flag VARCHAR2(1) := 'N';
1278: l_faxnum po_vendor_contacts.fax%TYPE;
1279: l_fax_area po_vendor_sites_all.fax_area_code%TYPE;
1280: l_preparer_id NUMBER;
1281: l_default_method po_vendor_sites_all.supplier_notif_method%TYPE;
1282: l_doc_num po_headers_all.segment1%TYPE;
1283: l_print_flag VARCHAR2(1) := 'N';
1284: --
1285:

Line 1634: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;

1630: l_po_currency po_headers.currency_code%TYPE;
1631: l_vendor_id number;
1632: l_vendor_site_id number;
1633: l_supplier_name po_vendors.vendor_name%TYPE;
1634: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
1635: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
1636: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
1637: l_sup_city po_vendor_sites_all.city%TYPE;
1638: l_sup_state po_vendor_sites_all.state%TYPE;

Line 1635: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;

1631: l_vendor_id number;
1632: l_vendor_site_id number;
1633: l_supplier_name po_vendors.vendor_name%TYPE;
1634: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
1635: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
1636: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
1637: l_sup_city po_vendor_sites_all.city%TYPE;
1638: l_sup_state po_vendor_sites_all.state%TYPE;
1639: l_sup_zip po_vendor_sites_all.zip%TYPE;

Line 1636: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;

1632: l_vendor_site_id number;
1633: l_supplier_name po_vendors.vendor_name%TYPE;
1634: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
1635: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
1636: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
1637: l_sup_city po_vendor_sites_all.city%TYPE;
1638: l_sup_state po_vendor_sites_all.state%TYPE;
1639: l_sup_zip po_vendor_sites_all.zip%TYPE;
1640: l_order_date varchar2(2000);

Line 1637: l_sup_city po_vendor_sites_all.city%TYPE;

1633: l_supplier_name po_vendors.vendor_name%TYPE;
1634: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
1635: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
1636: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
1637: l_sup_city po_vendor_sites_all.city%TYPE;
1638: l_sup_state po_vendor_sites_all.state%TYPE;
1639: l_sup_zip po_vendor_sites_all.zip%TYPE;
1640: l_order_date varchar2(2000);
1641: l_fob po_headers_all.fob_lookup_code%TYPE;

Line 1638: l_sup_state po_vendor_sites_all.state%TYPE;

1634: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
1635: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
1636: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
1637: l_sup_city po_vendor_sites_all.city%TYPE;
1638: l_sup_state po_vendor_sites_all.state%TYPE;
1639: l_sup_zip po_vendor_sites_all.zip%TYPE;
1640: l_order_date varchar2(2000);
1641: l_fob po_headers_all.fob_lookup_code%TYPE;
1642: l_carrier po_headers_all.ship_via_lookup_code%TYPE;

Line 1639: l_sup_zip po_vendor_sites_all.zip%TYPE;

1635: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
1636: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
1637: l_sup_city po_vendor_sites_all.city%TYPE;
1638: l_sup_state po_vendor_sites_all.state%TYPE;
1639: l_sup_zip po_vendor_sites_all.zip%TYPE;
1640: l_order_date varchar2(2000);
1641: l_fob po_headers_all.fob_lookup_code%TYPE;
1642: l_carrier po_headers_all.ship_via_lookup_code%TYPE;
1643: l_ship_to_id number;

Line 1994: from po_vendor_sites_all

1990: l_sup_address_line3,
1991: l_sup_city,
1992: l_sup_state,
1993: l_sup_zip
1994: from po_vendor_sites_all
1995: where vendor_site_id = l_vendor_site_id;
1996:
1997: /* Shipto */
1998: select

Line 2463: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;

2459: l_po_currency po_headers.currency_code%TYPE;
2460: l_vendor_id number;
2461: l_vendor_site_id number;
2462: l_supplier_name po_vendors.vendor_name%TYPE;
2463: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
2464: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
2465: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
2466: l_sup_city po_vendor_sites_all.city%TYPE;
2467: l_sup_state po_vendor_sites_all.state%TYPE;

Line 2464: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;

2460: l_vendor_id number;
2461: l_vendor_site_id number;
2462: l_supplier_name po_vendors.vendor_name%TYPE;
2463: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
2464: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
2465: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
2466: l_sup_city po_vendor_sites_all.city%TYPE;
2467: l_sup_state po_vendor_sites_all.state%TYPE;
2468: l_sup_zip po_vendor_sites_all.zip%TYPE;

Line 2465: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;

2461: l_vendor_site_id number;
2462: l_supplier_name po_vendors.vendor_name%TYPE;
2463: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
2464: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
2465: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
2466: l_sup_city po_vendor_sites_all.city%TYPE;
2467: l_sup_state po_vendor_sites_all.state%TYPE;
2468: l_sup_zip po_vendor_sites_all.zip%TYPE;
2469: l_order_date varchar2(2000);

Line 2466: l_sup_city po_vendor_sites_all.city%TYPE;

2462: l_supplier_name po_vendors.vendor_name%TYPE;
2463: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
2464: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
2465: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
2466: l_sup_city po_vendor_sites_all.city%TYPE;
2467: l_sup_state po_vendor_sites_all.state%TYPE;
2468: l_sup_zip po_vendor_sites_all.zip%TYPE;
2469: l_order_date varchar2(2000);
2470: l_fob po_headers_all.fob_lookup_code%TYPE;

Line 2467: l_sup_state po_vendor_sites_all.state%TYPE;

2463: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
2464: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
2465: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
2466: l_sup_city po_vendor_sites_all.city%TYPE;
2467: l_sup_state po_vendor_sites_all.state%TYPE;
2468: l_sup_zip po_vendor_sites_all.zip%TYPE;
2469: l_order_date varchar2(2000);
2470: l_fob po_headers_all.fob_lookup_code%TYPE;
2471: l_carrier po_headers_all.ship_via_lookup_code%TYPE;

Line 2468: l_sup_zip po_vendor_sites_all.zip%TYPE;

2464: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
2465: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
2466: l_sup_city po_vendor_sites_all.city%TYPE;
2467: l_sup_state po_vendor_sites_all.state%TYPE;
2468: l_sup_zip po_vendor_sites_all.zip%TYPE;
2469: l_order_date varchar2(2000);
2470: l_fob po_headers_all.fob_lookup_code%TYPE;
2471: l_carrier po_headers_all.ship_via_lookup_code%TYPE;
2472: l_ship_to_id number;

Line 2831: from po_vendor_sites_all

2827: l_sup_address_line3,
2828: l_sup_city,
2829: l_sup_state,
2830: l_sup_zip
2831: from po_vendor_sites_all
2832: where vendor_site_id = l_vendor_site_id;
2833:
2834: select
2835: address_line_1,

Line 3290: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;

3286: l_po_currency po_headers.currency_code%TYPE;
3287: l_vendor_id number;
3288: l_vendor_site_id number;
3289: l_supplier_name po_vendors.vendor_name%TYPE;
3290: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
3291: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
3292: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
3293: l_sup_city po_vendor_sites_all.city%TYPE;
3294: l_sup_state po_vendor_sites_all.state%TYPE;

Line 3291: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;

3287: l_vendor_id number;
3288: l_vendor_site_id number;
3289: l_supplier_name po_vendors.vendor_name%TYPE;
3290: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
3291: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
3292: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
3293: l_sup_city po_vendor_sites_all.city%TYPE;
3294: l_sup_state po_vendor_sites_all.state%TYPE;
3295: l_sup_zip po_vendor_sites_all.zip%TYPE;

Line 3292: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;

3288: l_vendor_site_id number;
3289: l_supplier_name po_vendors.vendor_name%TYPE;
3290: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
3291: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
3292: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
3293: l_sup_city po_vendor_sites_all.city%TYPE;
3294: l_sup_state po_vendor_sites_all.state%TYPE;
3295: l_sup_zip po_vendor_sites_all.zip%TYPE;
3296: l_order_date varchar2(2000);

Line 3293: l_sup_city po_vendor_sites_all.city%TYPE;

3289: l_supplier_name po_vendors.vendor_name%TYPE;
3290: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
3291: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
3292: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
3293: l_sup_city po_vendor_sites_all.city%TYPE;
3294: l_sup_state po_vendor_sites_all.state%TYPE;
3295: l_sup_zip po_vendor_sites_all.zip%TYPE;
3296: l_order_date varchar2(2000);
3297: l_fob po_headers_all.fob_lookup_code%TYPE;

Line 3294: l_sup_state po_vendor_sites_all.state%TYPE;

3290: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
3291: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
3292: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
3293: l_sup_city po_vendor_sites_all.city%TYPE;
3294: l_sup_state po_vendor_sites_all.state%TYPE;
3295: l_sup_zip po_vendor_sites_all.zip%TYPE;
3296: l_order_date varchar2(2000);
3297: l_fob po_headers_all.fob_lookup_code%TYPE;
3298: l_carrier po_headers_all.ship_via_lookup_code%TYPE;

Line 3295: l_sup_zip po_vendor_sites_all.zip%TYPE;

3291: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
3292: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
3293: l_sup_city po_vendor_sites_all.city%TYPE;
3294: l_sup_state po_vendor_sites_all.state%TYPE;
3295: l_sup_zip po_vendor_sites_all.zip%TYPE;
3296: l_order_date varchar2(2000);
3297: l_fob po_headers_all.fob_lookup_code%TYPE;
3298: l_carrier po_headers_all.ship_via_lookup_code%TYPE;
3299: l_ship_to_id number;

Line 3760: from po_vendor_sites_all

3756: l_sup_address_line3,
3757: l_sup_city,
3758: l_sup_state,
3759: l_sup_zip
3760: from po_vendor_sites_all
3761: where vendor_site_id = l_vendor_site_id;
3762:
3763: select
3764: address_line_1,

Line 4362: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;

4358: l_po_currency po_headers.currency_code%TYPE;
4359: l_vendor_id number;
4360: l_vendor_site_id number;
4361: l_supplier_name po_vendors.vendor_name%TYPE;
4362: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
4363: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
4364: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
4365: l_sup_city po_vendor_sites_all.city%TYPE;
4366: l_sup_state po_vendor_sites_all.state%TYPE;

Line 4363: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;

4359: l_vendor_id number;
4360: l_vendor_site_id number;
4361: l_supplier_name po_vendors.vendor_name%TYPE;
4362: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
4363: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
4364: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
4365: l_sup_city po_vendor_sites_all.city%TYPE;
4366: l_sup_state po_vendor_sites_all.state%TYPE;
4367: l_sup_zip po_vendor_sites_all.zip%TYPE;

Line 4364: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;

4360: l_vendor_site_id number;
4361: l_supplier_name po_vendors.vendor_name%TYPE;
4362: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
4363: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
4364: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
4365: l_sup_city po_vendor_sites_all.city%TYPE;
4366: l_sup_state po_vendor_sites_all.state%TYPE;
4367: l_sup_zip po_vendor_sites_all.zip%TYPE;
4368: l_order_date varchar2(2000);

Line 4365: l_sup_city po_vendor_sites_all.city%TYPE;

4361: l_supplier_name po_vendors.vendor_name%TYPE;
4362: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
4363: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
4364: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
4365: l_sup_city po_vendor_sites_all.city%TYPE;
4366: l_sup_state po_vendor_sites_all.state%TYPE;
4367: l_sup_zip po_vendor_sites_all.zip%TYPE;
4368: l_order_date varchar2(2000);
4369: l_fob po_headers_all.fob_lookup_code%TYPE;

Line 4366: l_sup_state po_vendor_sites_all.state%TYPE;

4362: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
4363: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
4364: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
4365: l_sup_city po_vendor_sites_all.city%TYPE;
4366: l_sup_state po_vendor_sites_all.state%TYPE;
4367: l_sup_zip po_vendor_sites_all.zip%TYPE;
4368: l_order_date varchar2(2000);
4369: l_fob po_headers_all.fob_lookup_code%TYPE;
4370: l_carrier po_headers_all.ship_via_lookup_code%TYPE;

Line 4367: l_sup_zip po_vendor_sites_all.zip%TYPE;

4363: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
4364: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
4365: l_sup_city po_vendor_sites_all.city%TYPE;
4366: l_sup_state po_vendor_sites_all.state%TYPE;
4367: l_sup_zip po_vendor_sites_all.zip%TYPE;
4368: l_order_date varchar2(2000);
4369: l_fob po_headers_all.fob_lookup_code%TYPE;
4370: l_carrier po_headers_all.ship_via_lookup_code%TYPE;
4371: l_ship_to_id number;

Line 4660: from po_vendor_sites_all

4656: l_sup_address_line3,
4657: l_sup_city,
4658: l_sup_state,
4659: l_sup_zip
4660: from po_vendor_sites_all
4661: where vendor_site_id = l_vendor_site_id;
4662:
4663: select
4664: address_line_1,