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_LINE_LOCATIONS_ARCHIVE_ALL

Line 1764: po_line_locations_archive_all plla,

1760: null SPLIT
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

Line 1810: po_line_locations_archive_all plla,

1806: fnd_message.get_string('PO','PO_WF_NOTIF_YES') SPLIT
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

Line 2599: po_line_locations_archive_all plla,

2595: null SPLIT
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

Line 2648: po_line_locations_archive_all plla,

2644: fnd_message.get_string('PO','PO_WF_NOTIF_YES') SPLIT
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

Line 3419: po_line_locations_archive_all plla,

3415: null SPLIT
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

Line 3462: po_line_locations_archive_all plla,

3458: fnd_message.get_string('PO','PO_WF_NOTIF_YES') SPLIT
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

Line 3524: po_line_locations_archive_all plla,

3520: pa.note NOTE
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

Line 3537: from po_line_locations_archive_all plla2

3533: --and plla.latest_external_flag = 'Y'
3534: and pla.latest_external_flag = 'Y'
3535: and pa.revision_num = l_rev
3536: and plla.revision_num = (select max(revision_num)
3537: from po_line_locations_archive_all plla2
3538: where plla2.line_location_id = plla.line_location_id and
3539: plla.revision_num <= l_rev)
3540: and msi.inventory_item_id(+) = pla.item_id
3541: --and msi.organization_id(+) = pla.org_id

Line 3567: po_line_locations_archive_all plla,

3563: pa.NOTE NOTE
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

Line 3580: from po_line_locations_archive_all plla2

3576: --and plla.latest_external_flag = 'Y'
3577: and pla.latest_external_flag = 'Y'
3578: and pa.revision_num = l_rev
3579: and plla.revision_num = (select max(revision_num)
3580: from po_line_locations_archive_all plla2
3581: where plla2.line_location_id = plla.line_location_id and
3582: plla.revision_num <= l_rev)
3583: and msi.inventory_item_id(+) = pla.item_id
3584: --and msi.organization_id(+) = pla.org_id

Line 4477: from po_change_requests pcr, po_lines_archive_all pla, po_line_locations_archive_all plla,

4473: pcr.response_reason REASON,
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'

Line 4512: from po_change_requests pcr, po_lines_archive_all pla, po_line_locations_archive_all plla,

4508: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION,
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'