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_EXPLNODES_AVAILVALUES_CV

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PS_NODE_ID	NUMBER	(15)		Structure Node ID
NAME	VARCHAR2	(1000)		Name of the node
PARENT_ID	NUMBER	(15)		ID of the parent node within its model
INITIAL_VALUE	VARCHAR2	(4000)		Initial value for the node (see description of CZ_PS_NODES table)
MINIMUM	NUMBER			Minimum value for the node (see description of CZ_PS_NODES table)
MAXIMUM	NUMBER			Maximum value for the node (see description of CZ_PS_NODES table)
PS_NODE_TYPE	NUMBER	(9)		Data type of this structure node.
FEATURE_TYPE	NUMBER	(9)		Feature type of this node if applicable.
REFERENCE_ID	NUMBER	(15)		For connector or reference nodes, holds the ID of the target node.
MINIMUM_SELECTED	NUMBER	(9)		Minimum selected instances for this node (see description of CZ_PS_NODES table)
MAXIMUM_SELECTED	NUMBER	(9)		Maximum selected instances for this node (see description of CZ_PS_NODES table)
PSN_CREATION_DATE	DATE			Date the structure node was created.
PSN_LAST_UPDATE_DATE	DATE			Date this structure node was last updated.
EFFECTIVE_USAGE_MASK	VARCHAR2	(16)		Usage mask for this node.
EFFECTIVE_FROM	DATE			Effectivity start for this node
EFFECTIVE_UNTIL	DATE			Effectivity end for this node
EFFECTIVITY_SET_ID	NUMBER	(9)		Effectivity set for this node if any
UI_OMIT	VARCHAR2	(1)		Flag instructing UI Gen to ignore this node and omit it from generated user interfaces.
TREE_SEQ	NUMBER	(9)		sequence of this structure node with regard to its parent node
DEVL_PROJECT_ID	NUMBER	(15)		model in which this structure node resides
INTL_TEXT_ID	NUMBER	(15)		reference to the translateable text carrying this node's description
TEXT_STR	VARCHAR2	(2000)		localized text with this node's description
CHILD_MODEL_EXPL_ID	NUMBER			explosion ID of this node/explosion in this node's enclosing model that is directly referenced by the current root model (MODEL_ID)
MODEL_REF_EXPL_ID	NUMBER			explosion ID of this instance of the node in the current root model (MODEL_ID)
MODEL_ID	NUMBER	(15)		Current root model with reference to which this node is listed.
PARENT_EXPL_NODE_ID	NUMBER	(9)		Parent explosion node of the current explosion node in the current root model.
PSN_COMPONENT_ID	NUMBER			Component ID for this node
XPL_VIRTUAL_FLAG	VARCHAR2	(1)		Virtual flag for this component in the context of the current explosion node
NODE_DEPTH	NUMBER			Depth of this component under the root model.
EFFECTIVE_PARENT_ID	NUMBER			"Effective" parent ID is the psnode ID of this instance of the psnode in its current context. Always null in the current model's root node. In the root node of a connected child model, this points to the enclosing model's connector. In the top-level children of a referenced child model, this points to the enclosing model's reference node. Root nodes of referenced models are not displayed. All other nodes -- depth 2 and higher in the current root model or connected child models, depth 3 and higher in referenced child models -- bear the "local" PARENT_ID value.
PARENT_PSNODE_EXPL_ID	NUMBER			Explosion ID carried by the EFFECTIVE_PARENT_ID in this node's current explosion context.
FULL_IMAGE_PATH	VARCHAR2	(4000)		Full path for the icon for this node type.
ALT_TEXT	VARCHAR2	(2000)		"Alt Text" description of the icon for this node type.
DETAILED_TYPE_ID	NUMBER			Detailed type of this node, e.g. Decimal BOM Standard Item.
NODE_DISABLED_FLAG	NUMBER			INDICATOR VARIABLE: if '0', this node CAN provide a value compatible with type P_DATA_TYPE, collection status P_COLLECTION_FLAG, mutable status P_MUTABLE_FLAG, and which comes from the requested P_SYSPROP_RULETYPE
P_DATA_TYPE	NUMBER		Yes	Data type against which the current node is tested.
P_COLLECTION_FLAG	CHAR	(1)		Collection flag against which the current node is tested.
P_MUTABLE_FLAG	CHAR	(1)		Mutable flag against which the current node is tested.
P_SYSPROP_RULETYPE	NUMBER			Type of system property for which this test result applies (500 -- "regular" CDL system properties; 501 -- Java system properties; -1 -- all system properties excluded from check)

Query Text

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


SELECT PS_NODE_ID
,      NAME
,      PARENT_ID
,      INITIAL_VALUE
,      MINIMUM
,      MAXIMUM
,      PS_NODE_TYPE
,      FEATURE_TYPE
,      REFERENCE_ID
,      MINIMUM_SELECTED
,      MAXIMUM_SELECTED
,      PSN_CREATION_DATE
,      PSN_LAST_UPDATE_DATE
,      EFFECTIVE_USAGE_MASK
,      EFFECTIVE_FROM
,      EFFECTIVE_UNTIL
,      EFFECTIVITY_SET_ID
,      UI_OMIT
,      TREE_SEQ
,      DEVL_PROJECT_ID
,      INTL_TEXT_ID
,      TEXT_STR
,      CHILD_MODEL_EXPL_ID
,      MODEL_REF_EXPL_ID
,      MODEL_ID
,      PARENT_EXPL_NODE_ID
,      PSN_COMPONENT_ID
,      XPL_VIRTUAL_FLAG
,      NODE_DEPTH
,      EFFECTIVE_PARENT_ID
,      PARENT_PSNODE_EXPL_ID
,      FULL_IMAGE_PATH
,      ALT_TEXT
,      DETAILED_TYPE_ID
,      NODE_DISABLED_FLAG
,      P_DATA_TYPE
,      P_COLLECTION_FLAG
,      P_MUTABLE_FLAG
,      P_SYSPROP_RULETYPE
FROM APPS.CZ_EXPLNODES_AVAILVALUES_CV;

Dependencies

[top of page]

APPS.CZ_EXPLNODES_AVAILVALUES_CV references the following:

APPS: CZ_DEVELOPER_UTILS_PVT - show dependent code; CZ_EXPLNODES_WITHIMAGES_V; CZ_PSNODE_PROPVAL_V; CZ_SIGNATURES; CZ_SYSTEM_PROPERTIES_V; CZ_TYPES - show dependent code; CZ_TYPE_RELATIONSHIPS; CZ_UTILS - show dependent code
PUBLIC: DUAL

APPS.CZ_EXPLNODES_AVAILVALUES_CV is not referenced by any database object