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]

VIEW: APPS.CZ_PSNODE_RULE_REFS_V

Object Details

Object Name:	CZ_PSNODE_RULE_REFS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CZ.CZ_PSNODE_RULE_REFS_V
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Comments
MODEL_ID	NUMBER	(15)
MODEL_REF_EXPL_ID	NUMBER
PS_NODE_ID	NUMBER	(15)
PSN_MODEL_ID	NUMBER	(15)
PSN_PS_NODE_TYPE	NUMBER	(9)
PARENT_ID	NUMBER	(15)
PS_NODE_NAME	VARCHAR2	(1000)
RULE_DEVL_PROJECT_ID	NUMBER	(15)
REFERENCED_RULE_FLAG	VARCHAR2	(1)
RULE_IN_ENCLOSING_MODEL_FLAG	VARCHAR2	(1)
RULE_ID	NUMBER	(9)
RULE_FOLDER_ID	NUMBER	(9)
RULE_FOLDER_TYPE	NUMBER	(9)
RULE_NAME	VARCHAR2	(255)
RULE_TYPE	NUMBER
RULE_TYPE_STRING	VARCHAR2	(255)
DESC_TEXT	VARCHAR2	(2000)
DISABLED_FLAG	VARCHAR2	(1)
PARENT_PSNODE_EXPL_ID	NUMBER
EFFECTIVE_PARENT_ID	NUMBER
DESCENDANT_EXPL_NODE_ID	NUMBER	(9)
DETAILED_RULE_TYPE	NUMBER
PARTICIPANT_ROLE_LIST	VARCHAR2	(49)
UNSATISFIED_MSG_SOURCE	VARCHAR2	(1)	Indicates where the message text comes from -- rule name (1), rule description (2), custom (3) or none (0).
REASON_ID	NUMBER		Contains a reference to a CZ_LOCALIZED_TEXTS record containing a message to be presented to the user when this rule is violated
INVALID_FLAG	VARCHAR2	(1)	'1' indicates this rule is invalid; '0' indicates it is valid
COMPONENT_ID	NUMBER	(15)	UNUSED
RULE_EXPL_NODE_ID	NUMBER
REASON_TYPE	NUMBER		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
ORIG_SYS_REF	VARCHAR2	(255)	Holds the key information by which an imported record can be identified in its source database
CHECKOUT_USER	VARCHAR2	(40)	UNUSED
SEQ_NBR	NUMBER		Provides an ordering among rules within a rule folder
EFFECTIVITY_SET_ID	NUMBER		Identifies the named effectivity set associated with this record
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.
EFFECTIVE_USAGE_MASK	VARCHAR2	(16)	Hexadecimal-encoded bit map identifying Usages for which this record is INEFFECTIVE
PERSISTENT_RULE_ID	NUMBER	(9)	Persistent ID (preserved in copies) of this rule
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.
TEMPLATE_PRIMITIVE_FLAG	VARCHAR2	(1)	In case of TEMPLATE_DEFINITION this field specifies whether this template is a primitive template:
PRESENTATION_FLAG	VARCHAR2	(1)	Presentation form of the rule:
SIGNATURE_ID	NUMBER
MUTABLE_FLAG	VARCHAR2	(1)
TEMPLATE_TOKEN	VARCHAR2	(30)
RULE_TEXT	CLOB	(4000)	Rule text (Corresponding to old cz_rule_texts.text)
NOTES	CLOB	(4000)	Notes about rule
CLASS_NAME	VARCHAR2	(2000)	Fully qualified FC class name
INSTANTIATION_SCOPE	NUMBER		FC rule instantiation scope
SEEDED_FLAG	VARCHAR2	(1)	'1' indicates this is a seeded expr node

Query Text

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


SELECT MODEL_ID
,      MODEL_REF_EXPL_ID
,      PS_NODE_ID
,      PSN_MODEL_ID
,      PSN_PS_NODE_TYPE
,      PARENT_ID
,      PS_NODE_NAME
,      RULE_DEVL_PROJECT_ID
,      REFERENCED_RULE_FLAG
,      RULE_IN_ENCLOSING_MODEL_FLAG
,      RULE_ID
,      RULE_FOLDER_ID
,      RULE_FOLDER_TYPE
,      RULE_NAME
,      RULE_TYPE
,      RULE_TYPE_STRING
,      DESC_TEXT
,      DISABLED_FLAG
,      PARENT_PSNODE_EXPL_ID
,      EFFECTIVE_PARENT_ID
,      DESCENDANT_EXPL_NODE_ID
,      DETAILED_RULE_TYPE
,      PARTICIPANT_ROLE_LIST
,      UNSATISFIED_MSG_SOURCE
,      REASON_ID
,      INVALID_FLAG
,      COMPONENT_ID
,      RULE_EXPL_NODE_ID
,      REASON_TYPE
,      ORIG_SYS_REF
,      CHECKOUT_USER
,      SEQ_NBR
,      EFFECTIVITY_SET_ID
,      EFFECTIVE_FROM
,      EFFECTIVE_UNTIL
,      EFFECTIVE_USAGE_MASK
,      PERSISTENT_RULE_ID
,      UNSATISFIED_MSG_ID
,      TEMPLATE_PRIMITIVE_FLAG
,      PRESENTATION_FLAG
,      SIGNATURE_ID
,      MUTABLE_FLAG
,      TEMPLATE_TOKEN
,      RULE_TEXT
,      NOTES
,      CLASS_NAME
,      INSTANTIATION_SCOPE
,      SEEDED_FLAG
FROM APPS.CZ_PSNODE_RULE_REFS_V;

Dependencies

[top of page]

APPS.CZ_PSNODE_RULE_REFS_V references the following:

APPS: CZ_DETAILEDRULETYPES_LKV; CZ_EXPLMODEL_NODES_V; CZ_FUNC_COMP_SPECS; CZ_MODEL_REF_EXPLS; CZ_RULES; CZ_RULE_FOLDERS; CZ_RULE_PARTICIPANTS_V; CZ_UTILS - show dependent code

APPS.CZ_PSNODE_RULE_REFS_V is referenced by following:

APPS: CZ_PSNODE_REFRULE_IMAGES_V; CZ_PSN_TYPED_RULE_REFS_V