SELECT FCLASS.ROW_ID, FCLASS.FCLASS_ID, FCLASS.FUND_ID, FCLASS.FEE_CLASS, LKP.MEANING, FCLASS.CREATED_BY, FCLASS.CREATION_DATE, FCLASS.LAST_UPDATED_BY, FCLASS.LAST_UPDATE_DATE, FCLASS.LAST_UPDATE_LOGIN FROM IGF_AW_FUND_FEECLAS FCLASS, IGS_LOOKUPS_VIEW LKP WHERE LKP.LOOKUP_TYPE = 'FEE_CLASS' AND FCLASS.FEE_CLASS = LKP.LOOKUP_CODE
SELECT FCLASS.ROW_ID
, FCLASS.FCLASS_ID
, FCLASS.FUND_ID
, FCLASS.FEE_CLASS
, LKP.MEANING
, FCLASS.CREATED_BY
, FCLASS.CREATION_DATE
, FCLASS.LAST_UPDATED_BY
, FCLASS.LAST_UPDATE_DATE
, FCLASS.LAST_UPDATE_LOGIN
FROM IGF_AW_FUND_FEECLAS FCLASS
, IGS_LOOKUPS_VIEW LKP
WHERE LKP.LOOKUP_TYPE = 'FEE_CLASS'
AND FCLASS.FEE_CLASS = LKP.LOOKUP_CODE
|
|
|