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 1493: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;

1489: l_po_currency po_headers.currency_code%TYPE;
1490: l_vendor_id number;
1491: l_vendor_site_id number;
1492: l_supplier_name po_vendors.vendor_name%TYPE;
1493: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
1494: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
1495: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
1496: l_sup_city po_vendor_sites_all.city%TYPE;
1497: l_sup_state po_vendor_sites_all.state%TYPE;

Line 1494: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;

1490: l_vendor_id number;
1491: l_vendor_site_id number;
1492: l_supplier_name po_vendors.vendor_name%TYPE;
1493: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
1494: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
1495: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
1496: l_sup_city po_vendor_sites_all.city%TYPE;
1497: l_sup_state po_vendor_sites_all.state%TYPE;
1498: l_sup_zip po_vendor_sites_all.zip%TYPE;

Line 1495: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;

1491: l_vendor_site_id number;
1492: l_supplier_name po_vendors.vendor_name%TYPE;
1493: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
1494: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
1495: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
1496: l_sup_city po_vendor_sites_all.city%TYPE;
1497: l_sup_state po_vendor_sites_all.state%TYPE;
1498: l_sup_zip po_vendor_sites_all.zip%TYPE;
1499: l_order_date varchar2(2000);

Line 1496: l_sup_city po_vendor_sites_all.city%TYPE;

1492: l_supplier_name po_vendors.vendor_name%TYPE;
1493: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
1494: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
1495: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
1496: l_sup_city po_vendor_sites_all.city%TYPE;
1497: l_sup_state po_vendor_sites_all.state%TYPE;
1498: l_sup_zip po_vendor_sites_all.zip%TYPE;
1499: l_order_date varchar2(2000);
1500: l_fob po_headers_all.fob_lookup_code%TYPE;

Line 1497: l_sup_state po_vendor_sites_all.state%TYPE;

1493: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
1494: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
1495: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
1496: l_sup_city po_vendor_sites_all.city%TYPE;
1497: l_sup_state po_vendor_sites_all.state%TYPE;
1498: l_sup_zip po_vendor_sites_all.zip%TYPE;
1499: l_order_date varchar2(2000);
1500: l_fob po_headers_all.fob_lookup_code%TYPE;
1501: l_carrier po_headers_all.ship_via_lookup_code%TYPE;

Line 1498: l_sup_zip po_vendor_sites_all.zip%TYPE;

1494: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
1495: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
1496: l_sup_city po_vendor_sites_all.city%TYPE;
1497: l_sup_state po_vendor_sites_all.state%TYPE;
1498: l_sup_zip po_vendor_sites_all.zip%TYPE;
1499: l_order_date varchar2(2000);
1500: l_fob po_headers_all.fob_lookup_code%TYPE;
1501: l_carrier po_headers_all.ship_via_lookup_code%TYPE;
1502: l_ship_to_id number;

Line 1846: from po_vendor_sites_all

1842: l_sup_address_line3,
1843: l_sup_city,
1844: l_sup_state,
1845: l_sup_zip
1846: from po_vendor_sites_all
1847: where vendor_site_id = l_vendor_site_id;
1848:
1849: /* Shipto */
1850: select

Line 2315: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;

2311: l_po_currency po_headers.currency_code%TYPE;
2312: l_vendor_id number;
2313: l_vendor_site_id number;
2314: l_supplier_name po_vendors.vendor_name%TYPE;
2315: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
2316: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
2317: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
2318: l_sup_city po_vendor_sites_all.city%TYPE;
2319: l_sup_state po_vendor_sites_all.state%TYPE;

Line 2316: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;

2312: l_vendor_id number;
2313: l_vendor_site_id number;
2314: l_supplier_name po_vendors.vendor_name%TYPE;
2315: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
2316: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
2317: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
2318: l_sup_city po_vendor_sites_all.city%TYPE;
2319: l_sup_state po_vendor_sites_all.state%TYPE;
2320: l_sup_zip po_vendor_sites_all.zip%TYPE;

Line 2317: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;

2313: l_vendor_site_id number;
2314: l_supplier_name po_vendors.vendor_name%TYPE;
2315: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
2316: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
2317: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
2318: l_sup_city po_vendor_sites_all.city%TYPE;
2319: l_sup_state po_vendor_sites_all.state%TYPE;
2320: l_sup_zip po_vendor_sites_all.zip%TYPE;
2321: l_order_date varchar2(2000);

