FND Design Data [Home] [Help]

View: AST_ENTY_ATTR_VALUES_V

Product: AST - TeleSales
Description:
Implementation/DBA Data: ViewAPPS.AST_ENTY_ATTR_VALUES_V
View Text

SELECT A.ROWID
, A.ENTY_ATTR_VAL_ID
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_LOGIN
, A.OBJECT_VERSION_NUMBER
, A.ENTITY
, A.ATTRIBUTE_ID
, A.PARTY_ID
, A.ATTR_VALUE
, A.SCORE
, NULL
, A.ENABLED_FLAG
, A.ENTITY_ID
, B.NAME
, B.SHORT_NAME
, B.DESCRIPTION
FROM PV_ENTY_ATTR_VALUES A
, PV_ATTRIBUTES_TL B
WHERE A.ATTRIBUTE_ID=B.ATTRIBUTE_ID
AND A.ENTITY='LEAD'
AND A.ENABLED_FLAG='Y'
AND B.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
ENTY_ATTR_VAL_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
ENTITY
ATTRIBUTE_ID
PARTY_ID
ATTR_VALUE
SCORE
SECURITY_GROUP_ID
ENABLED_FLAG
ENTITY_ID
NAME
SHORT_NAME
DESCRIPTION