MATERIALIZED VIEW: APPS.PJI_FP_ORGO_ET_F_MV

Source

select /* 12.0: bug#4526784 */
    feo.TIME_ID,
    den.ORGANIZATION_ID                 ORGANIZATION_ID,
    feo.CALENDAR_TYPE,
    feo.PERIOD_TYPE_ID,
    feo.CURR_RECORD_TYPE_ID,
    feo.CURRENCY_CODE,
    feo.ORG_ID,
    feo.EXP_EVT_TYPE_ID,
    count(*)                            CNT,
    sum  (feo.REVENUE)                  REVENUE,
    count(feo.REVENUE)                  REVENUE_CNT,
    sum  (feo.LABOR_REVENUE)            LABOR_REVENUE,
    count(feo.LABOR_REVENUE)            LABOR_REVENUE_CNT,
    sum  (feo.RAW_COST)                 RAW_COST,
    count(feo.RAW_COST)                 RAW_COST_CNT,
    sum  (feo.BURDENED_COST)            BURDENED_COST,
    count(feo.BURDENED_COST)            BURDENED_COST_CNT,
    sum  (feo.BILL_RAW_COST)            BILL_RAW_COST,
    count(feo.BILL_RAW_COST)            BILL_RAW_COST_CNT,
    sum  (feo.BILL_BURDENED_COST)       BILL_BURDENED_COST,
    count(feo.BILL_BURDENED_COST)       BILL_BURDENED_COST_CNT,
    sum  (feo.LABOR_RAW_COST)           LABOR_RAW_COST,
    count(feo.LABOR_RAW_COST)           LABOR_RAW_COST_CNT,
    sum  (feo.LABOR_BURDENED_COST)      LABOR_BURDENED_COST,
    count(feo.LABOR_BURDENED_COST)      LABOR_BURDENED_COST_CNT,
    sum  (feo.BILL_LABOR_RAW_COST)      BILL_LABOR_RAW_COST,
    count(feo.BILL_LABOR_RAW_COST)      BILL_LABOR_RAW_COST_CNT,
    sum  (feo.BILL_LABOR_BURDENED_COST) BILL_LABOR_BURDENED_COST,
    count(feo.BILL_LABOR_BURDENED_COST) BILL_LABOR_BURDENED_COST_CNT,
    sum  (feo.CAPITAL_RAW_COST)         CAPITAL_RAW_COST,
    count(feo.CAPITAL_RAW_COST)         CAPITAL_RAW_COST_CNT,
    sum  (feo.CAPITAL_BRDN_COST)        CAPITAL_BRDN_COST,
    count(feo.CAPITAL_BRDN_COST)        CAPITAL_BRDN_COST_CNT,
    sum  (feo.CONTRACT_RAW_COST)        CONTRACT_RAW_COST,
    count(feo.CONTRACT_RAW_COST)        CONTRACT_RAW_COST_CNT,
    sum  (feo.CONTRACT_BRDN_COST)       CONTRACT_BRDN_COST,
    count(feo.CONTRACT_BRDN_COST)       CONTRACT_BRDN_COST_CNT,
    sum  (feo.CAPITALIZABLE_RAW_COST)   CAPITALIZABLE_RAW_COST,
    count(feo.CAPITALIZABLE_RAW_COST)   CAPITALIZABLE_RAW_COST_CNT,
    sum  (feo.CAPITALIZABLE_BRDN_COST)  CAPITALIZABLE_BRDN_COST,
    count(feo.CAPITALIZABLE_BRDN_COST)  CAPITALIZABLE_BRDN_COST_CNT,
    sum  (feo.PROJECT_COUNT)            PROJECT_COUNT,
    count(feo.PROJECT_COUNT)            PROJECT_COUNT_CNT,
    sum  (feo.LABOR_HRS)                LABOR_HRS,
    count(feo.LABOR_HRS)                LABOR_HRS_CNT,
    sum  (feo.BILL_LABOR_HRS)           BILL_LABOR_HRS,
    count(feo.BILL_LABOR_HRS)           BILL_LABOR_HRS_CNT,
    sum  (feo.QUANTITY)                 QUANTITY,
    count(feo.QUANTITY)                 QUANTITY_CNT,
    sum  (feo.BILL_QUANTITY)            BILL_QUANTITY,
    count(feo.BILL_QUANTITY)            BILL_QUANTITY_CNT
  from
    PJI_FP_ORG_ET_F_MV feo,
    PJI.PJI_ORG_DENORM den
  where
    feo.ORGANIZATION_ID = den.SUB_ORGANIZATION_ID
  group by
    feo.TIME_ID,
    den.ORGANIZATION_ID,
    feo.CALENDAR_TYPE,
    feo.PERIOD_TYPE_ID,
    feo.CURR_RECORD_TYPE_ID,
    feo.CURRENCY_CODE,
    feo.ORG_ID,
    feo.EXP_EVT_TYPE_ID