VIEW: APPS.PJI_RM_ORG_F_MV

Source

View Text - Preformatted

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

View Text - HTML Formatted

SELECT COUNT(*) CNT
, SUM (CAPACITY_HRS) CAPACITY_HRS
, COUNT(CAPACITY_HRS) CAPACITY_HRS_CNT
, SUM (TOTAL_HRS_A) TOTAL_HRS_A
, COUNT(TOTAL_HRS_A) TOTAL_HRS_A_CNT
, SUM (TOTAL_WTD_ORG_HRS_A) TOTAL_WTD_ORG_HRS_A
, COUNT(TOTAL_WTD_ORG_HRS_A) TOTAL_WTD_ORG_HRS_A_CNT
, SUM (TOTAL_WTD_RES_HRS_A) TOTAL_WTD_RES_HRS_A
, COUNT(TOTAL_WTD_RES_HRS_A) TOTAL_WTD_RES_HRS_A_CNT
, SUM (BILL_HRS_A) BILL_HRS_A
, COUNT(BILL_HRS_A) BILL_HRS_A_CNT
, SUM (BILL_WTD_ORG_HRS_A) BILL_WTD_ORG_HRS_A
, COUNT(BILL_WTD_ORG_HRS_A) BILL_WTD_ORG_HRS_A_CNT
, SUM (BILL_WTD_RES_HRS_A) BILL_WTD_RES_HRS_A
, COUNT(BILL_WTD_RES_HRS_A) BILL_WTD_RES_HRS_A_CNT
, SUM (TRAINING_HRS_A) TRAINING_HRS_A
, COUNT(TRAINING_HRS_A) TRAINING_HRS_A_CNT
, SUM (UNASSIGNED_HRS_A) UNASSIGNED_HRS_A
, COUNT(UNASSIGNED_HRS_A) UNASSIGNED_HRS_A_CNT
, SUM (REDUCE_CAPACITY_HRS_A) REDUCE_CAPACITY_HRS_A
, COUNT(REDUCE_CAPACITY_HRS_A) REDUCE_CAPACITY_HRS_A_CNT
, SUM (CONF_HRS_S) CONF_HRS_S
, COUNT(CONF_HRS_S) CONF_HRS_S_CNT
, SUM (CONF_WTD_ORG_HRS_S) CONF_WTD_ORG_HRS_S
, COUNT(CONF_WTD_ORG_HRS_S) CONF_WTD_ORG_HRS_S_CNT
, SUM (CONF_WTD_RES_HRS_S) CONF_WTD_RES_HRS_S
, COUNT(CONF_WTD_RES_HRS_S) CONF_WTD_RES_HRS_S_CNT
, SUM (CONF_BILL_HRS_S) CONF_BILL_HRS_S
, COUNT(CONF_BILL_HRS_S) CONF_BILL_HRS_S_CNT
, SUM (CONF_BILL_WTD_ORG_HRS_S) CONF_BILL_WTD_ORG_HRS_S
, COUNT(CONF_BILL_WTD_ORG_HRS_S) CONF_BILL_WTD_ORG_HRS_S_CNT
, SUM (CONF_BILL_WTD_RES_HRS_S) CONF_BILL_WTD_RES_HRS_S
, COUNT(CONF_BILL_WTD_RES_HRS_S) CONF_BILL_WTD_RES_HRS_S_CNT
, SUM (PROV_HRS_S) PROV_HRS_S
, COUNT(PROV_HRS_S) PROV_HRS_S_CNT
, SUM (PROV_WTD_ORG_HRS_S) PROV_WTD_ORG_HRS_S
, COUNT(PROV_WTD_ORG_HRS_S) PROV_WTD_ORG_HRS_S_CNT
, SUM (PROV_WTD_RES_HRS_S) PROV_WTD_RES_HRS_S
, COUNT(PROV_WTD_RES_HRS_S) PROV_WTD_RES_HRS_S_CNT
, SUM (PROV_BILL_HRS_S) PROV_BILL_HRS_S
, COUNT(PROV_BILL_HRS_S) PROV_BILL_HRS_S_CNT
, SUM (PROV_BILL_WTD_ORG_HRS_S) PROV_BILL_WTD_ORG_HRS_S
, COUNT(PROV_BILL_WTD_ORG_HRS_S) PROV_BILL_WTD_ORG_HRS_S_CNT
, SUM (PROV_BILL_WTD_RES_HRS_S) PROV_BILL_WTD_RES_HRS_S
, COUNT(PROV_BILL_WTD_RES_HRS_S) PROV_BILL_WTD_RES_HRS_S_CNT
, SUM (TRAINING_HRS_S) TRAINING_HRS_S
, COUNT(TRAINING_HRS_S) TRAINING_HRS_S_CNT
, SUM (UNASSIGNED_HRS_S) UNASSIGNED_HRS_S
, COUNT(UNASSIGNED_HRS_S) UNASSIGNED_HRS_S_CNT
, SUM (REDUCE_CAPACITY_HRS_S) REDUCE_CAPACITY_HRS_S
, COUNT(REDUCE_CAPACITY_HRS_S) REDUCE_CAPACITY_HRS_S_CNT
, SUM (CONF_OVERCOM_HRS_S) CONF_OVERCOM_HRS_S
, COUNT(CONF_OVERCOM_HRS_S) CONF_OVERCOM_HRS_S_CNT
, SUM (PROV_OVERCOM_HRS_S) PROV_OVERCOM_HRS_S
, COUNT(PROV_OVERCOM_HRS_S) PROV_OVERCOM_HRS_S_CNT
, SUM (AVAILABLE_HRS_BKT1_S) AVAILABLE_HRS_BKT1_S
, COUNT(AVAILABLE_HRS_BKT1_S) AVAILABLE_HRS_BKT1_S_CNT
, SUM (AVAILABLE_HRS_BKT2_S) AVAILABLE_HRS_BKT2_S
, COUNT(AVAILABLE_HRS_BKT2_S) AVAILABLE_HRS_BKT2_S_CNT
, SUM (AVAILABLE_HRS_BKT3_S) AVAILABLE_HRS_BKT3_S
, COUNT(AVAILABLE_HRS_BKT3_S) AVAILABLE_HRS_BKT3_S_CNT
, SUM (AVAILABLE_HRS_BKT4_S) AVAILABLE_HRS_BKT4_S
, COUNT(AVAILABLE_HRS_BKT4_S) AVAILABLE_HRS_BKT4_S_CNT
, SUM (AVAILABLE_HRS_BKT5_S) AVAILABLE_HRS_BKT5_S
, COUNT(AVAILABLE_HRS_BKT5_S) AVAILABLE_HRS_BKT5_S_CNT
, SUM (AVAILABLE_RES_COUNT_BKT1_S) AVAILABLE_RES_COUNT_BKT1_S
, COUNT(AVAILABLE_RES_COUNT_BKT1_S) AVAILABLE_RES_COUNT_BKT1_S_CNT
, SUM (AVAILABLE_RES_COUNT_BKT2_S) AVAILABLE_RES_COUNT_BKT2_S
, COUNT(AVAILABLE_RES_COUNT_BKT2_S) AVAILABLE_RES_COUNT_BKT2_S_CNT
, SUM (AVAILABLE_RES_COUNT_BKT3_S) AVAILABLE_RES_COUNT_BKT3_S
, COUNT(AVAILABLE_RES_COUNT_BKT3_S) AVAILABLE_RES_COUNT_BKT3_S_CNT
, SUM (AVAILABLE_RES_COUNT_BKT4_S) AVAILABLE_RES_COUNT_BKT4_S
, COUNT(AVAILABLE_RES_COUNT_BKT4_S) AVAILABLE_RES_COUNT_BKT4_S_CNT
, SUM (AVAILABLE_RES_COUNT_BKT5_S) AVAILABLE_RES_COUNT_BKT5_S
, COUNT(AVAILABLE_RES_COUNT_BKT5_S) AVAILABLE_RES_COUNT_BKT5_S_CNT
, SUM (TOTAL_RES_COUNT) TOTAL_RES_COUNT
, COUNT(TOTAL_RES_COUNT) TOTAL_RES_COUNT_CNT
, SUM (MISSING_HRS_A) MISSING_HRS_A
, COUNT(MISSING_HRS_A) MISSING_HRS_A_CNT
, TIME_ID
, EXPENDITURE_ORGANIZATION_ID
, CALENDAR_TYPE
, PERIOD_TYPE_ID
, EXPENDITURE_ORG_ID
FROM PJI_RM_RES_F GROUP BY TIME_ID
, EXPENDITURE_ORGANIZATION_ID
, CALENDAR_TYPE
, PERIOD_TYPE_ID
, EXPENDITURE_ORG_ID