VIEW: APPS.IGW_DETAIL_AMTS_SUM_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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