[Home] [Help]
View: IGW_OH_EXPENDITURE_CAT_TYPES_V
View Text
SELECT EXPENDITURE_CATEGORY
, DESCRIPTION
, EXPENDITURE_CATEGORY
, 'C'
FROM PA_EXPENDITURE_CATEGORIES UNION SELECT EXPENDITURE_TYPE
, DESCRIPTION
, EXPENDITURE_CATEGORY
, 'T'
FROM PA_EXPENDITURE_TYPES
Columns
Name |
EXPENDITURE_CATEGORY_TYPE |
DESCRIPTION |
EXPENDITURE_CATEGORY |
EXPENDITURE_CAT_TYPE_FLAG |