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.PA_FP_GEN_BUDGET_AMT_PUB dependencies on PA_MAP_WP_TO_FIN_TASKS_V

Line 4490: PA_MAP_WP_TO_FIN_TASKS_V V1

4486: NVL(V1.MAPPED_FIN_TASK_VERSION_ID,0) mapped_fin_task_version_id,
4487: MIN(T.TXN_PLANNING_START_DATE) txn_planning_start_date,
4488: MAX(T.TXN_PLANNING_END_DATE) txn_planning_end_date
4489: FROM PA_RES_LIST_MAP_TMP4 T,
4490: PA_MAP_WP_TO_FIN_TASKS_V V1
4491: WHERE NOT EXISTS
4492: (SELECT /*+ INDEX(T,PA_RES_LIST_MAP_TMP4_N1)*/ 1
4493: FROM PA_RESOURCE_ASSIGNMENTS P,PA_MAP_WP_TO_FIN_TASKS_V V
4494: WHERE P.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID

Line 4493: FROM PA_RESOURCE_ASSIGNMENTS P,PA_MAP_WP_TO_FIN_TASKS_V V

4489: FROM PA_RES_LIST_MAP_TMP4 T,
4490: PA_MAP_WP_TO_FIN_TASKS_V V1
4491: WHERE NOT EXISTS
4492: (SELECT /*+ INDEX(T,PA_RES_LIST_MAP_TMP4_N1)*/ 1
4493: FROM PA_RESOURCE_ASSIGNMENTS P,PA_MAP_WP_TO_FIN_TASKS_V V
4494: WHERE P.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
4495: AND V.PARENT_STRUCTURE_VERSION_ID = P_WP_STRUCTURE_VER_ID
4496: AND nvl(T.TXN_TASK_ID,0) = NVL(V.PROJ_ELEMENT_ID,0)
4497: AND P.PROJECT_ASSIGNMENT_ID = -1

Line 4537: PA_MAP_WP_TO_FIN_TASKS_V V1

4533: MIN(T.TXN_PLANNING_START_DATE),
4534: MAX(T.TXN_PLANNING_END_DATE)
4535: FROM PA_RES_LIST_MAP_TMP4 T,
4536: PA_TASKS PAT,
4537: PA_MAP_WP_TO_FIN_TASKS_V V1
4538: WHERE NVL(V1.MAPPED_FIN_TASK_ID,0) = PAT.TASK_ID (+)
4539: AND NOT EXISTS
4540: (SELECT /*+ INDEX(T,PA_RES_LIST_MAP_TMP4_N1)*/ 1
4541: FROM PA_RESOURCE_ASSIGNMENTS P,PA_TASKS TS,PA_MAP_WP_TO_FIN_TASKS_V V

Line 4541: FROM PA_RESOURCE_ASSIGNMENTS P,PA_TASKS TS,PA_MAP_WP_TO_FIN_TASKS_V V

4537: PA_MAP_WP_TO_FIN_TASKS_V V1
4538: WHERE NVL(V1.MAPPED_FIN_TASK_ID,0) = PAT.TASK_ID (+)
4539: AND NOT EXISTS
4540: (SELECT /*+ INDEX(T,PA_RES_LIST_MAP_TMP4_N1)*/ 1
4541: FROM PA_RESOURCE_ASSIGNMENTS P,PA_TASKS TS,PA_MAP_WP_TO_FIN_TASKS_V V
4542: WHERE P.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
4543: AND V.PARENT_STRUCTURE_VERSION_ID = P_WP_STRUCTURE_VER_ID
4544: AND NVL(T.TXN_TASK_ID,0) = NVL(V.PROJ_ELEMENT_ID,0)
4545: AND TS.TASK_ID(+) = NVL(V.MAPPED_FIN_TASK_ID,0)

Line 5331: PA_MAP_WP_TO_FIN_TASKS_V V

5327: NVL(T.TXN_TASK_ID,0) txn_task_id ,
5328: NVL(V.MAPPED_FIN_TASK_ID,0) mapped_fin_task_id
5329: FROM PA_RESOURCE_ASSIGNMENTS P,
5330: PA_RES_LIST_MAP_TMP4 T,
5331: PA_MAP_WP_TO_FIN_TASKS_V V
5332: WHERE P.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
5333: AND V.PARENT_STRUCTURE_VERSION_ID = P_WP_STRUCTURE_VER_ID
5334: AND NVL(T.TXN_TASK_ID,0) = NVL(V.PROJ_ELEMENT_ID,0)
5335: AND P.PROJECT_ASSIGNMENT_ID = -1

Line 5423: PA_MAP_WP_TO_FIN_TASKS_V V,

5419: NVL(T.TXN_TASK_ID,0) txn_task_id,
5420: NVL(V.MAPPED_FIN_TASK_ID,0) mapped_fin_task_id
5421: FROM PA_RESOURCE_ASSIGNMENTS P,
5422: PA_RES_LIST_MAP_TMP4 T,
5423: PA_MAP_WP_TO_FIN_TASKS_V V,
5424: PA_TASKS TS
5425: WHERE P.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
5426: AND V.PARENT_STRUCTURE_VERSION_ID = P_WP_STRUCTURE_VER_ID
5427: AND t.txn_task_id = v.PROJ_ELEMENT_ID