eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: CS.CS_SR_UWQ_NODES_B

Object Details

Object Name:	CS_SR_UWQ_NODES_B
Object Type:	TABLE
Owner:	CS
FND Design Data:	CS.CS_SR_UWQ_NODES_B
Subobject Name:
Status:	VALID

Holds the non-translated definitions for UWQ Non-Media nodes.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CS_SR_UWQ_NODES_U1	NORMAL	UNIQUE	APPS_TS_SEED	NODE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
NODE_ID	NUMBER		Yes	The identifier of the node.
NODE_VIEW	VARCHAR2	(50)	Yes	The view on which the meta data is present.
DATA_SOURCE	VARCHAR2	(50)	Yes	The data source that will display all the service requests.
MEDIA_TYPE_ID	NUMBER			The media type id.
WHERE_CLAUSE	VARCHAR2	(500)		The where clause used to filter the data.
RES_CAT_ENUM_FLAG	VARCHAR2	(1)		Default query override option flag.
NODE_TYPE	VARCHAR2	(10)		The type of the node.
HIDE_IF_EMPTY	VARCHAR2	(1)		Flag indicates if the node is to be hidden when empty.
NODE_DEPTH	NUMBER			The depth of the node.
PARENT_ID	NUMBER			The Identifier of the parent node.
NODE_QUERY	VARCHAR2	(10)		The query type of the Node Single or Cursor.
CURSOR_SQL	VARCHAR2	(1500)		The cursor SQL. Results from this SQL when executed will form the UWQ Nodes.
CURSOR_KEY_COL	VARCHAR2	(30)		The key column that will be used to form the where clause in the cursor based SQL.
ENABLED_FLAG	VARCHAR2	(1)		Flag to Enable / Disable a Node.
CREATION_DATE	DATE		Yes	Standard Who Column.
CREATED_BY	NUMBER		Yes	Standard Who Column.
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column.
LAST_UPDATED_BY	NUMBER		Yes	Standard Who Column.
LAST_UPDATE_LOGIN	NUMBER		Yes	Standard Who Column.
OBJECT_VERSION_NUMBER	NUMBER		Yes	Object Version number.
SECURITY_GROUP_ID	NUMBER			Used for Application hosting.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT NODE_ID
,      NODE_VIEW
,      DATA_SOURCE
,      MEDIA_TYPE_ID
,      WHERE_CLAUSE
,      RES_CAT_ENUM_FLAG
,      NODE_TYPE
,      HIDE_IF_EMPTY
,      NODE_DEPTH
,      PARENT_ID
,      NODE_QUERY
,      CURSOR_SQL
,      CURSOR_KEY_COL
,      ENABLED_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
FROM CS.CS_SR_UWQ_NODES_B;

Dependencies

[top of page]

CS.CS_SR_UWQ_NODES_B does not reference any database object

CS.CS_SR_UWQ_NODES_B is referenced by following:

APPS: CS_SR_UWQ_NODES_B