Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.OKI_ENI_ITEM_VBH_NODES_V

Object Details
Object Name: OKI_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.

[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

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.OKI_ENI_ITEM_VBH_NODES_V;

Dependencies

[top of page]

APPS.OKI_ENI_ITEM_VBH_NODES_V references the following:

SchemaAPPS
ViewENI_ITEM_VBH_NODES_V

APPS.OKI_ENI_ITEM_VBH_NODES_V is not referenced by any database object