Attribute information for external products.
Output
Column | Type | Description |
|---|---|---|
product_id | NUMBER | Primary key of external product. |
attributeclass_id | NUMBER | The id of the attributeclass |
acronym | VARCHAR2 | The acronym of the attributeclass |
data | CLOB | The attribute value |
att_index | NUMBER | The index of the attribute value within the set of attributes. This may be used to order the attributes. |
Example
The following example shows the use of this view in an SQL statement.
select * from EXTERNAL_PRODUCT_ATTRIBUTES_VW order by attributeclass_id, att_index; |