VIEW: APPS.IGW_EXPENDITURE_TYPE_SUM_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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