MATERIALIZED VIEW: APPS.PJI_RM_WTO_F_MV

Source

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