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_ET_F_MV

Source


select /* 12.0: bug#4526784 */
    fpe.TIME_ID,
    fpe.PROJECT_ORGANIZATION_ID,
    fpe.CALENDAR_TYPE,
    fpe.PERIOD_TYPE_ID,
    cls.PROJECT_CLASS_ID,
    fpe.CURR_RECORD_TYPE_ID,
    fpe.CURRENCY_CODE,
    fpe.PROJECT_ORG_ID,
    fpe.EXP_EVT_TYPE_ID,
    count(*)                                      CNT,
    sum  (fpe.REVENUE *
          cls.CODE_PERCENTAGE / 100)              REVENUE,
    count(fpe.REVENUE *
          cls.CODE_PERCENTAGE / 100)              REVENUE_CNT,
    sum  (fpe.LABOR_REVENUE *
          cls.CODE_PERCENTAGE / 100)              LABOR_REVENUE,
    count(fpe.LABOR_REVENUE *
          cls.CODE_PERCENTAGE / 100)              LABOR_REVENUE_CNT,
    sum  (fpe.RAW_COST *
          cls.CODE_PERCENTAGE / 100)              RAW_COST,
    count(fpe.RAW_COST *
          cls.CODE_PERCENTAGE / 100)              RAW_COST_CNT,
    sum  (fpe.BURDENED_COST *
          cls.CODE_PERCENTAGE / 100)              BURDENED_COST,
    count(fpe.BURDENED_COST *
          cls.CODE_PERCENTAGE / 100)              BURDENED_COST_CNT,
    sum  (fpe.BILL_RAW_COST *
          cls.CODE_PERCENTAGE / 100)              BILL_RAW_COST,
    count(fpe.BILL_RAW_COST *
          cls.CODE_PERCENTAGE / 100)              BILL_RAW_COST_CNT,
    sum  (fpe.BILL_BURDENED_COST *
          cls.CODE_PERCENTAGE / 100)              BILL_BURDENED_COST,
    count(fpe.BILL_BURDENED_COST *
          cls.CODE_PERCENTAGE / 100)              BILL_BURDENED_COST_CNT,
    sum  (fpe.LABOR_RAW_COST *
          cls.CODE_PERCENTAGE / 100)              LABOR_RAW_COST,
    count(fpe.LABOR_RAW_COST *
          cls.CODE_PERCENTAGE / 100)              LABOR_RAW_COST_CNT,
    sum  (fpe.LABOR_BURDENED_COST *
          cls.CODE_PERCENTAGE / 100)              LABOR_BURDENED_COST,
    count(fpe.LABOR_BURDENED_COST *
          cls.CODE_PERCENTAGE / 100)              LABOR_BURDENED_COST_CNT,
    sum  (fpe.BILL_LABOR_RAW_COST *
          cls.CODE_PERCENTAGE / 100)              BILL_LABOR_RAW_COST,
    count(fpe.BILL_LABOR_RAW_COST *
          cls.CODE_PERCENTAGE / 100)              BILL_LABOR_RAW_COST_CNT,
    sum  (fpe.BILL_LABOR_BURDENED_COST *
          cls.CODE_PERCENTAGE / 100)              BILL_LABOR_BURDENED_COST,
    count(fpe.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  (fpe.CAPITALIZABLE_RAW_COST *
          cls.CODE_PERCENTAGE / 100)              CAPITALIZABLE_RAW_COST,
    count(fpe.CAPITALIZABLE_RAW_COST *
          cls.CODE_PERCENTAGE / 100)              CAPITALIZABLE_RAW_COST_CNT,
    sum  (fpe.CAPITALIZABLE_BRDN_COST *
          cls.CODE_PERCENTAGE / 100)              CAPITALIZABLE_BRDN_COST,
    count(fpe.CAPITALIZABLE_BRDN_COST *
          cls.CODE_PERCENTAGE / 100)              CAPITALIZABLE_BRDN_COST_CNT,
    sum  (1)                                      PROJECT_COUNT,
    count(1)                                      PROJECT_COUNT_CNT,
    sum  (fpe.LABOR_HRS *
          cls.CODE_PERCENTAGE / 100)              LABOR_HRS,
    count(fpe.LABOR_HRS *
          cls.CODE_PERCENTAGE / 100)              LABOR_HRS_CNT,
    sum  (fpe.BILL_LABOR_HRS *
          cls.CODE_PERCENTAGE / 100)              BILL_LABOR_HRS,
    count(fpe.BILL_LABOR_HRS *
          cls.CODE_PERCENTAGE / 100)              BILL_LABOR_HRS_CNT,
    sum  (fpe.QUANTITY *
          cls.CODE_PERCENTAGE / 100)              QUANTITY,
    count(fpe.QUANTITY *
          cls.CODE_PERCENTAGE / 100)              QUANTITY_CNT,
    sum  (fpe.BILL_QUANTITY *
          cls.CODE_PERCENTAGE / 100)              BILL_QUANTITY,
    count(fpe.BILL_QUANTITY *
          cls.CODE_PERCENTAGE / 100)              BILL_QUANTITY_CNT
  from
    PJI.PJI_FP_PROJ_ET_F    fpe,
    PJI.PJI_PROJECT_CLASSES cls
  where
    fpe.PROJECT_ID = cls.PROJECT_ID
  group by
    fpe.TIME_ID,
    fpe.PROJECT_ORGANIZATION_ID,
    fpe.CALENDAR_TYPE,
    fpe.PERIOD_TYPE_ID,
    cls.PROJECT_CLASS_ID,
    fpe.CURR_RECORD_TYPE_ID,
    fpe.CURRENCY_CODE,
    fpe.PROJECT_ORG_ID,
    fpe.EXP_EVT_TYPE_ID