[Home] [Help] [Dependency Information]
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 |
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 |
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;
|
|
|