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 HZ_LOCATIONS

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 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 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 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