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 HR_LOCATIONS_ALL

Line 1503: l_ship_addr_l1 hr_locations_all.address_line_1%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;
1503: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
1504: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
1505: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
1506: l_ship_city hr_locations_all.town_or_city%TYPE;
1507: l_ship_state hr_locations_all.region_1%TYPE;

Line 1504: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;

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;
1503: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
1504: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
1505: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
1506: l_ship_city hr_locations_all.town_or_city%TYPE;
1507: l_ship_state hr_locations_all.region_1%TYPE;
1508: l_ship_zip hr_locations_all.postal_code%TYPE;

Line 1505: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;

1501: l_carrier po_headers_all.ship_via_lookup_code%TYPE;
1502: l_ship_to_id number;
1503: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
1504: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
1505: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
1506: l_ship_city hr_locations_all.town_or_city%TYPE;
1507: l_ship_state hr_locations_all.region_1%TYPE;
1508: l_ship_zip hr_locations_all.postal_code%TYPE;
1509: l_base_url varchar2(2000);

Line 1506: l_ship_city hr_locations_all.town_or_city%TYPE;

1502: l_ship_to_id number;
1503: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
1504: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
1505: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
1506: l_ship_city hr_locations_all.town_or_city%TYPE;
1507: l_ship_state hr_locations_all.region_1%TYPE;
1508: l_ship_zip hr_locations_all.postal_code%TYPE;
1509: l_base_url varchar2(2000);
1510: l_base_url_tag varchar2(2000);

Line 1507: l_ship_state hr_locations_all.region_1%TYPE;

1503: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
1504: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
1505: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
1506: l_ship_city hr_locations_all.town_or_city%TYPE;
1507: l_ship_state hr_locations_all.region_1%TYPE;
1508: l_ship_zip hr_locations_all.postal_code%TYPE;
1509: l_base_url varchar2(2000);
1510: l_base_url_tag varchar2(2000);
1511:

Line 1508: l_ship_zip hr_locations_all.postal_code%TYPE;

1504: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
1505: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
1506: l_ship_city hr_locations_all.town_or_city%TYPE;
1507: l_ship_state hr_locations_all.region_1%TYPE;
1508: l_ship_zip hr_locations_all.postal_code%TYPE;
1509: l_base_url varchar2(2000);
1510: l_base_url_tag varchar2(2000);
1511:
1512: l_document1 VARCHAR2(32000) := '';

Line 1529: lc_ship_to_location hr_locations_all.location_code%TYPE;

1525: lc_new_price varchar2(2000);
1526: lc_action_type varchar2(2000);
1527: lc_item_desc po_lines_all.item_description%TYPE;
1528: lc_uom po_lines_all.unit_meas_lookup_code%TYPE;
1529: lc_ship_to_location hr_locations_all.location_code%TYPE;
1530: lc_action_code po_change_requests.ACTION_TYPE%TYPE;
1531: lc_reason po_change_requests.request_reason%TYPE;
1532: lc_split varchar2(2000);
1533: l_global_agreement_flag po_headers_all.GLOBAL_AGREEMENT_FLAG%TYPE := 'F';

Line 1621: hr_locations_all hla, hz_locations hz,

1617: from
1618: po_change_requests pcr,
1619: po_lines_archive_all pla,
1620: po_line_locations_archive_all plla,
1621: hr_locations_all hla, hz_locations hz,
1622: mtl_system_items_kfv msi,
1623: FINANCIALS_SYSTEM_PARAMS_ALL FSP
1624: where pcr.change_request_group_id =grp_id
1625: and pla.po_line_id = pcr.document_line_id

Line 1667: hr_locations_all hla, hz_locations hz,

1663: from
1664: po_change_requests pcr,
1665: po_lines_archive_all pla,
1666: po_line_locations_archive_all plla,
1667: hr_locations_all hla, hz_locations hz,
1668: mtl_system_items_kfv msi,
1669: FINANCIALS_SYSTEM_PARAMS_ALL FSP
1670: where pcr.change_request_group_id =grp_id
1671: and pla.po_line_id = pcr.document_line_id

Line 1864: from hr_locations_all

1860: l_ship_addr_l3,
1861: l_ship_city,
1862: l_ship_state,
1863: l_ship_zip
1864: from hr_locations_all
1865: where location_id = l_ship_to_id;
1866: l_progress := '003';
1867:
1868: if(l_release_id is null) then

Line 2325: l_ship_addr_l1 hr_locations_all.address_line_1%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;
2325: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
2326: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
2327: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
2328: l_ship_city hr_locations_all.town_or_city%TYPE;
2329: l_ship_state hr_locations_all.region_1%TYPE;

