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_NODE_ALL_PROPERTIES_V

Object Details

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

[View Source]

Columns

Name	Datatype	Length
MODEL_ID	NUMBER	(15)
PARENT_PSNODE_EXPL_ID	NUMBER
EFFECTIVE_PARENT_ID	NUMBER
MODEL_REF_EXPL_ID	NUMBER
PS_NODE_ID	NUMBER	(15)
PS_NODE_TYPE	NUMBER	(9)
DETAILED_TYPE_ID	NUMBER
DETAILED_TYPE_LABEL	VARCHAR2	(2000)
PS_NODE_TYPE_IMAGE_PATH	VARCHAR2	(4000)
PS_NODE_NAME	VARCHAR2	(1000)
PS_NODE_DESCRIPTION	VARCHAR2	(2000)
PROPERTY_RULE_TYPE	NUMBER
PROPERTY_TYPE_CODE	VARCHAR2	(255)
PROPERTY_ID	NUMBER
PROPERTY_NAME	VARCHAR2	(4000)
PROPERTY_DATA_TYPE	NUMBER
PROPERTY_DATA_TYPE_NAME	VARCHAR2	(30)
PROPERTY_MUTABLE_FLAG	VARCHAR2	(1)
PROPERTY_COLLECTION_FLAG	VARCHAR2	(1)
DATA_TYPE_ID	NUMBER
DATA_TYPE_NAME	VARCHAR2	(30)

Query Text

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


SELECT MODEL_ID
,      PARENT_PSNODE_EXPL_ID
,      EFFECTIVE_PARENT_ID
,      MODEL_REF_EXPL_ID
,      PS_NODE_ID
,      PS_NODE_TYPE
,      DETAILED_TYPE_ID
,      DETAILED_TYPE_LABEL
,      PS_NODE_TYPE_IMAGE_PATH
,      PS_NODE_NAME
,      PS_NODE_DESCRIPTION
,      PROPERTY_RULE_TYPE
,      PROPERTY_TYPE_CODE
,      PROPERTY_ID
,      PROPERTY_NAME
,      PROPERTY_DATA_TYPE
,      PROPERTY_DATA_TYPE_NAME
,      PROPERTY_MUTABLE_FLAG
,      PROPERTY_COLLECTION_FLAG
,      DATA_TYPE_ID
,      DATA_TYPE_NAME
FROM APPS.CZ_NODE_ALL_PROPERTIES_V;

Dependencies

[top of page]

APPS.CZ_NODE_ALL_PROPERTIES_V references the following:

APPS: CZ_DEVELOPER_UTILS_PVT - show dependent code; CZ_EXPLNODES_WITHIMAGES_V; CZ_ITEM_MASTERS; CZ_ITEM_TYPE_PROPERTIES; CZ_PROPERTIES; CZ_PS_NODES; CZ_PS_PROP_VALS; CZ_SIGNATURES; CZ_SIGNATURE_SYSPROPS_V; CZ_TYPES - show dependent code; CZ_TYPE_RELATIONSHIPS; CZ_UTILS - show dependent code; FND_PROFILE - show dependent code

APPS.CZ_NODE_ALL_PROPERTIES_V is not referenced by any database object