VIEW: APPS.AST_ENTY_ATTR_VALUES_SL_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')