DBA Data[Home] [Help]

VIEW: APPS.PV_ENTITY_ATTR_VAL_V

Source

View Text - Preformatted

SELECT a.enty_attr_val_id, a.entity, a.entity_id, a.attribute_id, b.name, b.description, a.enabled_flag, a.score, a.attr_value from pv_enty_attr_values a, pv_attributes_vl b WHERE a.attribute_id = b.attribute_id
View Text - HTML Formatted

SELECT A.ENTY_ATTR_VAL_ID
, A.ENTITY
, A.ENTITY_ID
, A.ATTRIBUTE_ID
, B.NAME
, B.DESCRIPTION
, A.ENABLED_FLAG
, A.SCORE
, A.ATTR_VALUE
FROM PV_ENTY_ATTR_VALUES A
, PV_ATTRIBUTES_VL B
WHERE A.ATTRIBUTE_ID = B.ATTRIBUTE_ID