8367: sum(pjp.CUSTOM14) CUSTOM14,
8368: sum(pjp.CUSTOM15) CUSTOM15
8369: from
8370: (
8371: select /*+ index(wbs PA_XBS_DENORM_N2) parallel(pjp1) */ -- changed for bug 5927368
8372: -- get incremental task level amounts from source and
8373: -- program rollup amounts from interim
8374: to_char(null) LINE_TYPE,
8375: wbs_hdr.WBS_VERSION_ID,
8481: pjp1.CUSTOM15
8482: from
8483: PJI_FP_AGGR_PJP1 pjp1,
8484: PJI_PJP_WBS_HEADER wbs_hdr,
8485: PA_XBS_DENORM wbs,
8486: PJI_XBS_DENORM prg,
8487: (
8488: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
8489: from DUAL union all
9688: sum(pjp.CUSTOM14) CUSTOM14,
9689: sum(pjp.CUSTOM15) CUSTOM15
9690: from
9691: (
9692: select /*+ index(wbs PA_XBS_DENORM_N2) parallel(pjp1) */ -- changed for bug 5927368
9693: -- get incremental task level amounts from source and
9694: -- program rollup amounts from interim
9695: to_char(null) LINE_TYPE,
9696: wbs_hdr.WBS_VERSION_ID,
9802: pjp1.CUSTOM15
9803: from
9804: PJI_FP_AGGR_PJP1 pjp1,
9805: PJI_PJP_WBS_HEADER wbs_hdr,
9806: PA_XBS_DENORM wbs,
9807: PJI_XBS_DENORM prg,
9808: (
9809: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9810: from DUAL union all
11007: sum(pjp.CUSTOM14) CUSTOM14,
11008: sum(pjp.CUSTOM15) CUSTOM15
11009: from
11010: (
11011: select /*+ index(wbs PA_XBS_DENORM_N2) parallel(pjp1) */ -- changed for bug 5927368
11012: -- get incremental task level amounts from source and
11013: -- program rollup amounts from interim
11014: to_char(null) LINE_TYPE,
11015: wbs_hdr.WBS_VERSION_ID,
11121: pjp1.CUSTOM15
11122: from
11123: PJI_FP_AGGR_PJP1 pjp1,
11124: PJI_PJP_WBS_HEADER wbs_hdr,
11125: PA_XBS_DENORM wbs,
11126: PJI_XBS_DENORM prg,
11127: (
11128: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
11129: from DUAL union all
12325: sum(pjp.CUSTOM14) CUSTOM14,
12326: sum(pjp.CUSTOM15) CUSTOM15
12327: from
12328: (
12329: select /*+ index(wbs PA_XBS_DENORM_N2) parallel(pjp1) */ -- changed for bug 5927368
12330: -- get incremental task level amounts from source and
12331: -- program rollup amounts from interim
12332: to_char(null) LINE_TYPE,
12333: wbs_hdr.WBS_VERSION_ID,
12439: pjp1.CUSTOM15
12440: from
12441: PJI_FP_AGGR_PJP1 pjp1,
12442: PJI_PJP_WBS_HEADER wbs_hdr,
12443: PA_XBS_DENORM wbs,
12444: PJI_XBS_DENORM prg,
12445: (
12446: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12447: from DUAL union all
13643: sum(pjp.CUSTOM14) CUSTOM14,
13644: sum(pjp.CUSTOM15) CUSTOM15
13645: from
13646: (
13647: select /*+ index(wbs PA_XBS_DENORM_N2) parallel(pjp1) */ -- changed for bug 5927368
13648: -- get incremental task level amounts from source and
13649: -- program rollup amounts from interim
13650: to_char(null) LINE_TYPE,
13651: wbs_hdr.WBS_VERSION_ID,
13757: pjp1.CUSTOM15
13758: from
13759: PJI_FP_AGGR_PJP1 pjp1,
13760: PJI_PJP_WBS_HEADER wbs_hdr,
13761: PA_XBS_DENORM wbs,
13762: PJI_XBS_DENORM prg,
13763: (
13764: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13765: from DUAL union all
14961: sum(pjp.CUSTOM14) CUSTOM14,
14962: sum(pjp.CUSTOM15) CUSTOM15
14963: from
14964: (
14965: select /*+ index(wbs PA_XBS_DENORM_N2) parallel(pjp1) */ -- changed for bug 5927368
14966: -- get incremental task level amounts from source and
14967: -- program rollup amounts from interim
14968: to_char(null) LINE_TYPE,
14969: wbs_hdr.WBS_VERSION_ID,
15075: pjp1.CUSTOM15
15076: from
15077: PJI_FP_AGGR_PJP1 pjp1,
15078: PJI_PJP_WBS_HEADER wbs_hdr,
15079: PA_XBS_DENORM wbs,
15080: PJI_XBS_DENORM prg,
15081: (
15082: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15083: from DUAL union all
16279: sum(pjp.CUSTOM14) CUSTOM14,
16280: sum(pjp.CUSTOM15) CUSTOM15
16281: from
16282: (
16283: select /*+ index(wbs PA_XBS_DENORM_N2) parallel(pjp1) */ -- changed for bug 5927368
16284: -- get incremental task level amounts from source and
16285: -- program rollup amounts from interim
16286: to_char(null) LINE_TYPE,
16287: wbs_hdr.WBS_VERSION_ID,
16393: pjp1.CUSTOM15
16394: from
16395: PJI_FP_AGGR_PJP1 pjp1,
16396: PJI_PJP_WBS_HEADER wbs_hdr,
16397: PA_XBS_DENORM wbs,
16398: PJI_XBS_DENORM prg,
16399: (
16400: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16401: from DUAL union all
17597: sum(pjp.CUSTOM14) CUSTOM14,
17598: sum(pjp.CUSTOM15) CUSTOM15
17599: from
17600: (
17601: select /*+ index(wbs PA_XBS_DENORM_N2) parallel(pjp1) */ -- changed for bug 5927368
17602: -- get incremental task level amounts from source and
17603: -- program rollup amounts from interim
17604: to_char(null) LINE_TYPE,
17605: wbs_hdr.WBS_VERSION_ID,
17711: pjp1.CUSTOM15
17712: from
17713: PJI_FP_AGGR_PJP1 pjp1,
17714: PJI_PJP_WBS_HEADER wbs_hdr,
17715: PA_XBS_DENORM wbs,
17716: PJI_XBS_DENORM prg,
17717: (
17718: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
17719: from DUAL union all
18915: sum(pjp.CUSTOM14) CUSTOM14,
18916: sum(pjp.CUSTOM15) CUSTOM15
18917: from
18918: (
18919: select /*+ index(wbs PA_XBS_DENORM_N2) parallel(pjp1) */ -- changed for bug 5927368
18920: -- get incremental task level amounts from source and
18921: -- program rollup amounts from interim
18922: to_char(null) LINE_TYPE,
18923: wbs_hdr.WBS_VERSION_ID,
19029: pjp1.CUSTOM15
19030: from
19031: PJI_FP_AGGR_PJP1 pjp1,
19032: PJI_PJP_WBS_HEADER wbs_hdr,
19033: PA_XBS_DENORM wbs,
19034: PJI_XBS_DENORM prg,
19035: (
19036: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
19037: from DUAL union all
20233: sum(pjp.CUSTOM14) CUSTOM14,
20234: sum(pjp.CUSTOM15) CUSTOM15
20235: from
20236: (
20237: select /*+ index(wbs PA_XBS_DENORM_N2) parallel(pjp1) */ -- changed for bug 5927368
20238: -- get incremental task level amounts from source and
20239: -- program rollup amounts from interim
20240: to_char(null) LINE_TYPE,
20241: wbs_hdr.WBS_VERSION_ID,
20347: pjp1.CUSTOM15
20348: from
20349: PJI_FP_AGGR_PJP1 pjp1,
20350: PJI_PJP_WBS_HEADER wbs_hdr,
20351: PA_XBS_DENORM wbs,
20352: PJI_XBS_DENORM prg,
20353: (
20354: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
20355: from DUAL union all
21098: sum(pjp.CUSTOM14) CUSTOM14,
21099: sum(pjp.CUSTOM15) CUSTOM15
21100: from
21101: (
21102: select /*+ ordered index(wbs PA_XBS_DENORM_N2) parallel(pjp1) */ -- changed for bug 5927368
21103: -- get incremental task level amounts from source and
21104: -- program rollup amounts from interim
21105: wbs_hdr.WBS_VERSION_ID,
21106: 'LF' RELATIONSHIP_TYPE,
21168: pjp1.CUSTOM15
21169: from
21170: PJI_AC_AGGR_PJP1 pjp1,
21171: PJI_PJP_WBS_HEADER wbs_hdr,
21172: PA_XBS_DENORM wbs,
21173: PJI_XBS_DENORM prg,
21174: (
21175: select 1 WBS_SUP_LEVEL,
21176: 1 WBS_SUB_LEVEL,
21680: sum(pjp.CUSTOM14) CUSTOM14,
21681: sum(pjp.CUSTOM15) CUSTOM15
21682: from
21683: (
21684: select /*+ ordered index(wbs PA_XBS_DENORM_N2) parallel(pjp1) */ -- changed for bug 5927368
21685: -- get incremental task level amounts from source and
21686: -- program rollup amounts from interim
21687: wbs_hdr.WBS_VERSION_ID,
21688: 'LF' RELATIONSHIP_TYPE,
21750: pjp1.CUSTOM15
21751: from
21752: PJI_AC_AGGR_PJP1 pjp1,
21753: PJI_PJP_WBS_HEADER wbs_hdr,
21754: PA_XBS_DENORM wbs,
21755: PJI_XBS_DENORM prg,
21756: (
21757: select 1 WBS_SUP_LEVEL,
21758: 1 WBS_SUB_LEVEL,
22262: sum(pjp.CUSTOM14) CUSTOM14,
22263: sum(pjp.CUSTOM15) CUSTOM15
22264: from
22265: (
22266: select /*+ ordered index(wbs PA_XBS_DENORM_N2) parallel(pjp1) */ -- changed for bug 5927368
22267: -- get incremental task level amounts from source and
22268: -- program rollup amounts from interim
22269: wbs_hdr.WBS_VERSION_ID,
22270: 'LF' RELATIONSHIP_TYPE,
22332: pjp1.CUSTOM15
22333: from
22334: PJI_AC_AGGR_PJP1 pjp1,
22335: PJI_PJP_WBS_HEADER wbs_hdr,
22336: PA_XBS_DENORM wbs,
22337: PJI_XBS_DENORM prg,
22338: (
22339: select 1 WBS_SUP_LEVEL,
22340: 1 WBS_SUB_LEVEL,
22844: sum(pjp.CUSTOM14) CUSTOM14,
22845: sum(pjp.CUSTOM15) CUSTOM15
22846: from
22847: (
22848: select /*+ ordered index(wbs PA_XBS_DENORM_N2) parallel(pjp1) */ -- changed for bug 5927368
22849: -- get incremental task level amounts from source and
22850: -- program rollup amounts from interim
22851: wbs_hdr.WBS_VERSION_ID,
22852: 'LF' RELATIONSHIP_TYPE,
22914: pjp1.CUSTOM15
22915: from
22916: PJI_AC_AGGR_PJP1 pjp1,
22917: PJI_PJP_WBS_HEADER wbs_hdr,
22918: PA_XBS_DENORM wbs,
22919: PJI_XBS_DENORM prg,
22920: (
22921: select 1 WBS_SUP_LEVEL,
22922: 1 WBS_SUB_LEVEL,
23426: sum(pjp.CUSTOM14) CUSTOM14,
23427: sum(pjp.CUSTOM15) CUSTOM15
23428: from
23429: (
23430: select /*+ ordered index(wbs PA_XBS_DENORM_N2) parallel(pjp1) */ -- changed for bug 5927368
23431: -- get incremental task level amounts from source and
23432: -- program rollup amounts from interim
23433: wbs_hdr.WBS_VERSION_ID,
23434: 'LF' RELATIONSHIP_TYPE,
23496: pjp1.CUSTOM15
23497: from
23498: PJI_AC_AGGR_PJP1 pjp1,
23499: PJI_PJP_WBS_HEADER wbs_hdr,
23500: PA_XBS_DENORM wbs,
23501: PJI_XBS_DENORM prg,
23502: (
23503: select 1 WBS_SUP_LEVEL,
23504: 1 WBS_SUB_LEVEL,
24008: sum(pjp.CUSTOM14) CUSTOM14,
24009: sum(pjp.CUSTOM15) CUSTOM15
24010: from
24011: (
24012: select /*+ ordered index(wbs PA_XBS_DENORM_N2) parallel(pjp1) */ -- changed for bug 5927368
24013: -- get incremental task level amounts from source and
24014: -- program rollup amounts from interim
24015: wbs_hdr.WBS_VERSION_ID,
24016: 'LF' RELATIONSHIP_TYPE,
24078: pjp1.CUSTOM15
24079: from
24080: PJI_AC_AGGR_PJP1 pjp1,
24081: PJI_PJP_WBS_HEADER wbs_hdr,
24082: PA_XBS_DENORM wbs,
24083: PJI_XBS_DENORM prg,
24084: (
24085: select 1 WBS_SUP_LEVEL,
24086: 1 WBS_SUB_LEVEL,
24590: sum(pjp.CUSTOM14) CUSTOM14,
24591: sum(pjp.CUSTOM15) CUSTOM15
24592: from
24593: (
24594: select /*+ ordered index(wbs PA_XBS_DENORM_N2) parallel(pjp1) */ -- changed for bug 5927368
24595: -- get incremental task level amounts from source and
24596: -- program rollup amounts from interim
24597: wbs_hdr.WBS_VERSION_ID,
24598: 'LF' RELATIONSHIP_TYPE,
24660: pjp1.CUSTOM15
24661: from
24662: PJI_AC_AGGR_PJP1 pjp1,
24663: PJI_PJP_WBS_HEADER wbs_hdr,
24664: PA_XBS_DENORM wbs,
24665: PJI_XBS_DENORM prg,
24666: (
24667: select 1 WBS_SUP_LEVEL,
24668: 1 WBS_SUB_LEVEL,
25172: sum(pjp.CUSTOM14) CUSTOM14,
25173: sum(pjp.CUSTOM15) CUSTOM15
25174: from
25175: (
25176: select /*+ ordered index(wbs PA_XBS_DENORM_N2) parallel(pjp1) */ -- changed for bug 5927368
25177: -- get incremental task level amounts from source and
25178: -- program rollup amounts from interim
25179: wbs_hdr.WBS_VERSION_ID,
25180: 'LF' RELATIONSHIP_TYPE,
25242: pjp1.CUSTOM15
25243: from
25244: PJI_AC_AGGR_PJP1 pjp1,
25245: PJI_PJP_WBS_HEADER wbs_hdr,
25246: PA_XBS_DENORM wbs,
25247: PJI_XBS_DENORM prg,
25248: (
25249: select 1 WBS_SUP_LEVEL,
25250: 1 WBS_SUB_LEVEL,
25754: sum(pjp.CUSTOM14) CUSTOM14,
25755: sum(pjp.CUSTOM15) CUSTOM15
25756: from
25757: (
25758: select /*+ ordered index(wbs PA_XBS_DENORM_N2) parallel(pjp1) */ -- changed for bug 5927368
25759: -- get incremental task level amounts from source and
25760: -- program rollup amounts from interim
25761: wbs_hdr.WBS_VERSION_ID,
25762: 'LF' RELATIONSHIP_TYPE,
25824: pjp1.CUSTOM15
25825: from
25826: PJI_AC_AGGR_PJP1 pjp1,
25827: PJI_PJP_WBS_HEADER wbs_hdr,
25828: PA_XBS_DENORM wbs,
25829: PJI_XBS_DENORM prg,
25830: (
25831: select 1 WBS_SUP_LEVEL,
25832: 1 WBS_SUB_LEVEL,
26336: sum(pjp.CUSTOM14) CUSTOM14,
26337: sum(pjp.CUSTOM15) CUSTOM15
26338: from
26339: (
26340: select /*+ ordered index(wbs PA_XBS_DENORM_N2) parallel(pjp1) */ -- changed for bug 5927368
26341: -- get incremental task level amounts from source and
26342: -- program rollup amounts from interim
26343: wbs_hdr.WBS_VERSION_ID,
26344: 'LF' RELATIONSHIP_TYPE,
26406: pjp1.CUSTOM15
26407: from
26408: PJI_AC_AGGR_PJP1 pjp1,
26409: PJI_PJP_WBS_HEADER wbs_hdr,
26410: PA_XBS_DENORM wbs,
26411: PJI_XBS_DENORM prg,
26412: (
26413: select 1 WBS_SUP_LEVEL,
26414: 1 WBS_SUB_LEVEL,
27632: from
27633: PJI_FP_AGGR_PJP1 pjp1,
27634: PJI_PJP_WBS_HEADER wbs_hdr,
27635: PA_PROJ_ELEMENTS prj_emt,
27636: PA_XBS_DENORM prg,
27637: PJI_XBS_DENORM_DELTA prg_delta,
27638: PJI_PJP_WBS_HEADER sup_wbs_hdr,
27639: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
27640: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
27732: ) pjp,
27733: PJI_PJP_PROJ_BATCH_MAP map,
27734: PA_PROJ_WORKPLAN_ATTR sup_wpa,
27735: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
27736: PA_XBS_DENORM wbs,
27737: (
27738: select 1 WBS_SUP_LEVEL,
27739: 'PRJ' INVERT_ID
27740: from DUAL
28677: from
28678: PJI_FP_AGGR_PJP1 pjp1,
28679: PJI_PJP_WBS_HEADER wbs_hdr,
28680: PA_PROJ_ELEMENTS prj_emt,
28681: PA_XBS_DENORM prg,
28682: PJI_XBS_DENORM_DELTA prg_delta,
28683: PJI_PJP_WBS_HEADER sup_wbs_hdr,
28684: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
28685: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
28777: ) pjp,
28778: PJI_PJP_PROJ_BATCH_MAP map,
28779: PA_PROJ_WORKPLAN_ATTR sup_wpa,
28780: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
28781: PA_XBS_DENORM wbs,
28782: (
28783: select 1 WBS_SUP_LEVEL,
28784: 'PRJ' INVERT_ID
28785: from DUAL
29722: from
29723: PJI_FP_AGGR_PJP1 pjp1,
29724: PJI_PJP_WBS_HEADER wbs_hdr,
29725: PA_PROJ_ELEMENTS prj_emt,
29726: PA_XBS_DENORM prg,
29727: PJI_XBS_DENORM_DELTA prg_delta,
29728: PJI_PJP_WBS_HEADER sup_wbs_hdr,
29729: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
29730: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
29822: ) pjp,
29823: PJI_PJP_PROJ_BATCH_MAP map,
29824: PA_PROJ_WORKPLAN_ATTR sup_wpa,
29825: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
29826: PA_XBS_DENORM wbs,
29827: (
29828: select 1 WBS_SUP_LEVEL,
29829: 'PRJ' INVERT_ID
29830: from DUAL
30767: from
30768: PJI_FP_AGGR_PJP1 pjp1,
30769: PJI_PJP_WBS_HEADER wbs_hdr,
30770: PA_PROJ_ELEMENTS prj_emt,
30771: PA_XBS_DENORM prg,
30772: PJI_XBS_DENORM_DELTA prg_delta,
30773: PJI_PJP_WBS_HEADER sup_wbs_hdr,
30774: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
30775: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
30867: ) pjp,
30868: PJI_PJP_PROJ_BATCH_MAP map,
30869: PA_PROJ_WORKPLAN_ATTR sup_wpa,
30870: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
30871: PA_XBS_DENORM wbs,
30872: (
30873: select 1 WBS_SUP_LEVEL,
30874: 'PRJ' INVERT_ID
30875: from DUAL
31812: from
31813: PJI_FP_AGGR_PJP1 pjp1,
31814: PJI_PJP_WBS_HEADER wbs_hdr,
31815: PA_PROJ_ELEMENTS prj_emt,
31816: PA_XBS_DENORM prg,
31817: PJI_XBS_DENORM_DELTA prg_delta,
31818: PJI_PJP_WBS_HEADER sup_wbs_hdr,
31819: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
31820: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
31912: ) pjp,
31913: PJI_PJP_PROJ_BATCH_MAP map,
31914: PA_PROJ_WORKPLAN_ATTR sup_wpa,
31915: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
31916: PA_XBS_DENORM wbs,
31917: (
31918: select 1 WBS_SUP_LEVEL,
31919: 'PRJ' INVERT_ID
31920: from DUAL
32857: from
32858: PJI_FP_AGGR_PJP1 pjp1,
32859: PJI_PJP_WBS_HEADER wbs_hdr,
32860: PA_PROJ_ELEMENTS prj_emt,
32861: PA_XBS_DENORM prg,
32862: PJI_XBS_DENORM_DELTA prg_delta,
32863: PJI_PJP_WBS_HEADER sup_wbs_hdr,
32864: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
32865: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
32957: ) pjp,
32958: PJI_PJP_PROJ_BATCH_MAP map,
32959: PA_PROJ_WORKPLAN_ATTR sup_wpa,
32960: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
32961: PA_XBS_DENORM wbs,
32962: (
32963: select 1 WBS_SUP_LEVEL,
32964: 'PRJ' INVERT_ID
32965: from DUAL
33902: from
33903: PJI_FP_AGGR_PJP1 pjp1,
33904: PJI_PJP_WBS_HEADER wbs_hdr,
33905: PA_PROJ_ELEMENTS prj_emt,
33906: PA_XBS_DENORM prg,
33907: PJI_XBS_DENORM_DELTA prg_delta,
33908: PJI_PJP_WBS_HEADER sup_wbs_hdr,
33909: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
33910: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
34002: ) pjp,
34003: PJI_PJP_PROJ_BATCH_MAP map,
34004: PA_PROJ_WORKPLAN_ATTR sup_wpa,
34005: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
34006: PA_XBS_DENORM wbs,
34007: (
34008: select 1 WBS_SUP_LEVEL,
34009: 'PRJ' INVERT_ID
34010: from DUAL
34947: from
34948: PJI_FP_AGGR_PJP1 pjp1,
34949: PJI_PJP_WBS_HEADER wbs_hdr,
34950: PA_PROJ_ELEMENTS prj_emt,
34951: PA_XBS_DENORM prg,
34952: PJI_XBS_DENORM_DELTA prg_delta,
34953: PJI_PJP_WBS_HEADER sup_wbs_hdr,
34954: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
34955: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
35047: ) pjp,
35048: PJI_PJP_PROJ_BATCH_MAP map,
35049: PA_PROJ_WORKPLAN_ATTR sup_wpa,
35050: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
35051: PA_XBS_DENORM wbs,
35052: (
35053: select 1 WBS_SUP_LEVEL,
35054: 'PRJ' INVERT_ID
35055: from DUAL
35992: from
35993: PJI_FP_AGGR_PJP1 pjp1,
35994: PJI_PJP_WBS_HEADER wbs_hdr,
35995: PA_PROJ_ELEMENTS prj_emt,
35996: PA_XBS_DENORM prg,
35997: PJI_XBS_DENORM_DELTA prg_delta,
35998: PJI_PJP_WBS_HEADER sup_wbs_hdr,
35999: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
36000: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
36092: ) pjp,
36093: PJI_PJP_PROJ_BATCH_MAP map,
36094: PA_PROJ_WORKPLAN_ATTR sup_wpa,
36095: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
36096: PA_XBS_DENORM wbs,
36097: (
36098: select 1 WBS_SUP_LEVEL,
36099: 'PRJ' INVERT_ID
36100: from DUAL
37037: from
37038: PJI_FP_AGGR_PJP1 pjp1,
37039: PJI_PJP_WBS_HEADER wbs_hdr,
37040: PA_PROJ_ELEMENTS prj_emt,
37041: PA_XBS_DENORM prg,
37042: PJI_XBS_DENORM_DELTA prg_delta,
37043: PJI_PJP_WBS_HEADER sup_wbs_hdr,
37044: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
37045: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
37137: ) pjp,
37138: PJI_PJP_PROJ_BATCH_MAP map,
37139: PA_PROJ_WORKPLAN_ATTR sup_wpa,
37140: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
37141: PA_XBS_DENORM wbs,
37142: (
37143: select 1 WBS_SUP_LEVEL,
37144: 'PRJ' INVERT_ID
37145: from DUAL
37478: from
37479: PJI_AC_AGGR_PJP1 pjp1,
37480: PJI_PJP_WBS_HEADER wbs_hdr,
37481: PA_PROJ_ELEMENTS prj_emt,
37482: PA_XBS_DENORM prg,
37483: PJI_XBS_DENORM_DELTA prg_delta
37484: where
37485: prg.STRUCT_TYPE = 'PRG' and
37486: prg.SUP_LEVEL = l_level and
37515: ) pjp,
37516: PJI_PJP_PROJ_BATCH_MAP map,
37517: PA_PROJ_WORKPLAN_ATTR sup_wpa,
37518: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
37519: PA_XBS_DENORM wbs,
37520: (
37521: select 1 WBS_SUP_LEVEL,
37522: 'PRJ' INVERT_ID
37523: from DUAL
37821: from
37822: PJI_AC_AGGR_PJP1 pjp1,
37823: PJI_PJP_WBS_HEADER wbs_hdr,
37824: PA_PROJ_ELEMENTS prj_emt,
37825: PA_XBS_DENORM prg,
37826: PJI_XBS_DENORM_DELTA prg_delta
37827: where
37828: prg.STRUCT_TYPE = 'PRG' and
37829: prg.SUP_LEVEL = l_level and
37858: ) pjp,
37859: PJI_PJP_PROJ_BATCH_MAP map,
37860: PA_PROJ_WORKPLAN_ATTR sup_wpa,
37861: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
37862: PA_XBS_DENORM wbs,
37863: (
37864: select 1 WBS_SUP_LEVEL,
37865: 'PRJ' INVERT_ID
37866: from DUAL
38163: from
38164: PJI_AC_AGGR_PJP1 pjp1,
38165: PJI_PJP_WBS_HEADER wbs_hdr,
38166: PA_PROJ_ELEMENTS prj_emt,
38167: PA_XBS_DENORM prg,
38168: PJI_XBS_DENORM_DELTA prg_delta
38169: where
38170: prg.STRUCT_TYPE = 'PRG' and
38171: prg.SUP_LEVEL = l_level and
38200: ) pjp,
38201: PJI_PJP_PROJ_BATCH_MAP map,
38202: PA_PROJ_WORKPLAN_ATTR sup_wpa,
38203: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
38204: PA_XBS_DENORM wbs,
38205: (
38206: select 1 WBS_SUP_LEVEL,
38207: 'PRJ' INVERT_ID
38208: from DUAL
38505: from
38506: PJI_AC_AGGR_PJP1 pjp1,
38507: PJI_PJP_WBS_HEADER wbs_hdr,
38508: PA_PROJ_ELEMENTS prj_emt,
38509: PA_XBS_DENORM prg,
38510: PJI_XBS_DENORM_DELTA prg_delta
38511: where
38512: prg.STRUCT_TYPE = 'PRG' and
38513: prg.SUP_LEVEL = l_level and
38542: ) pjp,
38543: PJI_PJP_PROJ_BATCH_MAP map,
38544: PA_PROJ_WORKPLAN_ATTR sup_wpa,
38545: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
38546: PA_XBS_DENORM wbs,
38547: (
38548: select 1 WBS_SUP_LEVEL,
38549: 'PRJ' INVERT_ID
38550: from DUAL
38847: from
38848: PJI_AC_AGGR_PJP1 pjp1,
38849: PJI_PJP_WBS_HEADER wbs_hdr,
38850: PA_PROJ_ELEMENTS prj_emt,
38851: PA_XBS_DENORM prg,
38852: PJI_XBS_DENORM_DELTA prg_delta
38853: where
38854: prg.STRUCT_TYPE = 'PRG' and
38855: prg.SUP_LEVEL = l_level and
38884: ) pjp,
38885: PJI_PJP_PROJ_BATCH_MAP map,
38886: PA_PROJ_WORKPLAN_ATTR sup_wpa,
38887: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
38888: PA_XBS_DENORM wbs,
38889: (
38890: select 1 WBS_SUP_LEVEL,
38891: 'PRJ' INVERT_ID
38892: from DUAL
39189: from
39190: PJI_AC_AGGR_PJP1 pjp1,
39191: PJI_PJP_WBS_HEADER wbs_hdr,
39192: PA_PROJ_ELEMENTS prj_emt,
39193: PA_XBS_DENORM prg,
39194: PJI_XBS_DENORM_DELTA prg_delta
39195: where
39196: prg.STRUCT_TYPE = 'PRG' and
39197: prg.SUP_LEVEL = l_level and
39226: ) pjp,
39227: PJI_PJP_PROJ_BATCH_MAP map,
39228: PA_PROJ_WORKPLAN_ATTR sup_wpa,
39229: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
39230: PA_XBS_DENORM wbs,
39231: (
39232: select 1 WBS_SUP_LEVEL,
39233: 'PRJ' INVERT_ID
39234: from DUAL
39531: from
39532: PJI_AC_AGGR_PJP1 pjp1,
39533: PJI_PJP_WBS_HEADER wbs_hdr,
39534: PA_PROJ_ELEMENTS prj_emt,
39535: PA_XBS_DENORM prg,
39536: PJI_XBS_DENORM_DELTA prg_delta
39537: where
39538: prg.STRUCT_TYPE = 'PRG' and
39539: prg.SUP_LEVEL = l_level and
39568: ) pjp,
39569: PJI_PJP_PROJ_BATCH_MAP map,
39570: PA_PROJ_WORKPLAN_ATTR sup_wpa,
39571: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
39572: PA_XBS_DENORM wbs,
39573: (
39574: select 1 WBS_SUP_LEVEL,
39575: 'PRJ' INVERT_ID
39576: from DUAL
39873: from
39874: PJI_AC_AGGR_PJP1 pjp1,
39875: PJI_PJP_WBS_HEADER wbs_hdr,
39876: PA_PROJ_ELEMENTS prj_emt,
39877: PA_XBS_DENORM prg,
39878: PJI_XBS_DENORM_DELTA prg_delta
39879: where
39880: prg.STRUCT_TYPE = 'PRG' and
39881: prg.SUP_LEVEL = l_level and
39910: ) pjp,
39911: PJI_PJP_PROJ_BATCH_MAP map,
39912: PA_PROJ_WORKPLAN_ATTR sup_wpa,
39913: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
39914: PA_XBS_DENORM wbs,
39915: (
39916: select 1 WBS_SUP_LEVEL,
39917: 'PRJ' INVERT_ID
39918: from DUAL
40215: from
40216: PJI_AC_AGGR_PJP1 pjp1,
40217: PJI_PJP_WBS_HEADER wbs_hdr,
40218: PA_PROJ_ELEMENTS prj_emt,
40219: PA_XBS_DENORM prg,
40220: PJI_XBS_DENORM_DELTA prg_delta
40221: where
40222: prg.STRUCT_TYPE = 'PRG' and
40223: prg.SUP_LEVEL = l_level and
40252: ) pjp,
40253: PJI_PJP_PROJ_BATCH_MAP map,
40254: PA_PROJ_WORKPLAN_ATTR sup_wpa,
40255: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
40256: PA_XBS_DENORM wbs,
40257: (
40258: select 1 WBS_SUP_LEVEL,
40259: 'PRJ' INVERT_ID
40260: from DUAL
40557: from
40558: PJI_AC_AGGR_PJP1 pjp1,
40559: PJI_PJP_WBS_HEADER wbs_hdr,
40560: PA_PROJ_ELEMENTS prj_emt,
40561: PA_XBS_DENORM prg,
40562: PJI_XBS_DENORM_DELTA prg_delta
40563: where
40564: prg.STRUCT_TYPE = 'PRG' and
40565: prg.SUP_LEVEL = l_level and
40594: ) pjp,
40595: PJI_PJP_PROJ_BATCH_MAP map,
40596: PA_PROJ_WORKPLAN_ATTR sup_wpa,
40597: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
40598: PA_XBS_DENORM wbs,
40599: (
40600: select 1 WBS_SUP_LEVEL,
40601: 'PRJ' INVERT_ID
40602: from DUAL
45103: from PJI_PJP_WBS_HEADER a
45104: where a.project_id in ( select b.project_id from PJI_PJP_PROJ_BATCH_MAP b
45105: where b.worker_id = p_worker_id );
45106:
45107: insert into PJI_PA_XBS_DENORM_T
45108: (STRUCT_TYPE,
45109: PRG_GROUP,
45110: STRUCT_VERSION_ID,
45111: SUP_PROJECT_ID,
45145: CREATED_BY,
45146: LAST_UPDATE_LOGIN,
45147: STRUCT_EMT_ID,
45148: RELATIONSHIP_TYPE
45149: from PA_XBS_DENORM a
45150: where a.STRUCT_VERSION_ID in ( select /*+ cardinality(b,1) */ b.wbs_VERSION_ID -- Hint added for bug 11694228
45151: from PJI_PJP_WBS_HEADER_T b, PJI_PJP_PROJ_BATCH_MAP c
45152: where c.worker_id = p_worker_id
45153: and b.project_id = c.project_id)
45198: STRUCT_EMT_ID,
45199: RELATIONSHIP_TYPE
45200: from PJI_XBS_DENORM a
45201: where a.SUP_PROJECT_ID in ( select distinct b.SUP_PROJECT_ID
45202: from PJI_PA_XBS_DENORM_T b, PJI_PJP_PROJ_BATCH_MAP c
45203: where c.worker_id = p_worker_id
45204: and b.sup_project_id = c.project_id);
45205:
45206:
45927: sum(pjp.CUSTOM14) CUSTOM14,
45928: sum(pjp.CUSTOM15) CUSTOM15
45929: from
45930: (
45931: select /*+ leading(helper) index(wbs PA_XBS_DENORM_N2) parallel(pjp1) use_hash(pjp1) */
45932: -- get incremental task level amounts from source and
45933: -- program rollup amounts from interim
45934: to_char(null) LINE_TYPE,
45935: wbs_hdr.WBS_VERSION_ID,
46042: from
46043: PJI_FP_AGGR_PJP1 pjp1,
46044: PJI_HELPER_420 helper,
46045: PJI_PJP_WBS_HEADER_T wbs_hdr,
46046: PA_XBS_DENORM wbs,
46047: PJI_XBS_DENORM_T prg,
46048: (
46049: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
46050: from DUAL union all