[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 |