MATERIALIZED VIEW: APPS.PJI_FP_ORGO_F_MV

Source

select /* 12.0: bug#4526784 */
    fpo.TIME_ID,
    den.ORGANIZATION_ID                   ORGANIZATION_ID,
    fpo.CALENDAR_TYPE,
    fpo.PERIOD_TYPE_ID,
    fpo.CURR_RECORD_TYPE_ID,
    fpo.CURRENCY_CODE,
    fpo.ORG_ID,
    count(*)                            CNT,
    sum  (fpo.REVENUE)                  REVENUE,
    count(fpo.REVENUE)                  REVENUE_CNT,
    sum  (fpo.LABOR_REVENUE)            LABOR_REVENUE,
    count(fpo.LABOR_REVENUE)            LABOR_REVENUE_CNT,
    sum  (fpo.RAW_COST)                 RAW_COST,
    count(fpo.RAW_COST)                 RAW_COST_CNT,
    sum  (fpo.BURDENED_COST)            BURDENED_COST,
    count(fpo.BURDENED_COST)            BURDENED_COST_CNT,
    sum  (fpo.BILL_RAW_COST)            BILL_RAW_COST,
    count(fpo.BILL_RAW_COST)            BILL_RAW_COST_CNT,
    sum  (fpo.BILL_BURDENED_COST)       BILL_BURDENED_COST,
    count(fpo.BILL_BURDENED_COST)       BILL_BURDENED_COST_CNT,
    sum  (fpo.LABOR_RAW_COST)           LABOR_RAW_COST,
    count(fpo.LABOR_RAW_COST)           LABOR_RAW_COST_CNT,
    sum  (fpo.LABOR_BURDENED_COST)      LABOR_BURDENED_COST,
    count(fpo.LABOR_BURDENED_COST)      LABOR_BURDENED_COST_CNT,
    sum  (fpo.BILL_LABOR_RAW_COST)      BILL_LABOR_RAW_COST,
    count(fpo.BILL_LABOR_RAW_COST)      BILL_LABOR_RAW_COST_CNT,
    sum  (fpo.BILL_LABOR_BURDENED_COST) BILL_LABOR_BURDENED_COST,
    count(fpo.BILL_LABOR_BURDENED_COST) BILL_LABOR_BURDENED_COST_CNT,
    sum  (fpo.CAPITAL_RAW_COST)         CAPITAL_RAW_COST,
    count(fpo.CAPITAL_RAW_COST)         CAPITAL_RAW_COST_CNT,
    sum  (fpo.CAPITAL_BRDN_COST)        CAPITAL_BRDN_COST,
    count(fpo.CAPITAL_BRDN_COST)        CAPITAL_BRDN_COST_CNT,
    sum  (fpo.CONTRACT_RAW_COST)        CONTRACT_RAW_COST,
    count(fpo.CONTRACT_RAW_COST)        CONTRACT_RAW_COST_CNT,
    sum  (fpo.CONTRACT_BRDN_COST)       CONTRACT_BRDN_COST,
    count(fpo.CONTRACT_BRDN_COST)       CONTRACT_BRDN_COST_CNT,
    sum  (fpo.CAPITALIZABLE_RAW_COST)   CAPITALIZABLE_RAW_COST,
    count(fpo.CAPITALIZABLE_RAW_COST)   CAPITALIZABLE_RAW_COST_CNT,
    sum  (fpo.CAPITALIZABLE_BRDN_COST)  CAPITALIZABLE_BRDN_COST,
    count(fpo.CAPITALIZABLE_BRDN_COST)  CAPITALIZABLE_BRDN_COST_CNT,
    sum  (fpo.PROJECT_COUNT)            PROJECT_COUNT,
    count(fpo.PROJECT_COUNT)            PROJECT_COUNT_CNT,
    sum  (fpo.REVENUE_WRITEOFF)         REVENUE_WRITEOFF,
    count(fpo.REVENUE_WRITEOFF)         REVENUE_WRITEOFF_CNT,
    sum  (fpo.CURR_BGT_REVENUE)         CURR_BGT_REVENUE,
    count(fpo.CURR_BGT_REVENUE)         CURR_BGT_REVENUE_CNT,
    sum  (fpo.CURR_BGT_RAW_COST)        CURR_BGT_RAW_COST,
    count(fpo.CURR_BGT_RAW_COST)        CURR_BGT_RAW_COST_CNT,
    sum  (fpo.CURR_BGT_BURDENED_COST)   CURR_BGT_BURDENED_COST,
    count(fpo.CURR_BGT_BURDENED_COST)   CURR_BGT_BURDENED_COST_CNT,
    sum  (fpo.CURR_BGT_LABOR_HRS)       CURR_BGT_LABOR_HRS,
    count(fpo.CURR_BGT_LABOR_HRS)       CURR_BGT_LABOR_HRS_CNT,
    sum  (fpo.ORIG_BGT_REVENUE)         ORIG_BGT_REVENUE,
    count(fpo.ORIG_BGT_REVENUE)         ORIG_BGT_REVENUE_CNT,
    sum  (fpo.ORIG_BGT_RAW_COST)        ORIG_BGT_RAW_COST,
    count(fpo.ORIG_BGT_RAW_COST)        ORIG_BGT_RAW_COST_CNT,
    sum  (fpo.ORIG_BGT_BURDENED_COST)   ORIG_BGT_BURDENED_COST,
    count(fpo.ORIG_BGT_BURDENED_COST)   ORIG_BGT_BURDENED_COST_CNT,
    sum  (fpo.ORIG_BGT_LABOR_HRS)       ORIG_BGT_LABOR_HRS,
    count(fpo.ORIG_BGT_LABOR_HRS)       ORIG_BGT_LABOR_HRS_CNT,
    sum  (fpo.FORECAST_REVENUE)         FORECAST_REVENUE,
    count(fpo.FORECAST_REVENUE)         FORECAST_REVENUE_CNT,
    sum  (fpo.FORECAST_RAW_COST)        FORECAST_RAW_COST,
    count(fpo.FORECAST_RAW_COST)        FORECAST_RAW_COST_CNT,
    sum  (fpo.FORECAST_BURDENED_COST)   FORECAST_BURDENED_COST,
    count(fpo.FORECAST_BURDENED_COST)   FORECAST_BURDENED_COST_CNT,
    sum  (fpo.FORECAST_LABOR_HRS)       FORECAST_LABOR_HRS,
    count(fpo.FORECAST_LABOR_HRS)       FORECAST_LABOR_HRS_CNT,
    sum  (fpo.CAP_CURR_BGT_RAW_COST)    CAP_CURR_BGT_RAW_COST,
    count(fpo.CAP_CURR_BGT_RAW_COST)    CAP_CURR_BGT_RAW_COST_CNT,
    sum  (fpo.CAP_CURR_BGT_BRDN_COST)   CAP_CURR_BGT_BRDN_COST,
    count(fpo.CAP_CURR_BGT_BRDN_COST)   CAP_CURR_BGT_BRDN_COST_CNT,
    sum  (fpo.CAP_ORIG_BGT_RAW_COST)    CAP_ORIG_BGT_RAW_COST,
    count(fpo.CAP_ORIG_BGT_RAW_COST)    CAP_ORIG_BGT_RAW_COST_CNT,
    sum  (fpo.CAP_ORIG_BGT_BRDN_COST)   CAP_ORIG_BGT_BRDN_COST,
    count(fpo.CAP_ORIG_BGT_BRDN_COST)   CAP_ORIG_BGT_BRDN_COST_CNT,
    sum  (fpo.CAP_FORECAST_RAW_COST)    CAP_FORECAST_RAW_COST,
    count(fpo.CAP_FORECAST_RAW_COST)    CAP_FORECAST_RAW_COST_CNT,
    sum  (fpo.CAP_FORECAST_BRDN_COST)   CAP_FORECAST_BRDN_COST,
    count(fpo.CAP_FORECAST_BRDN_COST)   CAP_FORECAST_BRDN_COST_CNT,
    sum  (fpo.CON_CURR_BGT_RAW_COST)    CON_CURR_BGT_RAW_COST,
    count(fpo.CON_CURR_BGT_RAW_COST)    CON_CURR_BGT_RAW_COST_CNT,
    sum  (fpo.CON_CURR_BGT_BRDN_COST)   CON_CURR_BGT_BRDN_COST,
    count(fpo.CON_CURR_BGT_BRDN_COST)   CON_CURR_BGT_BRDN_COST_CNT,
    sum  (fpo.CON_ORIG_BGT_RAW_COST)    CON_ORIG_BGT_RAW_COST,
    count(fpo.CON_ORIG_BGT_RAW_COST)    CON_ORIG_BGT_RAW_COST_CNT,
    sum  (fpo.CON_ORIG_BGT_BRDN_COST)   CON_ORIG_BGT_BRDN_COST,
    count(fpo.CON_ORIG_BGT_BRDN_COST)   CON_ORIG_BGT_BRDN_COST_CNT,
    sum  (fpo.CON_FORECAST_RAW_COST)    CON_FORECAST_RAW_COST,
    count(fpo.CON_FORECAST_RAW_COST)    CON_FORECAST_RAW_COST_CNT,
    sum  (fpo.CON_FORECAST_BRDN_COST)   CON_FORECAST_BRDN_COST,
    count(fpo.CON_FORECAST_BRDN_COST)   CON_FORECAST_BRDN_COST_CNT,
    sum  (fpo.LABOR_HRS)                LABOR_HRS,
    count(fpo.LABOR_HRS)                LABOR_HRS_CNT,
    sum  (fpo.BILL_LABOR_HRS)           BILL_LABOR_HRS,
    count(fpo.BILL_LABOR_HRS)           BILL_LABOR_HRS_CNT
  from
    PJI_FP_ORG_F_MV    fpo,
    PJI.PJI_ORG_DENORM den
  where
    fpo.ORGANIZATION_ID = den.SUB_ORGANIZATION_ID
  group by
    fpo.TIME_ID,
    den.ORGANIZATION_ID,
    fpo.CALENDAR_TYPE,
    fpo.PERIOD_TYPE_ID,
    fpo.CURR_RECORD_TYPE_ID,
    fpo.CURRENCY_CODE,
    fpo.ORG_ID