Line 2326: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;

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;
2325: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
2326: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
2327: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
2328: l_ship_city hr_locations_all.town_or_city%TYPE;
2329: l_ship_state hr_locations_all.region_1%TYPE;
2330: l_ship_zip hr_locations_all.postal_code%TYPE;

Line 2327: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;

2323: l_carrier po_headers_all.ship_via_lookup_code%TYPE;
2324: l_ship_to_id number;
2325: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
2326: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
2327: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
2328: l_ship_city hr_locations_all.town_or_city%TYPE;
2329: l_ship_state hr_locations_all.region_1%TYPE;
2330: l_ship_zip hr_locations_all.postal_code%TYPE;
2331:

Line 2328: l_ship_city hr_locations_all.town_or_city%TYPE;

2324: l_ship_to_id number;
2325: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
2326: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
2327: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
2328: l_ship_city hr_locations_all.town_or_city%TYPE;
2329: l_ship_state hr_locations_all.region_1%TYPE;
2330: l_ship_zip hr_locations_all.postal_code%TYPE;
2331:
2332: l_document1 VARCHAR2(32000) := '';

Line 2329: l_ship_state hr_locations_all.region_1%TYPE;

2325: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
2326: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
2327: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
2328: l_ship_city hr_locations_all.town_or_city%TYPE;
2329: l_ship_state hr_locations_all.region_1%TYPE;
2330: l_ship_zip hr_locations_all.postal_code%TYPE;
2331:
2332: l_document1 VARCHAR2(32000) := '';
2333: l_base_url varchar2(2000);

Line 2330: l_ship_zip hr_locations_all.postal_code%TYPE;

2326: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
2327: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
2328: l_ship_city hr_locations_all.town_or_city%TYPE;
2329: l_ship_state hr_locations_all.region_1%TYPE;
2330: l_ship_zip hr_locations_all.postal_code%TYPE;
2331:
2332: l_document1 VARCHAR2(32000) := '';
2333: l_base_url varchar2(2000);
2334: l_base_url_tag varchar2(2000);

Line 2352: lc_ship_to_location hr_locations_all.location_code%TYPE;

2348: lc_new_price varchar2(2000);
2349: lc_action_type varchar2(2000);
2350: lc_item_desc po_lines_all.item_description%TYPE;
2351: lc_uom po_lines_all.unit_meas_lookup_code%TYPE;
2352: lc_ship_to_location hr_locations_all.location_code%TYPE;
2353: lc_action_code po_change_requests.ACTION_TYPE%TYPE;
2354: lc_reason po_change_requests.request_reason%TYPE;
2355: lc_split varchar2(2000);
2356: l_global_agreement_flag po_headers_all.GLOBAL_AGREEMENT_FLAG%TYPE := 'F';

Line 2450: hr_locations_all hla, hz_locations hz,

2446: from
2447: po_change_requests pcr,
2448: po_lines_archive_all pla,
2449: po_line_locations_archive_all plla,
2450: hr_locations_all hla, hz_locations hz,
2451: mtl_system_items_kfv msi,
2452: mtl_planners mtp,
2453: financials_system_params_all fsp
2454: where pcr.change_request_group_id =grp_id

Line 2499: hr_locations_all hla, hz_locations hz,

2495: from
2496: po_change_requests pcr,
2497: po_lines_archive_all pla,
2498: po_line_locations_archive_all plla,
2499: hr_locations_all hla, hz_locations hz,
2500: mtl_system_items_kfv msi,
2501: mtl_planners mtp,
2502: financials_system_params_all fsp
2503: where pcr.change_request_group_id =grp_id

Line 2696: from hr_locations_all

2692: l_ship_addr_l3,
2693: l_ship_city,
2694: l_ship_state,
2695: l_ship_zip
2696: from hr_locations_all
2697: where location_id = l_ship_to_id;
2698: l_progress := '003';
2699:
2700: if(l_release_id is null) then

Line 3148: l_ship_addr_l1 hr_locations_all.address_line_1%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;
3148: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
3149: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
3150: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
3151: l_ship_city hr_locations_all.town_or_city%TYPE;
3152: l_ship_state hr_locations_all.region_1%TYPE;

Line 3149: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;

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;
3148: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
3149: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
3150: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
3151: l_ship_city hr_locations_all.town_or_city%TYPE;
3152: l_ship_state hr_locations_all.region_1%TYPE;
3153: l_ship_zip hr_locations_all.postal_code%TYPE;