Line 2318: l_sup_city po_vendor_sites_all.city%TYPE;

2314: l_supplier_name po_vendors.vendor_name%TYPE;
2315: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
2316: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
2317: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
2318: l_sup_city po_vendor_sites_all.city%TYPE;
2319: l_sup_state po_vendor_sites_all.state%TYPE;
2320: l_sup_zip po_vendor_sites_all.zip%TYPE;
2321: l_order_date varchar2(2000);
2322: l_fob po_headers_all.fob_lookup_code%TYPE;

Line 2319: l_sup_state po_vendor_sites_all.state%TYPE;

2315: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
2316: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
2317: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
2318: l_sup_city po_vendor_sites_all.city%TYPE;
2319: l_sup_state po_vendor_sites_all.state%TYPE;
2320: l_sup_zip po_vendor_sites_all.zip%TYPE;
2321: l_order_date varchar2(2000);
2322: l_fob po_headers_all.fob_lookup_code%TYPE;
2323: l_carrier po_headers_all.ship_via_lookup_code%TYPE;

Line 2320: l_sup_zip po_vendor_sites_all.zip%TYPE;

2316: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
2317: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
2318: l_sup_city po_vendor_sites_all.city%TYPE;
2319: l_sup_state po_vendor_sites_all.state%TYPE;
2320: l_sup_zip po_vendor_sites_all.zip%TYPE;
2321: l_order_date varchar2(2000);
2322: l_fob po_headers_all.fob_lookup_code%TYPE;
2323: l_carrier po_headers_all.ship_via_lookup_code%TYPE;
2324: l_ship_to_id number;

Line 2679: from po_vendor_sites_all

2675: l_sup_address_line3,
2676: l_sup_city,
2677: l_sup_state,
2678: l_sup_zip
2679: from po_vendor_sites_all
2680: where vendor_site_id = l_vendor_site_id;
2681:
2682: select
2683: address_line_1,

Line 3138: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;

3134: l_po_currency po_headers.currency_code%TYPE;
3135: l_vendor_id number;
3136: l_vendor_site_id number;
3137: l_supplier_name po_vendors.vendor_name%TYPE;
3138: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
3139: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
3140: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
3141: l_sup_city po_vendor_sites_all.city%TYPE;
3142: l_sup_state po_vendor_sites_all.state%TYPE;

Line 3139: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;

3135: l_vendor_id number;
3136: l_vendor_site_id number;
3137: l_supplier_name po_vendors.vendor_name%TYPE;
3138: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
3139: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
3140: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
3141: l_sup_city po_vendor_sites_all.city%TYPE;
3142: l_sup_state po_vendor_sites_all.state%TYPE;
3143: l_sup_zip po_vendor_sites_all.zip%TYPE;

Line 3140: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;

3136: l_vendor_site_id number;
3137: l_supplier_name po_vendors.vendor_name%TYPE;
3138: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
3139: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
3140: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
3141: l_sup_city po_vendor_sites_all.city%TYPE;
3142: l_sup_state po_vendor_sites_all.state%TYPE;
3143: l_sup_zip po_vendor_sites_all.zip%TYPE;
3144: l_order_date varchar2(2000);

Line 3141: l_sup_city po_vendor_sites_all.city%TYPE;

3137: l_supplier_name po_vendors.vendor_name%TYPE;
3138: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
3139: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
3140: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
3141: l_sup_city po_vendor_sites_all.city%TYPE;
3142: l_sup_state po_vendor_sites_all.state%TYPE;
3143: l_sup_zip po_vendor_sites_all.zip%TYPE;
3144: l_order_date varchar2(2000);
3145: l_fob po_headers_all.fob_lookup_code%TYPE;

Line 3142: l_sup_state po_vendor_sites_all.state%TYPE;

3138: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
3139: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
3140: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
3141: l_sup_city po_vendor_sites_all.city%TYPE;
3142: l_sup_state po_vendor_sites_all.state%TYPE;
3143: l_sup_zip po_vendor_sites_all.zip%TYPE;
3144: l_order_date varchar2(2000);
3145: l_fob po_headers_all.fob_lookup_code%TYPE;
3146: l_carrier po_headers_all.ship_via_lookup_code%TYPE;

