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 1644: l_ship_addr_l1 hr_locations_all.address_line_1%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;
1644: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
1645: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
1646: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
1647: l_ship_city hr_locations_all.town_or_city%TYPE;
1648: l_ship_state hr_locations_all.region_1%TYPE;

Line 1645: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;

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;
1644: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
1645: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
1646: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
1647: l_ship_city hr_locations_all.town_or_city%TYPE;
1648: l_ship_state hr_locations_all.region_1%TYPE;
1649: l_ship_zip hr_locations_all.postal_code%TYPE;

Line 1646: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;

1642: l_carrier po_headers_all.ship_via_lookup_code%TYPE;
1643: l_ship_to_id number;
1644: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
1645: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
1646: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
1647: l_ship_city hr_locations_all.town_or_city%TYPE;
1648: l_ship_state hr_locations_all.region_1%TYPE;
1649: l_ship_zip hr_locations_all.postal_code%TYPE;
1650: l_base_url varchar2(2000);

Line 1647: l_ship_city hr_locations_all.town_or_city%TYPE;

1643: l_ship_to_id number;
1644: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
1645: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
1646: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
1647: l_ship_city hr_locations_all.town_or_city%TYPE;
1648: l_ship_state hr_locations_all.region_1%TYPE;
1649: l_ship_zip hr_locations_all.postal_code%TYPE;
1650: l_base_url varchar2(2000);
1651: l_base_url_tag varchar2(2000);

Line 1648: l_ship_state hr_locations_all.region_1%TYPE;

1644: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
1645: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
1646: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
1647: l_ship_city hr_locations_all.town_or_city%TYPE;
1648: l_ship_state hr_locations_all.region_1%TYPE;
1649: l_ship_zip hr_locations_all.postal_code%TYPE;
1650: l_base_url varchar2(2000);
1651: l_base_url_tag varchar2(2000);
1652:

Line 1649: l_ship_zip hr_locations_all.postal_code%TYPE;

1645: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
1646: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
1647: l_ship_city hr_locations_all.town_or_city%TYPE;
1648: l_ship_state hr_locations_all.region_1%TYPE;
1649: l_ship_zip hr_locations_all.postal_code%TYPE;
1650: l_base_url varchar2(2000);
1651: l_base_url_tag varchar2(2000);
1652:
1653: l_document1 VARCHAR2(32000) := '';

Line 1670: lc_ship_to_location hr_locations_all.location_code%TYPE;

1666: lc_new_price varchar2(2000);
1667: lc_action_type varchar2(2000);
1668: lc_item_desc po_lines_all.item_description%TYPE;
1669: lc_uom po_lines_all.unit_meas_lookup_code%TYPE;
1670: lc_ship_to_location hr_locations_all.location_code%TYPE;
1671: lc_action_code po_change_requests.ACTION_TYPE%TYPE;
1672: lc_reason po_change_requests.request_reason%TYPE;
1673: lc_split varchar2(2000);
1674: l_global_agreement_flag po_headers_all.GLOBAL_AGREEMENT_FLAG%TYPE := 'F';

Line 1765: hr_locations_all hla, hz_locations hz,

1761: from
1762: po_change_requests pcr,
1763: po_lines_archive_all pla,
1764: po_line_locations_archive_all plla,
1765: hr_locations_all hla, hz_locations hz,
1766: mtl_system_items_kfv msi,
1767: FINANCIALS_SYSTEM_PARAMS_ALL FSP
1768: where pcr.change_request_group_id =grp_id
1769: and pla.po_line_id = pcr.document_line_id

Line 1811: hr_locations_all hla, hz_locations hz,

1807: from
1808: po_change_requests pcr,
1809: po_lines_archive_all pla,
1810: po_line_locations_archive_all plla,
1811: hr_locations_all hla, hz_locations hz,
1812: mtl_system_items_kfv msi,
1813: FINANCIALS_SYSTEM_PARAMS_ALL FSP
1814: where pcr.change_request_group_id =grp_id
1815: and pla.po_line_id = pcr.document_line_id

Line 2012: from hr_locations_all

2008: l_ship_addr_l3,
2009: l_ship_city,
2010: l_ship_state,
2011: l_ship_zip
2012: from hr_locations_all
2013: where location_id = l_ship_to_id;
2014: l_progress := '003';
2015:
2016: if(l_release_id is null) then

Line 2473: l_ship_addr_l1 hr_locations_all.address_line_1%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;
2473: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
2474: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
2475: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
2476: l_ship_city hr_locations_all.town_or_city%TYPE;
2477: l_ship_state hr_locations_all.region_1%TYPE;

