FND Design Data [Home] [Help]

View: FF_DATABASE_ITEMS_VL

Product: FF - FastFormula
Description: Standard _VL view definition for FF_DATABASE_ITEMS.
Implementation/DBA Data: ViewAPPS.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