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.

[Home] [Help]

APPS.PJI_PJP_PRG_PERF_ALL dependencies on PJI_FP_XBS_ACCUM_F

Line 2337: WHERE table_name = 'PJI_FP_XBS_ACCUM_F'

2333: /* Added for Bug 13813361 Start */
2334: IF PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then
2335: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
2336: FROM dba_indexes
2337: WHERE table_name = 'PJI_FP_XBS_ACCUM_F'
2338: AND table_owner = l_pji_schema ) LOOP
2339: EXECUTE IMMEDIATE 'ALTER INDEX '||ind_lp.ind_name||' UNUSABLE';
2340:
2341: END LOOP;

Line 2345: INSERT /+ append parallel(rl) / INTO pji_fp_xbs_accum_f rl

2341: END LOOP;
2342: END IF;
2343: /* Added for Bug 13813361 End */
2344:
2345: INSERT /*+ append parallel(rl) */ INTO pji_fp_xbs_accum_f rl
2346: (
2347: PROJECT_ID
2348: , PROJECT_ORG_ID
2349: , PROJECT_ORGANIZATION_ID

Line 2510: WHERE table_name = 'PJI_FP_XBS_ACCUM_F'

2506: /* Added for Bug 13813361 Start */
2507: IF PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then
2508: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
2509: FROM dba_indexes
2510: WHERE table_name = 'PJI_FP_XBS_ACCUM_F'
2511: AND table_owner = l_pji_schema ) LOOP
2512: EXECUTE IMMEDIATE 'ALTER INDEX '||ind_lp.ind_name||' REBUILD PARALLEL';
2513: END LOOP;
2514: END IF;

Line 2538: INSERT /+ append parallel(rl) / INTO pji_fp_xbs_accum_f rl

2534:
2535: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
2536: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME; /* Added for Bug 13813361 */
2537:
2538: INSERT /*+ append parallel(rl) */ INTO pji_fp_xbs_accum_f rl
2539: (
2540: PROJECT_ID
2541: , PROJECT_ORG_ID
2542: , PROJECT_ORGANIZATION_ID

Line 4356: pji_fp_xbs_accum_f fact,

4352: ,TO_DATE(NULL) END_DATE
4353: ,g_default_prg_level PRG_LEVEL
4354: , fact.plan_type_code plan_type_code
4355: FROM
4356: pji_fp_xbs_accum_f fact,
4357: pji_fm_extr_plnver4 ver,
4358: pa_proj_fp_options fp
4359: WHERE fact.plan_version_id=ver.plan_version_id
4360: AND fact.project_id = fp.project_id

Line 4525: p_tabname => 'PJI_FP_XBS_ACCUM_F',

4521: p_partname=>'P'|| g_worker_id,
4522: p_percent => 10);
4523:
4524: GATHER_TEMP_STATS1(p_ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
4525: p_tabname => 'PJI_FP_XBS_ACCUM_F',
4526: p_partname=> NULL,
4527: p_percent => 10);
4528:
4529: IF UPPER(FND_PROFILE.VALUE('PJI_SUM_CLEANALL')) = 'Y' THEN

Line 4533: /* Disable Indexes PJI_FP_XBS_ACCUM_F*/

4529: IF UPPER(FND_PROFILE.VALUE('PJI_SUM_CLEANALL')) = 'Y' THEN
4530: /* Clear temporary table */
4531: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(PJI_UTILS.GET_PJI_SCHEMA_NAME, 'PJI_MERGE_HELPER','NORMAL','P'||g_worker_id);
4532:
4533: /* Disable Indexes PJI_FP_XBS_ACCUM_F*/
4534: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
4535: , partitioned
4536: FROM dba_indexes
4537: WHERE table_name = 'PJI_FP_XBS_ACCUM_F'

Line 4537: WHERE table_name = 'PJI_FP_XBS_ACCUM_F'

4533: /* Disable Indexes PJI_FP_XBS_ACCUM_F*/
4534: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
4535: , partitioned
4536: FROM dba_indexes
4537: WHERE table_name = 'PJI_FP_XBS_ACCUM_F'
4538: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME
4539: AND status <> 'UNUSABLE') LOOP
4540:
4541: IF ind_lp.partitioned = 'YES' THEN

Line 4913: , pji_fp_xbs_accum_f fact

4909: AND NVL(tmp.plan_type_id,-1) = NVL(ver3.plan_type_id, -1) -- each plan type can have a different -3, -4 slice.
4910: AND ver3.plan_type_code = tmp.plan_type_code
4911: AND tmp.RATE_DANGLING_FLAG IS NULL
4912: AND tmp.TIME_DANGLING_FLAG IS NULL ) pjp1
4913: , pji_fp_xbs_accum_f fact
4914: WHERE pjp1.project_id = fact.project_id(+)
4915: AND pjp1.plan_version_id = fact.plan_version_id(+)
4916: AND pjp1.project_element_id = fact.project_element_id(+)
4917: AND pjp1.time_id = fact.time_id(+)

Line 4945: FROM pji_fp_xbs_accum_f fact

4941: 'PARTITION',
4942: 'P' || g_worker_id);
4943:
4944: DELETE /*+ rowid(fact) parallel(fact) */
4945: FROM pji_fp_xbs_accum_f fact
4946: WHERE EXISTS (SELECT /*+ parallel(pmh) use_hash(pmh)*/
4947: NULL
4948: FROM pji_merge_helper pmh
4949: WHERE fact.rowid = pmh.fact_row_id

Line 4959: /* Rebuild indexes on PJI_FP_XBS_ACCUM_F*/

4955: INSERT_INTO_FP_FACT1;
4956:
4957: COMMIT;
4958:
4959: /* Rebuild indexes on PJI_FP_XBS_ACCUM_F*/
4960: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
4961: , partitioned
4962: FROM dba_indexes
4963: WHERE table_name = 'PJI_FP_XBS_ACCUM_F'

Line 4963: WHERE table_name = 'PJI_FP_XBS_ACCUM_F'

4959: /* Rebuild indexes on PJI_FP_XBS_ACCUM_F*/
4960: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
4961: , partitioned
4962: FROM dba_indexes
4963: WHERE table_name = 'PJI_FP_XBS_ACCUM_F'
4964: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME) LOOP
4965:
4966: IF ind_lp.partitioned = 'YES' THEN
4967: EXECUTE IMMEDIATE 'ALTER INDEX '||ind_lp.ind_name||' REBUILD PARTITION P'||g_worker_id||' PARALLEL';

Line 5022: MERGE /+ parallel(fact) parallel(pjp1) / INTO PJI_FP_XBS_ACCUM_F fact

5018: IF l_pji_rowid_tab.COUNT > 0 THEN
5019:
5020: FOR i IN l_pji_rowid_tab.FIRST .. l_pji_rowid_tab.LAST LOOP
5021:
5022: MERGE /*+ parallel(fact) parallel(pjp1) */ INTO PJI_FP_XBS_ACCUM_F fact
5023: USING ( SELECT
5024: tmp.worker_id
5025: , tmp.PROJECT_ID
5026: , tmp.PROJECT_ORG_ID

Line 5430: -- Put indexes back PJI_FP_XBS_ACCUM_F

5426: WHEN OTHERS THEN
5427: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
5428: p_procedure_name => 'MERGE_INTO_FP_FACTS');
5429:
5430: -- Put indexes back PJI_FP_XBS_ACCUM_F
5431: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
5432: , partitioned
5433: FROM dba_indexes
5434: WHERE table_name = 'PJI_FP_XBS_ACCUM_F'

Line 5434: WHERE table_name = 'PJI_FP_XBS_ACCUM_F'

5430: -- Put indexes back PJI_FP_XBS_ACCUM_F
5431: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
5432: , partitioned
5433: FROM dba_indexes
5434: WHERE table_name = 'PJI_FP_XBS_ACCUM_F'
5435: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME) LOOP
5436:
5437: IF ind_lp.partitioned = 'YES' THEN
5438: EXECUTE IMMEDIATE 'ALTER INDEX '||ind_lp.ind_name||' REBUILD PARTITION P'||g_worker_id||' PARALLEL';

Line 6113: PJI_FP_XBS_ACCUM_F fpr

6109: - fpr.custom14 CUSTOM14,
6110: - fpr.custom15 CUSTOM15 /* Modified for Bug 8271578 End */
6111: from
6112: PJI_PJP_PROJ_BATCH_MAP map,
6113: PJI_FP_XBS_ACCUM_F fpr
6114: where
6115: l_extraction_type = 'INCREMENTAL' and
6116: map.WORKER_ID = p_worker_id and
6117: map.EXTRACTION_TYPE = 'M' and

Line 6204: PJI_FP_XBS_ACCUM_F fpr

6200: - fpr.CUSTOM14 CUSTOM14,
6201: - fpr.CUSTOM15 CUSTOM15
6202: from
6203: PJI_FM_EXTR_PLNVER3_T map,
6204: PJI_FP_XBS_ACCUM_F fpr
6205: where
6206: l_extraction_type = 'PARTIAL' and
6207: map.WORKER_ID = p_worker_id and
6208: fpr.PROJECT_ID = map.PROJECT_ID and

Line 6804: INDEX(@"SEL$19" "FPR"@"SEL$19" ("PJI_FP_XBS_ACCUM_F"."PROJECT_ID" "PJI_FP_XBS_ACCUM_F"."PLAN_VERSION_ID" "PJI_FP_XBS_ACCUM_F"."PROJECT_ELEMENT_ID" "PJI_FP_XBS_ACCUM_F"."TIME_ID" "PJI_FP_XBS_ACCUM_F"."RBS_VERSION_ID"))