Line 2474: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;

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;
2473: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
2474: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
2475: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
2476: l_ship_city hr_locations_all.town_or_city%TYPE;
2477: l_ship_state hr_locations_all.region_1%TYPE;
2478: l_ship_zip hr_locations_all.postal_code%TYPE;

Line 2475: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;

2471: l_carrier po_headers_all.ship_via_lookup_code%TYPE;
2472: l_ship_to_id number;
2473: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
2474: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
2475: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
2476: l_ship_city hr_locations_all.town_or_city%TYPE;
2477: l_ship_state hr_locations_all.region_1%TYPE;
2478: l_ship_zip hr_locations_all.postal_code%TYPE;
2479:

Line 2476: l_ship_city hr_locations_all.town_or_city%TYPE;

2472: l_ship_to_id number;
2473: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
2474: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
2475: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
2476: l_ship_city hr_locations_all.town_or_city%TYPE;
2477: l_ship_state hr_locations_all.region_1%TYPE;
2478: l_ship_zip hr_locations_all.postal_code%TYPE;
2479:
2480: l_document1 VARCHAR2(32000) := '';

Line 2477: l_ship_state hr_locations_all.region_1%TYPE;

2473: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
2474: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
2475: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
2476: l_ship_city hr_locations_all.town_or_city%TYPE;
2477: l_ship_state hr_locations_all.region_1%TYPE;
2478: l_ship_zip hr_locations_all.postal_code%TYPE;
2479:
2480: l_document1 VARCHAR2(32000) := '';
2481: l_base_url varchar2(2000);

Line 2478: l_ship_zip hr_locations_all.postal_code%TYPE;

2474: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
2475: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
2476: l_ship_city hr_locations_all.town_or_city%TYPE;
2477: l_ship_state hr_locations_all.region_1%TYPE;
2478: l_ship_zip hr_locations_all.postal_code%TYPE;
2479:
2480: l_document1 VARCHAR2(32000) := '';
2481: l_base_url varchar2(2000);
2482: l_base_url_tag varchar2(2000);

Line 2500: lc_ship_to_location hr_locations_all.location_code%TYPE;

2496: lc_new_price varchar2(2000);
2497: lc_action_type varchar2(2000);
2498: lc_item_desc po_lines_all.item_description%TYPE;
2499: lc_uom po_lines_all.unit_meas_lookup_code%TYPE;
2500: lc_ship_to_location hr_locations_all.location_code%TYPE;
2501: lc_action_code po_change_requests.ACTION_TYPE%TYPE;
2502: lc_reason po_change_requests.request_reason%TYPE;
2503: lc_split varchar2(2000);
2504: l_global_agreement_flag po_headers_all.GLOBAL_AGREEMENT_FLAG%TYPE := 'F';

Line 2600: hr_locations_all hla, hz_locations hz,

2596: from
2597: po_change_requests pcr,
2598: po_lines_archive_all pla,
2599: po_line_locations_archive_all plla,
2600: hr_locations_all hla, hz_locations hz,
2601: mtl_system_items_kfv msi,
2602: mtl_planners mtp,
2603: financials_system_params_all fsp
2604: where pcr.change_request_group_id =grp_id

Line 2649: hr_locations_all hla, hz_locations hz,

2645: from
2646: po_change_requests pcr,
2647: po_lines_archive_all pla,
2648: po_line_locations_archive_all plla,
2649: hr_locations_all hla, hz_locations hz,
2650: mtl_system_items_kfv msi,
2651: mtl_planners mtp,
2652: financials_system_params_all fsp
2653: where pcr.change_request_group_id =grp_id

Line 2848: from hr_locations_all

2844: l_ship_addr_l3,
2845: l_ship_city,
2846: l_ship_state,
2847: l_ship_zip
2848: from hr_locations_all
2849: where location_id = l_ship_to_id;
2850: l_progress := '003';
2851:
2852: if(l_release_id is null) then

Line 3300: l_ship_addr_l1 hr_locations_all.address_line_1%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;
3300: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
3301: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
3302: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
3303: l_ship_city hr_locations_all.town_or_city%TYPE;
3304: l_ship_state hr_locations_all.region_1%TYPE;

Line 3301: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;

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;
3300: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
3301: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
3302: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
3303: l_ship_city hr_locations_all.town_or_city%TYPE;
3304: l_ship_state hr_locations_all.region_1%TYPE;
3305: l_ship_zip hr_locations_all.postal_code%TYPE;

