[Home] [Help]
View: IGWBV_GRANT_PRPSL_EXP_CATEGORY
View Text
SELECT ECAT.EXPENDITURE_CATEGORY
, ECAT.DESCRIPTION
, LKUP1.MEANING
, ECAT.PERSONNEL_ATTACHED_FLAG
, ECAT.START_DATE_ACTIVE
, ECAT.END_DATE_ACTIVE
, ECAT.LAST_UPDATE_DATE
, ECAT.LAST_UPDATED_BY
, ECAT.CREATION_DATE
, ECAT.CREATED_BY
FROM IGW_EXPENDITURE_CATEGORIES ECAT
, IGW_LOOKUPS_V LKUP1
WHERE LKUP1.LOOKUP_TYPE = 'IGW_BUDGET_CATEGORY'
AND LKUP1.LOOKUP_CODE = ECAT.BUDGET_CATEGORY_CODE WITH READ ONLY
Columns
Name |
EXPENDITURE_CATEGORY |
EXP_CATEGORY_DESCRIPTION |
BUDGET_CATEGORY |
PERSONNEL_ATTACHED_FLAG |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |