[Home] [Help] [Dependency Information]
Object Name: | IEU_UWQ_SEL_RT_NODES |
---|---|
Object Type: | TABLE |
Owner: | IEU |
FND Design Data: | IEU.IEU_UWQ_SEL_RT_NODES |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IEU_UWQ_SEL_RT_NODES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
RESOURCE_ID
SEL_ENUM_ID NODE_ID NODE_TYPE |
IEU_UWQ_SEL_RT_NODES_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
RESOURCE_ID
NODE_ID NOT_VALID |
IEU_UWQ_SEL_RT_NODES_U3 | NORMAL | UNIQUE | APPS_TS_TX_IDX | SEL_RT_NODE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SEL_RT_NODE_ID | NUMBER | (15) | Yes | Uniquely identifies selector node row. |
CREATED_BY | NUMBER | (15) | Yes | Standard WHO columns. |
CREATION_DATE | DATE | Yes | Standard WHO columns. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO columns. |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO columns. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO columns. | |
RESOURCE_ID | NUMBER | (15) | Yes | Identifies JTF resource ID of the agent. |
SEL_ENUM_ID | NUMBER | (15) | Yes | FK to enumerator. |
NODE_ID | NUMBER | (10) | Yes | Node ID. |
NODE_TYPE | NUMBER | (10) | Yes | Type of node. |
NODE_LABEL | VARCHAR2 | (1996) | Yes | Display label of the node. |
COUNT | NUMBER | (10) | Elements contained in node (displayed). | |
DATA_SOURCE | VARCHAR2 | (64) | Yes | DataSource for SpreadTable. |
VIEW_NAME | VARCHAR2 | (64) | Yes | View that DataSource is based upon. |
MEDIA_TYPE_ID | NUMBER | (15) | FK to media type. | |
SEL_ENUM_PID | NUMBER | (15) | Parent's enumerator ID. | |
NODE_PID | NUMBER | (10) | Node's Parent. | |
NODE_WEIGHT | NUMBER | (10) | Weight for display order. | |
WHERE_CLAUSE | VARCHAR2 | (1996) | Where clause that qualifies agents view. | |
HIDE_IF_EMPTY | VARCHAR2 | (1) | Indicates to hide if count is zero (or not). | |
NOT_VALID | VARCHAR2 | (1) | Indicates if row is valid (or not). | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
OBJECT_VERSION_NUMBER | NUMBER | Standard column used by HTML utilities. | ||
REFRESH_VIEW_NAME | VARCHAR2 | (64) | View that is used for Refreshing the Counts. | |
RES_CAT_ENUM_FLAG | VARCHAR2 | (1) | Indicates if the Resource Categorization is obtained from Enumerator seed. | |
REFRESH_VIEW_SUM_COL | VARCHAR2 | (30) | If specified, tells UWQ which column to use to SUM counts. | |
NODE_DEPTH | NUMBER | (10) | Node Depth in the Tree |
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;
IEU.IEU_UWQ_SEL_RT_NODES does not reference any database object
IEU.IEU_UWQ_SEL_RT_NODES is referenced by following:
|
|
|