[Home] [Help]
8874: 'LW', 'Y',
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
10195: 'LW', 'Y',
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
11514: 'LW', 'Y',
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
12832: 'LW', 'Y',
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
14150: 'LW', 'Y',
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
15468: 'LW', 'Y',
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
16786: 'LW', 'Y',
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
18104: 'LW', 'Y',
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
19422: 'LW', 'Y',
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
20740: 'LW', 'Y',
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
21413: prg.SUB_ROLLUP_ID,
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
21995: prg.SUB_ROLLUP_ID,
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
22577: prg.SUB_ROLLUP_ID,
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
23159: prg.SUB_ROLLUP_ID,
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
23741: prg.SUB_ROLLUP_ID,
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
24323: prg.SUB_ROLLUP_ID,
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
24905: prg.SUB_ROLLUP_ID,
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
25487: prg.SUB_ROLLUP_ID,
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
26069: prg.SUB_ROLLUP_ID,
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
26651: prg.SUB_ROLLUP_ID,
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
27729: 'STRUCTURE_PUBLISHED' = sup_ver.STATUS_CODE (+) and
27730: wbs_hdr.CB_FLAG = fin_plan.CB (+) and
27731: wbs_hdr.CO_FLAG = fin_plan.CO (+)
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: (
28774: 'STRUCTURE_PUBLISHED' = sup_ver.STATUS_CODE (+) and
28775: wbs_hdr.CB_FLAG = fin_plan.CB (+) and
28776: wbs_hdr.CO_FLAG = fin_plan.CO (+)
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: (
29819: 'STRUCTURE_PUBLISHED' = sup_ver.STATUS_CODE (+) and
29820: wbs_hdr.CB_FLAG = fin_plan.CB (+) and
29821: wbs_hdr.CO_FLAG = fin_plan.CO (+)
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: (
30864: 'STRUCTURE_PUBLISHED' = sup_ver.STATUS_CODE (+) and
30865: wbs_hdr.CB_FLAG = fin_plan.CB (+) and
30866: wbs_hdr.CO_FLAG = fin_plan.CO (+)
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: (
31909: 'STRUCTURE_PUBLISHED' = sup_ver.STATUS_CODE (+) and
31910: wbs_hdr.CB_FLAG = fin_plan.CB (+) and
31911: wbs_hdr.CO_FLAG = fin_plan.CO (+)
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: (
32954: 'STRUCTURE_PUBLISHED' = sup_ver.STATUS_CODE (+) and
32955: wbs_hdr.CB_FLAG = fin_plan.CB (+) and
32956: wbs_hdr.CO_FLAG = fin_plan.CO (+)
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: (
33999: 'STRUCTURE_PUBLISHED' = sup_ver.STATUS_CODE (+) and
34000: wbs_hdr.CB_FLAG = fin_plan.CB (+) and
34001: wbs_hdr.CO_FLAG = fin_plan.CO (+)
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: (
35044: 'STRUCTURE_PUBLISHED' = sup_ver.STATUS_CODE (+) and
35045: wbs_hdr.CB_FLAG = fin_plan.CB (+) and
35046: wbs_hdr.CO_FLAG = fin_plan.CO (+)
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: (
36089: 'STRUCTURE_PUBLISHED' = sup_ver.STATUS_CODE (+) and
36090: wbs_hdr.CB_FLAG = fin_plan.CB (+) and
36091: wbs_hdr.CO_FLAG = fin_plan.CO (+)
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: (
37134: 'STRUCTURE_PUBLISHED' = sup_ver.STATUS_CODE (+) and
37135: wbs_hdr.CB_FLAG = fin_plan.CB (+) and
37136: wbs_hdr.CO_FLAG = fin_plan.CO (+)
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: (
37512: wbs_hdr.WBS_VERSION_ID = prg.SUB_ID and
37513: wbs_hdr.PROJECT_ID = pjp1.PROJECT_ID and
37514: wbs_hdr.PLAN_VERSION_ID = -1
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: (
37855: wbs_hdr.WBS_VERSION_ID = prg.SUB_ID and
37856: wbs_hdr.PROJECT_ID = pjp1.PROJECT_ID and
37857: wbs_hdr.PLAN_VERSION_ID = -1
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: (
38197: wbs_hdr.WBS_VERSION_ID = prg.SUB_ID and
38198: wbs_hdr.PROJECT_ID = pjp1.PROJECT_ID and
38199: wbs_hdr.PLAN_VERSION_ID = -1
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: (
38539: wbs_hdr.WBS_VERSION_ID = prg.SUB_ID and
38540: wbs_hdr.PROJECT_ID = pjp1.PROJECT_ID and
38541: wbs_hdr.PLAN_VERSION_ID = -1
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: (
38881: wbs_hdr.WBS_VERSION_ID = prg.SUB_ID and
38882: wbs_hdr.PROJECT_ID = pjp1.PROJECT_ID and
38883: wbs_hdr.PLAN_VERSION_ID = -1
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: (
39223: wbs_hdr.WBS_VERSION_ID = prg.SUB_ID and
39224: wbs_hdr.PROJECT_ID = pjp1.PROJECT_ID and
39225: wbs_hdr.PLAN_VERSION_ID = -1
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: (
39565: wbs_hdr.WBS_VERSION_ID = prg.SUB_ID and
39566: wbs_hdr.PROJECT_ID = pjp1.PROJECT_ID and
39567: wbs_hdr.PLAN_VERSION_ID = -1
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: (
39907: wbs_hdr.WBS_VERSION_ID = prg.SUB_ID and
39908: wbs_hdr.PROJECT_ID = pjp1.PROJECT_ID and
39909: wbs_hdr.PLAN_VERSION_ID = -1
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: (
40249: wbs_hdr.WBS_VERSION_ID = prg.SUB_ID and
40250: wbs_hdr.PROJECT_ID = pjp1.PROJECT_ID and
40251: wbs_hdr.PLAN_VERSION_ID = -1
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: (
40591: wbs_hdr.WBS_VERSION_ID = prg.SUB_ID and
40592: wbs_hdr.PROJECT_ID = pjp1.PROJECT_ID and
40593: wbs_hdr.PLAN_VERSION_ID = -1
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: (
44883:
44884:
44885: insert into pji_helper_420 (worker_id, project_id, batch_id, level_420, partial_mode_420, fpm_upgrade_420)
44886: (select worker_id, project_id, ceil(ROWNUM / l_batch_size) batch_id, l_level, l_partial_mode, l_fpm_upgrade
44887: FROM pji_pjp_proj_batch_map
44888: WHERE worker_id = g_worker_id );
44889:
44890:
44891: SELECT /*+ parallel(pji_merge_helper) */
45100: CREATED_BY,
45101: LAST_UPDATE_LOGIN,
45102: PLAN_TYPE_CODE
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,
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)
45154: and a.struct_type||'' = 'WBS'||'';
45155: -- Bug 13097931 - Forward port bugfix 12879208
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:
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
45254: where c.worker_id = p_worker_id and c.project_id = a.sup_project_id );
45255:
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
45254: where c.worker_id = p_worker_id and c.project_id = a.sup_project_id );
45255:
45256:
45257: insert /*+ parallel(PJI_FP_AGGR_PJP1) */
46443: 'LW', 'Y',
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