Line 3143: l_sup_zip po_vendor_sites_all.zip%TYPE;

3139: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
3140: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
3141: l_sup_city po_vendor_sites_all.city%TYPE;
3142: l_sup_state po_vendor_sites_all.state%TYPE;
3143: l_sup_zip po_vendor_sites_all.zip%TYPE;
3144: l_order_date varchar2(2000);
3145: l_fob po_headers_all.fob_lookup_code%TYPE;
3146: l_carrier po_headers_all.ship_via_lookup_code%TYPE;
3147: l_ship_to_id number;

Line 3608: from po_vendor_sites_all

3604: l_sup_address_line3,
3605: l_sup_city,
3606: l_sup_state,
3607: l_sup_zip
3608: from po_vendor_sites_all
3609: where vendor_site_id = l_vendor_site_id;
3610:
3611: select
3612: address_line_1,

Line 4210: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;

4206: l_po_currency po_headers.currency_code%TYPE;
4207: l_vendor_id number;
4208: l_vendor_site_id number;
4209: l_supplier_name po_vendors.vendor_name%TYPE;
4210: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
4211: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
4212: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
4213: l_sup_city po_vendor_sites_all.city%TYPE;
4214: l_sup_state po_vendor_sites_all.state%TYPE;

Line 4211: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;

4207: l_vendor_id number;
4208: l_vendor_site_id number;
4209: l_supplier_name po_vendors.vendor_name%TYPE;
4210: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
4211: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
4212: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
4213: l_sup_city po_vendor_sites_all.city%TYPE;
4214: l_sup_state po_vendor_sites_all.state%TYPE;
4215: l_sup_zip po_vendor_sites_all.zip%TYPE;

Line 4212: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;

4208: l_vendor_site_id number;
4209: l_supplier_name po_vendors.vendor_name%TYPE;
4210: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
4211: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
4212: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
4213: l_sup_city po_vendor_sites_all.city%TYPE;
4214: l_sup_state po_vendor_sites_all.state%TYPE;
4215: l_sup_zip po_vendor_sites_all.zip%TYPE;
4216: l_order_date varchar2(2000);

Line 4213: l_sup_city po_vendor_sites_all.city%TYPE;

4209: l_supplier_name po_vendors.vendor_name%TYPE;
4210: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
4211: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
4212: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
4213: l_sup_city po_vendor_sites_all.city%TYPE;
4214: l_sup_state po_vendor_sites_all.state%TYPE;
4215: l_sup_zip po_vendor_sites_all.zip%TYPE;
4216: l_order_date varchar2(2000);
4217: l_fob po_headers_all.fob_lookup_code%TYPE;

Line 4214: l_sup_state po_vendor_sites_all.state%TYPE;

4210: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
4211: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
4212: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
4213: l_sup_city po_vendor_sites_all.city%TYPE;
4214: l_sup_state po_vendor_sites_all.state%TYPE;
4215: l_sup_zip po_vendor_sites_all.zip%TYPE;
4216: l_order_date varchar2(2000);
4217: l_fob po_headers_all.fob_lookup_code%TYPE;
4218: l_carrier po_headers_all.ship_via_lookup_code%TYPE;

Line 4215: l_sup_zip po_vendor_sites_all.zip%TYPE;

4211: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
4212: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
4213: l_sup_city po_vendor_sites_all.city%TYPE;
4214: l_sup_state po_vendor_sites_all.state%TYPE;
4215: l_sup_zip po_vendor_sites_all.zip%TYPE;
4216: l_order_date varchar2(2000);
4217: l_fob po_headers_all.fob_lookup_code%TYPE;
4218: l_carrier po_headers_all.ship_via_lookup_code%TYPE;
4219: l_ship_to_id number;

Line 4508: from po_vendor_sites_all

4504: l_sup_address_line3,
4505: l_sup_city,
4506: l_sup_state,
4507: l_sup_zip
4508: from po_vendor_sites_all
4509: where vendor_site_id = l_vendor_site_id;
4510:
4511: select
4512: address_line_1,