Line 3302: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;

3298: l_carrier po_headers_all.ship_via_lookup_code%TYPE;
3299: l_ship_to_id number;
3300: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
3301: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
3302: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
3303: l_ship_city hr_locations_all.town_or_city%TYPE;
3304: l_ship_state hr_locations_all.region_1%TYPE;
3305: l_ship_zip hr_locations_all.postal_code%TYPE;
3306:

Line 3303: l_ship_city hr_locations_all.town_or_city%TYPE;

3299: l_ship_to_id number;
3300: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
3301: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
3302: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
3303: l_ship_city hr_locations_all.town_or_city%TYPE;
3304: l_ship_state hr_locations_all.region_1%TYPE;
3305: l_ship_zip hr_locations_all.postal_code%TYPE;
3306:
3307: l_document1 VARCHAR2(32000) := '';

Line 3304: l_ship_state hr_locations_all.region_1%TYPE;

3300: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
3301: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
3302: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
3303: l_ship_city hr_locations_all.town_or_city%TYPE;
3304: l_ship_state hr_locations_all.region_1%TYPE;
3305: l_ship_zip hr_locations_all.postal_code%TYPE;
3306:
3307: l_document1 VARCHAR2(32000) := '';
3308: l_base_url varchar2(2000);

Line 3305: l_ship_zip hr_locations_all.postal_code%TYPE;

3301: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
3302: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
3303: l_ship_city hr_locations_all.town_or_city%TYPE;
3304: l_ship_state hr_locations_all.region_1%TYPE;
3305: l_ship_zip hr_locations_all.postal_code%TYPE;
3306:
3307: l_document1 VARCHAR2(32000) := '';
3308: l_base_url varchar2(2000);
3309: l_base_url_tag varchar2(2000);

Line 3328: lc_ship_to_location hr_locations_all.location_code%TYPE;

3324: lc_new_price varchar2(2000);
3325: lc_action_type varchar2(2000);
3326: lc_item_desc po_lines_all.item_description%TYPE;
3327: lc_uom po_lines_all.unit_meas_lookup_code%TYPE;
3328: lc_ship_to_location hr_locations_all.location_code%TYPE;
3329: lc_action_code po_change_requests.ACTION_TYPE%TYPE;
3330: lc_reason po_change_requests.request_reason%TYPE;
3331: lc_split varchar2(2000);
3332: l_global_agreement_flag po_headers_all.GLOBAL_AGREEMENT_FLAG%TYPE;

Line 3420: hr_locations_all hla, hz_locations hz,

3416: from
3417: po_change_requests pcr,
3418: po_lines_archive_all pla,
3419: po_line_locations_archive_all plla,
3420: hr_locations_all hla, hz_locations hz,
3421: mtl_system_items_kfv msi,
3422: FINANCIALS_SYSTEM_PARAMS_ALL FSP
3423: where pcr.change_request_group_id =grp_id
3424: and pla.po_line_id = pcr.document_line_id

Line 3463: hr_locations_all hla, hz_locations hz,

3459: from
3460: po_change_requests pcr,
3461: po_lines_archive_all pla,
3462: po_line_locations_archive_all plla,
3463: hr_locations_all hla, hz_locations hz,
3464: mtl_system_items_kfv msi,
3465: FINANCIALS_SYSTEM_PARAMS_ALL FSP
3466: where pcr.change_request_group_id =grp_id
3467: and pla.po_line_id = pcr.document_line_id

Line 3525: hr_locations_all hla, hz_locations hz,

3521: from
3522: po_acceptances pa,
3523: po_lines_archive_all pla,
3524: po_line_locations_archive_all plla,
3525: hr_locations_all hla, hz_locations hz,
3526: mtl_system_items_kfv msi,
3527: FINANCIALS_SYSTEM_PARAMS_ALL FSP
3528: where plla.po_header_id = l_po_document_id
3529: and plla.po_line_id = pla.po_line_id

Line 3568: hr_locations_all hla, hz_locations hz,

3564: from
3565: po_acceptances pa,
3566: po_lines_archive_all pla,
3567: po_line_locations_archive_all plla,
3568: hr_locations_all hla, hz_locations hz,
3569: mtl_system_items_kfv msi,
3570: FINANCIALS_SYSTEM_PARAMS_ALL FSP
3571: where plla.po_release_id = l_rel_document_id
3572: and plla.po_line_id = pla.po_line_id

Line 3777: from hr_locations_all

