[Home] [Help] [Dependency Information]
Object Name: | ECX_OBJECT_ATTRIBUTES# |
---|---|
Object Type: | VIEW |
Owner: | ECX |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ATTRIBUTE_ID | NUMBER | Yes | ||
OBJECTLEVEL_ID | NUMBER | Yes | ||
ATTRIBUTE_NAME | VARCHAR2 | (255) | ||
OBJECT_COLUMN_FLAG | VARCHAR2 | (2) | ||
DATA_TYPE | NUMBER | |||
PARENT_ATTRIBUTE_ID | NUMBER | Yes | ||
POSITION | NUMBER | |||
WIDTH | NUMBER | |||
XREF_CATEGORY_ID | NUMBER | |||
STAGING_COLUMN | VARCHAR2 | (30) | ||
DEFAULT_VALUE | VARCHAR2 | (255) | ||
ATTRIBUTE_TYPE | VARCHAR2 | (20) | ||
HAS_ATTRIBUTES | VARCHAR2 | (20) | ||
LEAF_NODE | VARCHAR2 | (1) | ||
REQUIRED_FLAG | VARCHAR2 | (1) | ||
MAP_ID | NUMBER | Yes | ||
COND_NODE | VARCHAR2 | (50) | ||
COND_VALUE | VARCHAR2 | (50) | ||
COND_NODE_TYPE | VARCHAR2 | (25) | ||
OCCURRENCE | NUMBER | (15) | ||
IS_MAPPED | VARCHAR2 | (20) | ||
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT ATTRIBUTE_ID
, OBJECTLEVEL_ID
, ATTRIBUTE_NAME
, OBJECT_COLUMN_FLAG
, DATA_TYPE
, PARENT_ATTRIBUTE_ID
, POSITION
, WIDTH
, XREF_CATEGORY_ID
, STAGING_COLUMN
, DEFAULT_VALUE
, ATTRIBUTE_TYPE
, HAS_ATTRIBUTES
, LEAF_NODE
, REQUIRED_FLAG
, MAP_ID
, COND_NODE
, COND_VALUE
, COND_NODE_TYPE
, OCCURRENCE
, IS_MAPPED
, ZD_EDITION_NAME
FROM ECX.ECX_OBJECT_ATTRIBUTES#;
|
|
|