VIEW: APPS.AST_PTR_RELATION_ATTRIBS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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