List of source registry attributes.
Output
Column | Type | Description |
|---|---|---|
source_name | VARCHAR2 | Name for this source registry item. |
sourceregistry_id | NUMBER | The primary key of the source registry. |
sourcereg_att_id | NUMBER | The primary key value of the attribute for this source registry. |
charval | VARCHAR2 | Character values for attributes. |
numberval | NUMBER | Numeric value for attributes. |
sequence | NUMBER | Sequence value for attributes. |
attributeclass_id | NUMBER | Primary key of attribute class ID. |
description | VARCHAR2 | Description of this attribute, if this is a list or enumerated value. |
Example
The following example shows the use of this view in an SQL statement.
select * from hpd_sourcereg_attrib_vw where sourceregistry_id=31001; |