[Home] [Help]
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
8490: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8635: pjp1.CUSTOM15
8636: from
8637: PJI_FP_AGGR_PJP1 pjp1,
8638: PJI_PJP_WBS_HEADER wbs_hdr,
8639: PJI_XBS_DENORM prg,
8640: (
8641: select 'Y' CB_FLAG,
8642: 'N' CO_FLAG,
8643: -3 PLAN_VERSION_ID
8786: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
8787: from
8788: PJI_PA_PROJ_EVENTS_LOG log,
8789: PJI_PJP_WBS_HEADER wbs_hdr,
8790: PJI_XBS_DENORM_DELTA wbs,
8791: PJI_XBS_DENORM prg,
8792: PJI_FP_XBS_ACCUM_F fpr,
8793: (
8794: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
8787: from
8788: PJI_PA_PROJ_EVENTS_LOG log,
8789: PJI_PJP_WBS_HEADER wbs_hdr,
8790: PJI_XBS_DENORM_DELTA wbs,
8791: PJI_XBS_DENORM prg,
8792: PJI_FP_XBS_ACCUM_F fpr,
8793: (
8794: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
8795: from DUAL union all
8875: 'LF', 'N') WP_FLAG,
8876: 'Y' PUSHUP_FLAG
8877: from
8878: PJI_PJP_PROJ_BATCH_MAP map,
8879: PJI_XBS_DENORM prg,
8880: (
8881: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
8882: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
8883: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
8882: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
8883: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
8884: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
8885: ) invert,
8886: PJI_XBS_DENORM_DELTA prg_delta
8887: where
8888: prg.STRUCT_TYPE = 'PRG' and
8889: prg.SUB_ROLLUP_ID is not null and
8890: prg.SUB_LEVEL = l_level and
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
9811: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9956: pjp1.CUSTOM15
9957: from
9958: PJI_FP_AGGR_PJP1 pjp1,
9959: PJI_PJP_WBS_HEADER wbs_hdr,
9960: PJI_XBS_DENORM prg,
9961: (
9962: select 'Y' CB_FLAG,
9963: 'N' CO_FLAG,
9964: -3 PLAN_VERSION_ID
10107: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
10108: from
10109: PJI_PA_PROJ_EVENTS_LOG log,
10110: PJI_PJP_WBS_HEADER wbs_hdr,
10111: PJI_XBS_DENORM_DELTA wbs,
10112: PJI_XBS_DENORM prg,
10113: PJI_FP_XBS_ACCUM_F fpr,
10114: (
10115: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10108: from
10109: PJI_PA_PROJ_EVENTS_LOG log,
10110: PJI_PJP_WBS_HEADER wbs_hdr,
10111: PJI_XBS_DENORM_DELTA wbs,
10112: PJI_XBS_DENORM prg,
10113: PJI_FP_XBS_ACCUM_F fpr,
10114: (
10115: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10116: from DUAL union all
10196: 'LF', 'N') WP_FLAG,
10197: 'Y' PUSHUP_FLAG
10198: from
10199: PJI_PJP_PROJ_BATCH_MAP map,
10200: PJI_XBS_DENORM prg,
10201: (
10202: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
10203: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
10204: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
10203: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
10204: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
10205: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
10206: ) invert,
10207: PJI_XBS_DENORM_DELTA prg_delta
10208: where
10209: prg.STRUCT_TYPE = 'PRG' and
10210: prg.SUB_ROLLUP_ID is not null and
10211: prg.SUB_LEVEL = l_level and
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
11130: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11275: pjp1.CUSTOM15
11276: from
11277: PJI_FP_AGGR_PJP1 pjp1,
11278: PJI_PJP_WBS_HEADER wbs_hdr,
11279: PJI_XBS_DENORM prg,
11280: (
11281: select 'Y' CB_FLAG,
11282: 'N' CO_FLAG,
11283: -3 PLAN_VERSION_ID
11426: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
11427: from
11428: PJI_PA_PROJ_EVENTS_LOG log,
11429: PJI_PJP_WBS_HEADER wbs_hdr,
11430: PJI_XBS_DENORM_DELTA wbs,
11431: PJI_XBS_DENORM prg,
11432: PJI_FP_XBS_ACCUM_F fpr,
11433: (
11434: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
11427: from
11428: PJI_PA_PROJ_EVENTS_LOG log,
11429: PJI_PJP_WBS_HEADER wbs_hdr,
11430: PJI_XBS_DENORM_DELTA wbs,
11431: PJI_XBS_DENORM prg,
11432: PJI_FP_XBS_ACCUM_F fpr,
11433: (
11434: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
11435: from DUAL union all
11515: 'LF', 'N') WP_FLAG,
11516: 'Y' PUSHUP_FLAG
11517: from
11518: PJI_PJP_PROJ_BATCH_MAP map,
11519: PJI_XBS_DENORM prg,
11520: (
11521: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
11522: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
11523: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
11522: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
11523: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
11524: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
11525: ) invert,
11526: PJI_XBS_DENORM_DELTA prg_delta
11527: where
11528: prg.STRUCT_TYPE = 'PRG' and
11529: prg.SUB_ROLLUP_ID is not null and
11530: prg.SUB_LEVEL = l_level and
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
12448: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12593: pjp1.CUSTOM15
12594: from
12595: PJI_FP_AGGR_PJP1 pjp1,
12596: PJI_PJP_WBS_HEADER wbs_hdr,
12597: PJI_XBS_DENORM prg,
12598: (
12599: select 'Y' CB_FLAG,
12600: 'N' CO_FLAG,
12601: -3 PLAN_VERSION_ID
12744: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
12745: from
12746: PJI_PA_PROJ_EVENTS_LOG log,
12747: PJI_PJP_WBS_HEADER wbs_hdr,
12748: PJI_XBS_DENORM_DELTA wbs,
12749: PJI_XBS_DENORM prg,
12750: PJI_FP_XBS_ACCUM_F fpr,
12751: (
12752: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12745: from
12746: PJI_PA_PROJ_EVENTS_LOG log,
12747: PJI_PJP_WBS_HEADER wbs_hdr,
12748: PJI_XBS_DENORM_DELTA wbs,
12749: PJI_XBS_DENORM prg,
12750: PJI_FP_XBS_ACCUM_F fpr,
12751: (
12752: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12753: from DUAL union all
12833: 'LF', 'N') WP_FLAG,
12834: 'Y' PUSHUP_FLAG
12835: from
12836: PJI_PJP_PROJ_BATCH_MAP map,
12837: PJI_XBS_DENORM prg,
12838: (
12839: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
12840: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
12841: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
12840: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
12841: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
12842: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
12843: ) invert,
12844: PJI_XBS_DENORM_DELTA prg_delta
12845: where
12846: prg.STRUCT_TYPE = 'PRG' and
12847: prg.SUB_ROLLUP_ID is not null and
12848: prg.SUB_LEVEL = l_level and
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
13766: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13911: pjp1.CUSTOM15
13912: from
13913: PJI_FP_AGGR_PJP1 pjp1,
13914: PJI_PJP_WBS_HEADER wbs_hdr,
13915: PJI_XBS_DENORM prg,
13916: (
13917: select 'Y' CB_FLAG,
13918: 'N' CO_FLAG,
13919: -3 PLAN_VERSION_ID
14062: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
14063: from
14064: PJI_PA_PROJ_EVENTS_LOG log,
14065: PJI_PJP_WBS_HEADER wbs_hdr,
14066: PJI_XBS_DENORM_DELTA wbs,
14067: PJI_XBS_DENORM prg,
14068: PJI_FP_XBS_ACCUM_F fpr,
14069: (
14070: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
14063: from
14064: PJI_PA_PROJ_EVENTS_LOG log,
14065: PJI_PJP_WBS_HEADER wbs_hdr,
14066: PJI_XBS_DENORM_DELTA wbs,
14067: PJI_XBS_DENORM prg,
14068: PJI_FP_XBS_ACCUM_F fpr,
14069: (
14070: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
14071: from DUAL union all
14151: 'LF', 'N') WP_FLAG,
14152: 'Y' PUSHUP_FLAG
14153: from
14154: PJI_PJP_PROJ_BATCH_MAP map,
14155: PJI_XBS_DENORM prg,
14156: (
14157: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
14158: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
14159: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
14158: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
14159: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
14160: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
14161: ) invert,
14162: PJI_XBS_DENORM_DELTA prg_delta
14163: where
14164: prg.STRUCT_TYPE = 'PRG' and
14165: prg.SUB_ROLLUP_ID is not null and
14166: prg.SUB_LEVEL = l_level and
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
15084: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15229: pjp1.CUSTOM15
15230: from
15231: PJI_FP_AGGR_PJP1 pjp1,
15232: PJI_PJP_WBS_HEADER wbs_hdr,
15233: PJI_XBS_DENORM prg,
15234: (
15235: select 'Y' CB_FLAG,
15236: 'N' CO_FLAG,
15237: -3 PLAN_VERSION_ID
15380: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
15381: from
15382: PJI_PA_PROJ_EVENTS_LOG log,
15383: PJI_PJP_WBS_HEADER wbs_hdr,
15384: PJI_XBS_DENORM_DELTA wbs,
15385: PJI_XBS_DENORM prg,
15386: PJI_FP_XBS_ACCUM_F fpr,
15387: (
15388: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15381: from
15382: PJI_PA_PROJ_EVENTS_LOG log,
15383: PJI_PJP_WBS_HEADER wbs_hdr,
15384: PJI_XBS_DENORM_DELTA wbs,
15385: PJI_XBS_DENORM prg,
15386: PJI_FP_XBS_ACCUM_F fpr,
15387: (
15388: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15389: from DUAL union all
15469: 'LF', 'N') WP_FLAG,
15470: 'Y' PUSHUP_FLAG
15471: from
15472: PJI_PJP_PROJ_BATCH_MAP map,
15473: PJI_XBS_DENORM prg,
15474: (
15475: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
15476: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
15477: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
15476: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
15477: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
15478: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
15479: ) invert,
15480: PJI_XBS_DENORM_DELTA prg_delta
15481: where
15482: prg.STRUCT_TYPE = 'PRG' and
15483: prg.SUB_ROLLUP_ID is not null and
15484: prg.SUB_LEVEL = l_level and
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
16402: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16547: pjp1.CUSTOM15
16548: from
16549: PJI_FP_AGGR_PJP1 pjp1,
16550: PJI_PJP_WBS_HEADER wbs_hdr,
16551: PJI_XBS_DENORM prg,
16552: (
16553: select 'Y' CB_FLAG,
16554: 'N' CO_FLAG,
16555: -3 PLAN_VERSION_ID
16698: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
16699: from
16700: PJI_PA_PROJ_EVENTS_LOG log,
16701: PJI_PJP_WBS_HEADER wbs_hdr,
16702: PJI_XBS_DENORM_DELTA wbs,
16703: PJI_XBS_DENORM prg,
16704: PJI_FP_XBS_ACCUM_F fpr,
16705: (
16706: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16699: from
16700: PJI_PA_PROJ_EVENTS_LOG log,
16701: PJI_PJP_WBS_HEADER wbs_hdr,
16702: PJI_XBS_DENORM_DELTA wbs,
16703: PJI_XBS_DENORM prg,
16704: PJI_FP_XBS_ACCUM_F fpr,
16705: (
16706: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16707: from DUAL union all
16787: 'LF', 'N') WP_FLAG,
16788: 'Y' PUSHUP_FLAG
16789: from
16790: PJI_PJP_PROJ_BATCH_MAP map,
16791: PJI_XBS_DENORM prg,
16792: (
16793: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
16794: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
16795: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
16794: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
16795: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
16796: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
16797: ) invert,
16798: PJI_XBS_DENORM_DELTA prg_delta
16799: where
16800: prg.STRUCT_TYPE = 'PRG' and
16801: prg.SUB_ROLLUP_ID is not null and
16802: prg.SUB_LEVEL = l_level and
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
17720: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
17865: pjp1.CUSTOM15
17866: from
17867: PJI_FP_AGGR_PJP1 pjp1,
17868: PJI_PJP_WBS_HEADER wbs_hdr,
17869: PJI_XBS_DENORM prg,
17870: (
17871: select 'Y' CB_FLAG,
17872: 'N' CO_FLAG,
17873: -3 PLAN_VERSION_ID
18016: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
18017: from
18018: PJI_PA_PROJ_EVENTS_LOG log,
18019: PJI_PJP_WBS_HEADER wbs_hdr,
18020: PJI_XBS_DENORM_DELTA wbs,
18021: PJI_XBS_DENORM prg,
18022: PJI_FP_XBS_ACCUM_F fpr,
18023: (
18024: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
18017: from
18018: PJI_PA_PROJ_EVENTS_LOG log,
18019: PJI_PJP_WBS_HEADER wbs_hdr,
18020: PJI_XBS_DENORM_DELTA wbs,
18021: PJI_XBS_DENORM prg,
18022: PJI_FP_XBS_ACCUM_F fpr,
18023: (
18024: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
18025: from DUAL union all
18105: 'LF', 'N') WP_FLAG,
18106: 'Y' PUSHUP_FLAG
18107: from
18108: PJI_PJP_PROJ_BATCH_MAP map,
18109: PJI_XBS_DENORM prg,
18110: (
18111: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
18112: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
18113: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
18112: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
18113: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
18114: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
18115: ) invert,
18116: PJI_XBS_DENORM_DELTA prg_delta
18117: where
18118: prg.STRUCT_TYPE = 'PRG' and
18119: prg.SUB_ROLLUP_ID is not null and
18120: prg.SUB_LEVEL = l_level and
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
19038: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19183: pjp1.CUSTOM15
19184: from
19185: PJI_FP_AGGR_PJP1 pjp1,
19186: PJI_PJP_WBS_HEADER wbs_hdr,
19187: PJI_XBS_DENORM prg,
19188: (
19189: select 'Y' CB_FLAG,
19190: 'N' CO_FLAG,
19191: -3 PLAN_VERSION_ID
19334: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
19335: from
19336: PJI_PA_PROJ_EVENTS_LOG log,
19337: PJI_PJP_WBS_HEADER wbs_hdr,
19338: PJI_XBS_DENORM_DELTA wbs,
19339: PJI_XBS_DENORM prg,
19340: PJI_FP_XBS_ACCUM_F fpr,
19341: (
19342: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
19335: from
19336: PJI_PA_PROJ_EVENTS_LOG log,
19337: PJI_PJP_WBS_HEADER wbs_hdr,
19338: PJI_XBS_DENORM_DELTA wbs,
19339: PJI_XBS_DENORM prg,
19340: PJI_FP_XBS_ACCUM_F fpr,
19341: (
19342: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
19343: from DUAL union all
19423: 'LF', 'N') WP_FLAG,
19424: 'Y' PUSHUP_FLAG
19425: from
19426: PJI_PJP_PROJ_BATCH_MAP map,
19427: PJI_XBS_DENORM prg,
19428: (
19429: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
19430: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
19431: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
19430: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
19431: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
19432: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
19433: ) invert,
19434: PJI_XBS_DENORM_DELTA prg_delta
19435: where
19436: prg.STRUCT_TYPE = 'PRG' and
19437: prg.SUB_ROLLUP_ID is not null and
19438: prg.SUB_LEVEL = l_level and
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
20356: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
20501: pjp1.CUSTOM15
20502: from
20503: PJI_FP_AGGR_PJP1 pjp1,
20504: PJI_PJP_WBS_HEADER wbs_hdr,
20505: PJI_XBS_DENORM prg,
20506: (
20507: select 'Y' CB_FLAG,
20508: 'N' CO_FLAG,
20509: -3 PLAN_VERSION_ID
20652: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
20653: from
20654: PJI_PA_PROJ_EVENTS_LOG log,
20655: PJI_PJP_WBS_HEADER wbs_hdr,
20656: PJI_XBS_DENORM_DELTA wbs,
20657: PJI_XBS_DENORM prg,
20658: PJI_FP_XBS_ACCUM_F fpr,
20659: (
20660: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
20653: from
20654: PJI_PA_PROJ_EVENTS_LOG log,
20655: PJI_PJP_WBS_HEADER wbs_hdr,
20656: PJI_XBS_DENORM_DELTA wbs,
20657: PJI_XBS_DENORM prg,
20658: PJI_FP_XBS_ACCUM_F fpr,
20659: (
20660: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
20661: from DUAL union all
20741: 'LF', 'N') WP_FLAG,
20742: 'Y' PUSHUP_FLAG
20743: from
20744: PJI_PJP_PROJ_BATCH_MAP map,
20745: PJI_XBS_DENORM prg,
20746: (
20747: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
20748: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
20749: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
20748: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
20749: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
20750: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
20751: ) invert,
20752: PJI_XBS_DENORM_DELTA prg_delta
20753: where
20754: prg.STRUCT_TYPE = 'PRG' and
20755: prg.SUB_ROLLUP_ID is not null and
20756: prg.SUB_LEVEL = l_level and
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,
21177: 'PRJ' INVERT_ID
21264: pjp1.CUSTOM15
21265: from
21266: PJI_AC_AGGR_PJP1 pjp1,
21267: PJI_PJP_WBS_HEADER wbs_hdr,
21268: PJI_XBS_DENORM prg
21269: where
21270: prg.STRUCT_TYPE = 'PRG' and
21271: prg.SUP_LEVEL = l_level and
21272: prg.SUB_LEVEL = l_level and
21357: wbs.SIGN * acr.CUSTOM15 CUSTOM15
21358: from
21359: PJI_PA_PROJ_EVENTS_LOG log,
21360: PJI_PJP_WBS_HEADER wbs_hdr,
21361: PJI_XBS_DENORM_DELTA wbs,
21362: PJI_XBS_DENORM prg,
21363: PJI_AC_XBS_ACCUM_F acr,
21364: (
21365: select 1 WBS_SUP_LEVEL,
21358: from
21359: PJI_PA_PROJ_EVENTS_LOG log,
21360: PJI_PJP_WBS_HEADER wbs_hdr,
21361: PJI_XBS_DENORM_DELTA wbs,
21362: PJI_XBS_DENORM prg,
21363: PJI_AC_XBS_ACCUM_F acr,
21364: (
21365: select 1 WBS_SUP_LEVEL,
21366: 1 WBS_SUB_LEVEL,
21414: prg.RELATIONSHIP_TYPE RELATIONSHIP_TYPE,
21415: 'Y' PUSHUP_FLAG
21416: from
21417: PJI_PJP_PROJ_BATCH_MAP map,
21418: PJI_XBS_DENORM prg,
21419: PJI_XBS_DENORM_DELTA prg_delta
21420: where
21421: prg.STRUCT_TYPE = 'PRG' and
21422: prg.RELATIONSHIP_TYPE = 'LF' and
21415: 'Y' PUSHUP_FLAG
21416: from
21417: PJI_PJP_PROJ_BATCH_MAP map,
21418: PJI_XBS_DENORM prg,
21419: PJI_XBS_DENORM_DELTA prg_delta
21420: where
21421: prg.STRUCT_TYPE = 'PRG' and
21422: prg.RELATIONSHIP_TYPE = 'LF' and
21423: prg.SUB_ROLLUP_ID is not null and
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,
21759: 'PRJ' INVERT_ID
21846: pjp1.CUSTOM15
21847: from
21848: PJI_AC_AGGR_PJP1 pjp1,
21849: PJI_PJP_WBS_HEADER wbs_hdr,
21850: PJI_XBS_DENORM prg
21851: where
21852: prg.STRUCT_TYPE = 'PRG' and
21853: prg.SUP_LEVEL = l_level and
21854: prg.SUB_LEVEL = l_level and
21939: wbs.SIGN * acr.CUSTOM15 CUSTOM15
21940: from
21941: PJI_PA_PROJ_EVENTS_LOG log,
21942: PJI_PJP_WBS_HEADER wbs_hdr,
21943: PJI_XBS_DENORM_DELTA wbs,
21944: PJI_XBS_DENORM prg,
21945: PJI_AC_XBS_ACCUM_F acr,
21946: (
21947: select 1 WBS_SUP_LEVEL,
21940: from
21941: PJI_PA_PROJ_EVENTS_LOG log,
21942: PJI_PJP_WBS_HEADER wbs_hdr,
21943: PJI_XBS_DENORM_DELTA wbs,
21944: PJI_XBS_DENORM prg,
21945: PJI_AC_XBS_ACCUM_F acr,
21946: (
21947: select 1 WBS_SUP_LEVEL,
21948: 1 WBS_SUB_LEVEL,
21996: prg.RELATIONSHIP_TYPE RELATIONSHIP_TYPE,
21997: 'Y' PUSHUP_FLAG
21998: from
21999: PJI_PJP_PROJ_BATCH_MAP map,
22000: PJI_XBS_DENORM prg,
22001: PJI_XBS_DENORM_DELTA prg_delta
22002: where
22003: prg.STRUCT_TYPE = 'PRG' and
22004: prg.RELATIONSHIP_TYPE = 'LF' and
21997: 'Y' PUSHUP_FLAG
21998: from
21999: PJI_PJP_PROJ_BATCH_MAP map,
22000: PJI_XBS_DENORM prg,
22001: PJI_XBS_DENORM_DELTA prg_delta
22002: where
22003: prg.STRUCT_TYPE = 'PRG' and
22004: prg.RELATIONSHIP_TYPE = 'LF' and
22005: prg.SUB_ROLLUP_ID is not null and
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,
22341: 'PRJ' INVERT_ID
22428: pjp1.CUSTOM15
22429: from
22430: PJI_AC_AGGR_PJP1 pjp1,
22431: PJI_PJP_WBS_HEADER wbs_hdr,
22432: PJI_XBS_DENORM prg
22433: where
22434: prg.STRUCT_TYPE = 'PRG' and
22435: prg.SUP_LEVEL = l_level and
22436: prg.SUB_LEVEL = l_level and
22521: wbs.SIGN * acr.CUSTOM15 CUSTOM15
22522: from
22523: PJI_PA_PROJ_EVENTS_LOG log,
22524: PJI_PJP_WBS_HEADER wbs_hdr,
22525: PJI_XBS_DENORM_DELTA wbs,
22526: PJI_XBS_DENORM prg,
22527: PJI_AC_XBS_ACCUM_F acr,
22528: (
22529: select 1 WBS_SUP_LEVEL,
22522: from
22523: PJI_PA_PROJ_EVENTS_LOG log,
22524: PJI_PJP_WBS_HEADER wbs_hdr,
22525: PJI_XBS_DENORM_DELTA wbs,
22526: PJI_XBS_DENORM prg,
22527: PJI_AC_XBS_ACCUM_F acr,
22528: (
22529: select 1 WBS_SUP_LEVEL,
22530: 1 WBS_SUB_LEVEL,
22578: prg.RELATIONSHIP_TYPE RELATIONSHIP_TYPE,
22579: 'Y' PUSHUP_FLAG
22580: from
22581: PJI_PJP_PROJ_BATCH_MAP map,
22582: PJI_XBS_DENORM prg,
22583: PJI_XBS_DENORM_DELTA prg_delta
22584: where
22585: prg.STRUCT_TYPE = 'PRG' and
22586: prg.RELATIONSHIP_TYPE = 'LF' and
22579: 'Y' PUSHUP_FLAG
22580: from
22581: PJI_PJP_PROJ_BATCH_MAP map,
22582: PJI_XBS_DENORM prg,
22583: PJI_XBS_DENORM_DELTA prg_delta
22584: where
22585: prg.STRUCT_TYPE = 'PRG' and
22586: prg.RELATIONSHIP_TYPE = 'LF' and
22587: prg.SUB_ROLLUP_ID is not null and
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,
22923: 'PRJ' INVERT_ID
23010: pjp1.CUSTOM15
23011: from
23012: PJI_AC_AGGR_PJP1 pjp1,
23013: PJI_PJP_WBS_HEADER wbs_hdr,
23014: PJI_XBS_DENORM prg
23015: where
23016: prg.STRUCT_TYPE = 'PRG' and
23017: prg.SUP_LEVEL = l_level and
23018: prg.SUB_LEVEL = l_level and
23103: wbs.SIGN * acr.CUSTOM15 CUSTOM15
23104: from
23105: PJI_PA_PROJ_EVENTS_LOG log,
23106: PJI_PJP_WBS_HEADER wbs_hdr,
23107: PJI_XBS_DENORM_DELTA wbs,
23108: PJI_XBS_DENORM prg,
23109: PJI_AC_XBS_ACCUM_F acr,
23110: (
23111: select 1 WBS_SUP_LEVEL,
23104: from
23105: PJI_PA_PROJ_EVENTS_LOG log,
23106: PJI_PJP_WBS_HEADER wbs_hdr,
23107: PJI_XBS_DENORM_DELTA wbs,
23108: PJI_XBS_DENORM prg,
23109: PJI_AC_XBS_ACCUM_F acr,
23110: (
23111: select 1 WBS_SUP_LEVEL,
23112: 1 WBS_SUB_LEVEL,
23160: prg.RELATIONSHIP_TYPE RELATIONSHIP_TYPE,
23161: 'Y' PUSHUP_FLAG
23162: from
23163: PJI_PJP_PROJ_BATCH_MAP map,
23164: PJI_XBS_DENORM prg,
23165: PJI_XBS_DENORM_DELTA prg_delta
23166: where
23167: prg.STRUCT_TYPE = 'PRG' and
23168: prg.RELATIONSHIP_TYPE = 'LF' and
23161: 'Y' PUSHUP_FLAG
23162: from
23163: PJI_PJP_PROJ_BATCH_MAP map,
23164: PJI_XBS_DENORM prg,
23165: PJI_XBS_DENORM_DELTA prg_delta
23166: where
23167: prg.STRUCT_TYPE = 'PRG' and
23168: prg.RELATIONSHIP_TYPE = 'LF' and
23169: prg.SUB_ROLLUP_ID is not null and
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,
23505: 'PRJ' INVERT_ID
23592: pjp1.CUSTOM15
23593: from
23594: PJI_AC_AGGR_PJP1 pjp1,
23595: PJI_PJP_WBS_HEADER wbs_hdr,
23596: PJI_XBS_DENORM prg
23597: where
23598: prg.STRUCT_TYPE = 'PRG' and
23599: prg.SUP_LEVEL = l_level and
23600: prg.SUB_LEVEL = l_level and
23685: wbs.SIGN * acr.CUSTOM15 CUSTOM15
23686: from
23687: PJI_PA_PROJ_EVENTS_LOG log,
23688: PJI_PJP_WBS_HEADER wbs_hdr,
23689: PJI_XBS_DENORM_DELTA wbs,
23690: PJI_XBS_DENORM prg,
23691: PJI_AC_XBS_ACCUM_F acr,
23692: (
23693: select 1 WBS_SUP_LEVEL,
23686: from
23687: PJI_PA_PROJ_EVENTS_LOG log,
23688: PJI_PJP_WBS_HEADER wbs_hdr,
23689: PJI_XBS_DENORM_DELTA wbs,
23690: PJI_XBS_DENORM prg,
23691: PJI_AC_XBS_ACCUM_F acr,
23692: (
23693: select 1 WBS_SUP_LEVEL,
23694: 1 WBS_SUB_LEVEL,
23742: prg.RELATIONSHIP_TYPE RELATIONSHIP_TYPE,
23743: 'Y' PUSHUP_FLAG
23744: from
23745: PJI_PJP_PROJ_BATCH_MAP map,
23746: PJI_XBS_DENORM prg,
23747: PJI_XBS_DENORM_DELTA prg_delta
23748: where
23749: prg.STRUCT_TYPE = 'PRG' and
23750: prg.RELATIONSHIP_TYPE = 'LF' and
23743: 'Y' PUSHUP_FLAG
23744: from
23745: PJI_PJP_PROJ_BATCH_MAP map,
23746: PJI_XBS_DENORM prg,
23747: PJI_XBS_DENORM_DELTA prg_delta
23748: where
23749: prg.STRUCT_TYPE = 'PRG' and
23750: prg.RELATIONSHIP_TYPE = 'LF' and
23751: prg.SUB_ROLLUP_ID is not null and
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,
24087: 'PRJ' INVERT_ID
24174: pjp1.CUSTOM15
24175: from
24176: PJI_AC_AGGR_PJP1 pjp1,
24177: PJI_PJP_WBS_HEADER wbs_hdr,
24178: PJI_XBS_DENORM prg
24179: where
24180: prg.STRUCT_TYPE = 'PRG' and
24181: prg.SUP_LEVEL = l_level and
24182: prg.SUB_LEVEL = l_level and
24267: wbs.SIGN * acr.CUSTOM15 CUSTOM15
24268: from
24269: PJI_PA_PROJ_EVENTS_LOG log,
24270: PJI_PJP_WBS_HEADER wbs_hdr,
24271: PJI_XBS_DENORM_DELTA wbs,
24272: PJI_XBS_DENORM prg,
24273: PJI_AC_XBS_ACCUM_F acr,
24274: (
24275: select 1 WBS_SUP_LEVEL,
24268: from
24269: PJI_PA_PROJ_EVENTS_LOG log,
24270: PJI_PJP_WBS_HEADER wbs_hdr,
24271: PJI_XBS_DENORM_DELTA wbs,
24272: PJI_XBS_DENORM prg,
24273: PJI_AC_XBS_ACCUM_F acr,
24274: (
24275: select 1 WBS_SUP_LEVEL,
24276: 1 WBS_SUB_LEVEL,
24324: prg.RELATIONSHIP_TYPE RELATIONSHIP_TYPE,
24325: 'Y' PUSHUP_FLAG
24326: from
24327: PJI_PJP_PROJ_BATCH_MAP map,
24328: PJI_XBS_DENORM prg,
24329: PJI_XBS_DENORM_DELTA prg_delta
24330: where
24331: prg.STRUCT_TYPE = 'PRG' and
24332: prg.RELATIONSHIP_TYPE = 'LF' and
24325: 'Y' PUSHUP_FLAG
24326: from
24327: PJI_PJP_PROJ_BATCH_MAP map,
24328: PJI_XBS_DENORM prg,
24329: PJI_XBS_DENORM_DELTA prg_delta
24330: where
24331: prg.STRUCT_TYPE = 'PRG' and
24332: prg.RELATIONSHIP_TYPE = 'LF' and
24333: prg.SUB_ROLLUP_ID is not null and
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,
24669: 'PRJ' INVERT_ID
24756: pjp1.CUSTOM15
24757: from
24758: PJI_AC_AGGR_PJP1 pjp1,
24759: PJI_PJP_WBS_HEADER wbs_hdr,
24760: PJI_XBS_DENORM prg
24761: where
24762: prg.STRUCT_TYPE = 'PRG' and
24763: prg.SUP_LEVEL = l_level and
24764: prg.SUB_LEVEL = l_level and
24849: wbs.SIGN * acr.CUSTOM15 CUSTOM15
24850: from
24851: PJI_PA_PROJ_EVENTS_LOG log,
24852: PJI_PJP_WBS_HEADER wbs_hdr,
24853: PJI_XBS_DENORM_DELTA wbs,
24854: PJI_XBS_DENORM prg,
24855: PJI_AC_XBS_ACCUM_F acr,
24856: (
24857: select 1 WBS_SUP_LEVEL,
24850: from
24851: PJI_PA_PROJ_EVENTS_LOG log,
24852: PJI_PJP_WBS_HEADER wbs_hdr,
24853: PJI_XBS_DENORM_DELTA wbs,
24854: PJI_XBS_DENORM prg,
24855: PJI_AC_XBS_ACCUM_F acr,
24856: (
24857: select 1 WBS_SUP_LEVEL,
24858: 1 WBS_SUB_LEVEL,
24906: prg.RELATIONSHIP_TYPE RELATIONSHIP_TYPE,
24907: 'Y' PUSHUP_FLAG
24908: from
24909: PJI_PJP_PROJ_BATCH_MAP map,
24910: PJI_XBS_DENORM prg,
24911: PJI_XBS_DENORM_DELTA prg_delta
24912: where
24913: prg.STRUCT_TYPE = 'PRG' and
24914: prg.RELATIONSHIP_TYPE = 'LF' and
24907: 'Y' PUSHUP_FLAG
24908: from
24909: PJI_PJP_PROJ_BATCH_MAP map,
24910: PJI_XBS_DENORM prg,
24911: PJI_XBS_DENORM_DELTA prg_delta
24912: where
24913: prg.STRUCT_TYPE = 'PRG' and
24914: prg.RELATIONSHIP_TYPE = 'LF' and
24915: prg.SUB_ROLLUP_ID is not null and
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,
25251: 'PRJ' INVERT_ID
25338: pjp1.CUSTOM15
25339: from
25340: PJI_AC_AGGR_PJP1 pjp1,
25341: PJI_PJP_WBS_HEADER wbs_hdr,
25342: PJI_XBS_DENORM prg
25343: where
25344: prg.STRUCT_TYPE = 'PRG' and
25345: prg.SUP_LEVEL = l_level and
25346: prg.SUB_LEVEL = l_level and
25431: wbs.SIGN * acr.CUSTOM15 CUSTOM15
25432: from
25433: PJI_PA_PROJ_EVENTS_LOG log,
25434: PJI_PJP_WBS_HEADER wbs_hdr,
25435: PJI_XBS_DENORM_DELTA wbs,
25436: PJI_XBS_DENORM prg,
25437: PJI_AC_XBS_ACCUM_F acr,
25438: (
25439: select 1 WBS_SUP_LEVEL,
25432: from
25433: PJI_PA_PROJ_EVENTS_LOG log,
25434: PJI_PJP_WBS_HEADER wbs_hdr,
25435: PJI_XBS_DENORM_DELTA wbs,
25436: PJI_XBS_DENORM prg,
25437: PJI_AC_XBS_ACCUM_F acr,
25438: (
25439: select 1 WBS_SUP_LEVEL,
25440: 1 WBS_SUB_LEVEL,
25488: prg.RELATIONSHIP_TYPE RELATIONSHIP_TYPE,
25489: 'Y' PUSHUP_FLAG
25490: from
25491: PJI_PJP_PROJ_BATCH_MAP map,
25492: PJI_XBS_DENORM prg,
25493: PJI_XBS_DENORM_DELTA prg_delta
25494: where
25495: prg.STRUCT_TYPE = 'PRG' and
25496: prg.RELATIONSHIP_TYPE = 'LF' and
25489: 'Y' PUSHUP_FLAG
25490: from
25491: PJI_PJP_PROJ_BATCH_MAP map,
25492: PJI_XBS_DENORM prg,
25493: PJI_XBS_DENORM_DELTA prg_delta
25494: where
25495: prg.STRUCT_TYPE = 'PRG' and
25496: prg.RELATIONSHIP_TYPE = 'LF' and
25497: prg.SUB_ROLLUP_ID is not null and
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,
25833: 'PRJ' INVERT_ID
25920: pjp1.CUSTOM15
25921: from
25922: PJI_AC_AGGR_PJP1 pjp1,
25923: PJI_PJP_WBS_HEADER wbs_hdr,
25924: PJI_XBS_DENORM prg
25925: where
25926: prg.STRUCT_TYPE = 'PRG' and
25927: prg.SUP_LEVEL = l_level and
25928: prg.SUB_LEVEL = l_level and
26013: wbs.SIGN * acr.CUSTOM15 CUSTOM15
26014: from
26015: PJI_PA_PROJ_EVENTS_LOG log,
26016: PJI_PJP_WBS_HEADER wbs_hdr,
26017: PJI_XBS_DENORM_DELTA wbs,
26018: PJI_XBS_DENORM prg,
26019: PJI_AC_XBS_ACCUM_F acr,
26020: (
26021: select 1 WBS_SUP_LEVEL,
26014: from
26015: PJI_PA_PROJ_EVENTS_LOG log,
26016: PJI_PJP_WBS_HEADER wbs_hdr,
26017: PJI_XBS_DENORM_DELTA wbs,
26018: PJI_XBS_DENORM prg,
26019: PJI_AC_XBS_ACCUM_F acr,
26020: (
26021: select 1 WBS_SUP_LEVEL,
26022: 1 WBS_SUB_LEVEL,
26070: prg.RELATIONSHIP_TYPE RELATIONSHIP_TYPE,
26071: 'Y' PUSHUP_FLAG
26072: from
26073: PJI_PJP_PROJ_BATCH_MAP map,
26074: PJI_XBS_DENORM prg,
26075: PJI_XBS_DENORM_DELTA prg_delta
26076: where
26077: prg.STRUCT_TYPE = 'PRG' and
26078: prg.RELATIONSHIP_TYPE = 'LF' and
26071: 'Y' PUSHUP_FLAG
26072: from
26073: PJI_PJP_PROJ_BATCH_MAP map,
26074: PJI_XBS_DENORM prg,
26075: PJI_XBS_DENORM_DELTA prg_delta
26076: where
26077: prg.STRUCT_TYPE = 'PRG' and
26078: prg.RELATIONSHIP_TYPE = 'LF' and
26079: prg.SUB_ROLLUP_ID is not null and
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,
26415: 'PRJ' INVERT_ID
26502: pjp1.CUSTOM15
26503: from
26504: PJI_AC_AGGR_PJP1 pjp1,
26505: PJI_PJP_WBS_HEADER wbs_hdr,
26506: PJI_XBS_DENORM prg
26507: where
26508: prg.STRUCT_TYPE = 'PRG' and
26509: prg.SUP_LEVEL = l_level and
26510: prg.SUB_LEVEL = l_level and
26595: wbs.SIGN * acr.CUSTOM15 CUSTOM15
26596: from
26597: PJI_PA_PROJ_EVENTS_LOG log,
26598: PJI_PJP_WBS_HEADER wbs_hdr,
26599: PJI_XBS_DENORM_DELTA wbs,
26600: PJI_XBS_DENORM prg,
26601: PJI_AC_XBS_ACCUM_F acr,
26602: (
26603: select 1 WBS_SUP_LEVEL,
26596: from
26597: PJI_PA_PROJ_EVENTS_LOG log,
26598: PJI_PJP_WBS_HEADER wbs_hdr,
26599: PJI_XBS_DENORM_DELTA wbs,
26600: PJI_XBS_DENORM prg,
26601: PJI_AC_XBS_ACCUM_F acr,
26602: (
26603: select 1 WBS_SUP_LEVEL,
26604: 1 WBS_SUB_LEVEL,
26652: prg.RELATIONSHIP_TYPE RELATIONSHIP_TYPE,
26653: 'Y' PUSHUP_FLAG
26654: from
26655: PJI_PJP_PROJ_BATCH_MAP map,
26656: PJI_XBS_DENORM prg,
26657: PJI_XBS_DENORM_DELTA prg_delta
26658: where
26659: prg.STRUCT_TYPE = 'PRG' and
26660: prg.RELATIONSHIP_TYPE = 'LF' and
26653: 'Y' PUSHUP_FLAG
26654: from
26655: PJI_PJP_PROJ_BATCH_MAP map,
26656: PJI_XBS_DENORM prg,
26657: PJI_XBS_DENORM_DELTA prg_delta
26658: where
26659: prg.STRUCT_TYPE = 'PRG' and
26660: prg.RELATIONSHIP_TYPE = 'LF' and
26661: prg.SUB_ROLLUP_ID is not null and
27229: prg.SIGN * fpr.CUSTOM13 CUSTOM13,
27230: prg.SIGN * fpr.CUSTOM14 CUSTOM14,
27231: prg.SIGN * fpr.CUSTOM15 CUSTOM15
27232: from
27233: PJI_XBS_DENORM_DELTA prg,
27234: PA_PROJ_ELEMENTS prj_emt,
27235: PJI_PJP_WBS_HEADER wbs_hdr,
27236: PJI_FP_XBS_ACCUM_F fpr,
27237: PJI_PJP_WBS_HEADER sup_wbs_hdr,
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,
27641: (
28274: prg.SIGN * fpr.CUSTOM13 CUSTOM13,
28275: prg.SIGN * fpr.CUSTOM14 CUSTOM14,
28276: prg.SIGN * fpr.CUSTOM15 CUSTOM15
28277: from
28278: PJI_XBS_DENORM_DELTA prg,
28279: PA_PROJ_ELEMENTS prj_emt,
28280: PJI_PJP_WBS_HEADER wbs_hdr,
28281: PJI_FP_XBS_ACCUM_F fpr,
28282: PJI_PJP_WBS_HEADER sup_wbs_hdr,
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,
28686: (
29319: prg.SIGN * fpr.CUSTOM13 CUSTOM13,
29320: prg.SIGN * fpr.CUSTOM14 CUSTOM14,
29321: prg.SIGN * fpr.CUSTOM15 CUSTOM15
29322: from
29323: PJI_XBS_DENORM_DELTA prg,
29324: PA_PROJ_ELEMENTS prj_emt,
29325: PJI_PJP_WBS_HEADER wbs_hdr,
29326: PJI_FP_XBS_ACCUM_F fpr,
29327: PJI_PJP_WBS_HEADER sup_wbs_hdr,
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,
29731: (
30364: prg.SIGN * fpr.CUSTOM13 CUSTOM13,
30365: prg.SIGN * fpr.CUSTOM14 CUSTOM14,
30366: prg.SIGN * fpr.CUSTOM15 CUSTOM15
30367: from
30368: PJI_XBS_DENORM_DELTA prg,
30369: PA_PROJ_ELEMENTS prj_emt,
30370: PJI_PJP_WBS_HEADER wbs_hdr,
30371: PJI_FP_XBS_ACCUM_F fpr,
30372: PJI_PJP_WBS_HEADER sup_wbs_hdr,
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,
30776: (
31409: prg.SIGN * fpr.CUSTOM13 CUSTOM13,
31410: prg.SIGN * fpr.CUSTOM14 CUSTOM14,
31411: prg.SIGN * fpr.CUSTOM15 CUSTOM15
31412: from
31413: PJI_XBS_DENORM_DELTA prg,
31414: PA_PROJ_ELEMENTS prj_emt,
31415: PJI_PJP_WBS_HEADER wbs_hdr,
31416: PJI_FP_XBS_ACCUM_F fpr,
31417: PJI_PJP_WBS_HEADER sup_wbs_hdr,
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,
31821: (
32454: prg.SIGN * fpr.CUSTOM13 CUSTOM13,
32455: prg.SIGN * fpr.CUSTOM14 CUSTOM14,
32456: prg.SIGN * fpr.CUSTOM15 CUSTOM15
32457: from
32458: PJI_XBS_DENORM_DELTA prg,
32459: PA_PROJ_ELEMENTS prj_emt,
32460: PJI_PJP_WBS_HEADER wbs_hdr,
32461: PJI_FP_XBS_ACCUM_F fpr,
32462: PJI_PJP_WBS_HEADER sup_wbs_hdr,
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,
32866: (
33499: prg.SIGN * fpr.CUSTOM13 CUSTOM13,
33500: prg.SIGN * fpr.CUSTOM14 CUSTOM14,
33501: prg.SIGN * fpr.CUSTOM15 CUSTOM15
33502: from
33503: PJI_XBS_DENORM_DELTA prg,
33504: PA_PROJ_ELEMENTS prj_emt,
33505: PJI_PJP_WBS_HEADER wbs_hdr,
33506: PJI_FP_XBS_ACCUM_F fpr,
33507: PJI_PJP_WBS_HEADER sup_wbs_hdr,
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,
33911: (
34544: prg.SIGN * fpr.CUSTOM13 CUSTOM13,
34545: prg.SIGN * fpr.CUSTOM14 CUSTOM14,
34546: prg.SIGN * fpr.CUSTOM15 CUSTOM15
34547: from
34548: PJI_XBS_DENORM_DELTA prg,
34549: PA_PROJ_ELEMENTS prj_emt,
34550: PJI_PJP_WBS_HEADER wbs_hdr,
34551: PJI_FP_XBS_ACCUM_F fpr,
34552: PJI_PJP_WBS_HEADER sup_wbs_hdr,
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,
34956: (
35589: prg.SIGN * fpr.CUSTOM13 CUSTOM13,
35590: prg.SIGN * fpr.CUSTOM14 CUSTOM14,
35591: prg.SIGN * fpr.CUSTOM15 CUSTOM15
35592: from
35593: PJI_XBS_DENORM_DELTA prg,
35594: PA_PROJ_ELEMENTS prj_emt,
35595: PJI_PJP_WBS_HEADER wbs_hdr,
35596: PJI_FP_XBS_ACCUM_F fpr,
35597: PJI_PJP_WBS_HEADER sup_wbs_hdr,
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,
36001: (
36634: prg.SIGN * fpr.CUSTOM13 CUSTOM13,
36635: prg.SIGN * fpr.CUSTOM14 CUSTOM14,
36636: prg.SIGN * fpr.CUSTOM15 CUSTOM15
36637: from
36638: PJI_XBS_DENORM_DELTA prg,
36639: PA_PROJ_ELEMENTS prj_emt,
36640: PJI_PJP_WBS_HEADER wbs_hdr,
36641: PJI_FP_XBS_ACCUM_F fpr,
36642: PJI_PJP_WBS_HEADER sup_wbs_hdr,
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,
37046: (
37399: prg.SIGN * acr.CUSTOM13 CUSTOM13,
37400: prg.SIGN * acr.CUSTOM14 CUSTOM14,
37401: prg.SIGN * acr.CUSTOM15 CUSTOM15
37402: from
37403: PJI_XBS_DENORM_DELTA prg,
37404: PA_PROJ_ELEMENTS prj_emt,
37405: PJI_PJP_WBS_HEADER wbs_hdr,
37406: PJI_AC_XBS_ACCUM_F acr
37407: where
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
37487: nvl(prg.SUB_ROLLUP_ID,
37742: prg.SIGN * acr.CUSTOM13 CUSTOM13,
37743: prg.SIGN * acr.CUSTOM14 CUSTOM14,
37744: prg.SIGN * acr.CUSTOM15 CUSTOM15
37745: from
37746: PJI_XBS_DENORM_DELTA prg,
37747: PA_PROJ_ELEMENTS prj_emt,
37748: PJI_PJP_WBS_HEADER wbs_hdr,
37749: PJI_AC_XBS_ACCUM_F acr
37750: where
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
37830: nvl(prg.SUB_ROLLUP_ID,
38084: prg.SIGN * acr.CUSTOM13 CUSTOM13,
38085: prg.SIGN * acr.CUSTOM14 CUSTOM14,
38086: prg.SIGN * acr.CUSTOM15 CUSTOM15
38087: from
38088: PJI_XBS_DENORM_DELTA prg,
38089: PA_PROJ_ELEMENTS prj_emt,
38090: PJI_PJP_WBS_HEADER wbs_hdr,
38091: PJI_AC_XBS_ACCUM_F acr
38092: where
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
38172: nvl(prg.SUB_ROLLUP_ID,
38426: prg.SIGN * acr.CUSTOM13 CUSTOM13,
38427: prg.SIGN * acr.CUSTOM14 CUSTOM14,
38428: prg.SIGN * acr.CUSTOM15 CUSTOM15
38429: from
38430: PJI_XBS_DENORM_DELTA prg,
38431: PA_PROJ_ELEMENTS prj_emt,
38432: PJI_PJP_WBS_HEADER wbs_hdr,
38433: PJI_AC_XBS_ACCUM_F acr
38434: where
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
38514: nvl(prg.SUB_ROLLUP_ID,
38768: prg.SIGN * acr.CUSTOM13 CUSTOM13,
38769: prg.SIGN * acr.CUSTOM14 CUSTOM14,
38770: prg.SIGN * acr.CUSTOM15 CUSTOM15
38771: from
38772: PJI_XBS_DENORM_DELTA prg,
38773: PA_PROJ_ELEMENTS prj_emt,
38774: PJI_PJP_WBS_HEADER wbs_hdr,
38775: PJI_AC_XBS_ACCUM_F acr
38776: where
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
38856: nvl(prg.SUB_ROLLUP_ID,
39110: prg.SIGN * acr.CUSTOM13 CUSTOM13,
39111: prg.SIGN * acr.CUSTOM14 CUSTOM14,
39112: prg.SIGN * acr.CUSTOM15 CUSTOM15
39113: from
39114: PJI_XBS_DENORM_DELTA prg,
39115: PA_PROJ_ELEMENTS prj_emt,
39116: PJI_PJP_WBS_HEADER wbs_hdr,
39117: PJI_AC_XBS_ACCUM_F acr
39118: where
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
39198: nvl(prg.SUB_ROLLUP_ID,
39452: prg.SIGN * acr.CUSTOM13 CUSTOM13,
39453: prg.SIGN * acr.CUSTOM14 CUSTOM14,
39454: prg.SIGN * acr.CUSTOM15 CUSTOM15
39455: from
39456: PJI_XBS_DENORM_DELTA prg,
39457: PA_PROJ_ELEMENTS prj_emt,
39458: PJI_PJP_WBS_HEADER wbs_hdr,
39459: PJI_AC_XBS_ACCUM_F acr
39460: where
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
39540: nvl(prg.SUB_ROLLUP_ID,
39794: prg.SIGN * acr.CUSTOM13 CUSTOM13,
39795: prg.SIGN * acr.CUSTOM14 CUSTOM14,
39796: prg.SIGN * acr.CUSTOM15 CUSTOM15
39797: from
39798: PJI_XBS_DENORM_DELTA prg,
39799: PA_PROJ_ELEMENTS prj_emt,
39800: PJI_PJP_WBS_HEADER wbs_hdr,
39801: PJI_AC_XBS_ACCUM_F acr
39802: where
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
39882: nvl(prg.SUB_ROLLUP_ID,
40136: prg.SIGN * acr.CUSTOM13 CUSTOM13,
40137: prg.SIGN * acr.CUSTOM14 CUSTOM14,
40138: prg.SIGN * acr.CUSTOM15 CUSTOM15
40139: from
40140: PJI_XBS_DENORM_DELTA prg,
40141: PA_PROJ_ELEMENTS prj_emt,
40142: PJI_PJP_WBS_HEADER wbs_hdr,
40143: PJI_AC_XBS_ACCUM_F acr
40144: where
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
40224: nvl(prg.SUB_ROLLUP_ID,
40478: prg.SIGN * acr.CUSTOM13 CUSTOM13,
40479: prg.SIGN * acr.CUSTOM14 CUSTOM14,
40480: prg.SIGN * acr.CUSTOM15 CUSTOM15
40481: from
40482: PJI_XBS_DENORM_DELTA prg,
40483: PA_PROJ_ELEMENTS prj_emt,
40484: PJI_PJP_WBS_HEADER wbs_hdr,
40485: PJI_AC_XBS_ACCUM_F acr
40486: where
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
40566: nvl(prg.SUB_ROLLUP_ID,
45154: and a.struct_type||'' = 'WBS'||'';
45155: -- Bug 13097931 - Forward port bugfix 12879208
45156:
45157:
45158: insert into PJI_XBS_DENORM_T
45159: (STRUCT_TYPE,
45160: PRG_GROUP,
45161: STRUCT_VERSION_ID,
45162: SUP_PROJECT_ID,
45196: CREATED_BY,
45197: LAST_UPDATE_LOGIN,
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);
45203: where c.worker_id = p_worker_id
45204: and b.sup_project_id = c.project_id);
45205:
45206:
45207: insert into PJI_XBS_DENORM_T
45208: (STRUCT_TYPE,
45209: PRG_GROUP,
45210: STRUCT_VERSION_ID,
45211: SUP_PROJECT_ID,
45245: CREATED_BY,
45246: LAST_UPDATE_LOGIN,
45247: STRUCT_EMT_ID,
45248: RELATIONSHIP_TYPE
45249: from PJI_XBS_DENORM a
45250: where a.SUP_PROJECT_ID in ( select b.PROJECT_ID
45251: from PJI_PJP_PROJ_BATCH_MAP b
45252: where b.worker_id = p_worker_id )
45253: and not exists ( select 'x' from PJI_PJP_PROJ_BATCH_MAP c
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
46051: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
46199: from
46200: PJI_FP_AGGR_PJP1 pjp1,
46201: PJI_HELPER_420 helper, -- order in the From clause should not be changed unless recommended by perf team
46202: PJI_PJP_WBS_HEADER_T wbs_hdr,
46203: PJI_XBS_DENORM_T prg,
46204: (
46205: select 'Y' CB_FLAG,
46206: 'N' CO_FLAG,
46207: -3 PLAN_VERSION_ID
46353: from
46354: PJI_PA_PROJ_EVENTS_LOG log,
46355: PJI_HELPER_420 helper,
46356: PJI_PJP_WBS_HEADER_T wbs_hdr,
46357: PJI_XBS_DENORM_DELTA wbs,
46358: PJI_XBS_DENORM_T prg,
46359: PJI_FP_XBS_ACCUM_F fpr,
46360: (
46361: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
46354: PJI_PA_PROJ_EVENTS_LOG log,
46355: PJI_HELPER_420 helper,
46356: PJI_PJP_WBS_HEADER_T wbs_hdr,
46357: PJI_XBS_DENORM_DELTA wbs,
46358: PJI_XBS_DENORM_T prg,
46359: PJI_FP_XBS_ACCUM_F fpr,
46360: (
46361: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
46362: from DUAL union all
46444: 'LF', 'N') WP_FLAG,
46445: 'Y' PUSHUP_FLAG
46446: from
46447: PJI_PJP_PROJ_BATCH_MAP map,
46448: PJI_XBS_DENORM_T prg,
46449: (
46450: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
46451: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
46452: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
46451: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
46452: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
46453: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
46454: ) invert,
46455: PJI_XBS_DENORM_DELTA prg_delta
46456: where
46457: prg.STRUCT_TYPE = 'PRG' and
46458: prg.SUB_ROLLUP_ID is not null and
46459: prg.SUB_LEVEL = l_level and