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 FINANCIALS_SYSTEM_PARAMS_ALL

Line 1725: FINANCIALS_SYSTEM_PARAMS_ALL FSP

1721: from
1722: po_change_requests pcr,
1723: po_lines_archive_all pla,
1724: mtl_system_items_kfv msi,
1725: FINANCIALS_SYSTEM_PARAMS_ALL FSP
1726: where pla.po_line_id = pcr.document_line_id
1727: and pcr.change_request_group_id =grp_id
1728: and pcr.request_level = 'LINE'
1729: and pcr.request_status in ('PENDING','REQ_APP')

Line 1767: FINANCIALS_SYSTEM_PARAMS_ALL FSP

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
1770: and pla.latest_external_flag = 'Y'
1771: and plla.line_location_id = pcr.document_line_location_id

Line 1813: FINANCIALS_SYSTEM_PARAMS_ALL FSP

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
1816: and pla.latest_external_flag = 'Y'
1817: and plla.line_location_id = pcr.parent_line_location_id

Line 2559: financials_system_params_all fsp

2555: po_change_requests pcr,
2556: po_lines_archive_all pla,
2557: mtl_system_items_kfv msi,
2558: mtl_planners mtp,
2559: financials_system_params_all fsp
2560: where pla.po_line_id = pcr.document_line_id
2561: and pcr.change_request_group_id =grp_id
2562: and pcr.request_level = 'LINE'
2563: and pcr.request_status in ('PENDING','REQ_APP')

Line 2603: financials_system_params_all fsp

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
2605: and pla.po_line_id = pcr.document_line_id
2606: and pla.latest_external_flag = 'Y'
2607: and plla.line_location_id = pcr.document_line_location_id

Line 2652: financials_system_params_all fsp

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
2654: and pla.po_line_id = pcr.document_line_id
2655: and pla.latest_external_flag = 'Y'
2656: and plla.line_location_id = pcr.parent_line_location_id

Line 3383: FINANCIALS_SYSTEM_PARAMS_ALL FSP

3379: from
3380: po_change_requests pcr,
3381: po_lines_archive_all pla,
3382: mtl_system_items_kfv msi,
3383: FINANCIALS_SYSTEM_PARAMS_ALL FSP
3384: where pla.po_line_id = pcr.document_line_id
3385: and pcr.change_request_group_id =grp_id
3386: and pcr.request_level = 'LINE'
3387: and pcr.request_status = 'PENDING'

Line 3422: FINANCIALS_SYSTEM_PARAMS_ALL FSP

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
3425: and pla.latest_external_flag = 'Y'
3426: and plla.line_location_id = pcr.document_line_location_id

Line 3465: FINANCIALS_SYSTEM_PARAMS_ALL FSP

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
3468: and pla.latest_external_flag = 'Y'
3469: and plla.line_location_id = pcr.parent_line_location_id

Line 3527: FINANCIALS_SYSTEM_PARAMS_ALL FSP

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
3530: and pa.po_line_location_id = plla.line_location_id
3531: and hla.location_id(+) = plla.ship_to_location_id

Line 3570: FINANCIALS_SYSTEM_PARAMS_ALL FSP

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
3573: and pa.po_line_location_id = plla.line_location_id
3574: and hla.location_id(+) = plla.ship_to_location_id

Line 7629: financials_system_params_all fsp

7625: mtl_system_items msi,
7626: mtl_planners mtp,
7627: po_change_requests pcr,
7628: po_lines_all pla,
7629: financials_system_params_all fsp
7630: where pcr.change_request_group_id = grp_id
7631: and pcr.document_line_id = pla.po_line_id
7632: and pla.item_id = msi.inventory_item_id
7633: and pla.org_id = fsp.org_id

Line 8068: financials_system_params_all fsp,

8064: is
8065: select fr.responsibility_id,fu.user_id
8066: from wf_local_user_roles wur,
8067: fnd_responsibility fr,
8068: financials_system_params_all fsp,
8069: fnd_user fu
8070: where wur.user_name = fu.user_name
8071: and wur.role_orig_system = 'FND_RESP'
8072: and wur.role_orig_system_id = fr.responsibility_id

Line 8133: financials_system_params_all fsp

8129: select fr.responsibility_id
8130: into l_resp_id
8131: from wf_local_user_roles wur,
8132: fnd_responsibility fr,
8133: financials_system_params_all fsp
8134: where
8135: wur.role_orig_system = 'FND_RESP'
8136: and wur.role_orig_system_id = fr.responsibility_id
8137: and wur.partition_id = 2

Line 8192: financials_system_params_all fsp,

8188: select MIN(fr.responsibility_id)
8189: into l_resp_id
8190: from wf_local_user_roles wur,
8191: fnd_responsibility fr,
8192: financials_system_params_all fsp,
8193: fnd_user fu
8194: where wur.user_name = fu.user_name
8195: and fu.user_id = l_user_id
8196: and wur.role_orig_system = 'FND_RESP'

Line 8231: financials_system_params_all fsp,

8227: select MIN(fr.responsibility_id),fu.user_id
8228: into l_resp_id,l_user_id
8229: from wf_local_user_roles wur,
8230: fnd_responsibility fr,
8231: financials_system_params_all fsp,
8232: fnd_user fu
8233: where wur.user_name = fu.user_name
8234: and wur.role_orig_system = 'FND_RESP'
8235: and wur.role_orig_system_id = fr.responsibility_id