4096: AND ver.worker_id = g_worker_id
4097: ) spread_bl
4098: ,
4099: (
4100: select 1 INVERT_ID from dual union all
4101: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
4102: select 4 INVERT_ID from dual union all
4103: select 8 INVERT_ID from dual union all
4104: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
4097: ) spread_bl
4098: ,
4099: (
4100: select 1 INVERT_ID from dual union all
4101: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
4102: select 4 INVERT_ID from dual union all
4103: select 8 INVERT_ID from dual union all
4104: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
4105: ) invert
4098: ,
4099: (
4100: select 1 INVERT_ID from dual union all
4101: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
4102: select 4 INVERT_ID from dual union all
4103: select 8 INVERT_ID from dual union all
4104: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
4105: ) invert
4106: ) collapse_bl
4099: (
4100: select 1 INVERT_ID from dual union all
4101: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
4102: select 4 INVERT_ID from dual union all
4103: select 8 INVERT_ID from dual union all
4104: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
4105: ) invert
4106: ) collapse_bl
4107: GROUP BY
4100: select 1 INVERT_ID from dual union all
4101: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
4102: select 4 INVERT_ID from dual union all
4103: select 8 INVERT_ID from dual union all
4104: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
4105: ) invert
4106: ) collapse_bl
4107: GROUP BY
4108: collapse_bl.PROJECT_ID
5672: (
5673: Select decode(
5674: bitand(l_refresh_code,g_all_plans),g_all_plans,'Y',
5675: decode( bitand(l_refresh_code,g_cb_plans),g_cb_plans,
5676: decode(decode(bv.baselined_date, NULL, 'N', 'Y')||bv.current_flag,'YY', 'Y', 'N'),'X')) from dual
5677: UNION ALL
5678: Select decode(
5679: bitand(l_refresh_code,g_all_plans),g_all_plans,'Y',
5680: decode( bitand(l_refresh_code,g_co_plans),g_co_plans,bv.current_original_flag,'X')) from dual
5676: decode(decode(bv.baselined_date, NULL, 'N', 'Y')||bv.current_flag,'YY', 'Y', 'N'),'X')) from dual
5677: UNION ALL
5678: Select decode(
5679: bitand(l_refresh_code,g_all_plans),g_all_plans,'Y',
5680: decode( bitand(l_refresh_code,g_co_plans),g_co_plans,bv.current_original_flag,'X')) from dual
5681: )
5682: OR -- Bug#5099574 Pull Reversals for Fin plan Working Versions when l_refresh_code=16,30. ignore if l_refresh_code>=62
5683: (
5684: bv.BUDGET_STATUS_CODE in ('W','S') and
5707: map.worker_id,map.project_id, plan_version_id, 'G' time_phased_code
5708: from
5709: PJI_PJP_PROJ_BATCH_MAP map,
5710: (
5711: select decode (bitand (l_refresh_code,1),1,-1,-999) plan_version_id from dual where l_plan_type_id is null
5712: union all
5713: select decode (bitand (l_refresh_code,g_cb_plans),g_cb_plans,-3,-999) plan_version_id from dual
5714: union all
5715: select decode (bitand (l_refresh_code,g_co_plans),g_co_plans,-4,-999) plan_version_id from dual
5709: PJI_PJP_PROJ_BATCH_MAP map,
5710: (
5711: select decode (bitand (l_refresh_code,1),1,-1,-999) plan_version_id from dual where l_plan_type_id is null
5712: union all
5713: select decode (bitand (l_refresh_code,g_cb_plans),g_cb_plans,-3,-999) plan_version_id from dual
5714: union all
5715: select decode (bitand (l_refresh_code,g_co_plans),g_co_plans,-4,-999) plan_version_id from dual
5716: )
5717: where map.worker_id=p_worker_id;
5711: select decode (bitand (l_refresh_code,1),1,-1,-999) plan_version_id from dual where l_plan_type_id is null
5712: union all
5713: select decode (bitand (l_refresh_code,g_cb_plans),g_cb_plans,-3,-999) plan_version_id from dual
5714: union all
5715: select decode (bitand (l_refresh_code,g_co_plans),g_co_plans,-4,-999) plan_version_id from dual
5716: )
5717: where map.worker_id=p_worker_id;
5718:
5719:
6398: 'ROLLUP_FPR_WBS - level ' || to_char(l_level - x + 1) STEP_NAME,
6399: null START_DATE,
6400: null END_DATE
6401: from
6402: DUAL;
6403:
6404: end loop;
6405:
6406: end if;
7638: PA_XBS_DENORM wbs,
7639: PJI_XBS_DENORM prg,
7640: (
7641: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
7642: from DUAL union all
7643: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7644: from DUAL union all
7645: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
7646: from DUAL union all
7640: (
7641: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
7642: from DUAL union all
7643: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7644: from DUAL union all
7645: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
7646: from DUAL union all
7647: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7648: from DUAL union all
7642: from DUAL union all
7643: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7644: from DUAL union all
7645: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
7646: from DUAL union all
7647: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7648: from DUAL union all
7649: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
7650: from DUAL union all
7644: from DUAL union all
7645: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
7646: from DUAL union all
7647: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7648: from DUAL union all
7649: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
7650: from DUAL union all
7651: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7652: from DUAL union all
7646: from DUAL union all
7647: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7648: from DUAL union all
7649: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
7650: from DUAL union all
7651: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7652: from DUAL union all
7653: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
7654: from DUAL union all
7648: from DUAL union all
7649: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
7650: from DUAL union all
7651: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7652: from DUAL union all
7653: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
7654: from DUAL union all
7655: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7656: from DUAL
7650: from DUAL union all
7651: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7652: from DUAL union all
7653: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
7654: from DUAL union all
7655: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7656: from DUAL
7657: ) fin_plan,
7658: (
7652: from DUAL union all
7653: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
7654: from DUAL union all
7655: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7656: from DUAL
7657: ) fin_plan,
7658: (
7659: select 1 WBS_SUP_LEVEL,
7660: 1 WBS_SUB_LEVEL,
7658: (
7659: select 1 WBS_SUP_LEVEL,
7660: 1 WBS_SUB_LEVEL,
7661: 'PRJ' INVERT_ID
7662: from DUAL
7663: union all
7664: select 1 WBS_SUP_LEVEL,
7665: 1 WBS_SUB_LEVEL,
7666: 'WBS' INVERT_ID
7663: union all
7664: select 1 WBS_SUP_LEVEL,
7665: 1 WBS_SUB_LEVEL,
7666: 'WBS' INVERT_ID
7667: from DUAL
7668: ) top_slice
7669: where
7670: prg.STRUCT_TYPE = 'PRG' and
7671: prg.SUP_LEVEL = l_level and
7793: (
7794: select 'Y' CB_FLAG,
7795: 'N' CO_FLAG,
7796: -3 PLAN_VERSION_ID
7797: from DUAL union all
7798: select 'N' CB_FLAG,
7799: 'Y' CO_FLAG,
7800: -4 PLAN_VERSION_ID
7801: from DUAL union all
7797: from DUAL union all
7798: select 'N' CB_FLAG,
7799: 'Y' CO_FLAG,
7800: -4 PLAN_VERSION_ID
7801: from DUAL union all
7802: select 'Y' CB_FLAG,
7803: 'Y' CO_FLAG,
7804: -3 PLAN_VERSION_ID
7805: from DUAL union all
7801: from DUAL union all
7802: select 'Y' CB_FLAG,
7803: 'Y' CO_FLAG,
7804: -3 PLAN_VERSION_ID
7805: from DUAL union all
7806: select 'Y' CB_FLAG,
7807: 'Y' CO_FLAG,
7808: -4 PLAN_VERSION_ID
7809: from DUAL
7805: from DUAL union all
7806: select 'Y' CB_FLAG,
7807: 'Y' CO_FLAG,
7808: -4 PLAN_VERSION_ID
7809: from DUAL
7810: ) fin_plan
7811: where
7812: prg.STRUCT_TYPE = 'PRG' and
7813: prg.SUP_LEVEL = l_level and
7944: PJI_XBS_DENORM prg,
7945: PJI_FP_XBS_ACCUM_F fpr,
7946: (
7947: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
7948: from DUAL union all
7949: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7950: from DUAL union all
7951: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
7952: from DUAL union all
7946: (
7947: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
7948: from DUAL union all
7949: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7950: from DUAL union all
7951: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
7952: from DUAL union all
7953: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7954: from DUAL union all
7948: from DUAL union all
7949: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7950: from DUAL union all
7951: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
7952: from DUAL union all
7953: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7954: from DUAL union all
7955: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
7956: from DUAL union all
7950: from DUAL union all
7951: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
7952: from DUAL union all
7953: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7954: from DUAL union all
7955: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
7956: from DUAL union all
7957: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7958: from DUAL union all
7952: from DUAL union all
7953: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7954: from DUAL union all
7955: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
7956: from DUAL union all
7957: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7958: from DUAL union all
7959: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
7960: from DUAL union all
7954: from DUAL union all
7955: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
7956: from DUAL union all
7957: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7958: from DUAL union all
7959: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
7960: from DUAL union all
7961: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7962: from DUAL
7956: from DUAL union all
7957: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7958: from DUAL union all
7959: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
7960: from DUAL union all
7961: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7962: from DUAL
7963: ) fin_plan,
7964: (
7958: from DUAL union all
7959: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
7960: from DUAL union all
7961: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7962: from DUAL
7963: ) fin_plan,
7964: (
7965: select 1 WBS_SUP_LEVEL,
7966: 1 WBS_SUB_LEVEL,
7964: (
7965: select 1 WBS_SUP_LEVEL,
7966: 1 WBS_SUB_LEVEL,
7967: 'PRJ' INVERT_ID
7968: from DUAL
7969: union all
7970: select 1 WBS_SUP_LEVEL,
7971: 1 WBS_SUB_LEVEL,
7972: 'WBS' INVERT_ID
7969: union all
7970: select 1 WBS_SUP_LEVEL,
7971: 1 WBS_SUB_LEVEL,
7972: 'WBS' INVERT_ID
7973: from DUAL
7974: ) top_slice
7975: where
7976: prg.STRUCT_TYPE = 'PRG' and
7977: prg.SUP_LEVEL = l_level and
8030: from
8031: PJI_PJP_PROJ_BATCH_MAP map,
8032: PJI_XBS_DENORM prg,
8033: (
8034: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
8035: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
8036: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
8037: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
8038: ) invert,
8031: PJI_PJP_PROJ_BATCH_MAP map,
8032: PJI_XBS_DENORM prg,
8033: (
8034: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
8035: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
8036: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
8037: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
8038: ) invert,
8039: PJI_XBS_DENORM_DELTA prg_delta
8032: PJI_XBS_DENORM prg,
8033: (
8034: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
8035: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
8036: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
8037: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
8038: ) invert,
8039: PJI_XBS_DENORM_DELTA prg_delta
8040: where
8033: (
8034: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
8035: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
8036: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
8037: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
8038: ) invert,
8039: PJI_XBS_DENORM_DELTA prg_delta
8040: where
8041: prg.STRUCT_TYPE = 'PRG' and
9132: PA_XBS_DENORM wbs,
9133: PJI_XBS_DENORM prg,
9134: (
9135: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9136: from DUAL union all
9137: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9138: from DUAL union all
9139: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9140: from DUAL union all
9134: (
9135: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9136: from DUAL union all
9137: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9138: from DUAL union all
9139: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9140: from DUAL union all
9141: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9142: from DUAL union all
9136: from DUAL union all
9137: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9138: from DUAL union all
9139: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9140: from DUAL union all
9141: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9142: from DUAL union all
9143: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9144: from DUAL union all
9138: from DUAL union all
9139: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9140: from DUAL union all
9141: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9142: from DUAL union all
9143: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9144: from DUAL union all
9145: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9146: from DUAL union all
9140: from DUAL union all
9141: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9142: from DUAL union all
9143: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9144: from DUAL union all
9145: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9146: from DUAL union all
9147: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9148: from DUAL union all
9142: from DUAL union all
9143: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9144: from DUAL union all
9145: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9146: from DUAL union all
9147: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9148: from DUAL union all
9149: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9150: from DUAL
9144: from DUAL union all
9145: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9146: from DUAL union all
9147: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9148: from DUAL union all
9149: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9150: from DUAL
9151: ) fin_plan,
9152: (
9146: from DUAL union all
9147: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9148: from DUAL union all
9149: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9150: from DUAL
9151: ) fin_plan,
9152: (
9153: select 1 WBS_SUP_LEVEL,
9154: 1 WBS_SUB_LEVEL,
9152: (
9153: select 1 WBS_SUP_LEVEL,
9154: 1 WBS_SUB_LEVEL,
9155: 'PRJ' INVERT_ID
9156: from DUAL
9157: union all
9158: select 1 WBS_SUP_LEVEL,
9159: 1 WBS_SUB_LEVEL,
9160: 'WBS' INVERT_ID
9157: union all
9158: select 1 WBS_SUP_LEVEL,
9159: 1 WBS_SUB_LEVEL,
9160: 'WBS' INVERT_ID
9161: from DUAL
9162: ) top_slice
9163: where
9164: prg.STRUCT_TYPE = 'PRG' and
9165: prg.SUP_LEVEL = l_level and
9287: (
9288: select 'Y' CB_FLAG,
9289: 'N' CO_FLAG,
9290: -3 PLAN_VERSION_ID
9291: from DUAL union all
9292: select 'N' CB_FLAG,
9293: 'Y' CO_FLAG,
9294: -4 PLAN_VERSION_ID
9295: from DUAL union all
9291: from DUAL union all
9292: select 'N' CB_FLAG,
9293: 'Y' CO_FLAG,
9294: -4 PLAN_VERSION_ID
9295: from DUAL union all
9296: select 'Y' CB_FLAG,
9297: 'Y' CO_FLAG,
9298: -3 PLAN_VERSION_ID
9299: from DUAL union all
9295: from DUAL union all
9296: select 'Y' CB_FLAG,
9297: 'Y' CO_FLAG,
9298: -3 PLAN_VERSION_ID
9299: from DUAL union all
9300: select 'Y' CB_FLAG,
9301: 'Y' CO_FLAG,
9302: -4 PLAN_VERSION_ID
9303: from DUAL
9299: from DUAL union all
9300: select 'Y' CB_FLAG,
9301: 'Y' CO_FLAG,
9302: -4 PLAN_VERSION_ID
9303: from DUAL
9304: ) fin_plan
9305: where
9306: prg.STRUCT_TYPE = 'PRG' and
9307: prg.SUP_LEVEL = l_level and
9438: PJI_XBS_DENORM prg,
9439: PJI_FP_XBS_ACCUM_F fpr,
9440: (
9441: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9442: from DUAL union all
9443: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9444: from DUAL union all
9445: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9446: from DUAL union all
9440: (
9441: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9442: from DUAL union all
9443: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9444: from DUAL union all
9445: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9446: from DUAL union all
9447: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9448: from DUAL union all
9442: from DUAL union all
9443: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9444: from DUAL union all
9445: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9446: from DUAL union all
9447: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9448: from DUAL union all
9449: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9450: from DUAL union all
9444: from DUAL union all
9445: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9446: from DUAL union all
9447: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9448: from DUAL union all
9449: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9450: from DUAL union all
9451: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9452: from DUAL union all
9446: from DUAL union all
9447: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9448: from DUAL union all
9449: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9450: from DUAL union all
9451: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9452: from DUAL union all
9453: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9454: from DUAL union all
9448: from DUAL union all
9449: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9450: from DUAL union all
9451: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9452: from DUAL union all
9453: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9454: from DUAL union all
9455: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9456: from DUAL
9450: from DUAL union all
9451: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9452: from DUAL union all
9453: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9454: from DUAL union all
9455: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9456: from DUAL
9457: ) fin_plan,
9458: (
9452: from DUAL union all
9453: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9454: from DUAL union all
9455: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9456: from DUAL
9457: ) fin_plan,
9458: (
9459: select 1 WBS_SUP_LEVEL,
9460: 1 WBS_SUB_LEVEL,
9458: (
9459: select 1 WBS_SUP_LEVEL,
9460: 1 WBS_SUB_LEVEL,
9461: 'PRJ' INVERT_ID
9462: from DUAL
9463: union all
9464: select 1 WBS_SUP_LEVEL,
9465: 1 WBS_SUB_LEVEL,
9466: 'WBS' INVERT_ID
9463: union all
9464: select 1 WBS_SUP_LEVEL,
9465: 1 WBS_SUB_LEVEL,
9466: 'WBS' INVERT_ID
9467: from DUAL
9468: ) top_slice
9469: where
9470: prg.STRUCT_TYPE = 'PRG' and
9471: prg.SUP_LEVEL = l_level and
9524: from
9525: PJI_PJP_PROJ_BATCH_MAP map,
9526: PJI_XBS_DENORM prg,
9527: (
9528: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
9529: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
9530: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
9531: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
9532: ) invert,
9525: PJI_PJP_PROJ_BATCH_MAP map,
9526: PJI_XBS_DENORM prg,
9527: (
9528: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
9529: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
9530: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
9531: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
9532: ) invert,
9533: PJI_XBS_DENORM_DELTA prg_delta
9526: PJI_XBS_DENORM prg,
9527: (
9528: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
9529: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
9530: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
9531: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
9532: ) invert,
9533: PJI_XBS_DENORM_DELTA prg_delta
9534: where
9527: (
9528: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
9529: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
9530: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
9531: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
9532: ) invert,
9533: PJI_XBS_DENORM_DELTA prg_delta
9534: where
9535: prg.STRUCT_TYPE = 'PRG' and
10626: PA_XBS_DENORM wbs,
10627: PJI_XBS_DENORM prg,
10628: (
10629: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10630: from DUAL union all
10631: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10632: from DUAL union all
10633: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10634: from DUAL union all
10628: (
10629: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10630: from DUAL union all
10631: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10632: from DUAL union all
10633: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10634: from DUAL union all
10635: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10636: from DUAL union all
10630: from DUAL union all
10631: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10632: from DUAL union all
10633: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10634: from DUAL union all
10635: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10636: from DUAL union all
10637: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10638: from DUAL union all
10632: from DUAL union all
10633: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10634: from DUAL union all
10635: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10636: from DUAL union all
10637: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10638: from DUAL union all
10639: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10640: from DUAL union all
10634: from DUAL union all
10635: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10636: from DUAL union all
10637: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10638: from DUAL union all
10639: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10640: from DUAL union all
10641: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10642: from DUAL union all
10636: from DUAL union all
10637: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10638: from DUAL union all
10639: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10640: from DUAL union all
10641: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10642: from DUAL union all
10643: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10644: from DUAL
10638: from DUAL union all
10639: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10640: from DUAL union all
10641: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10642: from DUAL union all
10643: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10644: from DUAL
10645: ) fin_plan,
10646: (
10640: from DUAL union all
10641: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10642: from DUAL union all
10643: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10644: from DUAL
10645: ) fin_plan,
10646: (
10647: select 1 WBS_SUP_LEVEL,
10648: 1 WBS_SUB_LEVEL,
10646: (
10647: select 1 WBS_SUP_LEVEL,
10648: 1 WBS_SUB_LEVEL,
10649: 'PRJ' INVERT_ID
10650: from DUAL
10651: union all
10652: select 1 WBS_SUP_LEVEL,
10653: 1 WBS_SUB_LEVEL,
10654: 'WBS' INVERT_ID
10651: union all
10652: select 1 WBS_SUP_LEVEL,
10653: 1 WBS_SUB_LEVEL,
10654: 'WBS' INVERT_ID
10655: from DUAL
10656: ) top_slice
10657: where
10658: prg.STRUCT_TYPE = 'PRG' and
10659: prg.SUP_LEVEL = l_level and
10781: (
10782: select 'Y' CB_FLAG,
10783: 'N' CO_FLAG,
10784: -3 PLAN_VERSION_ID
10785: from DUAL union all
10786: select 'N' CB_FLAG,
10787: 'Y' CO_FLAG,
10788: -4 PLAN_VERSION_ID
10789: from DUAL union all
10785: from DUAL union all
10786: select 'N' CB_FLAG,
10787: 'Y' CO_FLAG,
10788: -4 PLAN_VERSION_ID
10789: from DUAL union all
10790: select 'Y' CB_FLAG,
10791: 'Y' CO_FLAG,
10792: -3 PLAN_VERSION_ID
10793: from DUAL union all
10789: from DUAL union all
10790: select 'Y' CB_FLAG,
10791: 'Y' CO_FLAG,
10792: -3 PLAN_VERSION_ID
10793: from DUAL union all
10794: select 'Y' CB_FLAG,
10795: 'Y' CO_FLAG,
10796: -4 PLAN_VERSION_ID
10797: from DUAL
10793: from DUAL union all
10794: select 'Y' CB_FLAG,
10795: 'Y' CO_FLAG,
10796: -4 PLAN_VERSION_ID
10797: from DUAL
10798: ) fin_plan
10799: where
10800: prg.STRUCT_TYPE = 'PRG' and
10801: prg.SUP_LEVEL = l_level and
10932: PJI_XBS_DENORM prg,
10933: PJI_FP_XBS_ACCUM_F fpr,
10934: (
10935: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10936: from DUAL union all
10937: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10938: from DUAL union all
10939: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10940: from DUAL union all
10934: (
10935: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10936: from DUAL union all
10937: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10938: from DUAL union all
10939: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10940: from DUAL union all
10941: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10942: from DUAL union all
10936: from DUAL union all
10937: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10938: from DUAL union all
10939: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10940: from DUAL union all
10941: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10942: from DUAL union all
10943: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10944: from DUAL union all
10938: from DUAL union all
10939: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10940: from DUAL union all
10941: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10942: from DUAL union all
10943: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10944: from DUAL union all
10945: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10946: from DUAL union all
10940: from DUAL union all
10941: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10942: from DUAL union all
10943: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10944: from DUAL union all
10945: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10946: from DUAL union all
10947: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10948: from DUAL union all
10942: from DUAL union all
10943: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10944: from DUAL union all
10945: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10946: from DUAL union all
10947: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10948: from DUAL union all
10949: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10950: from DUAL
10944: from DUAL union all
10945: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10946: from DUAL union all
10947: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10948: from DUAL union all
10949: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10950: from DUAL
10951: ) fin_plan,
10952: (
10946: from DUAL union all
10947: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10948: from DUAL union all
10949: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10950: from DUAL
10951: ) fin_plan,
10952: (
10953: select 1 WBS_SUP_LEVEL,
10954: 1 WBS_SUB_LEVEL,
10952: (
10953: select 1 WBS_SUP_LEVEL,
10954: 1 WBS_SUB_LEVEL,
10955: 'PRJ' INVERT_ID
10956: from DUAL
10957: union all
10958: select 1 WBS_SUP_LEVEL,
10959: 1 WBS_SUB_LEVEL,
10960: 'WBS' INVERT_ID
10957: union all
10958: select 1 WBS_SUP_LEVEL,
10959: 1 WBS_SUB_LEVEL,
10960: 'WBS' INVERT_ID
10961: from DUAL
10962: ) top_slice
10963: where
10964: prg.STRUCT_TYPE = 'PRG' and
10965: prg.SUP_LEVEL = l_level and
11018: from
11019: PJI_PJP_PROJ_BATCH_MAP map,
11020: PJI_XBS_DENORM prg,
11021: (
11022: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
11023: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
11024: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
11025: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
11026: ) invert,
11019: PJI_PJP_PROJ_BATCH_MAP map,
11020: PJI_XBS_DENORM prg,
11021: (
11022: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
11023: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
11024: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
11025: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
11026: ) invert,
11027: PJI_XBS_DENORM_DELTA prg_delta
11020: PJI_XBS_DENORM prg,
11021: (
11022: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
11023: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
11024: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
11025: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
11026: ) invert,
11027: PJI_XBS_DENORM_DELTA prg_delta
11028: where
11021: (
11022: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
11023: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
11024: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
11025: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
11026: ) invert,
11027: PJI_XBS_DENORM_DELTA prg_delta
11028: where
11029: prg.STRUCT_TYPE = 'PRG' and
12119: PA_XBS_DENORM wbs,
12120: PJI_XBS_DENORM prg,
12121: (
12122: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12123: from DUAL union all
12124: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12125: from DUAL union all
12126: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12127: from DUAL union all
12121: (
12122: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12123: from DUAL union all
12124: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12125: from DUAL union all
12126: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12127: from DUAL union all
12128: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12129: from DUAL union all
12123: from DUAL union all
12124: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12125: from DUAL union all
12126: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12127: from DUAL union all
12128: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12129: from DUAL union all
12130: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12131: from DUAL union all
12125: from DUAL union all
12126: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12127: from DUAL union all
12128: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12129: from DUAL union all
12130: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12131: from DUAL union all
12132: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12133: from DUAL union all
12127: from DUAL union all
12128: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12129: from DUAL union all
12130: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12131: from DUAL union all
12132: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12133: from DUAL union all
12134: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12135: from DUAL union all
12129: from DUAL union all
12130: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12131: from DUAL union all
12132: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12133: from DUAL union all
12134: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12135: from DUAL union all
12136: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12137: from DUAL
12131: from DUAL union all
12132: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12133: from DUAL union all
12134: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12135: from DUAL union all
12136: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12137: from DUAL
12138: ) fin_plan,
12139: (
12133: from DUAL union all
12134: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12135: from DUAL union all
12136: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12137: from DUAL
12138: ) fin_plan,
12139: (
12140: select 1 WBS_SUP_LEVEL,
12141: 1 WBS_SUB_LEVEL,
12139: (
12140: select 1 WBS_SUP_LEVEL,
12141: 1 WBS_SUB_LEVEL,
12142: 'PRJ' INVERT_ID
12143: from DUAL
12144: union all
12145: select 1 WBS_SUP_LEVEL,
12146: 1 WBS_SUB_LEVEL,
12147: 'WBS' INVERT_ID
12144: union all
12145: select 1 WBS_SUP_LEVEL,
12146: 1 WBS_SUB_LEVEL,
12147: 'WBS' INVERT_ID
12148: from DUAL
12149: ) top_slice
12150: where
12151: prg.STRUCT_TYPE = 'PRG' and
12152: prg.SUP_LEVEL = l_level and
12274: (
12275: select 'Y' CB_FLAG,
12276: 'N' CO_FLAG,
12277: -3 PLAN_VERSION_ID
12278: from DUAL union all
12279: select 'N' CB_FLAG,
12280: 'Y' CO_FLAG,
12281: -4 PLAN_VERSION_ID
12282: from DUAL union all
12278: from DUAL union all
12279: select 'N' CB_FLAG,
12280: 'Y' CO_FLAG,
12281: -4 PLAN_VERSION_ID
12282: from DUAL union all
12283: select 'Y' CB_FLAG,
12284: 'Y' CO_FLAG,
12285: -3 PLAN_VERSION_ID
12286: from DUAL union all
12282: from DUAL union all
12283: select 'Y' CB_FLAG,
12284: 'Y' CO_FLAG,
12285: -3 PLAN_VERSION_ID
12286: from DUAL union all
12287: select 'Y' CB_FLAG,
12288: 'Y' CO_FLAG,
12289: -4 PLAN_VERSION_ID
12290: from DUAL
12286: from DUAL union all
12287: select 'Y' CB_FLAG,
12288: 'Y' CO_FLAG,
12289: -4 PLAN_VERSION_ID
12290: from DUAL
12291: ) fin_plan
12292: where
12293: prg.STRUCT_TYPE = 'PRG' and
12294: prg.SUP_LEVEL = l_level and
12425: PJI_XBS_DENORM prg,
12426: PJI_FP_XBS_ACCUM_F fpr,
12427: (
12428: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12429: from DUAL union all
12430: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12431: from DUAL union all
12432: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12433: from DUAL union all
12427: (
12428: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12429: from DUAL union all
12430: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12431: from DUAL union all
12432: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12433: from DUAL union all
12434: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12435: from DUAL union all
12429: from DUAL union all
12430: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12431: from DUAL union all
12432: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12433: from DUAL union all
12434: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12435: from DUAL union all
12436: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12437: from DUAL union all
12431: from DUAL union all
12432: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12433: from DUAL union all
12434: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12435: from DUAL union all
12436: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12437: from DUAL union all
12438: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12439: from DUAL union all
12433: from DUAL union all
12434: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12435: from DUAL union all
12436: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12437: from DUAL union all
12438: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12439: from DUAL union all
12440: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12441: from DUAL union all
12435: from DUAL union all
12436: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12437: from DUAL union all
12438: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12439: from DUAL union all
12440: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12441: from DUAL union all
12442: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12443: from DUAL
12437: from DUAL union all
12438: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12439: from DUAL union all
12440: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12441: from DUAL union all
12442: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12443: from DUAL
12444: ) fin_plan,
12445: (
12439: from DUAL union all
12440: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12441: from DUAL union all
12442: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12443: from DUAL
12444: ) fin_plan,
12445: (
12446: select 1 WBS_SUP_LEVEL,
12447: 1 WBS_SUB_LEVEL,
12445: (
12446: select 1 WBS_SUP_LEVEL,
12447: 1 WBS_SUB_LEVEL,
12448: 'PRJ' INVERT_ID
12449: from DUAL
12450: union all
12451: select 1 WBS_SUP_LEVEL,
12452: 1 WBS_SUB_LEVEL,
12453: 'WBS' INVERT_ID
12450: union all
12451: select 1 WBS_SUP_LEVEL,
12452: 1 WBS_SUB_LEVEL,
12453: 'WBS' INVERT_ID
12454: from DUAL
12455: ) top_slice
12456: where
12457: prg.STRUCT_TYPE = 'PRG' and
12458: prg.SUP_LEVEL = l_level and
12511: from
12512: PJI_PJP_PROJ_BATCH_MAP map,
12513: PJI_XBS_DENORM prg,
12514: (
12515: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
12516: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
12517: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
12518: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
12519: ) invert,
12512: PJI_PJP_PROJ_BATCH_MAP map,
12513: PJI_XBS_DENORM prg,
12514: (
12515: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
12516: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
12517: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
12518: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
12519: ) invert,
12520: PJI_XBS_DENORM_DELTA prg_delta
12513: PJI_XBS_DENORM prg,
12514: (
12515: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
12516: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
12517: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
12518: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
12519: ) invert,
12520: PJI_XBS_DENORM_DELTA prg_delta
12521: where
12514: (
12515: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
12516: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
12517: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
12518: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
12519: ) invert,
12520: PJI_XBS_DENORM_DELTA prg_delta
12521: where
12522: prg.STRUCT_TYPE = 'PRG' and
13613: PA_XBS_DENORM wbs,
13614: PJI_XBS_DENORM prg,
13615: (
13616: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13617: from DUAL union all
13618: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13619: from DUAL union all
13620: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13621: from DUAL union all
13615: (
13616: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13617: from DUAL union all
13618: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13619: from DUAL union all
13620: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13621: from DUAL union all
13622: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13623: from DUAL union all
13617: from DUAL union all
13618: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13619: from DUAL union all
13620: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13621: from DUAL union all
13622: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13623: from DUAL union all
13624: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13625: from DUAL union all
13619: from DUAL union all
13620: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13621: from DUAL union all
13622: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13623: from DUAL union all
13624: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13625: from DUAL union all
13626: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13627: from DUAL union all
13621: from DUAL union all
13622: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13623: from DUAL union all
13624: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13625: from DUAL union all
13626: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13627: from DUAL union all
13628: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13629: from DUAL union all
13623: from DUAL union all
13624: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13625: from DUAL union all
13626: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13627: from DUAL union all
13628: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13629: from DUAL union all
13630: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13631: from DUAL
13625: from DUAL union all
13626: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13627: from DUAL union all
13628: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13629: from DUAL union all
13630: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13631: from DUAL
13632: ) fin_plan,
13633: (
13627: from DUAL union all
13628: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13629: from DUAL union all
13630: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13631: from DUAL
13632: ) fin_plan,
13633: (
13634: select 1 WBS_SUP_LEVEL,
13635: 1 WBS_SUB_LEVEL,
13633: (
13634: select 1 WBS_SUP_LEVEL,
13635: 1 WBS_SUB_LEVEL,
13636: 'PRJ' INVERT_ID
13637: from DUAL
13638: union all
13639: select 1 WBS_SUP_LEVEL,
13640: 1 WBS_SUB_LEVEL,
13641: 'WBS' INVERT_ID
13638: union all
13639: select 1 WBS_SUP_LEVEL,
13640: 1 WBS_SUB_LEVEL,
13641: 'WBS' INVERT_ID
13642: from DUAL
13643: ) top_slice
13644: where
13645: prg.STRUCT_TYPE = 'PRG' and
13646: prg.SUP_LEVEL = l_level and
13768: (
13769: select 'Y' CB_FLAG,
13770: 'N' CO_FLAG,
13771: -3 PLAN_VERSION_ID
13772: from DUAL union all
13773: select 'N' CB_FLAG,
13774: 'Y' CO_FLAG,
13775: -4 PLAN_VERSION_ID
13776: from DUAL union all
13772: from DUAL union all
13773: select 'N' CB_FLAG,
13774: 'Y' CO_FLAG,
13775: -4 PLAN_VERSION_ID
13776: from DUAL union all
13777: select 'Y' CB_FLAG,
13778: 'Y' CO_FLAG,
13779: -3 PLAN_VERSION_ID
13780: from DUAL union all
13776: from DUAL union all
13777: select 'Y' CB_FLAG,
13778: 'Y' CO_FLAG,
13779: -3 PLAN_VERSION_ID
13780: from DUAL union all
13781: select 'Y' CB_FLAG,
13782: 'Y' CO_FLAG,
13783: -4 PLAN_VERSION_ID
13784: from DUAL
13780: from DUAL union all
13781: select 'Y' CB_FLAG,
13782: 'Y' CO_FLAG,
13783: -4 PLAN_VERSION_ID
13784: from DUAL
13785: ) fin_plan
13786: where
13787: prg.STRUCT_TYPE = 'PRG' and
13788: prg.SUP_LEVEL = l_level and
13919: PJI_XBS_DENORM prg,
13920: PJI_FP_XBS_ACCUM_F fpr,
13921: (
13922: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13923: from DUAL union all
13924: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13925: from DUAL union all
13926: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13927: from DUAL union all
13921: (
13922: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13923: from DUAL union all
13924: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13925: from DUAL union all
13926: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13927: from DUAL union all
13928: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13929: from DUAL union all
13923: from DUAL union all
13924: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13925: from DUAL union all
13926: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13927: from DUAL union all
13928: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13929: from DUAL union all
13930: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13931: from DUAL union all
13925: from DUAL union all
13926: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13927: from DUAL union all
13928: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13929: from DUAL union all
13930: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13931: from DUAL union all
13932: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13933: from DUAL union all
13927: from DUAL union all
13928: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13929: from DUAL union all
13930: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13931: from DUAL union all
13932: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13933: from DUAL union all
13934: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13935: from DUAL union all
13929: from DUAL union all
13930: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13931: from DUAL union all
13932: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13933: from DUAL union all
13934: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13935: from DUAL union all
13936: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13937: from DUAL
13931: from DUAL union all
13932: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13933: from DUAL union all
13934: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13935: from DUAL union all
13936: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13937: from DUAL
13938: ) fin_plan,
13939: (
13933: from DUAL union all
13934: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13935: from DUAL union all
13936: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13937: from DUAL
13938: ) fin_plan,
13939: (
13940: select 1 WBS_SUP_LEVEL,
13941: 1 WBS_SUB_LEVEL,
13939: (
13940: select 1 WBS_SUP_LEVEL,
13941: 1 WBS_SUB_LEVEL,
13942: 'PRJ' INVERT_ID
13943: from DUAL
13944: union all
13945: select 1 WBS_SUP_LEVEL,
13946: 1 WBS_SUB_LEVEL,
13947: 'WBS' INVERT_ID
13944: union all
13945: select 1 WBS_SUP_LEVEL,
13946: 1 WBS_SUB_LEVEL,
13947: 'WBS' INVERT_ID
13948: from DUAL
13949: ) top_slice
13950: where
13951: prg.STRUCT_TYPE = 'PRG' and
13952: prg.SUP_LEVEL = l_level and
14005: from
14006: PJI_PJP_PROJ_BATCH_MAP map,
14007: PJI_XBS_DENORM prg,
14008: (
14009: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
14010: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
14011: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
14012: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
14013: ) invert,
14006: PJI_PJP_PROJ_BATCH_MAP map,
14007: PJI_XBS_DENORM prg,
14008: (
14009: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
14010: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
14011: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
14012: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
14013: ) invert,
14014: PJI_XBS_DENORM_DELTA prg_delta
14007: PJI_XBS_DENORM prg,
14008: (
14009: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
14010: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
14011: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
14012: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
14013: ) invert,
14014: PJI_XBS_DENORM_DELTA prg_delta
14015: where
14008: (
14009: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
14010: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
14011: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
14012: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
14013: ) invert,
14014: PJI_XBS_DENORM_DELTA prg_delta
14015: where
14016: prg.STRUCT_TYPE = 'PRG' and
15106: PA_XBS_DENORM wbs,
15107: PJI_XBS_DENORM prg,
15108: (
15109: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15110: from DUAL union all
15111: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15112: from DUAL union all
15113: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15114: from DUAL union all
15108: (
15109: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15110: from DUAL union all
15111: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15112: from DUAL union all
15113: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15114: from DUAL union all
15115: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15116: from DUAL union all
15110: from DUAL union all
15111: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15112: from DUAL union all
15113: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15114: from DUAL union all
15115: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15116: from DUAL union all
15117: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15118: from DUAL union all
15112: from DUAL union all
15113: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15114: from DUAL union all
15115: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15116: from DUAL union all
15117: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15118: from DUAL union all
15119: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15120: from DUAL union all
15114: from DUAL union all
15115: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15116: from DUAL union all
15117: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15118: from DUAL union all
15119: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15120: from DUAL union all
15121: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15122: from DUAL union all
15116: from DUAL union all
15117: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15118: from DUAL union all
15119: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15120: from DUAL union all
15121: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15122: from DUAL union all
15123: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15124: from DUAL
15118: from DUAL union all
15119: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15120: from DUAL union all
15121: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15122: from DUAL union all
15123: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15124: from DUAL
15125: ) fin_plan,
15126: (
15120: from DUAL union all
15121: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15122: from DUAL union all
15123: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15124: from DUAL
15125: ) fin_plan,
15126: (
15127: select 1 WBS_SUP_LEVEL,
15128: 1 WBS_SUB_LEVEL,
15126: (
15127: select 1 WBS_SUP_LEVEL,
15128: 1 WBS_SUB_LEVEL,
15129: 'PRJ' INVERT_ID
15130: from DUAL
15131: union all
15132: select 1 WBS_SUP_LEVEL,
15133: 1 WBS_SUB_LEVEL,
15134: 'WBS' INVERT_ID
15131: union all
15132: select 1 WBS_SUP_LEVEL,
15133: 1 WBS_SUB_LEVEL,
15134: 'WBS' INVERT_ID
15135: from DUAL
15136: ) top_slice
15137: where
15138: prg.STRUCT_TYPE = 'PRG' and
15139: prg.SUP_LEVEL = l_level and
15261: (
15262: select 'Y' CB_FLAG,
15263: 'N' CO_FLAG,
15264: -3 PLAN_VERSION_ID
15265: from DUAL union all
15266: select 'N' CB_FLAG,
15267: 'Y' CO_FLAG,
15268: -4 PLAN_VERSION_ID
15269: from DUAL union all
15265: from DUAL union all
15266: select 'N' CB_FLAG,
15267: 'Y' CO_FLAG,
15268: -4 PLAN_VERSION_ID
15269: from DUAL union all
15270: select 'Y' CB_FLAG,
15271: 'Y' CO_FLAG,
15272: -3 PLAN_VERSION_ID
15273: from DUAL union all
15269: from DUAL union all
15270: select 'Y' CB_FLAG,
15271: 'Y' CO_FLAG,
15272: -3 PLAN_VERSION_ID
15273: from DUAL union all
15274: select 'Y' CB_FLAG,
15275: 'Y' CO_FLAG,
15276: -4 PLAN_VERSION_ID
15277: from DUAL
15273: from DUAL union all
15274: select 'Y' CB_FLAG,
15275: 'Y' CO_FLAG,
15276: -4 PLAN_VERSION_ID
15277: from DUAL
15278: ) fin_plan
15279: where
15280: prg.STRUCT_TYPE = 'PRG' and
15281: prg.SUP_LEVEL = l_level and
15412: PJI_XBS_DENORM prg,
15413: PJI_FP_XBS_ACCUM_F fpr,
15414: (
15415: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15416: from DUAL union all
15417: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15418: from DUAL union all
15419: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15420: from DUAL union all
15414: (
15415: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15416: from DUAL union all
15417: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15418: from DUAL union all
15419: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15420: from DUAL union all
15421: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15422: from DUAL union all
15416: from DUAL union all
15417: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15418: from DUAL union all
15419: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15420: from DUAL union all
15421: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15422: from DUAL union all
15423: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15424: from DUAL union all
15418: from DUAL union all
15419: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15420: from DUAL union all
15421: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15422: from DUAL union all
15423: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15424: from DUAL union all
15425: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15426: from DUAL union all
15420: from DUAL union all
15421: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15422: from DUAL union all
15423: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15424: from DUAL union all
15425: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15426: from DUAL union all
15427: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15428: from DUAL union all
15422: from DUAL union all
15423: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15424: from DUAL union all
15425: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15426: from DUAL union all
15427: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15428: from DUAL union all
15429: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15430: from DUAL
15424: from DUAL union all
15425: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15426: from DUAL union all
15427: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15428: from DUAL union all
15429: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15430: from DUAL
15431: ) fin_plan,
15432: (
15426: from DUAL union all
15427: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15428: from DUAL union all
15429: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15430: from DUAL
15431: ) fin_plan,
15432: (
15433: select 1 WBS_SUP_LEVEL,
15434: 1 WBS_SUB_LEVEL,
15432: (
15433: select 1 WBS_SUP_LEVEL,
15434: 1 WBS_SUB_LEVEL,
15435: 'PRJ' INVERT_ID
15436: from DUAL
15437: union all
15438: select 1 WBS_SUP_LEVEL,
15439: 1 WBS_SUB_LEVEL,
15440: 'WBS' INVERT_ID
15437: union all
15438: select 1 WBS_SUP_LEVEL,
15439: 1 WBS_SUB_LEVEL,
15440: 'WBS' INVERT_ID
15441: from DUAL
15442: ) top_slice
15443: where
15444: prg.STRUCT_TYPE = 'PRG' and
15445: prg.SUP_LEVEL = l_level and
15498: from
15499: PJI_PJP_PROJ_BATCH_MAP map,
15500: PJI_XBS_DENORM prg,
15501: (
15502: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
15503: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
15504: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
15505: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
15506: ) invert,
15499: PJI_PJP_PROJ_BATCH_MAP map,
15500: PJI_XBS_DENORM prg,
15501: (
15502: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
15503: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
15504: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
15505: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
15506: ) invert,
15507: PJI_XBS_DENORM_DELTA prg_delta
15500: PJI_XBS_DENORM prg,
15501: (
15502: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
15503: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
15504: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
15505: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
15506: ) invert,
15507: PJI_XBS_DENORM_DELTA prg_delta
15508: where
15501: (
15502: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
15503: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
15504: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
15505: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
15506: ) invert,
15507: PJI_XBS_DENORM_DELTA prg_delta
15508: where
15509: prg.STRUCT_TYPE = 'PRG' and
16599: PA_XBS_DENORM wbs,
16600: PJI_XBS_DENORM prg,
16601: (
16602: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16603: from DUAL union all
16604: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16605: from DUAL union all
16606: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16607: from DUAL union all
16601: (
16602: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16603: from DUAL union all
16604: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16605: from DUAL union all
16606: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16607: from DUAL union all
16608: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16609: from DUAL union all
16603: from DUAL union all
16604: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16605: from DUAL union all
16606: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16607: from DUAL union all
16608: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16609: from DUAL union all
16610: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16611: from DUAL union all
16605: from DUAL union all
16606: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16607: from DUAL union all
16608: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16609: from DUAL union all
16610: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16611: from DUAL union all
16612: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16613: from DUAL union all
16607: from DUAL union all
16608: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16609: from DUAL union all
16610: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16611: from DUAL union all
16612: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16613: from DUAL union all
16614: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16615: from DUAL union all
16609: from DUAL union all
16610: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16611: from DUAL union all
16612: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16613: from DUAL union all
16614: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16615: from DUAL union all
16616: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16617: from DUAL
16611: from DUAL union all
16612: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16613: from DUAL union all
16614: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16615: from DUAL union all
16616: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16617: from DUAL
16618: ) fin_plan,
16619: (
16613: from DUAL union all
16614: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16615: from DUAL union all
16616: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16617: from DUAL
16618: ) fin_plan,
16619: (
16620: select 1 WBS_SUP_LEVEL,
16621: 1 WBS_SUB_LEVEL,
16619: (
16620: select 1 WBS_SUP_LEVEL,
16621: 1 WBS_SUB_LEVEL,
16622: 'PRJ' INVERT_ID
16623: from DUAL
16624: union all
16625: select 1 WBS_SUP_LEVEL,
16626: 1 WBS_SUB_LEVEL,
16627: 'WBS' INVERT_ID
16624: union all
16625: select 1 WBS_SUP_LEVEL,
16626: 1 WBS_SUB_LEVEL,
16627: 'WBS' INVERT_ID
16628: from DUAL
16629: ) top_slice
16630: where
16631: prg.STRUCT_TYPE = 'PRG' and
16632: prg.SUP_LEVEL = l_level and
16754: (
16755: select 'Y' CB_FLAG,
16756: 'N' CO_FLAG,
16757: -3 PLAN_VERSION_ID
16758: from DUAL union all
16759: select 'N' CB_FLAG,
16760: 'Y' CO_FLAG,
16761: -4 PLAN_VERSION_ID
16762: from DUAL union all
16758: from DUAL union all
16759: select 'N' CB_FLAG,
16760: 'Y' CO_FLAG,
16761: -4 PLAN_VERSION_ID
16762: from DUAL union all
16763: select 'Y' CB_FLAG,
16764: 'Y' CO_FLAG,
16765: -3 PLAN_VERSION_ID
16766: from DUAL union all
16762: from DUAL union all
16763: select 'Y' CB_FLAG,
16764: 'Y' CO_FLAG,
16765: -3 PLAN_VERSION_ID
16766: from DUAL union all
16767: select 'Y' CB_FLAG,
16768: 'Y' CO_FLAG,
16769: -4 PLAN_VERSION_ID
16770: from DUAL
16766: from DUAL union all
16767: select 'Y' CB_FLAG,
16768: 'Y' CO_FLAG,
16769: -4 PLAN_VERSION_ID
16770: from DUAL
16771: ) fin_plan
16772: where
16773: prg.STRUCT_TYPE = 'PRG' and
16774: prg.SUP_LEVEL = l_level and
16905: PJI_XBS_DENORM prg,
16906: PJI_FP_XBS_ACCUM_F fpr,
16907: (
16908: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16909: from DUAL union all
16910: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16911: from DUAL union all
16912: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16913: from DUAL union all
16907: (
16908: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16909: from DUAL union all
16910: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16911: from DUAL union all
16912: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16913: from DUAL union all
16914: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16915: from DUAL union all
16909: from DUAL union all
16910: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16911: from DUAL union all
16912: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16913: from DUAL union all
16914: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16915: from DUAL union all
16916: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16917: from DUAL union all
16911: from DUAL union all
16912: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16913: from DUAL union all
16914: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16915: from DUAL union all
16916: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16917: from DUAL union all
16918: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16919: from DUAL union all
16913: from DUAL union all
16914: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16915: from DUAL union all
16916: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16917: from DUAL union all
16918: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16919: from DUAL union all
16920: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16921: from DUAL union all
16915: from DUAL union all
16916: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16917: from DUAL union all
16918: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16919: from DUAL union all
16920: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16921: from DUAL union all
16922: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16923: from DUAL
16917: from DUAL union all
16918: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16919: from DUAL union all
16920: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16921: from DUAL union all
16922: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16923: from DUAL
16924: ) fin_plan,
16925: (
16919: from DUAL union all
16920: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16921: from DUAL union all
16922: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16923: from DUAL
16924: ) fin_plan,
16925: (
16926: select 1 WBS_SUP_LEVEL,
16927: 1 WBS_SUB_LEVEL,
16925: (
16926: select 1 WBS_SUP_LEVEL,
16927: 1 WBS_SUB_LEVEL,
16928: 'PRJ' INVERT_ID
16929: from DUAL
16930: union all
16931: select 1 WBS_SUP_LEVEL,
16932: 1 WBS_SUB_LEVEL,
16933: 'WBS' INVERT_ID
16930: union all
16931: select 1 WBS_SUP_LEVEL,
16932: 1 WBS_SUB_LEVEL,
16933: 'WBS' INVERT_ID
16934: from DUAL
16935: ) top_slice
16936: where
16937: prg.STRUCT_TYPE = 'PRG' and
16938: prg.SUP_LEVEL = l_level and
16991: from
16992: PJI_PJP_PROJ_BATCH_MAP map,
16993: PJI_XBS_DENORM prg,
16994: (
16995: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
16996: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
16997: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
16998: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
16999: ) invert,
16992: PJI_PJP_PROJ_BATCH_MAP map,
16993: PJI_XBS_DENORM prg,
16994: (
16995: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
16996: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
16997: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
16998: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
16999: ) invert,
17000: PJI_XBS_DENORM_DELTA prg_delta
16993: PJI_XBS_DENORM prg,
16994: (
16995: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
16996: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
16997: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
16998: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
16999: ) invert,
17000: PJI_XBS_DENORM_DELTA prg_delta
17001: where
16994: (
16995: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
16996: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
16997: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
16998: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
16999: ) invert,
17000: PJI_XBS_DENORM_DELTA prg_delta
17001: where
17002: prg.STRUCT_TYPE = 'PRG' and
18093: PA_XBS_DENORM wbs,
18094: PJI_XBS_DENORM prg,
18095: (
18096: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
18097: from DUAL union all
18098: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18099: from DUAL union all
18100: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
18101: from DUAL union all
18095: (
18096: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
18097: from DUAL union all
18098: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18099: from DUAL union all
18100: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
18101: from DUAL union all
18102: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18103: from DUAL union all
18097: from DUAL union all
18098: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18099: from DUAL union all
18100: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
18101: from DUAL union all
18102: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18103: from DUAL union all
18104: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
18105: from DUAL union all
18099: from DUAL union all
18100: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
18101: from DUAL union all
18102: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18103: from DUAL union all
18104: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
18105: from DUAL union all
18106: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18107: from DUAL union all
18101: from DUAL union all
18102: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18103: from DUAL union all
18104: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
18105: from DUAL union all
18106: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18107: from DUAL union all
18108: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
18109: from DUAL union all
18103: from DUAL union all
18104: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
18105: from DUAL union all
18106: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18107: from DUAL union all
18108: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
18109: from DUAL union all
18110: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18111: from DUAL
18105: from DUAL union all
18106: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18107: from DUAL union all
18108: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
18109: from DUAL union all
18110: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18111: from DUAL
18112: ) fin_plan,
18113: (
18107: from DUAL union all
18108: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
18109: from DUAL union all
18110: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18111: from DUAL
18112: ) fin_plan,
18113: (
18114: select 1 WBS_SUP_LEVEL,
18115: 1 WBS_SUB_LEVEL,
18113: (
18114: select 1 WBS_SUP_LEVEL,
18115: 1 WBS_SUB_LEVEL,
18116: 'PRJ' INVERT_ID
18117: from DUAL
18118: union all
18119: select 1 WBS_SUP_LEVEL,
18120: 1 WBS_SUB_LEVEL,
18121: 'WBS' INVERT_ID
18118: union all
18119: select 1 WBS_SUP_LEVEL,
18120: 1 WBS_SUB_LEVEL,
18121: 'WBS' INVERT_ID
18122: from DUAL
18123: ) top_slice
18124: where
18125: prg.STRUCT_TYPE = 'PRG' and
18126: prg.SUP_LEVEL = l_level and
18248: (
18249: select 'Y' CB_FLAG,
18250: 'N' CO_FLAG,
18251: -3 PLAN_VERSION_ID
18252: from DUAL union all
18253: select 'N' CB_FLAG,
18254: 'Y' CO_FLAG,
18255: -4 PLAN_VERSION_ID
18256: from DUAL union all
18252: from DUAL union all
18253: select 'N' CB_FLAG,
18254: 'Y' CO_FLAG,
18255: -4 PLAN_VERSION_ID
18256: from DUAL union all
18257: select 'Y' CB_FLAG,
18258: 'Y' CO_FLAG,
18259: -3 PLAN_VERSION_ID
18260: from DUAL union all
18256: from DUAL union all
18257: select 'Y' CB_FLAG,
18258: 'Y' CO_FLAG,
18259: -3 PLAN_VERSION_ID
18260: from DUAL union all
18261: select 'Y' CB_FLAG,
18262: 'Y' CO_FLAG,
18263: -4 PLAN_VERSION_ID
18264: from DUAL
18260: from DUAL union all
18261: select 'Y' CB_FLAG,
18262: 'Y' CO_FLAG,
18263: -4 PLAN_VERSION_ID
18264: from DUAL
18265: ) fin_plan
18266: where
18267: prg.STRUCT_TYPE = 'PRG' and
18268: prg.SUP_LEVEL = l_level and
18399: PJI_XBS_DENORM prg,
18400: PJI_FP_XBS_ACCUM_F fpr,
18401: (
18402: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
18403: from DUAL union all
18404: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18405: from DUAL union all
18406: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
18407: from DUAL union all
18401: (
18402: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
18403: from DUAL union all
18404: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18405: from DUAL union all
18406: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
18407: from DUAL union all
18408: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18409: from DUAL union all
18403: from DUAL union all
18404: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18405: from DUAL union all
18406: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
18407: from DUAL union all
18408: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18409: from DUAL union all
18410: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
18411: from DUAL union all
18405: from DUAL union all
18406: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
18407: from DUAL union all
18408: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18409: from DUAL union all
18410: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
18411: from DUAL union all
18412: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18413: from DUAL union all
18407: from DUAL union all
18408: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18409: from DUAL union all
18410: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
18411: from DUAL union all
18412: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18413: from DUAL union all
18414: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
18415: from DUAL union all
18409: from DUAL union all
18410: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
18411: from DUAL union all
18412: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18413: from DUAL union all
18414: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
18415: from DUAL union all
18416: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18417: from DUAL
18411: from DUAL union all
18412: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18413: from DUAL union all
18414: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
18415: from DUAL union all
18416: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18417: from DUAL
18418: ) fin_plan,
18419: (
18413: from DUAL union all
18414: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
18415: from DUAL union all
18416: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18417: from DUAL
18418: ) fin_plan,
18419: (
18420: select 1 WBS_SUP_LEVEL,
18421: 1 WBS_SUB_LEVEL,
18419: (
18420: select 1 WBS_SUP_LEVEL,
18421: 1 WBS_SUB_LEVEL,
18422: 'PRJ' INVERT_ID
18423: from DUAL
18424: union all
18425: select 1 WBS_SUP_LEVEL,
18426: 1 WBS_SUB_LEVEL,
18427: 'WBS' INVERT_ID
18424: union all
18425: select 1 WBS_SUP_LEVEL,
18426: 1 WBS_SUB_LEVEL,
18427: 'WBS' INVERT_ID
18428: from DUAL
18429: ) top_slice
18430: where
18431: prg.STRUCT_TYPE = 'PRG' and
18432: prg.SUP_LEVEL = l_level and
18485: from
18486: PJI_PJP_PROJ_BATCH_MAP map,
18487: PJI_XBS_DENORM prg,
18488: (
18489: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
18490: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
18491: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
18492: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
18493: ) invert,
18486: PJI_PJP_PROJ_BATCH_MAP map,
18487: PJI_XBS_DENORM prg,
18488: (
18489: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
18490: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
18491: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
18492: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
18493: ) invert,
18494: PJI_XBS_DENORM_DELTA prg_delta
18487: PJI_XBS_DENORM prg,
18488: (
18489: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
18490: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
18491: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
18492: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
18493: ) invert,
18494: PJI_XBS_DENORM_DELTA prg_delta
18495: where
18488: (
18489: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
18490: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
18491: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
18492: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
18493: ) invert,
18494: PJI_XBS_DENORM_DELTA prg_delta
18495: where
18496: prg.STRUCT_TYPE = 'PRG' and
19587: PA_XBS_DENORM wbs,
19588: PJI_XBS_DENORM prg,
19589: (
19590: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
19591: from DUAL union all
19592: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19593: from DUAL union all
19594: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19595: from DUAL union all
19589: (
19590: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
19591: from DUAL union all
19592: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19593: from DUAL union all
19594: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19595: from DUAL union all
19596: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19597: from DUAL union all
19591: from DUAL union all
19592: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19593: from DUAL union all
19594: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19595: from DUAL union all
19596: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19597: from DUAL union all
19598: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
19599: from DUAL union all
19593: from DUAL union all
19594: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19595: from DUAL union all
19596: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19597: from DUAL union all
19598: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
19599: from DUAL union all
19600: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19601: from DUAL union all
19595: from DUAL union all
19596: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19597: from DUAL union all
19598: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
19599: from DUAL union all
19600: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19601: from DUAL union all
19602: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19603: from DUAL union all
19597: from DUAL union all
19598: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
19599: from DUAL union all
19600: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19601: from DUAL union all
19602: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19603: from DUAL union all
19604: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19605: from DUAL
19599: from DUAL union all
19600: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19601: from DUAL union all
19602: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19603: from DUAL union all
19604: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19605: from DUAL
19606: ) fin_plan,
19607: (
19601: from DUAL union all
19602: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19603: from DUAL union all
19604: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19605: from DUAL
19606: ) fin_plan,
19607: (
19608: select 1 WBS_SUP_LEVEL,
19609: 1 WBS_SUB_LEVEL,
19607: (
19608: select 1 WBS_SUP_LEVEL,
19609: 1 WBS_SUB_LEVEL,
19610: 'PRJ' INVERT_ID
19611: from DUAL
19612: union all
19613: select 1 WBS_SUP_LEVEL,
19614: 1 WBS_SUB_LEVEL,
19615: 'WBS' INVERT_ID
19612: union all
19613: select 1 WBS_SUP_LEVEL,
19614: 1 WBS_SUB_LEVEL,
19615: 'WBS' INVERT_ID
19616: from DUAL
19617: ) top_slice
19618: where
19619: prg.STRUCT_TYPE = 'PRG' and
19620: prg.SUP_LEVEL = l_level and
19742: (
19743: select 'Y' CB_FLAG,
19744: 'N' CO_FLAG,
19745: -3 PLAN_VERSION_ID
19746: from DUAL union all
19747: select 'N' CB_FLAG,
19748: 'Y' CO_FLAG,
19749: -4 PLAN_VERSION_ID
19750: from DUAL union all
19746: from DUAL union all
19747: select 'N' CB_FLAG,
19748: 'Y' CO_FLAG,
19749: -4 PLAN_VERSION_ID
19750: from DUAL union all
19751: select 'Y' CB_FLAG,
19752: 'Y' CO_FLAG,
19753: -3 PLAN_VERSION_ID
19754: from DUAL union all
19750: from DUAL union all
19751: select 'Y' CB_FLAG,
19752: 'Y' CO_FLAG,
19753: -3 PLAN_VERSION_ID
19754: from DUAL union all
19755: select 'Y' CB_FLAG,
19756: 'Y' CO_FLAG,
19757: -4 PLAN_VERSION_ID
19758: from DUAL
19754: from DUAL union all
19755: select 'Y' CB_FLAG,
19756: 'Y' CO_FLAG,
19757: -4 PLAN_VERSION_ID
19758: from DUAL
19759: ) fin_plan
19760: where
19761: prg.STRUCT_TYPE = 'PRG' and
19762: prg.SUP_LEVEL = l_level and
19893: PJI_XBS_DENORM prg,
19894: PJI_FP_XBS_ACCUM_F fpr,
19895: (
19896: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
19897: from DUAL union all
19898: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19899: from DUAL union all
19900: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19901: from DUAL union all
19895: (
19896: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
19897: from DUAL union all
19898: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19899: from DUAL union all
19900: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19901: from DUAL union all
19902: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19903: from DUAL union all
19897: from DUAL union all
19898: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19899: from DUAL union all
19900: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19901: from DUAL union all
19902: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19903: from DUAL union all
19904: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
19905: from DUAL union all
19899: from DUAL union all
19900: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19901: from DUAL union all
19902: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19903: from DUAL union all
19904: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
19905: from DUAL union all
19906: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19907: from DUAL union all
19901: from DUAL union all
19902: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19903: from DUAL union all
19904: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
19905: from DUAL union all
19906: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19907: from DUAL union all
19908: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19909: from DUAL union all
19903: from DUAL union all
19904: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
19905: from DUAL union all
19906: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19907: from DUAL union all
19908: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19909: from DUAL union all
19910: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19911: from DUAL
19905: from DUAL union all
19906: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19907: from DUAL union all
19908: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19909: from DUAL union all
19910: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19911: from DUAL
19912: ) fin_plan,
19913: (
19907: from DUAL union all
19908: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19909: from DUAL union all
19910: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19911: from DUAL
19912: ) fin_plan,
19913: (
19914: select 1 WBS_SUP_LEVEL,
19915: 1 WBS_SUB_LEVEL,
19913: (
19914: select 1 WBS_SUP_LEVEL,
19915: 1 WBS_SUB_LEVEL,
19916: 'PRJ' INVERT_ID
19917: from DUAL
19918: union all
19919: select 1 WBS_SUP_LEVEL,
19920: 1 WBS_SUB_LEVEL,
19921: 'WBS' INVERT_ID
19918: union all
19919: select 1 WBS_SUP_LEVEL,
19920: 1 WBS_SUB_LEVEL,
19921: 'WBS' INVERT_ID
19922: from DUAL
19923: ) top_slice
19924: where
19925: prg.STRUCT_TYPE = 'PRG' and
19926: prg.SUP_LEVEL = l_level and
19979: from
19980: PJI_PJP_PROJ_BATCH_MAP map,
19981: PJI_XBS_DENORM prg,
19982: (
19983: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
19984: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
19985: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
19986: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
19987: ) invert,
19980: PJI_PJP_PROJ_BATCH_MAP map,
19981: PJI_XBS_DENORM prg,
19982: (
19983: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
19984: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
19985: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
19986: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
19987: ) invert,
19988: PJI_XBS_DENORM_DELTA prg_delta
19981: PJI_XBS_DENORM prg,
19982: (
19983: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
19984: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
19985: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
19986: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
19987: ) invert,
19988: PJI_XBS_DENORM_DELTA prg_delta
19989: where
19982: (
19983: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
19984: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
19985: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
19986: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
19987: ) invert,
19988: PJI_XBS_DENORM_DELTA prg_delta
19989: where
19990: prg.STRUCT_TYPE = 'PRG' and
21081: PA_XBS_DENORM wbs,
21082: PJI_XBS_DENORM prg,
21083: (
21084: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
21085: from DUAL union all
21086: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21087: from DUAL union all
21088: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
21089: from DUAL union all
21083: (
21084: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
21085: from DUAL union all
21086: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21087: from DUAL union all
21088: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
21089: from DUAL union all
21090: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21091: from DUAL union all
21085: from DUAL union all
21086: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21087: from DUAL union all
21088: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
21089: from DUAL union all
21090: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21091: from DUAL union all
21092: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
21093: from DUAL union all
21087: from DUAL union all
21088: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
21089: from DUAL union all
21090: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21091: from DUAL union all
21092: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
21093: from DUAL union all
21094: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21095: from DUAL union all
21089: from DUAL union all
21090: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21091: from DUAL union all
21092: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
21093: from DUAL union all
21094: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21095: from DUAL union all
21096: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
21097: from DUAL union all
21091: from DUAL union all
21092: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
21093: from DUAL union all
21094: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21095: from DUAL union all
21096: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
21097: from DUAL union all
21098: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21099: from DUAL
21093: from DUAL union all
21094: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21095: from DUAL union all
21096: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
21097: from DUAL union all
21098: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21099: from DUAL
21100: ) fin_plan,
21101: (
21095: from DUAL union all
21096: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
21097: from DUAL union all
21098: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21099: from DUAL
21100: ) fin_plan,
21101: (
21102: select 1 WBS_SUP_LEVEL,
21103: 1 WBS_SUB_LEVEL,
21101: (
21102: select 1 WBS_SUP_LEVEL,
21103: 1 WBS_SUB_LEVEL,
21104: 'PRJ' INVERT_ID
21105: from DUAL
21106: union all
21107: select 1 WBS_SUP_LEVEL,
21108: 1 WBS_SUB_LEVEL,
21109: 'WBS' INVERT_ID
21106: union all
21107: select 1 WBS_SUP_LEVEL,
21108: 1 WBS_SUB_LEVEL,
21109: 'WBS' INVERT_ID
21110: from DUAL
21111: ) top_slice
21112: where
21113: prg.STRUCT_TYPE = 'PRG' and
21114: prg.SUP_LEVEL = l_level and
21236: (
21237: select 'Y' CB_FLAG,
21238: 'N' CO_FLAG,
21239: -3 PLAN_VERSION_ID
21240: from DUAL union all
21241: select 'N' CB_FLAG,
21242: 'Y' CO_FLAG,
21243: -4 PLAN_VERSION_ID
21244: from DUAL union all
21240: from DUAL union all
21241: select 'N' CB_FLAG,
21242: 'Y' CO_FLAG,
21243: -4 PLAN_VERSION_ID
21244: from DUAL union all
21245: select 'Y' CB_FLAG,
21246: 'Y' CO_FLAG,
21247: -3 PLAN_VERSION_ID
21248: from DUAL union all
21244: from DUAL union all
21245: select 'Y' CB_FLAG,
21246: 'Y' CO_FLAG,
21247: -3 PLAN_VERSION_ID
21248: from DUAL union all
21249: select 'Y' CB_FLAG,
21250: 'Y' CO_FLAG,
21251: -4 PLAN_VERSION_ID
21252: from DUAL
21248: from DUAL union all
21249: select 'Y' CB_FLAG,
21250: 'Y' CO_FLAG,
21251: -4 PLAN_VERSION_ID
21252: from DUAL
21253: ) fin_plan
21254: where
21255: prg.STRUCT_TYPE = 'PRG' and
21256: prg.SUP_LEVEL = l_level and
21387: PJI_XBS_DENORM prg,
21388: PJI_FP_XBS_ACCUM_F fpr,
21389: (
21390: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
21391: from DUAL union all
21392: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21393: from DUAL union all
21394: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
21395: from DUAL union all
21389: (
21390: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
21391: from DUAL union all
21392: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21393: from DUAL union all
21394: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
21395: from DUAL union all
21396: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21397: from DUAL union all
21391: from DUAL union all
21392: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21393: from DUAL union all
21394: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
21395: from DUAL union all
21396: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21397: from DUAL union all
21398: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
21399: from DUAL union all
21393: from DUAL union all
21394: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
21395: from DUAL union all
21396: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21397: from DUAL union all
21398: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
21399: from DUAL union all
21400: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21401: from DUAL union all
21395: from DUAL union all
21396: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21397: from DUAL union all
21398: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
21399: from DUAL union all
21400: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21401: from DUAL union all
21402: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
21403: from DUAL union all
21397: from DUAL union all
21398: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
21399: from DUAL union all
21400: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21401: from DUAL union all
21402: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
21403: from DUAL union all
21404: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21405: from DUAL
21399: from DUAL union all
21400: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21401: from DUAL union all
21402: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
21403: from DUAL union all
21404: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21405: from DUAL
21406: ) fin_plan,
21407: (
21401: from DUAL union all
21402: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
21403: from DUAL union all
21404: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21405: from DUAL
21406: ) fin_plan,
21407: (
21408: select 1 WBS_SUP_LEVEL,
21409: 1 WBS_SUB_LEVEL,
21407: (
21408: select 1 WBS_SUP_LEVEL,
21409: 1 WBS_SUB_LEVEL,
21410: 'PRJ' INVERT_ID
21411: from DUAL
21412: union all
21413: select 1 WBS_SUP_LEVEL,
21414: 1 WBS_SUB_LEVEL,
21415: 'WBS' INVERT_ID
21412: union all
21413: select 1 WBS_SUP_LEVEL,
21414: 1 WBS_SUB_LEVEL,
21415: 'WBS' INVERT_ID
21416: from DUAL
21417: ) top_slice
21418: where
21419: prg.STRUCT_TYPE = 'PRG' and
21420: prg.SUP_LEVEL = l_level and
21473: from
21474: PJI_PJP_PROJ_BATCH_MAP map,
21475: PJI_XBS_DENORM prg,
21476: (
21477: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
21478: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
21479: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
21480: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
21481: ) invert,
21474: PJI_PJP_PROJ_BATCH_MAP map,
21475: PJI_XBS_DENORM prg,
21476: (
21477: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
21478: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
21479: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
21480: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
21481: ) invert,
21482: PJI_XBS_DENORM_DELTA prg_delta
21475: PJI_XBS_DENORM prg,
21476: (
21477: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
21478: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
21479: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
21480: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
21481: ) invert,
21482: PJI_XBS_DENORM_DELTA prg_delta
21483: where
21476: (
21477: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
21478: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
21479: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
21480: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
21481: ) invert,
21482: PJI_XBS_DENORM_DELTA prg_delta
21483: where
21484: prg.STRUCT_TYPE = 'PRG' and