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_WITH_UIREFS_V

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
MODEL_ID	NUMBER	(15)
PS_NODE_ID	NUMBER	(15)	Yes
PARENT_ID	NUMBER	(15)
PERSISTENT_NODE_ID	NUMBER	(15)	Yes
PS_NODE_TYPE	NUMBER	(9)	Yes
NAME	VARCHAR2	(1000)
UI_DEF_ID	NUMBER
PAGE_ID	NUMBER
ELEMENT_ID	VARCHAR2	(255)
PARENT_ELEMENT_ID	VARCHAR2	(255)
PAGE_STRUCTURE_NAME	VARCHAR2	(255)
STRUCT_SIGNATURE_ID	NUMBER
ELEMENT_TYPE	NUMBER
UI_STRUCT_CODE	CHAR	(3)
UI_DEF_NAME	VARCHAR2	(255)	Yes
UI_STYLE	VARCHAR2	(3)	Yes

Query Text

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


SELECT MODEL_ID
,      PS_NODE_ID
,      PARENT_ID
,      PERSISTENT_NODE_ID
,      PS_NODE_TYPE
,      NAME
,      UI_DEF_ID
,      PAGE_ID
,      ELEMENT_ID
,      PARENT_ELEMENT_ID
,      PAGE_STRUCTURE_NAME
,      STRUCT_SIGNATURE_ID
,      ELEMENT_TYPE
,      UI_STRUCT_CODE
,      UI_DEF_NAME
,      UI_STYLE
FROM APPS.CZ_PSNODE_WITH_UIREFS_V;

Dependencies

[top of page]

APPS.CZ_PSNODE_WITH_UIREFS_V references the following:

APPS: CZ_PS_NODES; CZ_UI_DEFS; CZ_UI_PAGES; CZ_UI_PAGE_ELEMENTS

APPS.CZ_PSNODE_WITH_UIREFS_V is referenced by following:

APPS: CZ_PSNODE_REFUI_IMAGES_V