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