View: IGW_BUDGET_MATRIX_V

Product:	IGW - Grants Proposal
Description:	10SC Only
Implementation/DBA Data:	APPS.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