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_PSNODES_FOR_UIELEMS_CV

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PS_NODE_ID	NUMBER	(15)
NAME	VARCHAR2	(1000)
INITIAL_VALUE	VARCHAR2	(4000)
PARENT_ID	NUMBER	(15)
MINIMUM	NUMBER
MAXIMUM	NUMBER
FEATURE_TYPE	NUMBER	(9)
MINIMUM_SELECTED	NUMBER	(9)
MAXIMUM_SELECTED	NUMBER	(9)
PSN_CREATION_DATE	DATE
PSN_CREATED_BY	NUMBER	(15)
PSN_LAST_UPDATE_DATE	DATE
EFFECTIVE_USAGE_MASK	VARCHAR2	(16)
EFFECTIVE_FROM	DATE
EFFECTIVE_UNTIL	DATE
DEVL_PROJECT_ID	NUMBER	(15)
INTL_TEXT_ID	NUMBER	(15)
UI_OMIT	VARCHAR2	(1)
PARENT_EXPL_NODE_ID	NUMBER	(9)
NODE_DEPTH	NUMBER
PARENT_PSNODE_EXPL_ID	NUMBER
FULL_IMAGE_PATH	VARCHAR2	(4000)
ALT_TEXT	VARCHAR2	(2000)
TEXT_STR	VARCHAR2	(2000)
CHILD_MODEL_EXPL_ID	NUMBER
TREE_SEQ	NUMBER	(9)
PSN_COMPONENT_ID	NUMBER
XPL_VIRTUAL_FLAG	VARCHAR2	(1)
MODEL_REF_EXPL_ID	NUMBER
INSTANTIABLE_FLAG	VARCHAR2	(1)		From underlying CZ_PS_NODES record. INSTANTIABLE_FLAG records the user's intended instantiation behavior for Component and Reference structure nodes. '1' indicates an Optional node (minimum 0 instances, maximum 1 instance); '2' indicates a Mandatory or Single instance (1, 1) node; '4' indicates a Multiply-Instantiable node, allowing a maximum of two or more instances. Also, the value '3' is used for Connectors.
COUNTED_OPTIONS_FLAG	VARCHAR2	(1)
PS_NODE_TYPE	NUMBER	(9)
REFERENCE_ID	NUMBER	(15)
EFFECTIVE_PARENT_ID	NUMBER
MODEL_ID	NUMBER	(15)
PERSISTENT_NODE_ID	NUMBER	(15)
P_PAGE_ELEMENT_TYPE	NUMBER		Yes
NODE_DISABLED_FLAG	NUMBER
UI_TYPE	NUMBER
DETAILED_TYPE_ID	NUMBER
EFFECTIVITY_SET_ID	NUMBER	(9)

Query Text

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


SELECT PS_NODE_ID
,      NAME
,      INITIAL_VALUE
,      PARENT_ID
,      MINIMUM
,      MAXIMUM
,      FEATURE_TYPE
,      MINIMUM_SELECTED
,      MAXIMUM_SELECTED
,      PSN_CREATION_DATE
,      PSN_CREATED_BY
,      PSN_LAST_UPDATE_DATE
,      EFFECTIVE_USAGE_MASK
,      EFFECTIVE_FROM
,      EFFECTIVE_UNTIL
,      DEVL_PROJECT_ID
,      INTL_TEXT_ID
,      UI_OMIT
,      PARENT_EXPL_NODE_ID
,      NODE_DEPTH
,      PARENT_PSNODE_EXPL_ID
,      FULL_IMAGE_PATH
,      ALT_TEXT
,      TEXT_STR
,      CHILD_MODEL_EXPL_ID
,      TREE_SEQ
,      PSN_COMPONENT_ID
,      XPL_VIRTUAL_FLAG
,      MODEL_REF_EXPL_ID
,      INSTANTIABLE_FLAG
,      COUNTED_OPTIONS_FLAG
,      PS_NODE_TYPE
,      REFERENCE_ID
,      EFFECTIVE_PARENT_ID
,      MODEL_ID
,      PERSISTENT_NODE_ID
,      P_PAGE_ELEMENT_TYPE
,      NODE_DISABLED_FLAG
,      UI_TYPE
,      DETAILED_TYPE_ID
,      EFFECTIVITY_SET_ID
FROM APPS.CZ_PSNODES_FOR_UIELEMS_CV;

Dependencies

[top of page]

APPS.CZ_PSNODES_FOR_UIELEMS_CV references the following:

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

APPS.CZ_PSNODES_FOR_UIELEMS_CV is not referenced by any database object