[Home] [Help]
View: IGF_AW_FUND_FEECLAS_V
View Text
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
Columns
Name |
ROW_ID |
FCLASS_ID |
FUND_ID |
FEE_CLASS |
MEANING |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |