APPS.PJI_FM_PLAN_MAINT_PVT dependencies on PJI_XBS_DENORM

Line 1219: , pji_xbs_denorm den

1215: DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1216: FROM pji_pjp_proj_batch_map map
1217: , pji_fm_extr_plan_lines epl
1218: , pji_pjp_wbs_header hd2 -- SUB
1219: , pji_xbs_denorm den
1220: , pji_pjp_wbs_header hd9 -- SUP
1221: , PA_PROJ_ELEM_VER_STRUCTURE ppevs1
1222: , PA_PROJ_ELEM_VER_STRUCTURE ppevs2
1223: WHERE

Line 1257: , pji_xbs_denorm den

1253: SELECT /*+ ORDERED */
1254: DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1255: FROM pji_pjp_proj_batch_map map
1256: , pji_pjp_wbs_header hd1 -- SUB
1257: , pji_xbs_denorm den
1258: , pji_pjp_wbs_header hd9 -- SUP
1259: WHERE
1260: den.struct_version_id IS NULL
1261: AND hd1.wbs_version_id = den.sub_id -- struct_version_id

Line 1333: , pji_xbs_denorm den

1329: FROM
1330: pji_pjp_proj_batch_map map
1331: , pji_pa_proj_events_log ev
1332: , pji_pjp_wbs_header hd9 -- SUP
1333: , pji_xbs_denorm den
1334: , pji_pjp_wbs_header hd2 -- SUB
1335: WHERE
1336: den.struct_version_id IS NULL
1337: AND hd9.wbs_version_id = den.sub_id -- struct_version_id

Line 1389: FROM pji_xbs_denorm den

1385:
1386: INSERT INTO pji_fm_extr_plnver3_t
1387: (project_id, plan_version_id, plan_type_id)
1388: SELECT DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1389: FROM pji_xbs_denorm den
1390: , pji_pjp_wbs_header hd1 -- SUB
1391: , pji_pjp_proj_batch_map map
1392: , pji_pa_proj_events_log ev
1393: , pji_pjp_wbs_header hd9 -- SUP

Line 1431: , pji_xbs_denorm den

1427: DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1428: FROM pji_pjp_proj_batch_map map
1429: , pji_pa_proj_events_log ev
1430: -- , PA_BUDGET_VERSIONS bv
1431: , pji_xbs_denorm den
1432: , pji_pjp_wbs_header wh1 -- sup
1433: , pji_pjp_wbs_header hd9 -- SUb!!
1434: WHERE
1435: den.struct_version_id IS NULL

Line 1463: FROM pji_xbs_denorm den

1459:
1460: INSERT INTO pji_fm_extr_plnver3_t
1461: (project_id, plan_version_id, plan_type_id)
1462: SELECT DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1463: FROM pji_xbs_denorm den
1464: , pji_pjp_wbs_header hd2 -- SUB
1465: , pji_pjp_proj_batch_map map
1466: , pji_pa_proj_events_log ev
1467: , pji_pjp_wbs_header hd9 -- SUP

Line 1517: FROM pji_xbs_denorm den

1513:
1514: INSERT INTO pji_fm_extr_plnver3_t
1515: (project_id, plan_version_id, plan_type_id)
1516: SELECT DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1517: FROM pji_xbs_denorm den
1518: , pji_pjp_wbs_header hd1 -- SUB
1519: , pji_pjp_proj_batch_map map
1520: , pa_budget_versions bv
1521: , pji_pjp_wbs_header hd9 -- SUP

Line 1786: , pji_xbs_denorm den

1782: , 'Y' SECONDARY_RBS_FLAG
1783: , 'Y' lp_flag
1784: FROM
1785: pji_fm_extr_plnver4 hd2 -- sub
1786: , pji_xbs_denorm den
1787: , ( SELECT -3 plan_version_id FROM dual
1788: UNION ALL
1789: SELECT -4 plan_version_id FROM dual ) cbco
1790: WHERE

Line 2481: , pji_xbs_denorm den

2477: , pa_proj_fp_options fpo
2478: , pji_pa_proj_events_log ev
2479: , pji_pjp_wbs_header hd1 -- sup
2480: , pji_pjp_wbs_header hd2 -- sub
2481: , pji_xbs_denorm den
2482: WHERE bv.version_type IS NOT NULL
2483: AND bv.fin_plan_type_id IS NOT NULL
2484: AND fpo.project_id = bv.project_id
2485: AND bv.fin_plan_type_id = fpo.fin_plan_type_id

Line 2552: , pji_xbs_denorm den

2548: , pa_proj_fp_options fpo
2549: , PJI_PA_PROJ_EVENTS_LOG ev
2550: , pji_pjp_wbs_header hd1 -- sup
2551: , pji_pjp_wbs_header hd2 -- sub
2552: , pji_xbs_denorm den
2553: , (SELECT -3 plan_version_id FROM DUAL
2554: UNION ALL
2555: SELECT -4 plan_version_id FROM DUAL
2556: ) cbcov

Line 2721: , pji_xbs_denorm den

2717: , 'Y' SECONDARY_RBS_FLAG
2718: , 'Y' lp_flag
2719: FROM
2720: pji_fm_extr_plnver4 hd2 -- sub
2721: , pji_xbs_denorm den
2722: , ( SELECT -3 plan_version_id FROM dual
2723: UNION ALL
2724: SELECT -4 plan_version_id FROM dual ) cbco
2725: WHERE hd2.baselined_flag = 'Y'