DBA Data[Home] [Help]

VIEW: APPS.IGF_AW_FUND_FEECLAS_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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