eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
MATERIALIZED VIEW: APPS.PJI_FP_CLS_F_MV

Source


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