VIEW: APPS.IGW_BUDGET_MATRIX_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)