MATERIALIZED VIEW: APPS.PJI_RM_WT_F_MV

Source

select /* 12.0: bug#4526784 */
    count(*)                   CNT,
    sum  (CAPACITY_HRS)        CAPACITY_HRS,
    count(CAPACITY_HRS)        CAPACITY_HRS_CNT,
    sum  (TOTAL_HRS_A)         TOTAL_HRS_A,
    count(TOTAL_HRS_A)         TOTAL_HRS_A_CNT,
    sum  (BILL_HRS_A)          BILL_HRS_A,
    count(BILL_HRS_A)          BILL_HRS_A_CNT,
    sum  (CONF_HRS_S)          CONF_HRS_S,
    count(CONF_HRS_S)          CONF_HRS_S_CNT,
    sum  (PROV_HRS_S)          PROV_HRS_S,
    count(PROV_HRS_S)          PROV_HRS_S_CNT,
    sum  (UNASSIGNED_HRS_S)    UNASSIGNED_HRS_S,
    count(UNASSIGNED_HRS_S)    UNASSIGNED_HRS_S_CNT,
    sum  (CONF_OVERCOM_HRS_S)  CONF_OVERCOM_HRS_S,
    count(CONF_OVERCOM_HRS_S)  CONF_OVERCOM_HRS_S_CNT,
    sum  (PROV_OVERCOM_HRS_S)  PROV_OVERCOM_HRS_S,
    count(PROV_OVERCOM_HRS_S)  PROV_OVERCOM_HRS_S_CNT,
    TIME_ID,
    EXPENDITURE_ORGANIZATION_ID,
    CALENDAR_TYPE,
    PERIOD_TYPE_ID,
    WORK_TYPE_ID,
    EXPENDITURE_ORG_ID
  from
    PJI.PJI_RM_RES_WT_F
  group by
    TIME_ID,
    EXPENDITURE_ORGANIZATION_ID,
    CALENDAR_TYPE,
    PERIOD_TYPE_ID,
    WORK_TYPE_ID,
    EXPENDITURE_ORG_ID