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_MODEL_ALL_RULEFOLDERS_V

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
MODEL_ID	NUMBER	(15)	Yes
NODE_DEPTH	NUMBER
RULE_FOLDER_ID	NUMBER	(9)		Identifies this rule folder
NAME	VARCHAR2	(255)		The name of this rule folder
DESC_TEXT	VARCHAR2	(2000)		Describes the rule folder
PARENT_RULE_FOLDER_ID	NUMBER	(9)		Identifies the rule folder that encloses this rule folder
DEVL_PROJECT_ID	NUMBER	(15)		Identifies the project/model associated with this record
REFERENCED_RULE_FOLDER_FLAG	VARCHAR2	(1)
TREE_SEQ	NUMBER			Provides an ordering among rule folders under the same parent rule folder
DELETED_FLAG	VARCHAR2	(1)		Standard flag; '0' indicates the record is active, '1' means deleted. Other values are reserved
CREATION_DATE	DATE			Standard field recording the date this record was created
CREATED_BY	NUMBER	(15)		Standard field recording the ID of the user that created this record
LAST_UPDATE_DATE	DATE			Standard field recording the date/time this record was last updated
LAST_UPDATED_BY	NUMBER	(15)		Standard field recording the ID of the user that last updated this record
LAST_UPDATE_LOGIN	NUMBER	(15)
FOLDER_TYPE	NUMBER	(9)		Indicates what type of rule folder this record is: 0 - standard rule folder; 1 - rule sequence
EFFECTIVE_USAGE_MASK	VARCHAR2	(16)		Hexadecimal-encoded bit map identifying Usages for which this record is INEFFECTIVE
EFFECTIVE_FROM	DATE			Date beginning on which this data is effective
EFFECTIVE_UNTIL	DATE			Date at which this data is no longer effective. Note this is EXCLUSIVE.
PERSISTENT_RULE_FOLDER_ID	NUMBER	(9)		Persistent ID (preserved in copies) of this rule folder
EFFECTIVITY_SET_ID	NUMBER	(9)
OBJECT_TYPE	VARCHAR2	(255)		PK. Type of the rule entity:
DISABLED_FLAG	VARCHAR2	(1)		'1' = disabled '0' = enabled (default)
ORIG_SYS_REF	VARCHAR2	(255)		Holds the key information by which an imported record can be identified in its source database
DETAILED_RULE_TYPE	NUMBER
RULE_TYPE_LABEL	VARCHAR2	(255)
RULE_TYPE_DESCRIPTION	VARCHAR2	(4000)
INVALID_FLAG	VARCHAR2	(1)
PRESENTATION_FLAG	VARCHAR2	(1)
RULE_TYPE	NUMBER
SEQ_NBR	NUMBER
RULE_CLASS	NUMBER
CLASS_SEQ	NUMBER

Query Text

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


SELECT MODEL_ID
,      NODE_DEPTH
,      RULE_FOLDER_ID
,      NAME
,      DESC_TEXT
,      PARENT_RULE_FOLDER_ID
,      DEVL_PROJECT_ID
,      REFERENCED_RULE_FOLDER_FLAG
,      TREE_SEQ
,      DELETED_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      FOLDER_TYPE
,      EFFECTIVE_USAGE_MASK
,      EFFECTIVE_FROM
,      EFFECTIVE_UNTIL
,      PERSISTENT_RULE_FOLDER_ID
,      EFFECTIVITY_SET_ID
,      OBJECT_TYPE
,      DISABLED_FLAG
,      ORIG_SYS_REF
,      DETAILED_RULE_TYPE
,      RULE_TYPE_LABEL
,      RULE_TYPE_DESCRIPTION
,      INVALID_FLAG
,      PRESENTATION_FLAG
,      RULE_TYPE
,      SEQ_NBR
,      RULE_CLASS
,      CLASS_SEQ
FROM APPS.CZ_MODEL_ALL_RULEFOLDERS_V;

Dependencies

[top of page]

APPS.CZ_MODEL_ALL_RULEFOLDERS_V references the following:

APPS: CZ_MODEL_REF_EXPLS; CZ_RULETYPECODES_LKV; CZ_RULE_FOLDERS; CZ_TYPED_RULES_V

APPS.CZ_MODEL_ALL_RULEFOLDERS_V is referenced by following:

APPS: CZ_MODELRULEFOLDER_IMAGES_V