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 1581: FINANCIALS_SYSTEM_PARAMS_ALL FSP

1577: from
1578: po_change_requests pcr,
1579: po_lines_archive_all pla,
1580: mtl_system_items_kfv msi,
1581: FINANCIALS_SYSTEM_PARAMS_ALL FSP
1582: where pla.po_line_id = pcr.document_line_id
1583: and pcr.change_request_group_id =grp_id
1584: and pcr.request_level = 'LINE'
1585: and pcr.request_status in ('PENDING','REQ_APP')

Line 1623: FINANCIALS_SYSTEM_PARAMS_ALL FSP

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

Line 1669: FINANCIALS_SYSTEM_PARAMS_ALL FSP

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

Line 2409: financials_system_params_all fsp

2405: po_change_requests pcr,
2406: po_lines_archive_all pla,
2407: mtl_system_items_kfv msi,
2408: mtl_planners mtp,
2409: financials_system_params_all fsp
2410: where pla.po_line_id = pcr.document_line_id
2411: and pcr.change_request_group_id =grp_id
2412: and pcr.request_level = 'LINE'
2413: and pcr.request_status in ('PENDING','REQ_APP')

Line 2453: financials_system_params_all fsp

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
2455: and pla.po_line_id = pcr.document_line_id
2456: and pla.latest_external_flag = 'Y'
2457: and plla.line_location_id = pcr.document_line_location_id

Line 2502: financials_system_params_all fsp

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
2504: and pla.po_line_id = pcr.document_line_id
2505: and pla.latest_external_flag = 'Y'
2506: and plla.line_location_id = pcr.parent_line_location_id

Line 3231: FINANCIALS_SYSTEM_PARAMS_ALL FSP

3227: from
3228: po_change_requests pcr,
3229: po_lines_archive_all pla,
3230: mtl_system_items_kfv msi,
3231: FINANCIALS_SYSTEM_PARAMS_ALL FSP
3232: where pla.po_line_id = pcr.document_line_id
3233: and pcr.change_request_group_id =grp_id
3234: and pcr.request_level = 'LINE'
3235: and pcr.request_status = 'PENDING'

Line 3270: FINANCIALS_SYSTEM_PARAMS_ALL FSP

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

Line 3313: FINANCIALS_SYSTEM_PARAMS_ALL FSP

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

Line 3375: FINANCIALS_SYSTEM_PARAMS_ALL FSP

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

Line 3418: FINANCIALS_SYSTEM_PARAMS_ALL FSP

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

Line 7471: financials_system_params_all fsp

7467: mtl_system_items msi,
7468: mtl_planners mtp,
7469: po_change_requests pcr,
7470: po_lines_all pla,
7471: financials_system_params_all fsp
7472: where pcr.change_request_group_id = grp_id
7473: and pcr.document_line_id = pla.po_line_id
7474: and pla.item_id = msi.inventory_item_id
7475: and pla.org_id = fsp.org_id

Line 7900: financials_system_params_all fsp,

7896: is
7897: select fr.responsibility_id,fu.user_id
7898: from wf_local_user_roles wur,
7899: fnd_responsibility fr,
7900: financials_system_params_all fsp,
7901: fnd_user fu
7902: where wur.user_name = fu.user_name
7903: and wur.role_orig_system = 'FND_RESP'
7904: and wur.role_orig_system_id = fr.responsibility_id

Line 7949: financials_system_params_all fsp,

7945: select MIN(fr.responsibility_id)
7946: into l_resp_id
7947: from wf_local_user_roles wur,
7948: fnd_responsibility fr,
7949: financials_system_params_all fsp,
7950: fnd_user fu
7951: where wur.user_name = fu.user_name
7952: and fu.user_id = l_user_id
7953: and wur.role_orig_system = 'FND_RESP'