[Home] [Help]
3021: , MIN(LEAST(cal.start_date, NVL(whdr.min_txn_date, cal.start_date))) start_date
3022: , MAX(GREATEST(cal.end_date, NVL(whdr.max_txn_date, cal.end_date))) end_date
3023: FROM PJI_FP_AGGR_PJP1 pjp1
3024: , pji_time_cal_period_v cal
3025: , pji_pjp_wbs_header whdr
3026: WHERE
3027: pjp1.worker_id = g_worker_id
3028: AND pjp1.project_id = whdr.project_id
3029: AND pjp1.plan_type_id = NVL(whdr.plan_type_id, -1)
3034: GROUP BY whdr.project_id, whdr.plan_type_id
3035: , whdr.plan_version_id, whdr.plan_type_code;
3036:
3037: commit;
3038: UPDATE /*+ index(whdr,PJI_PJP_WBS_HEADER_N1) */
3039: PJI_PJP_WBS_HEADER whdr
3040: SET ( MIN_TXN_DATE
3041: , MAX_TXN_DATE
3042: , LAST_UPDATE_DATE
3035: , whdr.plan_version_id, whdr.plan_type_code;
3036:
3037: commit;
3038: UPDATE /*+ index(whdr,PJI_PJP_WBS_HEADER_N1) */
3039: PJI_PJP_WBS_HEADER whdr
3040: SET ( MIN_TXN_DATE
3041: , MAX_TXN_DATE
3042: , LAST_UPDATE_DATE
3043: , LAST_UPDATED_BY
4436: , pjp2.PLAN_TYPE_CODE ;
4437: /* Added for bug 13897252 starts */
4438:
4439:
4440: TYPE proj_id_tab_type IS TABLE OF pji_pjp_wbs_header.project_id%TYPE;
4441: TYPE plan_ver_id_tab_type IS TABLE OF pji_pjp_wbs_header.plan_version_id%TYPE;
4442: TYPE plan_type_id_tab_type IS TABLE OF pji_pjp_wbs_header.plan_type_id%TYPE;
4443: TYPE plan_type_code_tab_type IS TABLE OF pji_pjp_wbs_header.plan_type_code%TYPE;
4444: TYPE min_txn_date_tab_type IS TABLE OF pji_pjp_wbs_header.min_txn_date%TYPE;
4437: /* Added for bug 13897252 starts */
4438:
4439:
4440: TYPE proj_id_tab_type IS TABLE OF pji_pjp_wbs_header.project_id%TYPE;
4441: TYPE plan_ver_id_tab_type IS TABLE OF pji_pjp_wbs_header.plan_version_id%TYPE;
4442: TYPE plan_type_id_tab_type IS TABLE OF pji_pjp_wbs_header.plan_type_id%TYPE;
4443: TYPE plan_type_code_tab_type IS TABLE OF pji_pjp_wbs_header.plan_type_code%TYPE;
4444: TYPE min_txn_date_tab_type IS TABLE OF pji_pjp_wbs_header.min_txn_date%TYPE;
4445: TYPE max_txn_date_tab_type IS TABLE OF pji_pjp_wbs_header.max_txn_date%TYPE;
4438:
4439:
4440: TYPE proj_id_tab_type IS TABLE OF pji_pjp_wbs_header.project_id%TYPE;
4441: TYPE plan_ver_id_tab_type IS TABLE OF pji_pjp_wbs_header.plan_version_id%TYPE;
4442: TYPE plan_type_id_tab_type IS TABLE OF pji_pjp_wbs_header.plan_type_id%TYPE;
4443: TYPE plan_type_code_tab_type IS TABLE OF pji_pjp_wbs_header.plan_type_code%TYPE;
4444: TYPE min_txn_date_tab_type IS TABLE OF pji_pjp_wbs_header.min_txn_date%TYPE;
4445: TYPE max_txn_date_tab_type IS TABLE OF pji_pjp_wbs_header.max_txn_date%TYPE;
4446:
4439:
4440: TYPE proj_id_tab_type IS TABLE OF pji_pjp_wbs_header.project_id%TYPE;
4441: TYPE plan_ver_id_tab_type IS TABLE OF pji_pjp_wbs_header.plan_version_id%TYPE;
4442: TYPE plan_type_id_tab_type IS TABLE OF pji_pjp_wbs_header.plan_type_id%TYPE;
4443: TYPE plan_type_code_tab_type IS TABLE OF pji_pjp_wbs_header.plan_type_code%TYPE;
4444: TYPE min_txn_date_tab_type IS TABLE OF pji_pjp_wbs_header.min_txn_date%TYPE;
4445: TYPE max_txn_date_tab_type IS TABLE OF pji_pjp_wbs_header.max_txn_date%TYPE;
4446:
4447: proj_id_tab proj_id_tab_TYPE;
4440: TYPE proj_id_tab_type IS TABLE OF pji_pjp_wbs_header.project_id%TYPE;
4441: TYPE plan_ver_id_tab_type IS TABLE OF pji_pjp_wbs_header.plan_version_id%TYPE;
4442: TYPE plan_type_id_tab_type IS TABLE OF pji_pjp_wbs_header.plan_type_id%TYPE;
4443: TYPE plan_type_code_tab_type IS TABLE OF pji_pjp_wbs_header.plan_type_code%TYPE;
4444: TYPE min_txn_date_tab_type IS TABLE OF pji_pjp_wbs_header.min_txn_date%TYPE;
4445: TYPE max_txn_date_tab_type IS TABLE OF pji_pjp_wbs_header.max_txn_date%TYPE;
4446:
4447: proj_id_tab proj_id_tab_TYPE;
4448: plan_ver_id_tab plan_ver_id_tab_TYPE;
4441: TYPE plan_ver_id_tab_type IS TABLE OF pji_pjp_wbs_header.plan_version_id%TYPE;
4442: TYPE plan_type_id_tab_type IS TABLE OF pji_pjp_wbs_header.plan_type_id%TYPE;
4443: TYPE plan_type_code_tab_type IS TABLE OF pji_pjp_wbs_header.plan_type_code%TYPE;
4444: TYPE min_txn_date_tab_type IS TABLE OF pji_pjp_wbs_header.min_txn_date%TYPE;
4445: TYPE max_txn_date_tab_type IS TABLE OF pji_pjp_wbs_header.max_txn_date%TYPE;
4446:
4447: proj_id_tab proj_id_tab_TYPE;
4448: plan_ver_id_tab plan_ver_id_tab_TYPE;
4449: plan_type_id_tab plan_type_id_tab_TYPE;
4463:
4464: -- EXIT WHEN wbs_cur%NOTFOUND; -- bug 6316433
4465: If proj_id_tab.count > 0 then
4466: FORALL i IN proj_id_tab.FIRST .. proj_id_tab.LAST
4467: UPDATE /*+ index(whdr,PJI_PJP_WBS_HEADER_N1) */
4468: PJI_PJP_WBS_HEADER whdr
4469: SET MIN_TXN_DATE = LEAST(min_txn_date_tab(i), NVL(whdr.min_txn_date, min_txn_date_tab(i)))
4470: , MAX_TXN_DATE = GREATEST(max_txn_date_tab(i), NVL(whdr.max_txn_date, max_txn_date_tab(i)))
4471: , LAST_UPDATE_DATE = sysdate
4464: -- EXIT WHEN wbs_cur%NOTFOUND; -- bug 6316433
4465: If proj_id_tab.count > 0 then
4466: FORALL i IN proj_id_tab.FIRST .. proj_id_tab.LAST
4467: UPDATE /*+ index(whdr,PJI_PJP_WBS_HEADER_N1) */
4468: PJI_PJP_WBS_HEADER whdr
4469: SET MIN_TXN_DATE = LEAST(min_txn_date_tab(i), NVL(whdr.min_txn_date, min_txn_date_tab(i)))
4470: , MAX_TXN_DATE = GREATEST(max_txn_date_tab(i), NVL(whdr.max_txn_date, max_txn_date_tab(i)))
4471: , LAST_UPDATE_DATE = sysdate
4472: , LAST_UPDATED_BY = -9999
4900: , tmp.prg_level
4901: , tmp.record_type
4902: , tmp.rowid pjp_row_id
4903: FROM pji_fp_aggr_pjp2 tmp
4904: , pji_pjp_wbs_header ver3 -- replaced ver3 with wbs header for project-to-program association event.
4905: WHERE 1 = 1
4906: AND tmp.worker_id = g_worker_id
4907: AND tmp.project_id = ver3.project_id
4908: AND ver3.plan_version_id = tmp.plan_version_id
5157: , tmp.CUSTOM14
5158: , tmp.CUSTOM15
5159: , tmp.PLAN_TYPE_CODE
5160: FROM pji_fp_aggr_pjp2 tmp
5161: , pji_pjp_wbs_header ver3 -- replaced ver3 with wbs header for project-to-program association event.
5162: WHERE 1 = 1
5163: AND tmp.worker_id = g_worker_id
5164: AND tmp.project_id = ver3.project_id
5165: AND ver3.plan_version_id = tmp.plan_version_id
6774: NO_ACCESS(@"SEL$2" "PJP"@"SEL$2")
6775: INDEX_RS_ASC(@"SEL$2" "SUB_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
6776: NO_ACCESS(@"SEL$2" "PRG"@"SEL$2")
6777: INDEX_RS_ASC(@"SEL$2" "SUP_WPA"@"SEL$2" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
6778: INDEX_RS_ASC(@"SEL$2" "WBS_HDR"@"SEL$2" ("PJI_PJP_WBS_HEADER"."PROJECT_ID" "PJI_PJP_WBS_HEADER"."PLAN_VERSION_ID"))
6779: INDEX_RS_ASC(@"SEL$2" "SUP_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
6780: LEADING(@"SEL$2" "PJP"@"SEL$2" "SUB_VER"@"SEL$2" "PRG"@"SEL$2" "SUP_WPA"@"SEL$2" "WBS_HDR"@"SEL$2" "SUP_VER"@"SEL$2")
6781: USE_NL(@"SEL$2" "SUB_VER"@"SEL$2")
6782: USE_HASH(@"SEL$2" "PRG"@"SEL$2")
6797: PQ_DISTRIBUTE(@"SEL$30" "PRG_DELTA"@"SEL$30"NONE BROADCAST)
6798: SWAP_JOIN_INPUTS(@"SEL$30" "INVERT"@"SEL$30")
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")
7633: pjp1.CUSTOM14,
7634: pjp1.CUSTOM15
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
7787: pjp1.CUSTOM14,
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,
7938: wbs.SIGN * fpr.CUSTOM14 CUSTOM14,
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: (
8056: prg.RELATIONSHIP_TYPE = prg_delta.RELATIONSHIP_TYPE (+) and
8057: -1 = prg_delta.SIGN (+) and
8058: prg_delta.SUP_PROJECT_ID is null
8059: ) prg,
8060: PJI_PJP_WBS_HEADER wbs_hdr,
8061: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
8062: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
8063: PA_PROJ_WORKPLAN_ATTR sup_wpa
8064: where
8268: NO_ACCESS(@"SEL$2" "PJP"@"SEL$2")
8269: INDEX_RS_ASC(@"SEL$2" "SUB_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
8270: NO_ACCESS(@"SEL$2" "PRG"@"SEL$2")
8271: INDEX_RS_ASC(@"SEL$2" "SUP_WPA"@"SEL$2" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
8272: INDEX_RS_ASC(@"SEL$2" "WBS_HDR"@"SEL$2" ("PJI_PJP_WBS_HEADER"."PROJECT_ID" "PJI_PJP_WBS_HEADER"."PLAN_VERSION_ID"))
8273: INDEX_RS_ASC(@"SEL$2" "SUP_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
8274: LEADING(@"SEL$2" "PJP"@"SEL$2" "SUB_VER"@"SEL$2" "PRG"@"SEL$2" "SUP_WPA"@"SEL$2" "WBS_HDR"@"SEL$2" "SUP_VER"@"SEL$2")
8275: USE_NL(@"SEL$2" "SUB_VER"@"SEL$2")
8276: USE_HASH(@"SEL$2" "PRG"@"SEL$2")
8291: PQ_DISTRIBUTE(@"SEL$30" "PRG_DELTA"@"SEL$30"NONE BROADCAST)
8292: SWAP_JOIN_INPUTS(@"SEL$30" "INVERT"@"SEL$30")
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")
9127: pjp1.CUSTOM14,
9128: pjp1.CUSTOM15
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
9281: pjp1.CUSTOM14,
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,
9432: wbs.SIGN * fpr.CUSTOM14 CUSTOM14,
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: (
9550: prg.RELATIONSHIP_TYPE = prg_delta.RELATIONSHIP_TYPE (+) and
9551: -1 = prg_delta.SIGN (+) and
9552: prg_delta.SUP_PROJECT_ID is null
9553: ) prg,
9554: PJI_PJP_WBS_HEADER wbs_hdr,
9555: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
9556: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
9557: PA_PROJ_WORKPLAN_ATTR sup_wpa
9558: where
9762: NO_ACCESS(@"SEL$2" "PJP"@"SEL$2")
9763: INDEX_RS_ASC(@"SEL$2" "SUB_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
9764: NO_ACCESS(@"SEL$2" "PRG"@"SEL$2")
9765: INDEX_RS_ASC(@"SEL$2" "SUP_WPA"@"SEL$2" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
9766: INDEX_RS_ASC(@"SEL$2" "WBS_HDR"@"SEL$2" ("PJI_PJP_WBS_HEADER"."PROJECT_ID" "PJI_PJP_WBS_HEADER"."PLAN_VERSION_ID"))
9767: INDEX_RS_ASC(@"SEL$2" "SUP_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
9768: LEADING(@"SEL$2" "PJP"@"SEL$2" "SUB_VER"@"SEL$2" "PRG"@"SEL$2" "SUP_WPA"@"SEL$2" "WBS_HDR"@"SEL$2" "SUP_VER"@"SEL$2")
9769: USE_NL(@"SEL$2" "SUB_VER"@"SEL$2")
9770: USE_HASH(@"SEL$2" "PRG"@"SEL$2")
9785: PQ_DISTRIBUTE(@"SEL$30" "PRG_DELTA"@"SEL$30"NONE BROADCAST)
9786: SWAP_JOIN_INPUTS(@"SEL$30" "INVERT"@"SEL$30")
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")
10621: pjp1.CUSTOM14,
10622: pjp1.CUSTOM15
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
10775: pjp1.CUSTOM14,
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,
10926: wbs.SIGN * fpr.CUSTOM14 CUSTOM14,
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: (
11044: prg.RELATIONSHIP_TYPE = prg_delta.RELATIONSHIP_TYPE (+) and
11045: -1 = prg_delta.SIGN (+) and
11046: prg_delta.SUP_PROJECT_ID is null
11047: ) prg,
11048: PJI_PJP_WBS_HEADER wbs_hdr,
11049: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
11050: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
11051: PA_PROJ_WORKPLAN_ATTR sup_wpa
11052: where
11255: NO_ACCESS(@"SEL$2" "PJP"@"SEL$2")
11256: INDEX_RS_ASC(@"SEL$2" "SUB_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
11257: NO_ACCESS(@"SEL$2" "PRG"@"SEL$2")
11258: INDEX_RS_ASC(@"SEL$2" "SUP_WPA"@"SEL$2" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
11259: INDEX_RS_ASC(@"SEL$2" "WBS_HDR"@"SEL$2" ("PJI_PJP_WBS_HEADER"."PROJECT_ID" "PJI_PJP_WBS_HEADER"."PLAN_VERSION_ID"))
11260: INDEX_RS_ASC(@"SEL$2" "SUP_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
11261: LEADING(@"SEL$2" "PJP"@"SEL$2" "SUB_VER"@"SEL$2" "PRG"@"SEL$2" "SUP_WPA"@"SEL$2" "WBS_HDR"@"SEL$2" "SUP_VER"@"SEL$2")
11262: USE_NL(@"SEL$2" "SUB_VER"@"SEL$2")
11263: USE_HASH(@"SEL$2" "PRG"@"SEL$2")
11278: PQ_DISTRIBUTE(@"SEL$30" "PRG_DELTA"@"SEL$30"NONE BROADCAST)
11279: SWAP_JOIN_INPUTS(@"SEL$30" "INVERT"@"SEL$30")
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")
12114: pjp1.CUSTOM14,
12115: pjp1.CUSTOM15
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
12268: pjp1.CUSTOM14,
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,
12419: wbs.SIGN * fpr.CUSTOM14 CUSTOM14,
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: (
12537: prg.RELATIONSHIP_TYPE = prg_delta.RELATIONSHIP_TYPE (+) and
12538: -1 = prg_delta.SIGN (+) and
12539: prg_delta.SUP_PROJECT_ID is null
12540: ) prg,
12541: PJI_PJP_WBS_HEADER wbs_hdr,
12542: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
12543: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
12544: PA_PROJ_WORKPLAN_ATTR sup_wpa
12545: where
12749: NO_ACCESS(@"SEL$2" "PJP"@"SEL$2")
12750: INDEX_RS_ASC(@"SEL$2" "SUB_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
12751: NO_ACCESS(@"SEL$2" "PRG"@"SEL$2")
12752: INDEX_RS_ASC(@"SEL$2" "SUP_WPA"@"SEL$2" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
12753: INDEX_RS_ASC(@"SEL$2" "WBS_HDR"@"SEL$2" ("PJI_PJP_WBS_HEADER"."PROJECT_ID" "PJI_PJP_WBS_HEADER"."PLAN_VERSION_ID"))
12754: INDEX_RS_ASC(@"SEL$2" "SUP_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
12755: LEADING(@"SEL$2" "PJP"@"SEL$2" "SUB_VER"@"SEL$2" "PRG"@"SEL$2" "SUP_WPA"@"SEL$2" "WBS_HDR"@"SEL$2" "SUP_VER"@"SEL$2")
12756: USE_NL(@"SEL$2" "SUB_VER"@"SEL$2")
12757: USE_HASH(@"SEL$2" "PRG"@"SEL$2")
12772: PQ_DISTRIBUTE(@"SEL$30" "PRG_DELTA"@"SEL$30"NONE BROADCAST)
12773: SWAP_JOIN_INPUTS(@"SEL$30" "INVERT"@"SEL$30")
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")
13608: pjp1.CUSTOM14,
13609: pjp1.CUSTOM15
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
13762: pjp1.CUSTOM14,
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,
13913: wbs.SIGN * fpr.CUSTOM14 CUSTOM14,
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: (
14031: prg.RELATIONSHIP_TYPE = prg_delta.RELATIONSHIP_TYPE (+) and
14032: -1 = prg_delta.SIGN (+) and
14033: prg_delta.SUP_PROJECT_ID is null
14034: ) prg,
14035: PJI_PJP_WBS_HEADER wbs_hdr,
14036: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
14037: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
14038: PA_PROJ_WORKPLAN_ATTR sup_wpa
14039: where
14242: NO_ACCESS(@"SEL$2" "PJP"@"SEL$2")
14243: INDEX_RS_ASC(@"SEL$2" "SUB_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
14244: NO_ACCESS(@"SEL$2" "PRG"@"SEL$2")
14245: INDEX_RS_ASC(@"SEL$2" "SUP_WPA"@"SEL$2" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
14246: INDEX_RS_ASC(@"SEL$2" "WBS_HDR"@"SEL$2" ("PJI_PJP_WBS_HEADER"."PROJECT_ID" "PJI_PJP_WBS_HEADER"."PLAN_VERSION_ID"))
14247: INDEX_RS_ASC(@"SEL$2" "SUP_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
14248: LEADING(@"SEL$2" "PJP"@"SEL$2" "SUB_VER"@"SEL$2" "PRG"@"SEL$2" "SUP_WPA"@"SEL$2" "WBS_HDR"@"SEL$2" "SUP_VER"@"SEL$2")
14249: USE_NL(@"SEL$2" "SUB_VER"@"SEL$2")
14250: USE_HASH(@"SEL$2" "PRG"@"SEL$2")
14265: PQ_DISTRIBUTE(@"SEL$30" "PRG_DELTA"@"SEL$30"NONE BROADCAST)
14266: SWAP_JOIN_INPUTS(@"SEL$30" "INVERT"@"SEL$30")
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")
15101: pjp1.CUSTOM14,
15102: pjp1.CUSTOM15
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
15255: pjp1.CUSTOM14,
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,
15406: wbs.SIGN * fpr.CUSTOM14 CUSTOM14,
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: (
15524: prg.RELATIONSHIP_TYPE = prg_delta.RELATIONSHIP_TYPE (+) and
15525: -1 = prg_delta.SIGN (+) and
15526: prg_delta.SUP_PROJECT_ID is null
15527: ) prg,
15528: PJI_PJP_WBS_HEADER wbs_hdr,
15529: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
15530: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
15531: PA_PROJ_WORKPLAN_ATTR sup_wpa
15532: where
15735: NO_ACCESS(@"SEL$2" "PJP"@"SEL$2")
15736: INDEX_RS_ASC(@"SEL$2" "SUB_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
15737: NO_ACCESS(@"SEL$2" "PRG"@"SEL$2")
15738: INDEX_RS_ASC(@"SEL$2" "SUP_WPA"@"SEL$2" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
15739: INDEX_RS_ASC(@"SEL$2" "WBS_HDR"@"SEL$2" ("PJI_PJP_WBS_HEADER"."PROJECT_ID" "PJI_PJP_WBS_HEADER"."PLAN_VERSION_ID"))
15740: INDEX_RS_ASC(@"SEL$2" "SUP_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
15741: LEADING(@"SEL$2" "PJP"@"SEL$2" "SUB_VER"@"SEL$2" "PRG"@"SEL$2" "SUP_WPA"@"SEL$2" "WBS_HDR"@"SEL$2" "SUP_VER"@"SEL$2")
15742: USE_NL(@"SEL$2" "SUB_VER"@"SEL$2")
15743: USE_HASH(@"SEL$2" "PRG"@"SEL$2")
15758: PQ_DISTRIBUTE(@"SEL$30" "PRG_DELTA"@"SEL$30"NONE BROADCAST)
15759: SWAP_JOIN_INPUTS(@"SEL$30" "INVERT"@"SEL$30")
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")
16594: pjp1.CUSTOM14,
16595: pjp1.CUSTOM15
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
16748: pjp1.CUSTOM14,
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,
16899: wbs.SIGN * fpr.CUSTOM14 CUSTOM14,
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: (
17017: prg.RELATIONSHIP_TYPE = prg_delta.RELATIONSHIP_TYPE (+) and
17018: -1 = prg_delta.SIGN (+) and
17019: prg_delta.SUP_PROJECT_ID is null
17020: ) prg,
17021: PJI_PJP_WBS_HEADER wbs_hdr,
17022: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
17023: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
17024: PA_PROJ_WORKPLAN_ATTR sup_wpa
17025: where
17229: NO_ACCESS(@"SEL$2" "PJP"@"SEL$2")
17230: INDEX_RS_ASC(@"SEL$2" "SUB_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
17231: NO_ACCESS(@"SEL$2" "PRG"@"SEL$2")
17232: INDEX_RS_ASC(@"SEL$2" "SUP_WPA"@"SEL$2" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
17233: INDEX_RS_ASC(@"SEL$2" "WBS_HDR"@"SEL$2" ("PJI_PJP_WBS_HEADER"."PROJECT_ID" "PJI_PJP_WBS_HEADER"."PLAN_VERSION_ID"))
17234: INDEX_RS_ASC(@"SEL$2" "SUP_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
17235: LEADING(@"SEL$2" "PJP"@"SEL$2" "SUB_VER"@"SEL$2" "PRG"@"SEL$2" "SUP_WPA"@"SEL$2" "WBS_HDR"@"SEL$2" "SUP_VER"@"SEL$2")
17236: USE_NL(@"SEL$2" "SUB_VER"@"SEL$2")
17237: USE_HASH(@"SEL$2" "PRG"@"SEL$2")
17252: PQ_DISTRIBUTE(@"SEL$30" "PRG_DELTA"@"SEL$30"NONE BROADCAST)
17253: SWAP_JOIN_INPUTS(@"SEL$30" "INVERT"@"SEL$30")
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")
18088: pjp1.CUSTOM14,
18089: pjp1.CUSTOM15
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
18242: pjp1.CUSTOM14,
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,
18393: wbs.SIGN * fpr.CUSTOM14 CUSTOM14,
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: (
18511: prg.RELATIONSHIP_TYPE = prg_delta.RELATIONSHIP_TYPE (+) and
18512: -1 = prg_delta.SIGN (+) and
18513: prg_delta.SUP_PROJECT_ID is null
18514: ) prg,
18515: PJI_PJP_WBS_HEADER wbs_hdr,
18516: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
18517: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
18518: PA_PROJ_WORKPLAN_ATTR sup_wpa
18519: where
18723: NO_ACCESS(@"SEL$2" "PJP"@"SEL$2")
18724: INDEX_RS_ASC(@"SEL$2" "SUB_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
18725: NO_ACCESS(@"SEL$2" "PRG"@"SEL$2")
18726: INDEX_RS_ASC(@"SEL$2" "SUP_WPA"@"SEL$2" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
18727: INDEX_RS_ASC(@"SEL$2" "WBS_HDR"@"SEL$2" ("PJI_PJP_WBS_HEADER"."PROJECT_ID" "PJI_PJP_WBS_HEADER"."PLAN_VERSION_ID"))
18728: INDEX_RS_ASC(@"SEL$2" "SUP_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
18729: LEADING(@"SEL$2" "PJP"@"SEL$2" "SUB_VER"@"SEL$2" "PRG"@"SEL$2" "SUP_WPA"@"SEL$2" "WBS_HDR"@"SEL$2" "SUP_VER"@"SEL$2")
18730: USE_NL(@"SEL$2" "SUB_VER"@"SEL$2")
18731: USE_HASH(@"SEL$2" "PRG"@"SEL$2")
18746: PQ_DISTRIBUTE(@"SEL$30" "PRG_DELTA"@"SEL$30"NONE BROADCAST)
18747: SWAP_JOIN_INPUTS(@"SEL$30" "INVERT"@"SEL$30")
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")
19582: pjp1.CUSTOM14,
19583: pjp1.CUSTOM15
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
19736: pjp1.CUSTOM14,
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,
19887: wbs.SIGN * fpr.CUSTOM14 CUSTOM14,
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: (
20005: prg.RELATIONSHIP_TYPE = prg_delta.RELATIONSHIP_TYPE (+) and
20006: -1 = prg_delta.SIGN (+) and
20007: prg_delta.SUP_PROJECT_ID is null
20008: ) prg,
20009: PJI_PJP_WBS_HEADER wbs_hdr,
20010: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
20011: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
20012: PA_PROJ_WORKPLAN_ATTR sup_wpa
20013: where
20217: NO_ACCESS(@"SEL$2" "PJP"@"SEL$2")
20218: INDEX_RS_ASC(@"SEL$2" "SUB_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
20219: NO_ACCESS(@"SEL$2" "PRG"@"SEL$2")
20220: INDEX_RS_ASC(@"SEL$2" "SUP_WPA"@"SEL$2" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
20221: INDEX_RS_ASC(@"SEL$2" "WBS_HDR"@"SEL$2" ("PJI_PJP_WBS_HEADER"."PROJECT_ID" "PJI_PJP_WBS_HEADER"."PLAN_VERSION_ID"))
20222: INDEX_RS_ASC(@"SEL$2" "SUP_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
20223: LEADING(@"SEL$2" "PJP"@"SEL$2" "SUB_VER"@"SEL$2" "PRG"@"SEL$2" "SUP_WPA"@"SEL$2" "WBS_HDR"@"SEL$2" "SUP_VER"@"SEL$2")
20224: USE_NL(@"SEL$2" "SUB_VER"@"SEL$2")
20225: USE_HASH(@"SEL$2" "PRG"@"SEL$2")
20240: PQ_DISTRIBUTE(@"SEL$30" "PRG_DELTA"@"SEL$30"NONE BROADCAST)
20241: SWAP_JOIN_INPUTS(@"SEL$30" "INVERT"@"SEL$30")
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")
21076: pjp1.CUSTOM14,
21077: pjp1.CUSTOM15
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
21230: pjp1.CUSTOM14,
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,
21381: wbs.SIGN * fpr.CUSTOM14 CUSTOM14,
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: (
21499: prg.RELATIONSHIP_TYPE = prg_delta.RELATIONSHIP_TYPE (+) and
21500: -1 = prg_delta.SIGN (+) and
21501: prg_delta.SUP_PROJECT_ID is null
21502: ) prg,
21503: PJI_PJP_WBS_HEADER wbs_hdr,
21504: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
21505: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
21506: PA_PROJ_WORKPLAN_ATTR sup_wpa
21507: where