[Home] [Help]
MATERIALIZED VIEW: APPS.PJI_RM_ORGO_F_MV
Source
select /* 12.0: bug#4526784 */
count(*) CNT,
sum (rmo.CAPACITY_HRS) CAPACITY_HRS,
count(rmo.CAPACITY_HRS) CAPACITY_HRS_CNT,
sum (rmo.TOTAL_HRS_A) TOTAL_HRS_A,
count(rmo.TOTAL_HRS_A) TOTAL_HRS_A_CNT,
sum (rmo.TOTAL_WTD_ORG_HRS_A) TOTAL_WTD_ORG_HRS_A,
count(rmo.TOTAL_WTD_ORG_HRS_A) TOTAL_WTD_ORG_HRS_A_CNT,
sum (rmo.TOTAL_WTD_RES_HRS_A) TOTAL_WTD_RES_HRS_A,
count(rmo.TOTAL_WTD_RES_HRS_A) TOTAL_WTD_RES_HRS_A_CNT,
sum (rmo.BILL_HRS_A) BILL_HRS_A,
count(rmo.BILL_HRS_A) BILL_HRS_A_CNT,
sum (rmo.BILL_WTD_ORG_HRS_A) BILL_WTD_ORG_HRS_A,
count(rmo.BILL_WTD_ORG_HRS_A) BILL_WTD_ORG_HRS_A_CNT,
sum (rmo.BILL_WTD_RES_HRS_A) BILL_WTD_RES_HRS_A,
count(rmo.BILL_WTD_RES_HRS_A) BILL_WTD_RES_HRS_A_CNT,
sum (rmo.TRAINING_HRS_A) TRAINING_HRS_A,
count(rmo.TRAINING_HRS_A) TRAINING_HRS_A_CNT,
sum (rmo.UNASSIGNED_HRS_A) UNASSIGNED_HRS_A,
count(rmo.UNASSIGNED_HRS_A) UNASSIGNED_HRS_A_CNT,
sum (rmo.REDUCE_CAPACITY_HRS_A) REDUCE_CAPACITY_HRS_A,
count(rmo.REDUCE_CAPACITY_HRS_A) REDUCE_CAPACITY_HRS_A_CNT,
sum (rmo.CONF_HRS_S) CONF_HRS_S,
count(rmo.CONF_HRS_S) CONF_HRS_S_CNT,
sum (rmo.CONF_WTD_ORG_HRS_S) CONF_WTD_ORG_HRS_S,
count(rmo.CONF_WTD_ORG_HRS_S) CONF_WTD_ORG_HRS_S_CNT,
sum (rmo.CONF_WTD_RES_HRS_S) CONF_WTD_RES_HRS_S,
count(rmo.CONF_WTD_RES_HRS_S) CONF_WTD_RES_HRS_S_CNT,
sum (rmo.CONF_BILL_HRS_S) CONF_BILL_HRS_S,
count(rmo.CONF_BILL_HRS_S) CONF_BILL_HRS_S_CNT,
sum (rmo.CONF_BILL_WTD_ORG_HRS_S) CONF_BILL_WTD_ORG_HRS_S,
count(rmo.CONF_BILL_WTD_ORG_HRS_S) CONF_BILL_WTD_ORG_HRS_S_CNT,
sum (rmo.CONF_BILL_WTD_RES_HRS_S) CONF_BILL_WTD_RES_HRS_S,
count(rmo.CONF_BILL_WTD_RES_HRS_S) CONF_BILL_WTD_RES_HRS_S_CNT,
sum (rmo.PROV_HRS_S) PROV_HRS_S,
count(rmo.PROV_HRS_S) PROV_HRS_S_CNT,
sum (rmo.PROV_WTD_ORG_HRS_S) PROV_WTD_ORG_HRS_S,
count(rmo.PROV_WTD_ORG_HRS_S) PROV_WTD_ORG_HRS_S_CNT,
sum (rmo.PROV_WTD_RES_HRS_S) PROV_WTD_RES_HRS_S,
count(rmo.PROV_WTD_RES_HRS_S) PROV_WTD_RES_HRS_S_CNT,
sum (rmo.PROV_BILL_HRS_S) PROV_BILL_HRS_S,
count(rmo.PROV_BILL_HRS_S) PROV_BILL_HRS_S_CNT,
sum (rmo.PROV_BILL_WTD_ORG_HRS_S) PROV_BILL_WTD_ORG_HRS_S,
count(rmo.PROV_BILL_WTD_ORG_HRS_S) PROV_BILL_WTD_ORG_HRS_S_CNT,
sum (rmo.PROV_BILL_WTD_RES_HRS_S) PROV_BILL_WTD_RES_HRS_S,
count(rmo.PROV_BILL_WTD_RES_HRS_S) PROV_BILL_WTD_RES_HRS_S_CNT,
sum (rmo.TRAINING_HRS_S) TRAINING_HRS_S,
count(rmo.TRAINING_HRS_S) TRAINING_HRS_S_CNT,
sum (rmo.UNASSIGNED_HRS_S) UNASSIGNED_HRS_S,
count(rmo.UNASSIGNED_HRS_S) UNASSIGNED_HRS_S_CNT,
sum (rmo.REDUCE_CAPACITY_HRS_S) REDUCE_CAPACITY_HRS_S,
count(rmo.REDUCE_CAPACITY_HRS_S) REDUCE_CAPACITY_HRS_S_CNT,
sum (rmo.CONF_OVERCOM_HRS_S) CONF_OVERCOM_HRS_S,
count(rmo.CONF_OVERCOM_HRS_S) CONF_OVERCOM_HRS_S_CNT,
sum (rmo.PROV_OVERCOM_HRS_S) PROV_OVERCOM_HRS_S,
count(rmo.PROV_OVERCOM_HRS_S) PROV_OVERCOM_HRS_S_CNT,
sum (rmo.AVAILABLE_HRS_BKT1_S) AVAILABLE_HRS_BKT1_S,
count(rmo.AVAILABLE_HRS_BKT1_S) AVAILABLE_HRS_BKT1_S_CNT,
sum (rmo.AVAILABLE_HRS_BKT2_S) AVAILABLE_HRS_BKT2_S,
count(rmo.AVAILABLE_HRS_BKT2_S) AVAILABLE_HRS_BKT2_S_CNT,
sum (rmo.AVAILABLE_HRS_BKT3_S) AVAILABLE_HRS_BKT3_S,
count(rmo.AVAILABLE_HRS_BKT3_S) AVAILABLE_HRS_BKT3_S_CNT,
sum (rmo.AVAILABLE_HRS_BKT4_S) AVAILABLE_HRS_BKT4_S,
count(rmo.AVAILABLE_HRS_BKT4_S) AVAILABLE_HRS_BKT4_S_CNT,
sum (rmo.AVAILABLE_HRS_BKT5_S) AVAILABLE_HRS_BKT5_S,
count(rmo.AVAILABLE_HRS_BKT5_S) AVAILABLE_HRS_BKT5_S_CNT,
sum (rmo.AVAILABLE_RES_COUNT_BKT1_S) AVAILABLE_RES_COUNT_BKT1_S,
count(rmo.AVAILABLE_RES_COUNT_BKT1_S) AVAILABLE_RES_COUNT_BKT1_S_CNT,
sum (rmo.AVAILABLE_RES_COUNT_BKT2_S) AVAILABLE_RES_COUNT_BKT2_S,
count(rmo.AVAILABLE_RES_COUNT_BKT2_S) AVAILABLE_RES_COUNT_BKT2_S_CNT,
sum (rmo.AVAILABLE_RES_COUNT_BKT3_S) AVAILABLE_RES_COUNT_BKT3_S,
count(rmo.AVAILABLE_RES_COUNT_BKT3_S) AVAILABLE_RES_COUNT_BKT3_S_CNT,
sum (rmo.AVAILABLE_RES_COUNT_BKT4_S) AVAILABLE_RES_COUNT_BKT4_S,
count(rmo.AVAILABLE_RES_COUNT_BKT4_S) AVAILABLE_RES_COUNT_BKT4_S_CNT,
sum (rmo.AVAILABLE_RES_COUNT_BKT5_S) AVAILABLE_RES_COUNT_BKT5_S,
count(rmo.AVAILABLE_RES_COUNT_BKT5_S) AVAILABLE_RES_COUNT_BKT5_S_CNT,
sum (rmo.TOTAL_RES_COUNT) TOTAL_RES_COUNT,
count(rmo.TOTAL_RES_COUNT) TOTAL_RES_COUNT_CNT,
sum (rmo.MISSING_HRS_A) MISSING_HRS_A,
count(rmo.MISSING_HRS_A) MISSING_HRS_A_CNT,
rmo.TIME_ID,
den.ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID,
rmo.CALENDAR_TYPE,
rmo.PERIOD_TYPE_ID,
rmo.EXPENDITURE_ORG_ID
from
PJI_RM_ORG_F_MV rmo,
PJI.PJI_ORG_DENORM den
where
rmo.EXPENDITURE_ORGANIZATION_ID = den.SUB_ORGANIZATION_ID
group by
rmo.TIME_ID,
den.ORGANIZATION_ID,
rmo.CALENDAR_TYPE,
rmo.PERIOD_TYPE_ID,
rmo.EXPENDITURE_ORG_ID