[Home] [Help]
View: IGWFV_GRNT_PRPSL_EXP_RATE_ASGN
View Text
SELECT CLASS.DESCRIPTION
, TYPE.DESCRIPTION
, CAT.DESCRIPTION
, EXP_RATES.RATE_CLASS_ID
, EXP_RATES.RATE_TYPE_ID
, EXP_RATES.EXPENDITURE_CATEGORY
, EXP_RATES.LAST_UPDATE_DATE
, EXP_RATES.LAST_UPDATED_BY
, EXP_RATES.CREATION_DATE
, EXP_RATES.CREATED_BY
FROM IGW_EXP_TYPE_RATE_TYPES EXP_RATES
, IGW_RATE_CLASSES CLASS
, IGW_RATE_TYPES TYPE
, IGW_EXPENDITURE_CATEGORIES CAT
WHERE EXP_RATES.RATE_TYPE_ID = TYPE.RATE_TYPE_ID
AND EXP_RATES.RATE_CLASS_ID = CLASS.RATE_CLASS_ID
AND EXP_RATES.EXPENDITURE_CATEGORY = CAT.EXPENDITURE_CATEGORY WITH READ ONLY
Columns
Name |
RATE_CLASS_DESCRIPTION |
RATE_TYPE_DESCRIPTION |
EXP_CATEGORY_DESCRIPTION |
RATE_CLASS_ID |
RATE_TYPE_ID |
EXPENDITURE_CATEGORY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |