VIEW: APPS.IGWFV_GRNT_PRPSL_EXP_RATE_ASGN

Source

View Text - Preformatted

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

View Text - HTML Formatted

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