PJO_RES_PERIOD_ACCUM_V

Details

• Schema: FUSION

• Object owner: PJO

• Object type: VIEW

Columns

Name

PROJECT_ID PROJECT_ORG_ID PROJECT_ORGANIZATION_ID PROJECT_UNIT_ID PROJECT_ELEMENT_ID PERIOD_NAME PERIOD_TYPE_ID CALENDAR_TYPE RBS_VERSION_ID RBS_ELEMENT_ID PLAN_VERSION_ID CURRENCY_CODE START_DATE END_DATE PFC_ACT_RAW_COST PC_ACT_RAW_COST TC_ACT_RAW_COST PFC_ACT_BRDN_COST PC_ACT_BRDN_COST TC_ACT_BRDN_COST ACT_QUANTITY ACT_LABOR_HRS ACT_EQUIP_HRS PFC_ETC_RAW_COST PC_ETC_RAW_COST TC_ETC_RAW_COST PFC_ETC_BRDN_COST PC_ETC_BRDN_COST TC_ETC_BRDN_COST ETC_QUANTITY ETC_LABOR_HRS ETC_EQUIP_HRS BSLN_PFC_RAW_COST BSLN_PC_RAW_COST BSLN_TC_RAW_COST BSLN_PFC_BRDN_COST BSLN_PC_BRDN_COST BSLN_TC_BRDN_COST BSLN_QUANTITY BSLN_LABOR_HRS BSLN_EQUIP_HRS

Query

SQL_Statement

SELECT PROJECT_ID , PROJECT_ORG_ID , PROJECT_ORGANIZATION_ID , PROJECT_UNIT_ID , PROJECT_ELEMENT_ID , PERIOD_NAME, PERIOD_TYPE_ID, CALENDAR_TYPE, RBS_VERSION_ID , RBS_ELEMENT_ID , MAX(DECODE(PLAN_TYPE_CODE,'PP',PLAN_VERSION_ID,NULL)) PLAN_VERSION_ID, CURRENCY_CODE, MIN(START_DATE) START_DATE, MAX(END_DATE) END_DATE, SUM(DECODE(PLAN_TYPE_CODE,'PP',PFC_ACT_RAW_COST,NULL)) PFC_ACT_RAW_COST, SUM(DECODE(PLAN_TYPE_CODE,'PP',PC_ACT_RAW_COST,NULL)) PC_ACT_RAW_COST, SUM(DECODE(PLAN_TYPE_CODE,'PP',TC_ACT_RAW_COST,NULL)) TC_ACT_RAW_COST, SUM(DECODE(PLAN_TYPE_CODE,'PP',PFC_ACT_BRDN_COST,NULL)) PFC_ACT_BRDN_COST, SUM(DECODE(PLAN_TYPE_CODE,'PP',PC_ACT_BRDN_COST,NULL)) PC_ACT_BRDN_COST, SUM(DECODE(PLAN_TYPE_CODE,'PP',TC_ACT_BRDN_COST,NULL)) TC_ACT_BRDN_COST, SUM(DECODE(PLAN_TYPE_CODE,'PP',ACT_QUANTITY,NULL)) ACT_QUANTITY, SUM(DECODE(PLAN_TYPE_CODE,'PP',ACT_LABOR_HRS,NULL)) ACT_LABOR_HRS, SUM(DECODE(PLAN_TYPE_CODE,'PP',ACT_EQUIP_HRS,NULL)) ACT_EQUIP_HRS, SUM(DECODE(PLAN_TYPE_CODE,'PP',PFC_ETC_RAW_COST,NULL)) PFC_ETC_RAW_COST, SUM(DECODE(PLAN_TYPE_CODE,'PP',PC_ETC_RAW_COST,NULL)) PC_ETC_RAW_COST, SUM(DECODE(PLAN_TYPE_CODE,'PP',TC_ETC_RAW_COST,NULL)) TC_ETC_RAW_COST, SUM(DECODE(PLAN_TYPE_CODE,'PP',PFC_ETC_BRDN_COST,NULL)) PFC_ETC_BRDN_COST, SUM(DECODE(PLAN_TYPE_CODE,'PP',PC_ETC_BRDN_COST,NULL)) PC_ETC_BRDN_COST, SUM(DECODE(PLAN_TYPE_CODE,'PP',TC_ETC_BRDN_COST,NULL)) TC_ETC_BRDN_COST, SUM(DECODE(PLAN_TYPE_CODE,'PP',ETC_QUANTITY,NULL)) ETC_QUANTITY, SUM(DECODE(PLAN_TYPE_CODE,'PP',ETC_LABOR_HRS,NULL)) ETC_LABOR_HRS, SUM(DECODE(PLAN_TYPE_CODE,'PP',ETC_EQUIP_HRS,NULL)) ETC_EQUIP_HRS, SUM(DECODE(PLAN_TYPE_CODE,'PB',PFC_RAW_COST,NULL)) BSLN_PFC_RAW_COST, SUM(DECODE(PLAN_TYPE_CODE,'PB',PC_RAW_COST,NULL)) BSLN_PC_RAW_COST, SUM(DECODE(PLAN_TYPE_CODE,'PB',TC_RAW_COST,NULL)) BSLN_TC_RAW_COST, SUM(DECODE(PLAN_TYPE_CODE,'PB',PFC_BRDN_COST,NULL)) BSLN_PFC_BRDN_COST, SUM(DECODE(PLAN_TYPE_CODE,'PB',PC_BRDN_COST,NULL)) BSLN_PC_BRDN_COST, SUM(DECODE(PLAN_TYPE_CODE,'PB',TC_BRDN_COST,NULL)) BSLN_TC_BRDN_COST, SUM(DECODE(PLAN_TYPE_CODE,'PB',QUANTITY,NULL)) BSLN_QUANTITY, SUM(DECODE(PLAN_TYPE_CODE,'PB',LABOR_HRS,NULL)) BSLN_LABOR_HRS, SUM(DECODE(PLAN_TYPE_CODE,'PB',EQUIP_HRS,NULL)) BSLN_EQUIP_HRS FROM PJO_XBS_ACCUM_F FACT WHERE (FACT.PLAN_TYPE_CODE = 'PP' OR FACT.PLAN_TYPE_CODE = 'PB') AND RBS_AGGR_LEVEL = 'L' AND WBS_ROLLUP_FLAG = 'N' GROUP BY PROJECT_ID , PROJECT_ORG_ID , PROJECT_ORGANIZATION_ID , PROJECT_UNIT_ID , PROJECT_ELEMENT_ID , PERIOD_NAME, PERIOD_TYPE_ID, CALENDAR_TYPE, RBS_VERSION_ID , RBS_ELEMENT_ID , CURRENCY_CODE