[Home] [Help]
View: IGW_BUDGET_EXPENDITURES_V
View Text
SELECT EXPENDITURE_CATEGORY BUDGET_EXPENDITURE
, DESCRIPTION
, BUDGET_CATEGORY_CODE
, EXPENDITURE_CATEGORY
, NULL PARENT_CATEGORY
, PERSONNEL_ATTACHED_FLAG
, 'Y' EXPENDITURE_CATEGORY_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
FROM IGW_EXPENDITURE_CATEGORIES_V UNION SELECT ET.EXPENDITURE_TYPE BUDGET_EXPENDITURE
, ET.DESCRIPTION
, EC.BUDGET_CATEGORY_CODE
, ET.EXPENDITURE_CATEGORY
, ET.EXPENDITURE_CATEGORY PARENT_CATEGORY
, EC.PERSONNEL_ATTACHED_FLAG
, 'N' EXPENDITURE_CATEGORY_FLAG
, ET.START_DATE_ACTIVE
, ET.END_DATE_ACTIVE
FROM IGW_EXPENDITURE_TYPES_V ET
, IGW_EXPENDITURE_CATEGORIES_V EC WHERE EC.EXPENDITURE_CATEGORY = ET.EXPENDITURE_CATEGORY
Columns
Name |
BUDGET_EXPENDITURE |
DESCRIPTION |
BUDGET_CATEGORY_CODE |
EXPENDITURE_CATEGORY |
PARENT_CATEGORY |
PERSONNEL_ATTACHED_FLAG |
EXPENDITURE_CATEGORY_FLAG |
START_DATE_ACTIVE |
END_DATE_ACTIVE |