[Home] [Help]
View: FF_DATABASE_ITEMS_VL
Product: | FF - FastFormula |
Description: | Standard _VL view definition for FF_DATABASE_ITEMS. |
Implementation/DBA Data: |
APPS.FF_DATABASE_ITEMS_VL
|
View Text
SELECT B.ROWID ROW_ID
, B.USER_NAME
, B.USER_ENTITY_ID
, B.DATA_TYPE
, B.DEFINITION_TEXT
, B.NULL_ALLOWED_FLAG
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.CREATED_BY
, B.CREATION_DATE
, T.TRANSLATED_USER_NAME
, T.DESCRIPTION
FROM FF_DATABASE_ITEMS_TL T
, FF_DATABASE_ITEMS B
WHERE B.USER_NAME = T.USER_NAME
AND B.USER_ENTITY_ID = T.USER_ENTITY_ID
AND T.LANGUAGE = USERENV('LANG')
Columns
Name |
ROW_ID |
USER_NAME |
USER_ENTITY_ID |
DATA_TYPE |
DEFINITION_TEXT |
NULL_ALLOWED_FLAG |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
CREATED_BY |
CREATION_DATE |
TRANSLATED_USER_NAME |
DESCRIPTION |