VIEW: APPS.FF_FUNCTIONS_V

Source

View Text - Preformatted

SELECT ff.rowid, ff.function_id, fl1.lookup_code, fl1.meaning, ff.name, ff.alias_name, ff.business_group_id, ff.created_by, ff.creation_date, fl2.lookup_code, fl2.meaning, ff.definition, ff.last_updated_by, ff.last_update_date, ff.last_update_login, ff.legislation_code, ff.description FROM FF_FUNCTIONS FF,FF_LOOKUPS FL1,FF_LOOKUPS FL2 where (fl1.lookup_type = 'FUNCTION_CLASS' and fl1.lookup_code = ff.class) and (fl2.lookup_type = 'DATA_TYPE' and fl2.lookup_code = ff.data_type)

View Text - HTML Formatted

SELECT FF.ROWID
, FF.FUNCTION_ID
, FL1.LOOKUP_CODE
, FL1.MEANING
, FF.NAME
, FF.ALIAS_NAME
, FF.BUSINESS_GROUP_ID
, FF.CREATED_BY
, FF.CREATION_DATE
, FL2.LOOKUP_CODE
, FL2.MEANING
, FF.DEFINITION
, FF.LAST_UPDATED_BY
, FF.LAST_UPDATE_DATE
, FF.LAST_UPDATE_LOGIN
, FF.LEGISLATION_CODE
, FF.DESCRIPTION
FROM FF_FUNCTIONS FF
, FF_LOOKUPS FL1
, FF_LOOKUPS FL2
WHERE (FL1.LOOKUP_TYPE = 'FUNCTION_CLASS'
AND FL1.LOOKUP_CODE = FF.CLASS)
AND (FL2.LOOKUP_TYPE = 'DATA_TYPE'
AND FL2.LOOKUP_CODE = FF.DATA_TYPE)