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_RM_JOBO_F_MV

Source


select /* 12.0: bug#4526784 */
    count(*)                              CNT,
    sum  (rmj.CAPACITY_HRS)               CAPACITY_HRS,
    count(rmj.CAPACITY_HRS)               CAPACITY_HRS_CNT,
    sum  (rmj.TOTAL_HRS_A)                TOTAL_HRS_A,
    count(rmj.TOTAL_HRS_A)                TOTAL_HRS_A_CNT,
    sum  (rmj.TOTAL_WTD_ORG_HRS_A)        TOTAL_WTD_ORG_HRS_A,
    count(rmj.TOTAL_WTD_ORG_HRS_A)        TOTAL_WTD_ORG_HRS_A_CNT,
    sum  (rmj.TOTAL_WTD_RES_HRS_A)        TOTAL_WTD_RES_HRS_A,
    count(rmj.TOTAL_WTD_RES_HRS_A)        TOTAL_WTD_RES_HRS_A_CNT,
    sum  (rmj.BILL_HRS_A)                 BILL_HRS_A,
    count(rmj.BILL_HRS_A)                 BILL_HRS_A_CNT,
    sum  (rmj.BILL_WTD_ORG_HRS_A)         BILL_WTD_ORG_HRS_A,
    count(rmj.BILL_WTD_ORG_HRS_A)         BILL_WTD_ORG_HRS_A_CNT,
    sum  (rmj.BILL_WTD_RES_HRS_A)         BILL_WTD_RES_HRS_A,
    count(rmj.BILL_WTD_RES_HRS_A)         BILL_WTD_RES_HRS_A_CNT,
    sum  (rmj.TRAINING_HRS_A)             TRAINING_HRS_A,
    count(rmj.TRAINING_HRS_A)             TRAINING_HRS_A_CNT,
    sum  (rmj.UNASSIGNED_HRS_A)           UNASSIGNED_HRS_A,
    count(rmj.UNASSIGNED_HRS_A)           UNASSIGNED_HRS_A_CNT,
    sum  (rmj.REDUCE_CAPACITY_HRS_A)      REDUCE_CAPACITY_HRS_A,
    count(rmj.REDUCE_CAPACITY_HRS_A)      REDUCE_CAPACITY_HRS_A_CNT,
    sum  (rmj.CONF_HRS_S)                 CONF_HRS_S,
    count(rmj.CONF_HRS_S)                 CONF_HRS_S_CNT,
    sum  (rmj.CONF_WTD_ORG_HRS_S)         CONF_WTD_ORG_HRS_S,
    count(rmj.CONF_WTD_ORG_HRS_S)         CONF_WTD_ORG_HRS_S_CNT,
    sum  (rmj.CONF_WTD_RES_HRS_S)         CONF_WTD_RES_HRS_S,
    count(rmj.CONF_WTD_RES_HRS_S)         CONF_WTD_RES_HRS_S_CNT,
    sum  (rmj.CONF_BILL_HRS_S)            CONF_BILL_HRS_S,
    count(rmj.CONF_BILL_HRS_S)            CONF_BILL_HRS_S_CNT,
    sum  (rmj.CONF_BILL_WTD_ORG_HRS_S)    CONF_BILL_WTD_ORG_HRS_S,
    count(rmj.CONF_BILL_WTD_ORG_HRS_S)    CONF_BILL_WTD_ORG_HRS_S_CNT,
    sum  (rmj.CONF_BILL_WTD_RES_HRS_S)    CONF_BILL_WTD_RES_HRS_S,
    count(rmj.CONF_BILL_WTD_RES_HRS_S)    CONF_BILL_WTD_RES_HRS_S_CNT,
    sum  (rmj.PROV_HRS_S)                 PROV_HRS_S,
    count(rmj.PROV_HRS_S)                 PROV_HRS_S_CNT,
    sum  (rmj.PROV_WTD_ORG_HRS_S)         PROV_WTD_ORG_HRS_S,
    count(rmj.PROV_WTD_ORG_HRS_S)         PROV_WTD_ORG_HRS_S_CNT,
    sum  (rmj.PROV_WTD_RES_HRS_S)         PROV_WTD_RES_HRS_S,
    count(rmj.PROV_WTD_RES_HRS_S)         PROV_WTD_RES_HRS_S_CNT,
    sum  (rmj.PROV_BILL_HRS_S)            PROV_BILL_HRS_S,
    count(rmj.PROV_BILL_HRS_S)            PROV_BILL_HRS_S_CNT,
    sum  (rmj.PROV_BILL_WTD_ORG_HRS_S)    PROV_BILL_WTD_ORG_HRS_S,
    count(rmj.PROV_BILL_WTD_ORG_HRS_S)    PROV_BILL_WTD_ORG_HRS_S_CNT,
    sum  (rmj.PROV_BILL_WTD_RES_HRS_S)    PROV_BILL_WTD_RES_HRS_S,
    count(rmj.PROV_BILL_WTD_RES_HRS_S)    PROV_BILL_WTD_RES_HRS_S_CNT,
    sum  (rmj.TRAINING_HRS_S)             TRAINING_HRS_S,
    count(rmj.TRAINING_HRS_S)             TRAINING_HRS_S_CNT,
    sum  (rmj.UNASSIGNED_HRS_S)           UNASSIGNED_HRS_S,
    count(rmj.UNASSIGNED_HRS_S)           UNASSIGNED_HRS_S_CNT,
    sum  (rmj.REDUCE_CAPACITY_HRS_S)      REDUCE_CAPACITY_HRS_S,
    count(rmj.REDUCE_CAPACITY_HRS_S)      REDUCE_CAPACITY_HRS_S_CNT,
    sum  (rmj.CONF_OVERCOM_HRS_S)         CONF_OVERCOM_HRS_S,
    count(rmj.CONF_OVERCOM_HRS_S)         CONF_OVERCOM_HRS_S_CNT,
    sum  (rmj.PROV_OVERCOM_HRS_S)         PROV_OVERCOM_HRS_S,
    count(rmj.PROV_OVERCOM_HRS_S)         PROV_OVERCOM_HRS_S_CNT,
    sum  (rmj.AVAILABLE_HRS_BKT1_S)       AVAILABLE_HRS_BKT1_S,
    count(rmj.AVAILABLE_HRS_BKT1_S)       AVAILABLE_HRS_BKT1_S_CNT,
    sum  (rmj.AVAILABLE_HRS_BKT2_S)       AVAILABLE_HRS_BKT2_S,
    count(rmj.AVAILABLE_HRS_BKT2_S)       AVAILABLE_HRS_BKT2_S_CNT,
    sum  (rmj.AVAILABLE_HRS_BKT3_S)       AVAILABLE_HRS_BKT3_S,
    count(rmj.AVAILABLE_HRS_BKT3_S)       AVAILABLE_HRS_BKT3_S_CNT,
    sum  (rmj.AVAILABLE_HRS_BKT4_S)       AVAILABLE_HRS_BKT4_S,
    count(rmj.AVAILABLE_HRS_BKT4_S)       AVAILABLE_HRS_BKT4_S_CNT,
    sum  (rmj.AVAILABLE_HRS_BKT5_S)       AVAILABLE_HRS_BKT5_S,
    count(rmj.AVAILABLE_HRS_BKT5_S)       AVAILABLE_HRS_BKT5_S_CNT,
    sum  (rmj.AVAILABLE_RES_COUNT_BKT1_S) AVAILABLE_RES_COUNT_BKT1_S,
    count(rmj.AVAILABLE_RES_COUNT_BKT1_S) AVAILABLE_RES_COUNT_BKT1_S_CNT,
    sum  (rmj.AVAILABLE_RES_COUNT_BKT2_S) AVAILABLE_RES_COUNT_BKT2_S,
    count(rmj.AVAILABLE_RES_COUNT_BKT2_S) AVAILABLE_RES_COUNT_BKT2_S_CNT,
    sum  (rmj.AVAILABLE_RES_COUNT_BKT3_S) AVAILABLE_RES_COUNT_BKT3_S,
    count(rmj.AVAILABLE_RES_COUNT_BKT3_S) AVAILABLE_RES_COUNT_BKT3_S_CNT,
    sum  (rmj.AVAILABLE_RES_COUNT_BKT4_S) AVAILABLE_RES_COUNT_BKT4_S,
    count(rmj.AVAILABLE_RES_COUNT_BKT4_S) AVAILABLE_RES_COUNT_BKT4_S_CNT,
    sum  (rmj.AVAILABLE_RES_COUNT_BKT5_S) AVAILABLE_RES_COUNT_BKT5_S,
    count(rmj.AVAILABLE_RES_COUNT_BKT5_S) AVAILABLE_RES_COUNT_BKT5_S_CNT,
    sum  (rmj.TOTAL_RES_COUNT)            TOTAL_RES_COUNT,
    count(rmj.TOTAL_RES_COUNT)            TOTAL_RES_COUNT_CNT,
    sum  (rmj.MISSING_HRS_A)              MISSING_HRS_A,
    count(rmj.MISSING_HRS_A)              MISSING_HRS_A_CNT,
    rmj.TIME_ID,
    den.ORGANIZATION_ID                   EXPENDITURE_ORGANIZATION_ID,
    rmj.CALENDAR_TYPE,
    rmj.PERIOD_TYPE_ID,
    rmj.JOB_ID,
    rmj.EXPENDITURE_ORG_ID
  from
    PJI_RM_JOB_F_MV    rmj,
    PJI.PJI_ORG_DENORM den
  where
    rmj.EXPENDITURE_ORGANIZATION_ID = den.SUB_ORGANIZATION_ID
  group by
    rmj.TIME_ID,
    den.ORGANIZATION_ID,
    rmj.CALENDAR_TYPE,
    rmj.PERIOD_TYPE_ID,
    rmj.JOB_ID,
    rmj.EXPENDITURE_ORG_ID