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: CZ.CZ_EXPRESSION_NODES#

Object Details

Object Name:	CZ_EXPRESSION_NODES#
Object Type:	VIEW
Owner:	CZ
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
LAST_UPDATE_LOGIN	NUMBER
EXPR_NODE_ID	NUMBER		Yes
EXPRESS_ID	NUMBER	(9)
SEQ_NBR	NUMBER	(9)	Yes
ITEM_TYPE_ID	NUMBER	(9)
PS_NODE_ID	NUMBER	(15)
ITEM_ID	NUMBER	(9)
FILTER_SET_ID	NUMBER	(9)
GRID_COL_ID	NUMBER	(9)
EXPR_PARENT_ID	NUMBER
PROPERTY_ID	NUMBER	(9)
COMPILE_ADVICE	NUMBER	(9)
COL	NUMBER	(9)
DATA_VALUE	VARCHAR2	(255)
FIELD_NAME	VARCHAR2	(80)
EXPR_TYPE	NUMBER	(9)	Yes
EXPR_SUBTYPE	NUMBER	(9)
TOKEN_LIST_SEQ	NUMBER	(9)
CREATION_DATE	DATE		Yes
LAST_UPDATE_DATE	DATE		Yes
DELETED_FLAG	VARCHAR2	(1)	Yes
EFF_FROM	DATE
EFF_TO	DATE
CREATED_BY	NUMBER	(15)	Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
SECURITY_MASK	VARCHAR2	(40)
EFF_MASK	VARCHAR2	(40)
CHECKOUT_USER	VARCHAR2	(40)
CONSEQUENT_FLAG	VARCHAR2	(1)
MODEL_REF_EXPL_ID	NUMBER	(9)
RULE_ID	NUMBER		Yes
TEMPLATE_ID	NUMBER
ARGUMENT_SIGNATURE_ID	NUMBER
ARGUMENT_INDEX	NUMBER
PARAM_SIGNATURE_ID	NUMBER
PARAM_INDEX	NUMBER
ARGUMENT_NAME	VARCHAR2	(2000)
DATA_TYPE	NUMBER
DISPLAY_NODE_DEPTH	NUMBER
COLLECTION_FLAG	VARCHAR2	(1)
SOURCE_OFFSET	NUMBER
SOURCE_LENGTH	NUMBER
RELATIVE_NODE_PATH	VARCHAR2	(4000)
MUTABLE_FLAG	VARCHAR2	(1)
EVENT_EXECUTION_SCOPE	NUMBER
DATA_NUM_VALUE	NUMBER
SEEDED_FLAG	VARCHAR2	(1)	Yes
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT LAST_UPDATE_LOGIN
,      EXPR_NODE_ID
,      EXPRESS_ID
,      SEQ_NBR
,      ITEM_TYPE_ID
,      PS_NODE_ID
,      ITEM_ID
,      FILTER_SET_ID
,      GRID_COL_ID
,      EXPR_PARENT_ID
,      PROPERTY_ID
,      COMPILE_ADVICE
,      COL
,      DATA_VALUE
,      FIELD_NAME
,      EXPR_TYPE
,      EXPR_SUBTYPE
,      TOKEN_LIST_SEQ
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      DELETED_FLAG
,      EFF_FROM
,      EFF_TO
,      CREATED_BY
,      LAST_UPDATED_BY
,      SECURITY_MASK
,      EFF_MASK
,      CHECKOUT_USER
,      CONSEQUENT_FLAG
,      MODEL_REF_EXPL_ID
,      RULE_ID
,      TEMPLATE_ID
,      ARGUMENT_SIGNATURE_ID
,      ARGUMENT_INDEX
,      PARAM_SIGNATURE_ID
,      PARAM_INDEX
,      ARGUMENT_NAME
,      DATA_TYPE
,      DISPLAY_NODE_DEPTH
,      COLLECTION_FLAG
,      SOURCE_OFFSET
,      SOURCE_LENGTH
,      RELATIVE_NODE_PATH
,      MUTABLE_FLAG
,      EVENT_EXECUTION_SCOPE
,      DATA_NUM_VALUE
,      SEEDED_FLAG
,      ZD_EDITION_NAME
FROM CZ.CZ_EXPRESSION_NODES#;

Dependencies

[top of page]

CZ.CZ_EXPRESSION_NODES# references the following:

CZ: CZ_EXPRESSION_NODES

CZ.CZ_EXPRESSION_NODES# is referenced by following:

APPS: CZ_EXPRESSION_NODES; CZ_EXPRESSION_NODES+; CZ_EXPRESSION_NODES_T1; CZ_EXPRESSION_NODES_T2