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.
[Home] [Help]
MATERIALIZED VIEW: APPS.PJI_FP_ORG_F_MV

Source


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