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.CZ_RULE_EXPRESSION_V

Object Details

Object Name:	CZ_RULE_EXPRESSION_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CZ.CZ_RULE_EXPRESSION_V
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
RULE_ID	NUMBER	(9)	Yes
RULE_NAME	VARCHAR2	(255)
RULE_TYPE	NUMBER	(9)	Yes
RULE_FOLDER_TYPE	NUMBER	(9)
RULE_TYPE_DESC	VARCHAR2	(58)
EXPR_NODE_ID	NUMBER		Yes
EXPR_PARENT_ID	NUMBER	(9)
EXPR_TYPE	NUMBER	(9)	Yes
EXPRNODE_DESC	VARCHAR2	(4000)
EXPR_TYPE_DESC	VARCHAR2	(255)
DATA_VALUE	VARCHAR2	(255)
DATA_NUM_VALUE	NUMBER
EXPRESS_ID	NUMBER	(9)

Query Text

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


SELECT RULE_ID
,      RULE_NAME
,      RULE_TYPE
,      RULE_FOLDER_TYPE
,      RULE_TYPE_DESC
,      EXPR_NODE_ID
,      EXPR_PARENT_ID
,      EXPR_TYPE
,      EXPRNODE_DESC
,      EXPR_TYPE_DESC
,      DATA_VALUE
,      DATA_NUM_VALUE
,      EXPRESS_ID
FROM APPS.CZ_RULE_EXPRESSION_V;

Dependencies

[top of page]

APPS.CZ_RULE_EXPRESSION_V references the following:

APPS: CZ_CREATERULEOBJECT_LKV; CZ_EXNEXPRTYPE_LKV; CZ_EXPRESSION_NODES; CZ_PROPERTIES; CZ_PS_NODES; CZ_RULES

APPS.CZ_RULE_EXPRESSION_V is not referenced by any database object