FND Design Data [Home] [Help]

View: AMS_DS_TCA_ENTITY_COLS_VL

Product: AMS - Marketing
Description:
Implementation/DBA Data: ViewAPPS.AMS_DS_TCA_ENTITY_COLS_VL
View Text

SELECT B.ROWID ROW_ID
, B.CREATED_BY
, B.CREATION_DATE
, B.ENTITY_COLUMN_ID
, B.ENTITY_ID
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.LAST_UPDATED_BY
, B.SECURITY_GROUP_ID
, B.FIELD_SIZE
, B.DATATYPE
, B.RECORD_STUCTURE
, B.SOURCE_CATEGORY
, B.ENABLED_FLAG
, T.DESCRIPTION
FROM AMS_DS_TCA_ENTITY_COLS_TL T
, AMS_DS_TCA_ENTITY_COLS B
WHERE B.ENTITY_COLUMN_ID = T.ENTITY_COLUMN_ID
AND T.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
CREATED_BY
CREATION_DATE
ENTITY_COLUMN_ID
ENTITY_ID
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
LAST_UPDATED_BY
SECURITY_GROUP_ID
FIELD_SIZE
DATATYPE
RECORD_STUCTURE
SOURCE_CATEGORY
ENABLED_FLAG
DESCRIPTION