Line 3150: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;

3146: l_carrier po_headers_all.ship_via_lookup_code%TYPE;
3147: l_ship_to_id number;
3148: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
3149: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
3150: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
3151: l_ship_city hr_locations_all.town_or_city%TYPE;
3152: l_ship_state hr_locations_all.region_1%TYPE;
3153: l_ship_zip hr_locations_all.postal_code%TYPE;
3154:

Line 3151: l_ship_city hr_locations_all.town_or_city%TYPE;

3147: l_ship_to_id number;
3148: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
3149: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
3150: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
3151: l_ship_city hr_locations_all.town_or_city%TYPE;
3152: l_ship_state hr_locations_all.region_1%TYPE;
3153: l_ship_zip hr_locations_all.postal_code%TYPE;
3154:
3155: l_document1 VARCHAR2(32000) := '';

Line 3152: l_ship_state hr_locations_all.region_1%TYPE;

3148: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
3149: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
3150: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
3151: l_ship_city hr_locations_all.town_or_city%TYPE;
3152: l_ship_state hr_locations_all.region_1%TYPE;
3153: l_ship_zip hr_locations_all.postal_code%TYPE;
3154:
3155: l_document1 VARCHAR2(32000) := '';
3156: l_base_url varchar2(2000);

Line 3153: l_ship_zip hr_locations_all.postal_code%TYPE;

3149: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
3150: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
3151: l_ship_city hr_locations_all.town_or_city%TYPE;
3152: l_ship_state hr_locations_all.region_1%TYPE;
3153: l_ship_zip hr_locations_all.postal_code%TYPE;
3154:
3155: l_document1 VARCHAR2(32000) := '';
3156: l_base_url varchar2(2000);
3157: l_base_url_tag varchar2(2000);

Line 3176: lc_ship_to_location hr_locations_all.location_code%TYPE;

3172: lc_new_price varchar2(2000);
3173: lc_action_type varchar2(2000);
3174: lc_item_desc po_lines_all.item_description%TYPE;
3175: lc_uom po_lines_all.unit_meas_lookup_code%TYPE;
3176: lc_ship_to_location hr_locations_all.location_code%TYPE;
3177: lc_action_code po_change_requests.ACTION_TYPE%TYPE;
3178: lc_reason po_change_requests.request_reason%TYPE;
3179: lc_split varchar2(2000);
3180: l_global_agreement_flag po_headers_all.GLOBAL_AGREEMENT_FLAG%TYPE;

Line 3268: hr_locations_all hla, hz_locations hz,

3264: from
3265: po_change_requests pcr,
3266: po_lines_archive_all pla,
3267: po_line_locations_archive_all plla,
3268: hr_locations_all hla, hz_locations hz,
3269: mtl_system_items_kfv msi,
3270: FINANCIALS_SYSTEM_PARAMS_ALL FSP
3271: where pcr.change_request_group_id =grp_id
3272: and pla.po_line_id = pcr.document_line_id

Line 3311: hr_locations_all hla, hz_locations hz,

3307: from
3308: po_change_requests pcr,
3309: po_lines_archive_all pla,
3310: po_line_locations_archive_all plla,
3311: hr_locations_all hla, hz_locations hz,
3312: mtl_system_items_kfv msi,
3313: FINANCIALS_SYSTEM_PARAMS_ALL FSP
3314: where pcr.change_request_group_id =grp_id
3315: and pla.po_line_id = pcr.document_line_id

Line 3373: hr_locations_all hla, hz_locations hz,

3369: from
3370: po_acceptances pa,
3371: po_lines_archive_all pla,
3372: po_line_locations_archive_all plla,
3373: hr_locations_all hla, hz_locations hz,
3374: mtl_system_items_kfv msi,
3375: FINANCIALS_SYSTEM_PARAMS_ALL FSP
3376: where plla.po_header_id = l_po_document_id
3377: and plla.po_line_id = pla.po_line_id

Line 3416: hr_locations_all hla, hz_locations hz,

3412: from
3413: po_acceptances pa,
3414: po_lines_archive_all pla,
3415: po_line_locations_archive_all plla,
3416: hr_locations_all hla, hz_locations hz,
3417: mtl_system_items_kfv msi,
3418: FINANCIALS_SYSTEM_PARAMS_ALL FSP
3419: where plla.po_release_id = l_rel_document_id
3420: and plla.po_line_id = pla.po_line_id

Line 3625: from hr_locations_all

