View panel product information.
This view is meant to be queried by panelvr_panelver_id to display information about a specific panel. Filtering solely by pannam, pannum, panpos, and panord will not be efficient. See PANEL_ATTRIBUTES_VIEW to efficiently query by those attributes.
Output
Column | Type | Description |
|---|---|---|
panelvr_panelver_id | NUMBER | Primary key of the panel version. |
pannam | VARCHAR2 | Panel name. |
pannum | VARCHAR2 | Panel number. |
panpos | VARCHAR2 | X, Y offset (mm). |
panord | VARCHAR2 | Panel order. |
pscale | NUMBER | Scale of the panel |
profile_id | NUMBER | ID of the product profile. |
scamin_filter | NUMBER | If not NULL, then source features that have a SCAMIN which is less than this value are excluded from the product. |
crs | CLOB | Coordinate reference system information. |
align_lat1 | NUMBER | Latitude of the first point of the alignment line. |
align_lon1 | NUMBER | Longitude of the first point of the alignment line. |
align_lat2 | NUMBER | Latitude of the second point of the alignment line. |
align_lon2 | NUMBER | Longitude of the second point of the alignment line. |
origin_x | NUMBER | Horizontal shift in millimetres. |
origin_y | NUMBER | Vertical shift in millimetres. |
boundary | SDO_GEOMETRY | Panel boundary in LLDG. |
Example
The following example shows the use of this view on an SQL statement
select * from PAPER_PANEL where panelvr_panelver_id = 1; |
Exceptions
None defined at this time.