[Home] [Help]
View: IGW_BUDGET_MATRIX_V
View Text
SELECT EXPENDITURE_TYPE
, RATE_CLASS_ID
, SUM(P1_AMT) P1_AMT
, SUM(P2_AMT) P2_AMT
, SUM(P3_AMT) P3_AMT
, SUM(P4_AMT) P4_AMT
FROM IGW_EXPENDITURE_TYPE_SUM_V GROUP BY EXPENDITURE_TYPE
, RATE_CLASS_ID UNION SELECT EXPENDITURE_TYPE
, RATE_CLASS_ID
, SUM(P1_AMT) P1_AMT
, SUM(P2_AMT) P2_AMT
, SUM(P3_AMT) P3_AMT
, SUM(P4_AMT) P4_AMT
FROM IGW_DETAIL_AMTS_SUM_V GROUP BY EXPENDITURE_TYPE
, RATE_CLASS_ID UNION SELECT DISTINCT EXPENDITURE_TYPE
, 0 RATE_CLASS_ID
, TO_NUMBER(NULL) P1_AMT
, TO_NUMBER(NULL) P2_AMT
, TO_NUMBER(NULL) P3_AMT
, TO_NUMBER(NULL) P4_AMT FROM IGW_BUDGET_DETAILS
WHERE PROPOSAL_ID = IGW_BUDGET_OPERATIONS.GET_PROPOSAL_ID AND PROPOSAL_ID = IGW_BUDGET_OPERATIONS.GET_VERSION_ID AND EXPENDITURE_TYPE NOT IN (SELECT EXPENDITURE_TYPE
FROM IGW_EXPENDITURE_TYPE_SUM_V) UNION SELECT DISTINCT DESCRIPTION EXPENDITURE_TYPE
, RATE_CLASS_ID
, TO_NUMBER(NULL) P1_AMT
, TO_NUMBER(NULL) P2_AMT
, TO_NUMBER(NULL) P3_AMT
, TO_NUMBER(NULL) P4_AMT FROM IGW_OH_TEMP_V
WHERE PROPOSAL_ID = IGW_BUDGET_OPERATIONS.GET_PROPOSAL_ID AND PROPOSAL_ID = IGW_BUDGET_OPERATIONS.GET_VERSION_ID
AND DESCRIPTION NOT IN (SELECT EXPENDITURE_TYPE
FROM IGW_DETAIL_AMTS_SUM_V)
Columns
Name |
EXPENDITURE_TYPE |
RATE_CLASS_ID |
P1_AMT |
P2_AMT |
P3_AMT |
P4_AMT |