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 Mandatory 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:

SchemaAPPS
SynonymENI_DENORM_HIERARCHIES
SynonymFND_LOOKUP_VALUES
ViewMTL_CATEGORIES_V
SynonymMTL_DEFAULT_CATEGORY_SETS

APPS.ENI_ITEM_VBH_NODES_V is not referenced by any database object