FND Design Data [Home] [Help]

View: AST_ENTY_ATTR_VALUES_SL_V

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

SELECT A.ROWID ROW_ID
, 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
, 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 = 'SALES_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
ENABLED_FLAG
ENTITY_ID
NAME
SHORT_NAME
DESCRIPTION