[Home] [Help] [Dependency Information]
Object Name: | CZ_PSN_TYPED_RULE_REFS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CZ.CZ_PSN_TYPED_RULE_REFS_V |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MODEL_ID | NUMBER | (15) | ||
PSN_EXPL_ID | NUMBER | |||
PSN_MODEL_ID | NUMBER | (15) | ||
REFERENCED_RULE_FLAG | VARCHAR2 | (1) | ||
RULE_IN_ENCLOSING_MODEL_FLAG | VARCHAR2 | (1) | ||
PS_NODE_ID | NUMBER | (15) | ||
PSN_PS_NODE_TYPE | NUMBER | (9) | ||
PARENT_ID | NUMBER | (15) | ||
PS_NODE_NAME | VARCHAR2 | (1000) | ||
RULE_DEVL_PROJECT_ID | NUMBER | (15) | ||
RULE_ID | NUMBER | (9) | Associates this record with a modelling Rule | |
RULE_FOLDER_ID | NUMBER | (9) | ||
RULE_FOLDER_TYPE | NUMBER | (9) | ||
RULE_NAME | VARCHAR2 | (255) | The name of this object | |
RULE_TYPE | NUMBER | 21 - Logic Rule; 22 - Numeric Rule; 23 - Compat Rule; 24 - Compat Table; 25 - Func Preselect; 26 - Func Validate; 27 - Comparison Rule; 28 - RULETYPE; 29 - Func Comp; 30 - Design Chart Rule | ||
RULE_DISABLED_FLAG | VARCHAR2 | (1) | ||
RULE_MODEL_ID | NUMBER | (15) | Yes | Identifies the project/model associated with this record |
DETAILED_RULE_TYPE | NUMBER | |||
RULETYPE_DATATYPE | NUMBER | |||
EXPR_ROOT_RULE_TEMPLATE_ID | NUMBER | |||
RULE_TYPE_CODE | VARCHAR2 | (255) | ||
RULE_TYPE_LABEL | VARCHAR2 | (255) | ||
RULE_TYPE_DESCRIPTION | VARCHAR2 | (4000) | ||
PERSISTENT_RULE_ID | NUMBER | (9) | Persistent ID (preserved in copies) of this rule | |
RULE_DESCRIPTION | VARCHAR2 | (2000) | Descriptive text | |
RULE_SEQ_NBR_IN_FOLDER | NUMBER | (9) | Yes | Provides an ordering among rules within a rule folder |
RULE_SIGNATURE_ID | NUMBER | In case of TEMPLATE_DEFINITION this points to the signature definition of the template | ||
MUTABLE_FLAG | VARCHAR2 | (1) | Default value of '0'. | |
TEMPLATE_PRIMITIVE_FLAG | VARCHAR2 | (1) | In case of TEMPLATE_DEFINITION this field specifies whether this template is a primitive template: | |
TEMPLATE_TOKEN | VARCHAR2 | (30) | In case of TEMPLATE_DEFINITION this field stores the token of the template. In case of function-like templates, template_token=name. | |
PRESENTATION_FLAG | VARCHAR2 | (1) | Presentation form of the rule: | |
RULE_TEXT | CHAR | (1) | ||
RULE_COMPONENT_ID | NUMBER | (15) | UNUSED | |
RULE_EXPL_ID | NUMBER | For FC rule | ||
RULE_NOTES | CHAR | (2) | ||
CLASS_NAME | VARCHAR2 | (2000) | Fully qualified FC class name | |
INSTANTIATION_SCOPE | NUMBER | FC rule instantiation scope | ||
REASON_ID | NUMBER | (9) | Contains a reference to a CZ_LOCALIZED_TEXTS record containing a message to be presented to the user when this rule is violated | |
REASON_TYPE | NUMBER | (15) | Indicates the type of message referenced by REASON_ID: 0 - Name of the rule; 1- a declarative statement; 2 - the description of the rule; 3 - custom rule type | |
UNSATISFIED_MSG_ID | NUMBER | FK to CZ_LOCALIZED_TEXTS. Holds description of rule to be used in displaying a message about the rule being unsatisfied. | ||
UNSATISFIED_MSG_SOURCE | VARCHAR2 | (1) | Indicates where the message text comes from -- rule name (1), rule description (2), custom (3) or none (0). | |
RULE_INVALID_FLAG | VARCHAR2 | (1) | Yes | '1' indicates this rule is invalid; '0' indicates it is valid |
RULE_EFFECTIVE_FROM | DATE | Date beginning on which this data is effective | ||
RULE_EFFECTIVE_UNTIL | DATE | Date at which this data is no longer effective. Note this is EXCLUSIVE. | ||
RULE_EFFECTIVE_USAGE_MASK | VARCHAR2 | (16) | Yes | Hexadecimal-encoded bit map identifying Usages for which this record is INEFFECTIVE |
RULE_EFFECTIVITY_SET_ID | NUMBER | (9) | Identifies the named effectivity set associated with this record | |
RULE_CHECKOUT_USER | VARCHAR2 | (40) | UNUSED |
Cut, paste (and edit) the following text to query this object:
SELECT MODEL_ID
, PSN_EXPL_ID
, PSN_MODEL_ID
, REFERENCED_RULE_FLAG
, RULE_IN_ENCLOSING_MODEL_FLAG
, PS_NODE_ID
, PSN_PS_NODE_TYPE
, PARENT_ID
, PS_NODE_NAME
, RULE_DEVL_PROJECT_ID
, RULE_ID
, RULE_FOLDER_ID
, RULE_FOLDER_TYPE
, RULE_NAME
, RULE_TYPE
, RULE_DISABLED_FLAG
, RULE_MODEL_ID
, DETAILED_RULE_TYPE
, RULETYPE_DATATYPE
, EXPR_ROOT_RULE_TEMPLATE_ID
, RULE_TYPE_CODE
, RULE_TYPE_LABEL
, RULE_TYPE_DESCRIPTION
, PERSISTENT_RULE_ID
, RULE_DESCRIPTION
, RULE_SEQ_NBR_IN_FOLDER
, RULE_SIGNATURE_ID
, MUTABLE_FLAG
, TEMPLATE_PRIMITIVE_FLAG
, TEMPLATE_TOKEN
, PRESENTATION_FLAG
, RULE_TEXT
, RULE_COMPONENT_ID
, RULE_EXPL_ID
, RULE_NOTES
, CLASS_NAME
, INSTANTIATION_SCOPE
, REASON_ID
, REASON_TYPE
, UNSATISFIED_MSG_ID
, UNSATISFIED_MSG_SOURCE
, RULE_INVALID_FLAG
, RULE_EFFECTIVE_FROM
, RULE_EFFECTIVE_UNTIL
, RULE_EFFECTIVE_USAGE_MASK
, RULE_EFFECTIVITY_SET_ID
, RULE_CHECKOUT_USER
FROM APPS.CZ_PSN_TYPED_RULE_REFS_V;
APPS.CZ_PSN_TYPED_RULE_REFS_V is not referenced by any database object
|
|
|