3621: l_ship_addr_l3,
3622: l_ship_city,
3623: l_ship_state,
3624: l_ship_zip
3625: from hr_locations_all
3626: where location_id = l_ship_to_id;
3627: l_progress := '003';
3628:
3629: if(l_release_id is null) then

Line 4220: l_ship_addr_l1 hr_locations_all.address_line_1%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;
4220: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
4221: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
4222: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
4223: l_ship_city hr_locations_all.town_or_city%TYPE;
4224: l_ship_state hr_locations_all.region_1%TYPE;

Line 4221: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;

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;
4220: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
4221: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
4222: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
4223: l_ship_city hr_locations_all.town_or_city%TYPE;
4224: l_ship_state hr_locations_all.region_1%TYPE;
4225: l_ship_zip hr_locations_all.postal_code%TYPE;

Line 4222: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;

4218: l_carrier po_headers_all.ship_via_lookup_code%TYPE;
4219: l_ship_to_id number;
4220: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
4221: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
4222: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
4223: l_ship_city hr_locations_all.town_or_city%TYPE;
4224: l_ship_state hr_locations_all.region_1%TYPE;
4225: l_ship_zip hr_locations_all.postal_code%TYPE;
4226:

Line 4223: l_ship_city hr_locations_all.town_or_city%TYPE;

4219: l_ship_to_id number;
4220: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
4221: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
4222: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
4223: l_ship_city hr_locations_all.town_or_city%TYPE;
4224: l_ship_state hr_locations_all.region_1%TYPE;
4225: l_ship_zip hr_locations_all.postal_code%TYPE;
4226:
4227: l_base_url varchar2(2000);

Line 4224: l_ship_state hr_locations_all.region_1%TYPE;

4220: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
4221: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
4222: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
4223: l_ship_city hr_locations_all.town_or_city%TYPE;
4224: l_ship_state hr_locations_all.region_1%TYPE;
4225: l_ship_zip hr_locations_all.postal_code%TYPE;
4226:
4227: l_base_url varchar2(2000);
4228: l_base_url_tag varchar2(2000);

Line 4225: l_ship_zip hr_locations_all.postal_code%TYPE;

4221: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
4222: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
4223: l_ship_city hr_locations_all.town_or_city%TYPE;
4224: l_ship_state hr_locations_all.region_1%TYPE;
4225: l_ship_zip hr_locations_all.postal_code%TYPE;
4226:
4227: l_base_url varchar2(2000);
4228: l_base_url_tag varchar2(2000);
4229:

Line 4252: lc_ship_to_location hr_locations_all.location_code%TYPE;

4248: lc_new_price varchar2(2000);
4249: lc_response varchar2(2000);
4250: lc_item_desc po_lines_all.item_description%TYPE;
4251: lc_uom po_lines_all.unit_meas_lookup_code%TYPE;
4252: lc_ship_to_location hr_locations_all.location_code%TYPE;
4253: lc_reason po_change_requests.response_reason%TYPE;
4254: lc_split varchar2(2000);
4255:
4256:

Line 4326: hr_locations_all hla, hz_locations hz

4322: decode(pcr.parent_line_location_id, null, null, fnd_message.get_string('PO','PO_WF_NOTIF_YES')) SPLIT,
4323: pcr.action_type ACTION_CODE
4324:
4325: from po_change_requests pcr, po_lines_archive_all pla, po_line_locations_archive_all plla,
4326: hr_locations_all hla, hz_locations hz
4327: where change_request_group_id =grp_id
4328: and pla.po_line_id = pcr.document_line_id
4329: and pla.latest_external_flag = 'Y'
4330: and plla.line_location_id = pcr.document_line_location_id

Line 4361: hr_locations_all hla, hz_locations hz

4357: pcr.response_reason REASON,
4358: decode(pcr.parent_line_location_id, null, null, fnd_message.get_string('PO','PO_WF_NOTIF_YES')) SPLIT,
4359: pcr.action_type ACTION_CODE
4360: from po_change_requests pcr, po_lines_archive_all pla, po_line_locations_archive_all plla,
4361: hr_locations_all hla, hz_locations hz
4362: where change_request_group_id =grp_id
4363: and pla.po_line_id = pcr.document_line_id
4364: and pla.latest_external_flag = 'Y'
4365: and plla.line_location_id = pcr.parent_line_location_id

Line 4525: from hr_locations_all

4521: l_ship_addr_l3,
4522: l_ship_city,
4523: l_ship_state,
4524: l_ship_zip
4525: from hr_locations_all
4526: where location_id = l_ship_to_id;
4527: l_progress := '003';
4528: if (display_type = 'text/html') then
4529: