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.PJI_FM_PLAN_MAINT_PVT dependencies on PJI_XBS_DENORM

Line 1317: , pji_xbs_denorm den

1313: DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1314: FROM pji_pjp_proj_batch_map map
1315: , pji_fm_extr_plan_lines epl
1316: , pji_pjp_wbs_header hd2 -- SUB
1317: , pji_xbs_denorm den
1318: , pji_pjp_wbs_header hd9 -- SUP
1319: , PA_PROJ_ELEM_VER_STRUCTURE ppevs1
1320: , PA_PROJ_ELEM_VER_STRUCTURE ppevs2
1321: WHERE

Line 1355: , pji_xbs_denorm den

1351: SELECT /*+ ORDERED */
1352: DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1353: FROM pji_pjp_proj_batch_map map
1354: , pji_pjp_wbs_header hd1 -- SUB
1355: , pji_xbs_denorm den
1356: , pji_pjp_wbs_header hd9 -- SUP
1357: WHERE
1358: den.struct_version_id IS NULL
1359: AND hd1.wbs_version_id = den.sub_id -- struct_version_id

Line 1431: , pji_xbs_denorm den

1427: FROM
1428: pji_pjp_proj_batch_map map
1429: , pji_pa_proj_events_log ev
1430: , pji_pjp_wbs_header hd9 -- SUP
1431: , pji_xbs_denorm den
1432: , pji_pjp_wbs_header hd2 -- SUB
1433: WHERE
1434: den.struct_version_id IS NULL
1435: AND hd9.wbs_version_id = den.sub_id -- struct_version_id

Line 1488: FROM pji_xbs_denorm den

1484:
1485: INSERT INTO pji_fm_extr_plnver3_t
1486: (project_id, plan_version_id, plan_type_id)
1487: SELECT DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1488: FROM pji_xbs_denorm den
1489: , pji_pjp_wbs_header hd1 -- SUB
1490: , pji_pjp_proj_batch_map map
1491: , pji_pa_proj_events_log ev
1492: , pji_pjp_wbs_header hd9 -- SUP

Line 1530: , pji_xbs_denorm den

1526: DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1527: FROM pji_pjp_proj_batch_map map
1528: , pji_pa_proj_events_log ev
1529: -- , PA_BUDGET_VERSIONS bv
1530: , pji_xbs_denorm den
1531: , pji_pjp_wbs_header wh1 -- sup
1532: , pji_pjp_wbs_header hd9 -- SUb!!
1533: WHERE
1534: den.struct_version_id IS NULL

Line 1562: FROM pji_xbs_denorm den

1558:
1559: INSERT INTO pji_fm_extr_plnver3_t
1560: (project_id, plan_version_id, plan_type_id)
1561: SELECT DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1562: FROM pji_xbs_denorm den
1563: , pji_pjp_wbs_header hd2 -- SUB
1564: , pji_pjp_proj_batch_map map
1565: , pji_pa_proj_events_log ev
1566: , pji_pjp_wbs_header hd9 -- SUP

Line 1616: FROM pji_xbs_denorm den

1612:
1613: INSERT INTO pji_fm_extr_plnver3_t
1614: (project_id, plan_version_id, plan_type_id)
1615: SELECT DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1616: FROM pji_xbs_denorm den
1617: , pji_pjp_wbs_header hd1 -- SUB
1618: , pji_pjp_proj_batch_map map
1619: , pa_budget_versions bv
1620: , pji_pjp_wbs_header hd9 -- SUP

Line 2134: , pji_xbs_denorm den

2130: , 'Y' SECONDARY_RBS_FLAG
2131: , 'Y' lp_flag
2132: FROM
2133: pji_fm_extr_plnver4 hd2 -- sub
2134: , pji_xbs_denorm den
2135: , ( SELECT -3 plan_version_id FROM dual
2136: UNION ALL
2137: SELECT -4 plan_version_id FROM dual ) cbco
2138: WHERE

Line 3072: , pji_xbs_denorm den

3068: ) lp_flag
3069: FROM
3070: pji_pa_proj_events_log ev
3071: , pji_pjp_wbs_header hd1 -- sup
3072: , pji_xbs_denorm den
3073: , pji_pjp_wbs_header hd2 -- sub
3074: , pa_budget_versions bv
3075: , pa_proj_fp_options fpo
3076: WHERE l_RBS_PRG_exists = 'Y' /* Added for bug 8708651 */

Line 3144: , pji_xbs_denorm den

3140: ) lp_flag
3141: FROM
3142: PJI_PA_PROJ_EVENTS_LOG ev
3143: , pji_pjp_wbs_header hd1 -- sup
3144: , pji_xbs_denorm den
3145: , pji_pjp_wbs_header hd2 -- sub
3146: , pa_budget_versions bv
3147: , pa_proj_fp_options fpo
3148: , (SELECT -3 plan_version_id FROM DUAL

Line 3204: SELECT DISTINCT /+ NO_MERGE(fpo) use_nl(fpo map whsub den) index(den pji_xbs_denorm_n6) / -- 'PRG_CHANGE' event.

3200: , SECONDARY_RBS_FLAG
3201: , lp_flag
3202: FROM
3203: (
3204: SELECT DISTINCT /*+ NO_MERGE(fpo) use_nl(fpo map whsub den) index(den pji_xbs_denorm_n6) */ -- 'PRG_CHANGE' event.
3205: den.sup_project_id project_id
3206: , cbco.plan_version_id plan_version_id -- -3/-4
3207: -- , Pa_Project_Structure_Utils.GET_FIN_STRUC_VER_ID(den.sup_project_id) wbs_version_id
3208: , fpo.parvi rbs_version_id

Line 3595: , pji_xbs_denorm den

3591: ) lp_flag
3592: FROM
3593: pji_pa_proj_events_log ev
3594: , pji_pjp_wbs_header hd1 -- sup
3595: , pji_xbs_denorm den
3596: , pji_pjp_wbs_header hd2 -- sub
3597: , pa_budget_versions bv
3598: , pa_proj_fp_options fpo
3599: WHERE l_RBS_PRG_exists = 'Y' /* Added for bug 8708651 */

Line 3667: , pji_xbs_denorm den

3663: ) lp_flag
3664: FROM
3665: PJI_PA_PROJ_EVENTS_LOG ev
3666: , pji_pjp_wbs_header hd1 -- sup
3667: , pji_xbs_denorm den
3668: , pji_pjp_wbs_header hd2 -- sub
3669: , pa_budget_versions bv
3670: , pa_proj_fp_options fpo
3671: , (SELECT -3 plan_version_id FROM DUAL

Line 3727: SELECT DISTINCT /+ NO_MERGE(fpo) use_nl(fpo map whsub den) index(den pji_xbs_denorm_n6) / -- 'PRG_CHANGE' event.

3723: , SECONDARY_RBS_FLAG
3724: , lp_flag
3725: FROM
3726: (
3727: SELECT DISTINCT /*+ NO_MERGE(fpo) use_nl(fpo map whsub den) index(den pji_xbs_denorm_n6) */ -- 'PRG_CHANGE' event.
3728: den.sup_project_id project_id
3729: , cbco.plan_version_id plan_version_id -- -3/-4
3730: -- , Pa_Project_Structure_Utils.GET_FIN_STRUC_VER_ID(den.sup_project_id) wbs_struct_version_id
3731: , fpo.parvi rbs_struct_version_id

Line 3840: , pji_xbs_denorm den

3836: , 'Y' SECONDARY_RBS_FLAG
3837: , 'Y' lp_flag
3838: FROM
3839: pji_fm_extr_plnver4 hd2 -- sub
3840: , pji_xbs_denorm den
3841: , ( SELECT -3 plan_version_id FROM dual
3842: UNION ALL
3843: SELECT -4 plan_version_id FROM dual ) cbco
3844: WHERE hd2.baselined_flag = 'Y'