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]

VIEW: APPS.CS_SR_UWQ_NODES_VL

Object Details

Object Name:	CS_SR_UWQ_NODES_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CS.CS_SR_UWQ_NODES_VL
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

MultiLingual view (a language resolved view of the data.)

The base view for the form CSXNODES. This view shows all the user defined UWQ nodes for Service Request.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row Identifier
NODE_ID	NUMBER		Yes	The identifier of the node.
NODE_LABEL	VARCHAR2	(100)		The label on 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.
PARENT_LABEL	VARCHAR2	(100)		The label of the parent node.

Query Text

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


SELECT ROW_ID
,      NODE_ID
,      NODE_LABEL
,      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
,      PARENT_LABEL
FROM APPS.CS_SR_UWQ_NODES_VL;

Dependencies

[top of page]

APPS.CS_SR_UWQ_NODES_VL references the following:

APPS: CS_SR_UWQ_NODES_B; CS_SR_UWQ_NODES_TL

APPS.CS_SR_UWQ_NODES_VL is referenced by following:

APPS: SR_UWQ_INTEG - show dependent code