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

VIEW: APPS.CZ_PSN_TYPED_RULE_REFS_V

Object Details
Object Name: CZ_PSN_TYPED_RULE_REFS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCZ.CZ_PSN_TYPED_RULE_REFS_V
Subobject Name:
Status: VALID

[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.CZ_PSN_TYPED_RULE_REFS_V references the following:

SchemaAPPS
ViewCZ_PSNODE_RULE_REFS_V
ViewCZ_TYPED_RULES_V
PL/SQL PackageCZ_UTILS - show dependent code

APPS.CZ_PSN_TYPED_RULE_REFS_V is not referenced by any database object