3773: l_ship_addr_l3,
3774: l_ship_city,
3775: l_ship_state,
3776: l_ship_zip
3777: from hr_locations_all
3778: where location_id = l_ship_to_id;
3779: l_progress := '003';
3780:
3781: if(l_release_id is null) then

Line 4372: l_ship_addr_l1 hr_locations_all.address_line_1%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;
4372: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
4373: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
4374: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
4375: l_ship_city hr_locations_all.town_or_city%TYPE;
4376: l_ship_state hr_locations_all.region_1%TYPE;

Line 4373: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;

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;
4372: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
4373: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
4374: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
4375: l_ship_city hr_locations_all.town_or_city%TYPE;
4376: l_ship_state hr_locations_all.region_1%TYPE;
4377: l_ship_zip hr_locations_all.postal_code%TYPE;

Line 4374: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;

4370: l_carrier po_headers_all.ship_via_lookup_code%TYPE;
4371: l_ship_to_id number;
4372: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
4373: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
4374: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
4375: l_ship_city hr_locations_all.town_or_city%TYPE;
4376: l_ship_state hr_locations_all.region_1%TYPE;
4377: l_ship_zip hr_locations_all.postal_code%TYPE;
4378:

Line 4375: l_ship_city hr_locations_all.town_or_city%TYPE;

4371: l_ship_to_id number;
4372: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
4373: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
4374: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
4375: l_ship_city hr_locations_all.town_or_city%TYPE;
4376: l_ship_state hr_locations_all.region_1%TYPE;
4377: l_ship_zip hr_locations_all.postal_code%TYPE;
4378:
4379: l_base_url varchar2(2000);

Line 4376: l_ship_state hr_locations_all.region_1%TYPE;

4372: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
4373: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
4374: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
4375: l_ship_city hr_locations_all.town_or_city%TYPE;
4376: l_ship_state hr_locations_all.region_1%TYPE;
4377: l_ship_zip hr_locations_all.postal_code%TYPE;
4378:
4379: l_base_url varchar2(2000);
4380: l_base_url_tag varchar2(2000);

Line 4377: l_ship_zip hr_locations_all.postal_code%TYPE;

4373: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
4374: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
4375: l_ship_city hr_locations_all.town_or_city%TYPE;
4376: l_ship_state hr_locations_all.region_1%TYPE;
4377: l_ship_zip hr_locations_all.postal_code%TYPE;
4378:
4379: l_base_url varchar2(2000);
4380: l_base_url_tag varchar2(2000);
4381:

Line 4404: lc_ship_to_location hr_locations_all.location_code%TYPE;

4400: lc_new_price varchar2(2000);
4401: lc_response varchar2(2000);
4402: lc_item_desc po_lines_all.item_description%TYPE;
4403: lc_uom po_lines_all.unit_meas_lookup_code%TYPE;
4404: lc_ship_to_location hr_locations_all.location_code%TYPE;
4405: lc_reason po_change_requests.response_reason%TYPE;
4406: lc_split varchar2(2000);
4407:
4408:

Line 4478: hr_locations_all hla, hz_locations hz

4474: decode(pcr.parent_line_location_id, null, null, fnd_message.get_string('PO','PO_WF_NOTIF_YES')) SPLIT,
4475: pcr.action_type ACTION_CODE
4476:
4477: from po_change_requests pcr, po_lines_archive_all pla, po_line_locations_archive_all plla,
4478: hr_locations_all hla, hz_locations hz
4479: where change_request_group_id =grp_id
4480: and pla.po_line_id = pcr.document_line_id
4481: and pla.latest_external_flag = 'Y'
4482: and plla.line_location_id = pcr.document_line_location_id

Line 4513: hr_locations_all hla, hz_locations hz

4509: pcr.response_reason REASON,
4510: decode(pcr.parent_line_location_id, null, null, fnd_message.get_string('PO','PO_WF_NOTIF_YES')) SPLIT,
4511: pcr.action_type ACTION_CODE
4512: from po_change_requests pcr, po_lines_archive_all pla, po_line_locations_archive_all plla,
4513: hr_locations_all hla, hz_locations hz
4514: where change_request_group_id =grp_id
4515: and pla.po_line_id = pcr.document_line_id
4516: and pla.latest_external_flag = 'Y'
4517: and plla.line_location_id = pcr.parent_line_location_id

Line 4677: from hr_locations_all

4673: l_ship_addr_l3,
4674: l_ship_city,
4675: l_ship_state,
4676: l_ship_zip
4677: from hr_locations_all
4678: where location_id = l_ship_to_id;
4679: l_progress := '003';
4680: if (display_type = 'text/html') then
4681: