[Home] [Help] [Dependency Information]
Object Name: | IEU_UWQ_SEL_RT_NODES# |
---|---|
Object Type: | VIEW |
Owner: | IEU |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SEL_RT_NODE_ID | NUMBER | (15) | Yes | |
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
RESOURCE_ID | NUMBER | (15) | Yes | |
SEL_ENUM_ID | NUMBER | (15) | Yes | |
NODE_ID | NUMBER | (10) | Yes | |
NODE_TYPE | NUMBER | (10) | Yes | |
NODE_LABEL | VARCHAR2 | (1996) | Yes | |
COUNT | NUMBER | (10) | ||
DATA_SOURCE | VARCHAR2 | (64) | Yes | |
VIEW_NAME | VARCHAR2 | (64) | Yes | |
MEDIA_TYPE_ID | NUMBER | (15) | ||
SEL_ENUM_PID | NUMBER | (15) | ||
NODE_PID | NUMBER | (10) | ||
NODE_WEIGHT | NUMBER | (10) | ||
WHERE_CLAUSE | VARCHAR2 | (1996) | ||
HIDE_IF_EMPTY | VARCHAR2 | (1) | ||
NOT_VALID | VARCHAR2 | (1) | ||
SECURITY_GROUP_ID | NUMBER | |||
OBJECT_VERSION_NUMBER | NUMBER | |||
REFRESH_VIEW_NAME | VARCHAR2 | (64) | ||
RES_CAT_ENUM_FLAG | VARCHAR2 | (1) | ||
REFRESH_VIEW_SUM_COL | VARCHAR2 | (30) | ||
NODE_DEPTH | NUMBER | (10) |
Cut, paste (and edit) the following text to query this object:
SELECT SEL_RT_NODE_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, RESOURCE_ID
, SEL_ENUM_ID
, NODE_ID
, NODE_TYPE
, NODE_LABEL
, COUNT
, DATA_SOURCE
, VIEW_NAME
, MEDIA_TYPE_ID
, SEL_ENUM_PID
, NODE_PID
, NODE_WEIGHT
, WHERE_CLAUSE
, HIDE_IF_EMPTY
, NOT_VALID
, SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER
, REFRESH_VIEW_NAME
, RES_CAT_ENUM_FLAG
, REFRESH_VIEW_SUM_COL
, NODE_DEPTH
FROM IEU.IEU_UWQ_SEL_RT_NODES#;
|
|
|