6800: FULL(@"SEL$19" "LOG"@"SEL$19")
6801: INDEX(@"SEL$19" "WBS_HDR"@"SEL$19" ("PJI_PJP_WBS_HEADER"."PROJECT_ID" "PJI_PJP_WBS_HEADER"."PLAN_VERSION_ID"))
6802: FULL(@"SEL$19" "WBS"@"SEL$19")
6803: INDEX_RS_ASC(@"SEL$19" "PRG"@"SEL$19" ("PJI_XBS_DENORM"."SUP_PROJECT_ID"))
6804: INDEX(@"SEL$19" "FPR"@"SEL$19" ("PJI_FP_XBS_ACCUM_F"."PROJECT_ID" "PJI_FP_XBS_ACCUM_F"."PLAN_VERSION_ID" "PJI_FP_XBS_ACCUM_F"."PROJECT_ELEMENT_ID" "PJI_FP_XBS_ACCUM_F"."TIME_ID" "PJI_FP_XBS_ACCUM_F"."RBS_VERSION_ID"))
6805: NO_ACCESS(@"SEL$19" "FIN_PLAN"@"SEL$19")
6806: NO_ACCESS(@"SEL$19" "TOP_SLICE"@"SEL$19")
6807: LEADING(@"SEL$19" "LOG"@"SEL$19" "WBS_HDR"@"SEL$19" "WBS"@"SEL$19" "PRG"@"SEL$19" "FPR"@"SEL$19" "FIN_PLAN"@"SEL$19" "TOP_SLICE"@"SEL$19")
6808: USE_NL(@"SEL$19" "WBS_HDR"@"SEL$19")

Line 7843: index(fpr PJI_FP_XBS_ACCUM_F_N1) */

7839: wbs_hdr.CB_FLAG = fin_plan.CB_FLAG (+) and
7840: wbs_hdr.CO_FLAG = fin_plan.CO_FLAG (+)
7841: union all
7842: select /*+ ordered
7843: index(fpr PJI_FP_XBS_ACCUM_F_N1) */
7844: -- get delta task level amounts from Reporting Lines
7845: to_char(null) LINE_TYPE,
7846: wbs_hdr.WBS_VERSION_ID,
7847: decode(wbs_hdr.WP_FLAG, 'Y', 'LW', 'LF') RELATIONSHIP_TYPE,

Line 7945: PJI_FP_XBS_ACCUM_F fpr,

