[Home] [Help]
View: FF_FUNCTION_CONTEXT_USAGES_V
View Text
SELECT FCU.ROWID
, FCU.FUNCTION_ID
, FCU.SEQUENCE_NUMBER
, FCU.CONTEXT_ID
, FFC.CONTEXT_NAME
, FFC.DATA_TYPE
, FFL.MEANING
, FCU.CREATED_BY
, FCU.CREATION_DATE
, FCU.LAST_UPDATED_BY
, FCU.LAST_UPDATE_DATE
, FCU.LAST_UPDATE_LOGIN
FROM FF_CONTEXTS FFC
, FF_FUNCTION_CONTEXT_USAGES FCU
, FF_LOOKUPS FFL
WHERE (FFC.CONTEXT_ID = FCU.CONTEXT_ID)
AND (FFL.LOOKUP_CODE = FFC.DATA_TYPE
AND FFL.LOOKUP_TYPE = 'DATA_TYPE')
Columns
Name |
ROW_ID |
FUNCTION_ID |
SEQUENCE_NUMBER |
CONTEXT_ID |
CONTEXT_NAME |
DATA_TYPE_CODE |
DATA_TYPE |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |