DBA Data[Home] [Help] [Dependency Information]

VIEW: CZ.CZ_RULE_FOLDERS#

Object Details
Object Name: CZ_RULE_FOLDERS#
Object Type: VIEW
Owner: CZ
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
RULE_FOLDER_ID NUMBER (9) Yes
NAME VARCHAR2 (255) Yes
DESC_TEXT VARCHAR2 (2000)
PARENT_RULE_FOLDER_ID NUMBER (9)
DEVL_PROJECT_ID NUMBER (15) Yes
TREE_SEQ NUMBER (15) Yes
DELETED_FLAG VARCHAR2 (1) Yes
EFF_TO DATE

EFF_FROM DATE

EFF_MASK VARCHAR2 (40)
CHECKOUT_USER VARCHAR2 (100)
SECURITY_MASK VARCHAR2 (40)
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
FOLDER_TYPE NUMBER (9)
EFFECTIVE_USAGE_MASK VARCHAR2 (16) Yes
EFFECTIVE_FROM DATE

EFFECTIVE_UNTIL DATE

PERSISTENT_RULE_FOLDER_ID NUMBER (9) Yes
EFFECTIVITY_SET_ID NUMBER (9)
OBJECT_TYPE VARCHAR2 (3) Yes
DISABLED_FLAG VARCHAR2 (1) Yes
ORIG_SYS_REF VARCHAR2 (255)
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# references the following:

SchemaCZ
TableCZ_RULE_FOLDERS
CZ.CZ_RULE_FOLDERS# is referenced by following:

SchemaAPPS
SynonymCZ_RULE_FOLDERS
TriggerCZ_RULE_FOLDERS_T1
TriggerCZ_RULE_FOLDERS_T2
TriggerCZ_RULE_FOLDERS_TP1