7941: PJI_PA_PROJ_EVENTS_LOG log,
7942: PJI_PJP_WBS_HEADER wbs_hdr,
7943: PJI_XBS_DENORM_DELTA wbs,
7944: PJI_XBS_DENORM prg,
7945: PJI_FP_XBS_ACCUM_F fpr,
7946: (
7947: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
7948: from DUAL union all
7949: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 8298: INDEX(@"SEL$19" "FPR"@"SEL$19" ("PJI_FP_XBS_ACCUM_F"."PROJECT_ID" "PJI_FP_XBS_ACCUM_F"."PLAN_VERSION_ID" "PJI_FP_XBS_ACCUM_F"."PROJECT_ELEMENT_ID" "PJI_FP_XBS_ACCUM_F"."TIME_ID" "PJI_FP_XBS_ACCUM_F"."RBS_VERSION_ID"))

8294: FULL(@"SEL$19" "LOG"@"SEL$19")
8295: INDEX(@"SEL$19" "WBS_HDR"@"SEL$19" ("PJI_PJP_WBS_HEADER"."PROJECT_ID" "PJI_PJP_WBS_HEADER"."PLAN_VERSION_ID"))
8296: FULL(@"SEL$19" "WBS"@"SEL$19")
8297: INDEX_RS_ASC(@"SEL$19" "PRG"@"SEL$19" ("PJI_XBS_DENORM"."SUP_PROJECT_ID"))
8298: INDEX(@"SEL$19" "FPR"@"SEL$19" ("PJI_FP_XBS_ACCUM_F"."PROJECT_ID" "PJI_FP_XBS_ACCUM_F"."PLAN_VERSION_ID" "PJI_FP_XBS_ACCUM_F"."PROJECT_ELEMENT_ID" "PJI_FP_XBS_ACCUM_F"."TIME_ID" "PJI_FP_XBS_ACCUM_F"."RBS_VERSION_ID"))
8299: NO_ACCESS(@"SEL$19" "FIN_PLAN"@"SEL$19")
8300: NO_ACCESS(@"SEL$19" "TOP_SLICE"@"SEL$19")
8301: LEADING(@"SEL$19" "LOG"@"SEL$19" "WBS_HDR"@"SEL$19" "WBS"@"SEL$19" "PRG"@"SEL$19" "FPR"@"SEL$19" "FIN_PLAN"@"SEL$19" "TOP_SLICE"@"SEL$19")
8302: USE_NL(@"SEL$19" "WBS_HDR"@"SEL$19")

Line 9337: index(fpr PJI_FP_XBS_ACCUM_F_N1) */

9333: wbs_hdr.CB_FLAG = fin_plan.CB_FLAG (+) and
9334: wbs_hdr.CO_FLAG = fin_plan.CO_FLAG (+)
9335: union all
9336: select /*+ ordered
9337: index(fpr PJI_FP_XBS_ACCUM_F_N1) */
9338: -- get delta task level amounts from Reporting Lines
9339: to_char(null) LINE_TYPE,
9340: wbs_hdr.WBS_VERSION_ID,
9341: decode(wbs_hdr.WP_FLAG, 'Y', 'LW', 'LF') RELATIONSHIP_TYPE,

Line 9439: PJI_FP_XBS_ACCUM_F fpr,

9435: PJI_PA_PROJ_EVENTS_LOG log,
9436: PJI_PJP_WBS_HEADER wbs_hdr,
9437: PJI_XBS_DENORM_DELTA wbs,
9438: PJI_XBS_DENORM prg,
9439: PJI_FP_XBS_ACCUM_F fpr,
9440: (
9441: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9442: from DUAL union all
9443: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 9792: INDEX(@"SEL$19" "FPR"@"SEL$19" ("PJI_FP_XBS_ACCUM_F"."PROJECT_ID" "PJI_FP_XBS_ACCUM_F"."PLAN_VERSION_ID" "PJI_FP_XBS_ACCUM_F"."PROJECT_ELEMENT_ID" "PJI_FP_XBS_ACCUM_F"."TIME_ID" "PJI_FP_XBS_ACCUM_F"."RBS_VERSION_ID"))

9788: FULL(@"SEL$19" "LOG"@"SEL$19")
9789: INDEX(@"SEL$19" "WBS_HDR"@"SEL$19" ("PJI_PJP_WBS_HEADER"."PROJECT_ID" "PJI_PJP_WBS_HEADER"."PLAN_VERSION_ID"))
9790: FULL(@"SEL$19" "WBS"@"SEL$19")
9791: INDEX_RS_ASC(@"SEL$19" "PRG"@"SEL$19" ("PJI_XBS_DENORM"."SUP_PROJECT_ID"))
9792: INDEX(@"SEL$19" "FPR"@"SEL$19" ("PJI_FP_XBS_ACCUM_F"."PROJECT_ID" "PJI_FP_XBS_ACCUM_F"."PLAN_VERSION_ID" "PJI_FP_XBS_ACCUM_F"."PROJECT_ELEMENT_ID" "PJI_FP_XBS_ACCUM_F"."TIME_ID" "PJI_FP_XBS_ACCUM_F"."RBS_VERSION_ID"))
9793: NO_ACCESS(@"SEL$19" "FIN_PLAN"@"SEL$19")
9794: NO_ACCESS(@"SEL$19" "TOP_SLICE"@"SEL$19")
9795: LEADING(@"SEL$19" "LOG"@"SEL$19" "WBS_HDR"@"SEL$19" "WBS"@"SEL$19" "PRG"@"SEL$19" "FPR"@"SEL$19" "FIN_PLAN"@"SEL$19" "TOP_SLICE"@"SEL$19")
9796: USE_NL(@"SEL$19" "WBS_HDR"@"SEL$19")

Line 10831: index(fpr PJI_FP_XBS_ACCUM_F_N1) */

10827: wbs_hdr.CB_FLAG = fin_plan.CB_FLAG (+) and
10828: wbs_hdr.CO_FLAG = fin_plan.CO_FLAG (+)
10829: union all
10830: select /*+ ordered
10831: index(fpr PJI_FP_XBS_ACCUM_F_N1) */
10832: -- get delta task level amounts from Reporting Lines
10833: to_char(null) LINE_TYPE,
10834: wbs_hdr.WBS_VERSION_ID,
10835: decode(wbs_hdr.WP_FLAG, 'Y', 'LW', 'LF') RELATIONSHIP_TYPE,

Line 10933: PJI_FP_XBS_ACCUM_F fpr,

10929: PJI_PA_PROJ_EVENTS_LOG log,
10930: PJI_PJP_WBS_HEADER wbs_hdr,
10931: PJI_XBS_DENORM_DELTA wbs,
10932: PJI_XBS_DENORM prg,
10933: PJI_FP_XBS_ACCUM_F fpr,
10934: (
10935: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10936: from DUAL union all
10937: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 11285: INDEX(@"SEL$19" "FPR"@"SEL$19" ("PJI_FP_XBS_ACCUM_F"."PROJECT_ID" "PJI_FP_XBS_ACCUM_F"."PLAN_VERSION_ID" "PJI_FP_XBS_ACCUM_F"."PROJECT_ELEMENT_ID" "PJI_FP_XBS_ACCUM_F"."TIME_ID" "PJI_FP_XBS_ACCUM_F"."RBS_VERSION_ID"))

11281: FULL(@"SEL$19" "LOG"@"SEL$19")
11282: INDEX(@"SEL$19" "WBS_HDR"@"SEL$19" ("PJI_PJP_WBS_HEADER"."PROJECT_ID" "PJI_PJP_WBS_HEADER"."PLAN_VERSION_ID"))
11283: FULL(@"SEL$19" "WBS"@"SEL$19")
11284: INDEX_RS_ASC(@"SEL$19" "PRG"@"SEL$19" ("PJI_XBS_DENORM"."SUP_PROJECT_ID"))
11285: INDEX(@"SEL$19" "FPR"@"SEL$19" ("PJI_FP_XBS_ACCUM_F"."PROJECT_ID" "PJI_FP_XBS_ACCUM_F"."PLAN_VERSION_ID" "PJI_FP_XBS_ACCUM_F"."PROJECT_ELEMENT_ID" "PJI_FP_XBS_ACCUM_F"."TIME_ID" "PJI_FP_XBS_ACCUM_F"."RBS_VERSION_ID"))
11286: NO_ACCESS(@"SEL$19" "FIN_PLAN"@"SEL$19")
11287: NO_ACCESS(@"SEL$19" "TOP_SLICE"@"SEL$19")
11288: LEADING(@"SEL$19" "LOG"@"SEL$19" "WBS_HDR"@"SEL$19" "WBS"@"SEL$19" "PRG"@"SEL$19" "FPR"@"SEL$19" "FIN_PLAN"@"SEL$19" "TOP_SLICE"@"SEL$19")
11289: USE_NL(@"SEL$19" "WBS_HDR"@"SEL$19")

Line 12324: index(fpr PJI_FP_XBS_ACCUM_F_N1) */

12320: wbs_hdr.CB_FLAG = fin_plan.CB_FLAG (+) and
12321: wbs_hdr.CO_FLAG = fin_plan.CO_FLAG (+)
12322: union all
12323: select /*+ ordered
12324: index(fpr PJI_FP_XBS_ACCUM_F_N1) */
12325: -- get delta task level amounts from Reporting Lines
12326: to_char(null) LINE_TYPE,
12327: wbs_hdr.WBS_VERSION_ID,
12328: decode(wbs_hdr.WP_FLAG, 'Y', 'LW', 'LF') RELATIONSHIP_TYPE,

Line 12426: PJI_FP_XBS_ACCUM_F fpr,

12422: PJI_PA_PROJ_EVENTS_LOG log,
12423: PJI_PJP_WBS_HEADER wbs_hdr,
12424: PJI_XBS_DENORM_DELTA wbs,
12425: PJI_XBS_DENORM prg,
12426: PJI_FP_XBS_ACCUM_F fpr,
12427: (
12428: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12429: from DUAL union all
12430: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 12779: INDEX(@"SEL$19" "FPR"@"SEL$19" ("PJI_FP_XBS_ACCUM_F"."PROJECT_ID" "PJI_FP_XBS_ACCUM_F"."PLAN_VERSION_ID" "PJI_FP_XBS_ACCUM_F"."PROJECT_ELEMENT_ID" "PJI_FP_XBS_ACCUM_F"."TIME_ID" "PJI_FP_XBS_ACCUM_F"."RBS_VERSION_ID"))

12775: FULL(@"SEL$19" "LOG"@"SEL$19")
12776: INDEX(@"SEL$19" "WBS_HDR"@"SEL$19" ("PJI_PJP_WBS_HEADER"."PROJECT_ID" "PJI_PJP_WBS_HEADER"."PLAN_VERSION_ID"))
12777: FULL(@"SEL$19" "WBS"@"SEL$19")
12778: INDEX_RS_ASC(@"SEL$19" "PRG"@"SEL$19" ("PJI_XBS_DENORM"."SUP_PROJECT_ID"))
12779: INDEX(@"SEL$19" "FPR"@"SEL$19" ("PJI_FP_XBS_ACCUM_F"."PROJECT_ID" "PJI_FP_XBS_ACCUM_F"."PLAN_VERSION_ID" "PJI_FP_XBS_ACCUM_F"."PROJECT_ELEMENT_ID" "PJI_FP_XBS_ACCUM_F"."TIME_ID" "PJI_FP_XBS_ACCUM_F"."RBS_VERSION_ID"))
12780: NO_ACCESS(@"SEL$19" "FIN_PLAN"@"SEL$19")
12781: NO_ACCESS(@"SEL$19" "TOP_SLICE"@"SEL$19")
12782: LEADING(@"SEL$19" "LOG"@"SEL$19" "WBS_HDR"@"SEL$19" "WBS"@"SEL$19" "PRG"@"SEL$19" "FPR"@"SEL$19" "FIN_PLAN"@"SEL$19" "TOP_SLICE"@"SEL$19")
12783: USE_NL(@"SEL$19" "WBS_HDR"@"SEL$19")

Line 13818: index(fpr PJI_FP_XBS_ACCUM_F_N1) */

13814: wbs_hdr.CB_FLAG = fin_plan.CB_FLAG (+) and
13815: wbs_hdr.CO_FLAG = fin_plan.CO_FLAG (+)
13816: union all
13817: select /*+ ordered
13818: index(fpr PJI_FP_XBS_ACCUM_F_N1) */
13819: -- get delta task level amounts from Reporting Lines
13820: to_char(null) LINE_TYPE,
13821: wbs_hdr.WBS_VERSION_ID,
13822: decode(wbs_hdr.WP_FLAG, 'Y', 'LW', 'LF') RELATIONSHIP_TYPE,

Line 13920: PJI_FP_XBS_ACCUM_F fpr,

13916: PJI_PA_PROJ_EVENTS_LOG log,
13917: PJI_PJP_WBS_HEADER wbs_hdr,
13918: PJI_XBS_DENORM_DELTA wbs,
13919: PJI_XBS_DENORM prg,
13920: PJI_FP_XBS_ACCUM_F fpr,
13921: (
13922: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13923: from DUAL union all
13924: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 14272: INDEX(@"SEL$19" "FPR"@"SEL$19" ("PJI_FP_XBS_ACCUM_F"."PROJECT_ID" "PJI_FP_XBS_ACCUM_F"."PLAN_VERSION_ID" "PJI_FP_XBS_ACCUM_F"."PROJECT_ELEMENT_ID" "PJI_FP_XBS_ACCUM_F"."TIME_ID" "PJI_FP_XBS_ACCUM_F"."RBS_VERSION_ID"))

14268: FULL(@"SEL$19" "LOG"@"SEL$19")
14269: INDEX(@"SEL$19" "WBS_HDR"@"SEL$19" ("PJI_PJP_WBS_HEADER"."PROJECT_ID" "PJI_PJP_WBS_HEADER"."PLAN_VERSION_ID"))
14270: FULL(@"SEL$19" "WBS"@"SEL$19")
14271: INDEX_RS_ASC(@"SEL$19" "PRG"@"SEL$19" ("PJI_XBS_DENORM"."SUP_PROJECT_ID"))
14272: INDEX(@"SEL$19" "FPR"@"SEL$19" ("PJI_FP_XBS_ACCUM_F"."PROJECT_ID" "PJI_FP_XBS_ACCUM_F"."PLAN_VERSION_ID" "PJI_FP_XBS_ACCUM_F"."PROJECT_ELEMENT_ID" "PJI_FP_XBS_ACCUM_F"."TIME_ID" "PJI_FP_XBS_ACCUM_F"."RBS_VERSION_ID"))
14273: NO_ACCESS(@"SEL$19" "FIN_PLAN"@"SEL$19")
14274: NO_ACCESS(@"SEL$19" "TOP_SLICE"@"SEL$19")
14275: LEADING(@"SEL$19" "LOG"@"SEL$19" "WBS_HDR"@"SEL$19" "WBS"@"SEL$19" "PRG"@"SEL$19" "FPR"@"SEL$19" "FIN_PLAN"@"SEL$19" "TOP_SLICE"@"SEL$19")
14276: USE_NL(@"SEL$19" "WBS_HDR"@"SEL$19")

Line 15311: index(fpr PJI_FP_XBS_ACCUM_F_N1) */

15307: wbs_hdr.CB_FLAG = fin_plan.CB_FLAG (+) and
15308: wbs_hdr.CO_FLAG = fin_plan.CO_FLAG (+)
15309: union all
15310: select /*+ ordered
15311: index(fpr PJI_FP_XBS_ACCUM_F_N1) */
15312: -- get delta task level amounts from Reporting Lines
15313: to_char(null) LINE_TYPE,
15314: wbs_hdr.WBS_VERSION_ID,
15315: decode(wbs_hdr.WP_FLAG, 'Y', 'LW', 'LF') RELATIONSHIP_TYPE,

Line 15413: PJI_FP_XBS_ACCUM_F fpr,

15409: PJI_PA_PROJ_EVENTS_LOG log,
15410: PJI_PJP_WBS_HEADER wbs_hdr,
15411: PJI_XBS_DENORM_DELTA wbs,
15412: PJI_XBS_DENORM prg,
15413: PJI_FP_XBS_ACCUM_F fpr,
15414: (
15415: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15416: from DUAL union all
15417: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 15765: INDEX(@"SEL$19" "FPR"@"SEL$19" ("PJI_FP_XBS_ACCUM_F"."PROJECT_ID" "PJI_FP_XBS_ACCUM_F"."PLAN_VERSION_ID" "PJI_FP_XBS_ACCUM_F"."PROJECT_ELEMENT_ID" "PJI_FP_XBS_ACCUM_F"."TIME_ID" "PJI_FP_XBS_ACCUM_F"."RBS_VERSION_ID"))

15761: FULL(@"SEL$19" "LOG"@"SEL$19")
15762: INDEX(@"SEL$19" "WBS_HDR"@"SEL$19" ("PJI_PJP_WBS_HEADER"."PROJECT_ID" "PJI_PJP_WBS_HEADER"."PLAN_VERSION_ID"))
15763: FULL(@"SEL$19" "WBS"@"SEL$19")
15764: INDEX_RS_ASC(@"SEL$19" "PRG"@"SEL$19" ("PJI_XBS_DENORM"."SUP_PROJECT_ID"))
15765: INDEX(@"SEL$19" "FPR"@"SEL$19" ("PJI_FP_XBS_ACCUM_F"."PROJECT_ID" "PJI_FP_XBS_ACCUM_F"."PLAN_VERSION_ID" "PJI_FP_XBS_ACCUM_F"."PROJECT_ELEMENT_ID" "PJI_FP_XBS_ACCUM_F"."TIME_ID" "PJI_FP_XBS_ACCUM_F"."RBS_VERSION_ID"))
15766: NO_ACCESS(@"SEL$19" "FIN_PLAN"@"SEL$19")
15767: NO_ACCESS(@"SEL$19" "TOP_SLICE"@"SEL$19")
15768: LEADING(@"SEL$19" "LOG"@"SEL$19" "WBS_HDR"@"SEL$19" "WBS"@"SEL$19" "PRG"@"SEL$19" "FPR"@"SEL$19" "FIN_PLAN"@"SEL$19" "TOP_SLICE"@"SEL$19")
15769: USE_NL(@"SEL$19" "WBS_HDR"@"SEL$19")

Line 16804: index(fpr PJI_FP_XBS_ACCUM_F_N1) */

16800: wbs_hdr.CB_FLAG = fin_plan.CB_FLAG (+) and
16801: wbs_hdr.CO_FLAG = fin_plan.CO_FLAG (+)
16802: union all
16803: select /*+ ordered
16804: index(fpr PJI_FP_XBS_ACCUM_F_N1) */
16805: -- get delta task level amounts from Reporting Lines
16806: to_char(null) LINE_TYPE,
16807: wbs_hdr.WBS_VERSION_ID,
16808: decode(wbs_hdr.WP_FLAG, 'Y', 'LW', 'LF') RELATIONSHIP_TYPE,

Line 16906: PJI_FP_XBS_ACCUM_F fpr,

16902: PJI_PA_PROJ_EVENTS_LOG log,
16903: PJI_PJP_WBS_HEADER wbs_hdr,
16904: PJI_XBS_DENORM_DELTA wbs,
16905: PJI_XBS_DENORM prg,
16906: PJI_FP_XBS_ACCUM_F fpr,
16907: (
16908: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16909: from DUAL union all
16910: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 17259: INDEX(@"SEL$19" "FPR"@"SEL$19" ("PJI_FP_XBS_ACCUM_F"."PROJECT_ID" "PJI_FP_XBS_ACCUM_F"."PLAN_VERSION_ID" "PJI_FP_XBS_ACCUM_F"."PROJECT_ELEMENT_ID" "PJI_FP_XBS_ACCUM_F"."TIME_ID" "PJI_FP_XBS_ACCUM_F"."RBS_VERSION_ID"))

17255: FULL(@"SEL$19" "LOG"@"SEL$19")
17256: INDEX(@"SEL$19" "WBS_HDR"@"SEL$19" ("PJI_PJP_WBS_HEADER"."PROJECT_ID" "PJI_PJP_WBS_HEADER"."PLAN_VERSION_ID"))
17257: FULL(@"SEL$19" "WBS"@"SEL$19")
17258: INDEX_RS_ASC(@"SEL$19" "PRG"@"SEL$19" ("PJI_XBS_DENORM"."SUP_PROJECT_ID"))
17259: INDEX(@"SEL$19" "FPR"@"SEL$19" ("PJI_FP_XBS_ACCUM_F"."PROJECT_ID" "PJI_FP_XBS_ACCUM_F"."PLAN_VERSION_ID" "PJI_FP_XBS_ACCUM_F"."PROJECT_ELEMENT_ID" "PJI_FP_XBS_ACCUM_F"."TIME_ID" "PJI_FP_XBS_ACCUM_F"."RBS_VERSION_ID"))
17260: NO_ACCESS(@"SEL$19" "FIN_PLAN"@"SEL$19")
17261: NO_ACCESS(@"SEL$19" "TOP_SLICE"@"SEL$19")
17262: LEADING(@"SEL$19" "LOG"@"SEL$19" "WBS_HDR"@"SEL$19" "WBS"@"SEL$19" "PRG"@"SEL$19" "FPR"@"SEL$19" "FIN_PLAN"@"SEL$19" "TOP_SLICE"@"SEL$19")
17263: USE_NL(@"SEL$19" "WBS_HDR"@"SEL$19")

Line 18298: index(fpr PJI_FP_XBS_ACCUM_F_N1) */

18294: wbs_hdr.CB_FLAG = fin_plan.CB_FLAG (+) and
18295: wbs_hdr.CO_FLAG = fin_plan.CO_FLAG (+)
18296: union all
18297: select /*+ ordered
18298: index(fpr PJI_FP_XBS_ACCUM_F_N1) */
18299: -- get delta task level amounts from Reporting Lines
18300: to_char(null) LINE_TYPE,
18301: wbs_hdr.WBS_VERSION_ID,
18302: decode(wbs_hdr.WP_FLAG, 'Y', 'LW', 'LF') RELATIONSHIP_TYPE,

Line 18400: PJI_FP_XBS_ACCUM_F fpr,

18396: PJI_PA_PROJ_EVENTS_LOG log,
18397: PJI_PJP_WBS_HEADER wbs_hdr,
18398: PJI_XBS_DENORM_DELTA wbs,
18399: PJI_XBS_DENORM prg,
18400: PJI_FP_XBS_ACCUM_F fpr,
18401: (
18402: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
18403: from DUAL union all
18404: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 18753: INDEX(@"SEL$19" "FPR"@"SEL$19" ("PJI_FP_XBS_ACCUM_F"."PROJECT_ID" "PJI_FP_XBS_ACCUM_F"."PLAN_VERSION_ID" "PJI_FP_XBS_ACCUM_F"."PROJECT_ELEMENT_ID" "PJI_FP_XBS_ACCUM_F"."TIME_ID" "PJI_FP_XBS_ACCUM_F"."RBS_VERSION_ID"))

18749: FULL(@"SEL$19" "LOG"@"SEL$19")
18750: INDEX(@"SEL$19" "WBS_HDR"@"SEL$19" ("PJI_PJP_WBS_HEADER"."PROJECT_ID" "PJI_PJP_WBS_HEADER"."PLAN_VERSION_ID"))
18751: FULL(@"SEL$19" "WBS"@"SEL$19")
18752: INDEX_RS_ASC(@"SEL$19" "PRG"@"SEL$19" ("PJI_XBS_DENORM"."SUP_PROJECT_ID"))
18753: INDEX(@"SEL$19" "FPR"@"SEL$19" ("PJI_FP_XBS_ACCUM_F"."PROJECT_ID" "PJI_FP_XBS_ACCUM_F"."PLAN_VERSION_ID" "PJI_FP_XBS_ACCUM_F"."PROJECT_ELEMENT_ID" "PJI_FP_XBS_ACCUM_F"."TIME_ID" "PJI_FP_XBS_ACCUM_F"."RBS_VERSION_ID"))
18754: NO_ACCESS(@"SEL$19" "FIN_PLAN"@"SEL$19")
18755: NO_ACCESS(@"SEL$19" "TOP_SLICE"@"SEL$19")
18756: LEADING(@"SEL$19" "LOG"@"SEL$19" "WBS_HDR"@"SEL$19" "WBS"@"SEL$19" "PRG"@"SEL$19" "FPR"@"SEL$19" "FIN_PLAN"@"SEL$19" "TOP_SLICE"@"SEL$19")
18757: USE_NL(@"SEL$19" "WBS_HDR"@"SEL$19")

Line 19792: index(fpr PJI_FP_XBS_ACCUM_F_N1) */

19788: wbs_hdr.CB_FLAG = fin_plan.CB_FLAG (+) and
19789: wbs_hdr.CO_FLAG = fin_plan.CO_FLAG (+)
19790: union all
19791: select /*+ ordered
19792: index(fpr PJI_FP_XBS_ACCUM_F_N1) */
19793: -- get delta task level amounts from Reporting Lines
19794: to_char(null) LINE_TYPE,
19795: wbs_hdr.WBS_VERSION_ID,
19796: decode(wbs_hdr.WP_FLAG, 'Y', 'LW', 'LF') RELATIONSHIP_TYPE,

Line 19894: PJI_FP_XBS_ACCUM_F fpr,

19890: PJI_PA_PROJ_EVENTS_LOG log,
19891: PJI_PJP_WBS_HEADER wbs_hdr,
19892: PJI_XBS_DENORM_DELTA wbs,
19893: PJI_XBS_DENORM prg,
19894: PJI_FP_XBS_ACCUM_F fpr,
19895: (
19896: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
19897: from DUAL union all
19898: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 20247: INDEX(@"SEL$19" "FPR"@"SEL$19" ("PJI_FP_XBS_ACCUM_F"."PROJECT_ID" "PJI_FP_XBS_ACCUM_F"."PLAN_VERSION_ID" "PJI_FP_XBS_ACCUM_F"."PROJECT_ELEMENT_ID" "PJI_FP_XBS_ACCUM_F"."TIME_ID" "PJI_FP_XBS_ACCUM_F"."RBS_VERSION_ID"))

20243: FULL(@"SEL$19" "LOG"@"SEL$19")
20244: INDEX(@"SEL$19" "WBS_HDR"@"SEL$19" ("PJI_PJP_WBS_HEADER"."PROJECT_ID" "PJI_PJP_WBS_HEADER"."PLAN_VERSION_ID"))
20245: FULL(@"SEL$19" "WBS"@"SEL$19")
20246: INDEX_RS_ASC(@"SEL$19" "PRG"@"SEL$19" ("PJI_XBS_DENORM"."SUP_PROJECT_ID"))
20247: INDEX(@"SEL$19" "FPR"@"SEL$19" ("PJI_FP_XBS_ACCUM_F"."PROJECT_ID" "PJI_FP_XBS_ACCUM_F"."PLAN_VERSION_ID" "PJI_FP_XBS_ACCUM_F"."PROJECT_ELEMENT_ID" "PJI_FP_XBS_ACCUM_F"."TIME_ID" "PJI_FP_XBS_ACCUM_F"."RBS_VERSION_ID"))
20248: NO_ACCESS(@"SEL$19" "FIN_PLAN"@"SEL$19")
20249: NO_ACCESS(@"SEL$19" "TOP_SLICE"@"SEL$19")
20250: LEADING(@"SEL$19" "LOG"@"SEL$19" "WBS_HDR"@"SEL$19" "WBS"@"SEL$19" "PRG"@"SEL$19" "FPR"@"SEL$19" "FIN_PLAN"@"SEL$19" "TOP_SLICE"@"SEL$19")
20251: USE_NL(@"SEL$19" "WBS_HDR"@"SEL$19")

Line 21286: index(fpr PJI_FP_XBS_ACCUM_F_N1) */

21282: wbs_hdr.CB_FLAG = fin_plan.CB_FLAG (+) and
21283: wbs_hdr.CO_FLAG = fin_plan.CO_FLAG (+)
21284: union all
21285: select /*+ ordered
21286: index(fpr PJI_FP_XBS_ACCUM_F_N1) */
21287: -- get delta task level amounts from Reporting Lines
21288: to_char(null) LINE_TYPE,
21289: wbs_hdr.WBS_VERSION_ID,
21290: decode(wbs_hdr.WP_FLAG, 'Y', 'LW', 'LF') RELATIONSHIP_TYPE,

Line 21388: PJI_FP_XBS_ACCUM_F fpr,

21384: PJI_PA_PROJ_EVENTS_LOG log,
21385: PJI_PJP_WBS_HEADER wbs_hdr,
21386: PJI_XBS_DENORM_DELTA wbs,
21387: PJI_XBS_DENORM prg,
21388: PJI_FP_XBS_ACCUM_F fpr,
21389: (
21390: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
21391: from DUAL union all
21392: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID