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

Object Details

Object Name:	ENI_ITEM_VBH_NODES_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view lists the immediate children and description of a parent category id in the product category hierarchy

[View Source]

Columns

Name	Datatype	Length	Comments
ID	NUMBER		The Catalog Category Identifier
VALUE	VARCHAR2	(406)	The Catalog Category Name
TOP_NODE_FLAG	VARCHAR2	(1)	This flag indicates whether the Catalog Category is a Top Node in the Hierarchy or not
PARENT_ID	NUMBER		The Parent Catalog Category Identifier
CHILD_ID	NUMBER		The Child Catalog Category Identifier
LEAF_NODE_FLAG	VARCHAR2	(1)	This flag indicates whether the Catalog Category is a Leaf Node in the Hierarchy
ITEM_ASSGN_FLAG	VARCHAR2	(1)	This flag indicates whether an Item has been assigned to the Catalog Category

Query Text

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


SELECT ID
,      VALUE
,      TOP_NODE_FLAG
,      PARENT_ID
,      CHILD_ID
,      LEAF_NODE_FLAG
,      ITEM_ASSGN_FLAG
FROM APPS.ENI_ITEM_VBH_NODES_V;

Dependencies

[top of page]

APPS.ENI_ITEM_VBH_NODES_V references the following:

APPS: ENI_DENORM_HIERARCHIES; FND_LOOKUP_VALUES; MTL_CATEGORIES_V; MTL_DEFAULT_CATEGORY_SETS

APPS.ENI_ITEM_VBH_NODES_V is not referenced by any database object