[Home] [Help]
View: IGW_EXPENDITURE_TYPE_SUM_V
View Text
SELECT EXPENDITURE_TYPE
, LINE_ITEM_COST P1_AMT
, TO_NUMBER(TO_NUMBER(NULL)) P2_AMT
, TO_NUMBER(TO_NUMBER(NULL)) P3_AMT
, TO_NUMBER(TO_NUMBER(NULL)) P4_AMT
, 0 RATE_CLASS_ID
FROM IGW_BUDGET_DETAILS
WHERE PROPOSAL_ID = IGW_BUDGET_OPERATIONS.GET_PROPOSAL_ID AND VERSION_ID = IGW_BUDGET_OPERATIONS.GET_VERSION_ID AND BUDGET_PERIOD_ID = IGW_BUDGET_OPERATIONS.GET_PERIOD_ID UNION SELECT EXPENDITURE_TYPE
, TO_NUMBER(TO_NUMBER(NULL)) P1_AMT
, LINE_ITEM_COST P2_AMT
, TO_NUMBER(TO_NUMBER(NULL)) P3_AMT
, TO_NUMBER(TO_NUMBER(NULL)) P4_AMT
, 0 RATE_CLASS_ID
FROM IGW_BUDGET_DETAILS
WHERE PROPOSAL_ID =IGW_BUDGET_OPERATIONS.GET_PROPOSAL_ID AND VERSION_ID = IGW_BUDGET_OPERATIONS.GET_VERSION_ID AND BUDGET_PERIOD_ID =IGW_BUDGET_OPERATIONS.GET_PERIOD_ID+1 UNION SELECT EXPENDITURE_TYPE
, TO_NUMBER(NULL) P1_AMT
, TO_NUMBER(NULL) P2_AMT
, LINE_ITEM_COST P3_AMT
, TO_NUMBER(NULL) P4_AMT
, 0 RATE_CLASS_ID
FROM IGW_BUDGET_DETAILS
WHERE PROPOSAL_ID =IGW_BUDGET_OPERATIONS.GET_PROPOSAL_ID AND VERSION_ID = IGW_BUDGET_OPERATIONS.GET_VERSION_ID AND BUDGET_PERIOD_ID = IGW_BUDGET_OPERATIONS.GET_PERIOD_ID+2 UNION SELECT EXPENDITURE_TYPE
, TO_NUMBER(NULL) P1_AMT
, TO_NUMBER(NULL) P2_AMT
, TO_NUMBER(NULL) P3_AMT
, LINE_ITEM_COST P4_AMT
, 0 RATE_CLASS_ID
FROM IGW_BUDGET_DETAILS
WHERE PROPOSAL_ID = IGW_BUDGET_OPERATIONS.GET_PROPOSAL_ID AND VERSION_ID = IGW_BUDGET_OPERATIONS.GET_VERSION_ID AND BUDGET_PERIOD_ID = IGW_BUDGET_OPERATIONS.GET_PERIOD_ID+3
Columns
Name |
EXPENDITURE_TYPE |
P1_AMT |
P2_AMT |
P3_AMT |
P4_AMT |
RATE_CLASS_ID |