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: CZ.CZ_RULE_FOLDERS

Object Details

Object Name:	CZ_RULE_FOLDERS
Object Type:	TABLE
Owner:	CZ
FND Design Data:	CZ.CZ_RULE_FOLDERS
Subobject Name:
Status:	VALID

This table groups Rules for a project into Rule Folders. It also holds Rule SEQUENCES.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Primary Key: CZ_RULE_FOLDERS_PK

RULE_FOLDER_ID
OBJECT_TYPE

Indexes

Index	Type	Uniqueness	Tablespace	Column
CZ_RULE_FOLDERS_PK	NORMAL	UNIQUE	APPS_TS_SEED	RULE_FOLDER_ID OBJECT_TYPE
CZ_RULE_FOLDERS_N2	NORMAL	NONUNIQUE	APPS_TS_SEED	DELETED_FLAG OBJECT_TYPE RULE_FOLDER_ID
CZ_RULE_FOLDERS_N3	NORMAL	NONUNIQUE	APPS_TS_SEED	PARENT_RULE_FOLDER_ID DELETED_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
RULE_FOLDER_ID	NUMBER	(9)	Yes	Identifies this rule folder
NAME	VARCHAR2	(255)	Yes	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)	Yes	Identifies the project/model associated with this record
TREE_SEQ	NUMBER	(15)	Yes	Provides an ordering among rule folders under the same parent rule folder
DELETED_FLAG	VARCHAR2	(1)	Yes	Standard flag; '0' indicates the record is active, '1' means deleted. Other values are reserved
EFF_TO	DATE			UNUSED
EFF_FROM	DATE			UNUSED
EFF_MASK	VARCHAR2	(40)		UNUSED
CHECKOUT_USER	VARCHAR2	(100)		UNUSED
SECURITY_MASK	VARCHAR2	(40)		UNUSED
CREATION_DATE	DATE		Yes	Standard field recording the date this record was created
CREATED_BY	NUMBER	(15)	Yes	Standard field recording the ID of the user that created this record
LAST_UPDATE_DATE	DATE		Yes	Standard field recording the date/time this record was last updated
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard field recording the ID of the user that last updated this record
LAST_UPDATE_LOGIN	NUMBER	(15)		Records the login ID under which this record was last updated
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)	Yes	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)	Yes	Persistent ID (preserved in copies) of this rule folder
EFFECTIVITY_SET_ID	NUMBER	(9)		Identifies the named effectivity set associated with this record
OBJECT_TYPE	VARCHAR2	(3)	Yes	PK. Type of the rule entity:
DISABLED_FLAG	VARCHAR2	(1)	Yes	'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

Query Text

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


SELECT RULE_FOLDER_ID
,      NAME
,      DESC_TEXT
,      PARENT_RULE_FOLDER_ID
,      DEVL_PROJECT_ID
,      TREE_SEQ
,      DELETED_FLAG
,      EFF_TO
,      EFF_FROM
,      EFF_MASK
,      CHECKOUT_USER
,      SECURITY_MASK
,      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
FROM CZ.CZ_RULE_FOLDERS;

Dependencies

[top of page]

CZ.CZ_RULE_FOLDERS does not reference any database object

CZ.CZ_RULE_FOLDERS is referenced by following:

APPS: CZ_RULE_FOLDERS; CZ_RULE_FOLDERS_T1; CZ_RULE_FOLDERS_T2; CZ_RULE_FOLDERS_TP1