Product: | FF - FastFormula |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.FF_FUNCTIONS_V |
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)