Product: | AST - TeleSales |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AST_ENTY_ATTR_VALUES_V |
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')