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.CSP_NAV_NODE_TYPES

Object Details

Object Name:	CSP_NAV_NODE_TYPES
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CSP.CSP_NAV_NODE_TYPES
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
TREE_ROOT_ID	NUMBER	(15)	Yes	Tree root identifier
NODE_TYPE_ID	NUMBER	(15)	Yes	Node type identifier
ROOT_KEY	VARCHAR2	(240)	Yes	Name of root node
NODE_TYPE	VARCHAR2	(240)	Yes	Node type
AK_FLOW_NAME	VARCHAR2	(30)		Name of the flow associated with the tree
AK_PARENT_PAGE_NAME	VARCHAR2	(30)		Parent page name in the flow
AK_PK_NAME	VARCHAR2	(30)		Primary key of the object
AK_WHERE_CLAUSE	VARCHAR2	(2000)		Optional where clause for the flow
AK_WHERE_BINDS	VARCHAR2	(2000)		Bind variables for the where clause
ICON_NAME	VARCHAR2	(30)		Icon name for the node
FORM_NAME	VARCHAR2	(30)		Name of the form to be called when node is activated
FORM_PARAM_LIST	VARCHAR2	(2000)		Parameters to be passed to the calling form
STATIC_CHILD_FLAG	VARCHAR2	(1)		Static child flag
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column - with the user id from FND_USER
CREATION_DATE	DATE		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column - with the user id from FND_USER
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column

Query Text

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


SELECT TREE_ROOT_ID
,      NODE_TYPE_ID
,      ROOT_KEY
,      NODE_TYPE
,      AK_FLOW_NAME
,      AK_PARENT_PAGE_NAME
,      AK_PK_NAME
,      AK_WHERE_CLAUSE
,      AK_WHERE_BINDS
,      ICON_NAME
,      FORM_NAME
,      FORM_PARAM_LIST
,      STATIC_CHILD_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM APPS.CSP_NAV_NODE_TYPES;

Dependencies

[top of page]

APPS.CSP_NAV_NODE_TYPES references the following:

APPS: JTF_NAV_NODE_TYPES_V

APPS.CSP_NAV_NODE_TYPES is referenced by following:

APPS: CSP_NOT_PLOOP_NAV; CSP_NOT_PLTYPES_NAV; CSP_NOT_STAT_ITEMS_NAV; CSP_NOT_TYSTAT_NAV; CSP_PACK_LIST_NAV; CSP_PARTS_LOOPS_NAV; CSP_PLIST_BOXES_NAV; CSP_PLIST_BOXITEMS_NAV; CSP_PLIST_ITMSLNO_NAV; CSP_PLIST_STATUS_NAV; CSP_PLN_ORG_NAV; CSP_PLN_REGIONS_NAV; CSP_PLN_REGION_ORG_NAV; CSP_REP_HIERARCHIES_NAV; CSP_REP_HIER_SECINV_NAV; CSP_SEC_INVENTORIES_NAV