[Home] [Help]
View: IGW_DETAIL_AMTS_SUM_V
View Text
SELECT DESCRIPTION EXPENDITURE_TYPE
, CALCULATED_COST P1_AMT
, TO_NUMBER(NULL) P2_AMT
, TO_NUMBER(NULL) P3_AMT
, TO_NUMBER(NULL) P4_AMT
, RATE_CLASS_ID
FROM IGW_OH_TEMP_V
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 DESCRIPTION EXPENDITURE_TYPE
, TO_NUMBER(NULL) P1_AMT
, CALCULATED_COST P2_AMT
, TO_NUMBER(NULL) P3_AMT
, TO_NUMBER(NULL) P4_AMT
, RATE_CLASS_ID
FROM IGW_OH_TEMP_V
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 DESCRIPTION EXPENDITURE_TYPE
, TO_NUMBER(NULL) P1_AMT
, TO_NUMBER(NULL) P2_AMT
, CALCULATED_COST P3_AMT
, TO_NUMBER(NULL) P4_AMT
, RATE_CLASS_ID
FROM IGW_OH_TEMP_V
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 DESCRIPTION EXPENDITURE_TYPE
, TO_NUMBER(NULL) P1_AMT
, TO_NUMBER(NULL) P2_AMT
, TO_NUMBER(NULL) P3_AMT
, CALCULATED_COST P4_AMT
, RATE_CLASS_ID
FROM IGW_OH_TEMP_V
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 |