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_PJP_PRG_PERF_ALL dependencies on PJI_XBS_DENORM

Line 635: ,p_tabname => 'PJI_XBS_DENORM_DELTA'

631: ,p_partname => 'P'||g_worker_id
632: ,p_percent => 10);
633:
634: GATHER_TEMP_STATS(p_ownname => l_pji_schema
635: ,p_tabname => 'PJI_XBS_DENORM_DELTA'
636: ,p_partname => 'P'||g_worker_id
637: ,p_percent => 10);
638:
639: GATHER_TEMP_STATS(p_ownname => l_pji_schema

Line 6366: select /+ ordered index(den PJI_XBS_DENORM_N3) use_hash(den) / --Bug 7516507

6362: STEP_NAME like 'ROLLUP_FPR_WBS%';
6363:
6364: if (l_count = 0) then
6365:
6366: select /*+ ordered index(den PJI_XBS_DENORM_N3) use_hash(den) */ --Bug 7516507
6367: nvl(max(den.SUP_LEVEL), 0)
6368: into
6369: l_level
6370: from

Line 6372: PJI_XBS_DENORM den

6368: into
6369: l_level
6370: from
6371: PJI_PJP_PROJ_BATCH_MAP map,
6372: PJI_XBS_DENORM den
6373: where
6374: map.WORKER_ID = p_worker_id and
6375: den.STRUCT_TYPE = 'PRG' and
6376: den.SUB_LEVEL = den.SUP_LEVEL and

Line 6803: INDEX_RS_ASC(@"SEL$19" "PRG"@"SEL$19" ("PJI_XBS_DENORM"."SUP_PROJECT_ID"))

6799: SWAP_JOIN_INPUTS(@"SEL$30" "PRG_DELTA"@"SEL$30")
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")

Line 7639: PJI_XBS_DENORM prg,

7635: from
7636: PJI_FP_AGGR_PJP1 pjp1,
7637: PJI_PJP_WBS_HEADER wbs_hdr,
7638: PA_XBS_DENORM wbs,
7639: PJI_XBS_DENORM prg,
7640: (
7641: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
7642: from DUAL union all
7643: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 7792: PJI_XBS_DENORM prg,

7788: pjp1.CUSTOM15
7789: from
7790: PJI_FP_AGGR_PJP1 pjp1,
7791: PJI_PJP_WBS_HEADER wbs_hdr,
7792: PJI_XBS_DENORM prg,
7793: (
7794: select 'Y' CB_FLAG,
7795: 'N' CO_FLAG,
7796: -3 PLAN_VERSION_ID

Line 7943: PJI_XBS_DENORM_DELTA wbs,

7939: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
7940: from
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

Line 7944: PJI_XBS_DENORM prg,

7940: from
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

Line 8032: PJI_XBS_DENORM prg,

8028: 'LF', 'N') WP_FLAG,
8029: 'Y' PUSHUP_FLAG
8030: from
8031: PJI_PJP_PROJ_BATCH_MAP map,
8032: PJI_XBS_DENORM prg,
8033: (
8034: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
8035: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
8036: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all

Line 8039: PJI_XBS_DENORM_DELTA prg_delta

8035: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
8036: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
8037: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
8038: ) invert,
8039: PJI_XBS_DENORM_DELTA prg_delta
8040: where
8041: prg.STRUCT_TYPE = 'PRG' and
8042: prg.SUB_ROLLUP_ID is not null and
8043: prg.SUB_LEVEL = l_level and

Line 8297: INDEX_RS_ASC(@"SEL$19" "PRG"@"SEL$19" ("PJI_XBS_DENORM"."SUP_PROJECT_ID"))

8293: SWAP_JOIN_INPUTS(@"SEL$30" "PRG_DELTA"@"SEL$30")
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")

Line 9133: PJI_XBS_DENORM prg,

9129: from
9130: PJI_FP_AGGR_PJP1 pjp1,
9131: PJI_PJP_WBS_HEADER wbs_hdr,
9132: PA_XBS_DENORM wbs,
9133: PJI_XBS_DENORM prg,
9134: (
9135: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9136: from DUAL union all
9137: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 9286: PJI_XBS_DENORM prg,

9282: pjp1.CUSTOM15
9283: from
9284: PJI_FP_AGGR_PJP1 pjp1,
9285: PJI_PJP_WBS_HEADER wbs_hdr,
9286: PJI_XBS_DENORM prg,
9287: (
9288: select 'Y' CB_FLAG,
9289: 'N' CO_FLAG,
9290: -3 PLAN_VERSION_ID

Line 9437: PJI_XBS_DENORM_DELTA wbs,

9433: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
9434: from
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

Line 9438: PJI_XBS_DENORM prg,

9434: from
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

Line 9526: PJI_XBS_DENORM prg,

9522: 'LF', 'N') WP_FLAG,
9523: 'Y' PUSHUP_FLAG
9524: from
9525: PJI_PJP_PROJ_BATCH_MAP map,
9526: PJI_XBS_DENORM prg,
9527: (
9528: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
9529: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
9530: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all

Line 9533: PJI_XBS_DENORM_DELTA prg_delta

9529: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
9530: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
9531: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
9532: ) invert,
9533: PJI_XBS_DENORM_DELTA prg_delta
9534: where
9535: prg.STRUCT_TYPE = 'PRG' and
9536: prg.SUB_ROLLUP_ID is not null and
9537: prg.SUB_LEVEL = l_level and

Line 9791: INDEX_RS_ASC(@"SEL$19" "PRG"@"SEL$19" ("PJI_XBS_DENORM"."SUP_PROJECT_ID"))

9787: SWAP_JOIN_INPUTS(@"SEL$30" "PRG_DELTA"@"SEL$30")
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")

Line 10627: PJI_XBS_DENORM prg,

10623: from
10624: PJI_FP_AGGR_PJP1 pjp1,
10625: PJI_PJP_WBS_HEADER wbs_hdr,
10626: PA_XBS_DENORM wbs,
10627: PJI_XBS_DENORM prg,
10628: (
10629: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10630: from DUAL union all
10631: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 10780: PJI_XBS_DENORM prg,

10776: pjp1.CUSTOM15
10777: from
10778: PJI_FP_AGGR_PJP1 pjp1,
10779: PJI_PJP_WBS_HEADER wbs_hdr,
10780: PJI_XBS_DENORM prg,
10781: (
10782: select 'Y' CB_FLAG,
10783: 'N' CO_FLAG,
10784: -3 PLAN_VERSION_ID

Line 10931: PJI_XBS_DENORM_DELTA wbs,

10927: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
10928: from
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

Line 10932: PJI_XBS_DENORM prg,

10928: from
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

Line 11020: PJI_XBS_DENORM prg,

11016: 'LF', 'N') WP_FLAG,
11017: 'Y' PUSHUP_FLAG
11018: from
11019: PJI_PJP_PROJ_BATCH_MAP map,
11020: PJI_XBS_DENORM prg,
11021: (
11022: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
11023: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
11024: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all

Line 11027: PJI_XBS_DENORM_DELTA prg_delta

11023: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
11024: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
11025: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
11026: ) invert,
11027: PJI_XBS_DENORM_DELTA prg_delta
11028: where
11029: prg.STRUCT_TYPE = 'PRG' and
11030: prg.SUB_ROLLUP_ID is not null and
11031: prg.SUB_LEVEL = l_level and

Line 11284: INDEX_RS_ASC(@"SEL$19" "PRG"@"SEL$19" ("PJI_XBS_DENORM"."SUP_PROJECT_ID"))

11280: SWAP_JOIN_INPUTS(@"SEL$30" "PRG_DELTA"@"SEL$30")
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")

Line 12120: PJI_XBS_DENORM prg,

12116: from
12117: PJI_FP_AGGR_PJP1 pjp1,
12118: PJI_PJP_WBS_HEADER wbs_hdr,
12119: PA_XBS_DENORM wbs,
12120: PJI_XBS_DENORM prg,
12121: (
12122: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12123: from DUAL union all
12124: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 12273: PJI_XBS_DENORM prg,

12269: pjp1.CUSTOM15
12270: from
12271: PJI_FP_AGGR_PJP1 pjp1,
12272: PJI_PJP_WBS_HEADER wbs_hdr,
12273: PJI_XBS_DENORM prg,
12274: (
12275: select 'Y' CB_FLAG,
12276: 'N' CO_FLAG,
12277: -3 PLAN_VERSION_ID

Line 12424: PJI_XBS_DENORM_DELTA wbs,

12420: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
12421: from
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

Line 12425: PJI_XBS_DENORM prg,

12421: from
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

Line 12513: PJI_XBS_DENORM prg,

12509: 'LF', 'N') WP_FLAG,
12510: 'Y' PUSHUP_FLAG
12511: from
12512: PJI_PJP_PROJ_BATCH_MAP map,
12513: PJI_XBS_DENORM prg,
12514: (
12515: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
12516: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
12517: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all

Line 12520: PJI_XBS_DENORM_DELTA prg_delta

12516: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
12517: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
12518: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
12519: ) invert,
12520: PJI_XBS_DENORM_DELTA prg_delta
12521: where
12522: prg.STRUCT_TYPE = 'PRG' and
12523: prg.SUB_ROLLUP_ID is not null and
12524: prg.SUB_LEVEL = l_level and

Line 12778: INDEX_RS_ASC(@"SEL$19" "PRG"@"SEL$19" ("PJI_XBS_DENORM"."SUP_PROJECT_ID"))

12774: SWAP_JOIN_INPUTS(@"SEL$30" "PRG_DELTA"@"SEL$30")
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")

Line 13614: PJI_XBS_DENORM prg,

13610: from
13611: PJI_FP_AGGR_PJP1 pjp1,
13612: PJI_PJP_WBS_HEADER wbs_hdr,
13613: PA_XBS_DENORM wbs,
13614: PJI_XBS_DENORM prg,
13615: (
13616: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13617: from DUAL union all
13618: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 13767: PJI_XBS_DENORM prg,

13763: pjp1.CUSTOM15
13764: from
13765: PJI_FP_AGGR_PJP1 pjp1,
13766: PJI_PJP_WBS_HEADER wbs_hdr,
13767: PJI_XBS_DENORM prg,
13768: (
13769: select 'Y' CB_FLAG,
13770: 'N' CO_FLAG,
13771: -3 PLAN_VERSION_ID

Line 13918: PJI_XBS_DENORM_DELTA wbs,

13914: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
13915: from
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

Line 13919: PJI_XBS_DENORM prg,

13915: from
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

Line 14007: PJI_XBS_DENORM prg,

14003: 'LF', 'N') WP_FLAG,
14004: 'Y' PUSHUP_FLAG
14005: from
14006: PJI_PJP_PROJ_BATCH_MAP map,
14007: PJI_XBS_DENORM prg,
14008: (
14009: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
14010: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
14011: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all

Line 14014: PJI_XBS_DENORM_DELTA prg_delta

14010: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
14011: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
14012: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
14013: ) invert,
14014: PJI_XBS_DENORM_DELTA prg_delta
14015: where
14016: prg.STRUCT_TYPE = 'PRG' and
14017: prg.SUB_ROLLUP_ID is not null and
14018: prg.SUB_LEVEL = l_level and

Line 14271: INDEX_RS_ASC(@"SEL$19" "PRG"@"SEL$19" ("PJI_XBS_DENORM"."SUP_PROJECT_ID"))

14267: SWAP_JOIN_INPUTS(@"SEL$30" "PRG_DELTA"@"SEL$30")
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")

Line 15107: PJI_XBS_DENORM prg,

15103: from
15104: PJI_FP_AGGR_PJP1 pjp1,
15105: PJI_PJP_WBS_HEADER wbs_hdr,
15106: PA_XBS_DENORM wbs,
15107: PJI_XBS_DENORM prg,
15108: (
15109: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15110: from DUAL union all
15111: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 15260: PJI_XBS_DENORM prg,

15256: pjp1.CUSTOM15
15257: from
15258: PJI_FP_AGGR_PJP1 pjp1,
15259: PJI_PJP_WBS_HEADER wbs_hdr,
15260: PJI_XBS_DENORM prg,
15261: (
15262: select 'Y' CB_FLAG,
15263: 'N' CO_FLAG,
15264: -3 PLAN_VERSION_ID

Line 15411: PJI_XBS_DENORM_DELTA wbs,

15407: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
15408: from
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

Line 15412: PJI_XBS_DENORM prg,

15408: from
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

Line 15500: PJI_XBS_DENORM prg,

15496: 'LF', 'N') WP_FLAG,
15497: 'Y' PUSHUP_FLAG
15498: from
15499: PJI_PJP_PROJ_BATCH_MAP map,
15500: PJI_XBS_DENORM prg,
15501: (
15502: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
15503: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
15504: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all

Line 15507: PJI_XBS_DENORM_DELTA prg_delta

15503: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
15504: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
15505: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
15506: ) invert,
15507: PJI_XBS_DENORM_DELTA prg_delta
15508: where
15509: prg.STRUCT_TYPE = 'PRG' and
15510: prg.SUB_ROLLUP_ID is not null and
15511: prg.SUB_LEVEL = l_level and

Line 15764: INDEX_RS_ASC(@"SEL$19" "PRG"@"SEL$19" ("PJI_XBS_DENORM"."SUP_PROJECT_ID"))

15760: SWAP_JOIN_INPUTS(@"SEL$30" "PRG_DELTA"@"SEL$30")
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")

Line 16600: PJI_XBS_DENORM prg,

16596: from
16597: PJI_FP_AGGR_PJP1 pjp1,
16598: PJI_PJP_WBS_HEADER wbs_hdr,
16599: PA_XBS_DENORM wbs,
16600: PJI_XBS_DENORM prg,
16601: (
16602: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16603: from DUAL union all
16604: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 16753: PJI_XBS_DENORM prg,

16749: pjp1.CUSTOM15
16750: from
16751: PJI_FP_AGGR_PJP1 pjp1,
16752: PJI_PJP_WBS_HEADER wbs_hdr,
16753: PJI_XBS_DENORM prg,
16754: (
16755: select 'Y' CB_FLAG,
16756: 'N' CO_FLAG,
16757: -3 PLAN_VERSION_ID

Line 16904: PJI_XBS_DENORM_DELTA wbs,

16900: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
16901: from
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

Line 16905: PJI_XBS_DENORM prg,

16901: from
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

Line 16993: PJI_XBS_DENORM prg,

16989: 'LF', 'N') WP_FLAG,
16990: 'Y' PUSHUP_FLAG
16991: from
16992: PJI_PJP_PROJ_BATCH_MAP map,
16993: PJI_XBS_DENORM prg,
16994: (
16995: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
16996: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
16997: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all

Line 17000: PJI_XBS_DENORM_DELTA prg_delta

16996: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
16997: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
16998: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
16999: ) invert,
17000: PJI_XBS_DENORM_DELTA prg_delta
17001: where
17002: prg.STRUCT_TYPE = 'PRG' and
17003: prg.SUB_ROLLUP_ID is not null and
17004: prg.SUB_LEVEL = l_level and

Line 17258: INDEX_RS_ASC(@"SEL$19" "PRG"@"SEL$19" ("PJI_XBS_DENORM"."SUP_PROJECT_ID"))

17254: SWAP_JOIN_INPUTS(@"SEL$30" "PRG_DELTA"@"SEL$30")
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")

Line 18094: PJI_XBS_DENORM prg,

18090: from
18091: PJI_FP_AGGR_PJP1 pjp1,
18092: PJI_PJP_WBS_HEADER wbs_hdr,
18093: PA_XBS_DENORM wbs,
18094: PJI_XBS_DENORM prg,
18095: (
18096: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
18097: from DUAL union all
18098: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 18247: PJI_XBS_DENORM prg,

18243: pjp1.CUSTOM15
18244: from
18245: PJI_FP_AGGR_PJP1 pjp1,
18246: PJI_PJP_WBS_HEADER wbs_hdr,
18247: PJI_XBS_DENORM prg,
18248: (
18249: select 'Y' CB_FLAG,
18250: 'N' CO_FLAG,
18251: -3 PLAN_VERSION_ID

Line 18398: PJI_XBS_DENORM_DELTA wbs,

18394: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
18395: from
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

Line 18399: PJI_XBS_DENORM prg,

18395: from
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

Line 18487: PJI_XBS_DENORM prg,

18483: 'LF', 'N') WP_FLAG,
18484: 'Y' PUSHUP_FLAG
18485: from
18486: PJI_PJP_PROJ_BATCH_MAP map,
18487: PJI_XBS_DENORM prg,
18488: (
18489: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
18490: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
18491: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all

Line 18494: PJI_XBS_DENORM_DELTA prg_delta

18490: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
18491: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
18492: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
18493: ) invert,
18494: PJI_XBS_DENORM_DELTA prg_delta
18495: where
18496: prg.STRUCT_TYPE = 'PRG' and
18497: prg.SUB_ROLLUP_ID is not null and
18498: prg.SUB_LEVEL = l_level and

Line 18752: INDEX_RS_ASC(@"SEL$19" "PRG"@"SEL$19" ("PJI_XBS_DENORM"."SUP_PROJECT_ID"))

18748: SWAP_JOIN_INPUTS(@"SEL$30" "PRG_DELTA"@"SEL$30")
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")

Line 19588: PJI_XBS_DENORM prg,

19584: from
19585: PJI_FP_AGGR_PJP1 pjp1,
19586: PJI_PJP_WBS_HEADER wbs_hdr,
19587: PA_XBS_DENORM wbs,
19588: PJI_XBS_DENORM prg,
19589: (
19590: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
19591: from DUAL union all
19592: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 19741: PJI_XBS_DENORM prg,

19737: pjp1.CUSTOM15
19738: from
19739: PJI_FP_AGGR_PJP1 pjp1,
19740: PJI_PJP_WBS_HEADER wbs_hdr,
19741: PJI_XBS_DENORM prg,
19742: (
19743: select 'Y' CB_FLAG,
19744: 'N' CO_FLAG,
19745: -3 PLAN_VERSION_ID

Line 19892: PJI_XBS_DENORM_DELTA wbs,

19888: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
19889: from
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

Line 19893: PJI_XBS_DENORM prg,

19889: from
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

Line 19981: PJI_XBS_DENORM prg,

19977: 'LF', 'N') WP_FLAG,
19978: 'Y' PUSHUP_FLAG
19979: from
19980: PJI_PJP_PROJ_BATCH_MAP map,
19981: PJI_XBS_DENORM prg,
19982: (
19983: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
19984: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
19985: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all

Line 19988: PJI_XBS_DENORM_DELTA prg_delta

19984: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
19985: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
19986: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
19987: ) invert,
19988: PJI_XBS_DENORM_DELTA prg_delta
19989: where
19990: prg.STRUCT_TYPE = 'PRG' and
19991: prg.SUB_ROLLUP_ID is not null and
19992: prg.SUB_LEVEL = l_level and

Line 20246: INDEX_RS_ASC(@"SEL$19" "PRG"@"SEL$19" ("PJI_XBS_DENORM"."SUP_PROJECT_ID"))

20242: SWAP_JOIN_INPUTS(@"SEL$30" "PRG_DELTA"@"SEL$30")
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")

Line 21082: PJI_XBS_DENORM prg,

21078: from
21079: PJI_FP_AGGR_PJP1 pjp1,
21080: PJI_PJP_WBS_HEADER wbs_hdr,
21081: PA_XBS_DENORM wbs,
21082: PJI_XBS_DENORM prg,
21083: (
21084: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
21085: from DUAL union all
21086: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 21235: PJI_XBS_DENORM prg,

21231: pjp1.CUSTOM15
21232: from
21233: PJI_FP_AGGR_PJP1 pjp1,
21234: PJI_PJP_WBS_HEADER wbs_hdr,
21235: PJI_XBS_DENORM prg,
21236: (
21237: select 'Y' CB_FLAG,
21238: 'N' CO_FLAG,
21239: -3 PLAN_VERSION_ID

Line 21386: PJI_XBS_DENORM_DELTA wbs,

21382: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
21383: from
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

Line 21387: PJI_XBS_DENORM prg,

21383: from
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

Line 21475: PJI_XBS_DENORM prg,

21471: 'LF', 'N') WP_FLAG,
21472: 'Y' PUSHUP_FLAG
21473: from
21474: PJI_PJP_PROJ_BATCH_MAP map,
21475: PJI_XBS_DENORM prg,
21476: (
21477: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
21478: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
21479: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all

Line 21482: PJI_XBS_DENORM_DELTA prg_delta

21478: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
21479: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
21480: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
21481: ) invert,
21482: PJI_XBS_DENORM_DELTA prg_delta
21483: where
21484: prg.STRUCT_TYPE = 'PRG' and
21485: prg.SUB_ROLLUP_ID is not null and
21486: prg.SUB_LEVEL = l_level and