[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 |