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_VALUES_EFF_CV

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
EFFECTIVITY_FILTER	CHAR	(1)
PS_NODE_ID	NUMBER	(15)
NAME	VARCHAR2	(1000)
PARENT_ID	NUMBER	(15)
INITIAL_VALUE	VARCHAR2	(4000)
MINIMUM	NUMBER
MAXIMUM	NUMBER
PS_NODE_TYPE	NUMBER	(9)
FEATURE_TYPE	NUMBER	(9)
REFERENCE_ID	NUMBER	(15)
MINIMUM_SELECTED	NUMBER	(9)
MAXIMUM_SELECTED	NUMBER	(9)
PSN_CREATION_DATE	DATE
PSN_LAST_UPDATE_DATE	DATE
EFFECTIVE_USAGE_MASK	VARCHAR2	(16)
EFFECTIVE_FROM	DATE
EFFECTIVE_UNTIL	DATE
EFFECTIVITY_SET_ID	NUMBER	(9)
UI_OMIT	VARCHAR2	(1)
TREE_SEQ	NUMBER	(9)
DEVL_PROJECT_ID	NUMBER	(15)
INTL_TEXT_ID	NUMBER	(15)
TEXT_STR	VARCHAR2	(2000)
CHILD_MODEL_EXPL_ID	NUMBER
MODEL_REF_EXPL_ID	NUMBER
MODEL_ID	NUMBER	(15)
PARENT_EXPL_NODE_ID	NUMBER	(9)
PSN_COMPONENT_ID	NUMBER
XPL_VIRTUAL_FLAG	VARCHAR2	(1)
NODE_DEPTH	NUMBER
EFFECTIVE_PARENT_ID	NUMBER
PARENT_PSNODE_EXPL_ID	NUMBER
FULL_IMAGE_PATH	VARCHAR2	(4000)
ALT_TEXT	VARCHAR2	(2000)
DETAILED_TYPE_ID	NUMBER
NODE_DISABLED_FLAG	NUMBER
P_DATA_TYPE	NUMBER		Yes
P_COLLECTION_FLAG	CHAR	(1)
P_MUTABLE_FLAG	CHAR	(1)
P_SYSPROP_RULETYPE	NUMBER

Query Text

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


SELECT EFFECTIVITY_FILTER
,      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_VALUES_EFF_CV;

Dependencies

[top of page]

APPS.CZ_EXPLNODES_VALUES_EFF_CV references the following:

APPS: CZ_DEVELOPER_UTILS_PVT - show dependent code; CZ_EXPLNODES_IMAGE_EFF_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_VALUES_EFF_CV is not referenced by any database object