[Home] [Help]
View: AST_PTR_RELATION_ATTRIBS_V
View Text
SELECT ATTR_VAL.ENTITY_ID
, ATTR.NAME
, ATTR_VAL.ATTR_VALUE
, ATTR.DESCRIPTION
FROM PV_ATTRIBUTES_TL ATTR
, PV_ENTY_ATTR_VALUES ATTR_VAL
WHERE ATTR.ATTRIBUTE_ID = ATTR_VAL.ATTRIBUTE_ID
AND ATTR_VAL.ENTITY = 'PARTNER'
AND ATTR.LANGUAGE = USERENV('LANG')
Columns
| Name |
| PARTNER_ID |
| ATTRIBUTE |
| VALUE |
| DESCRIPTION |