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


VIEW: APPS.ENI_PROD_DENORM_HRCHY_V

Object Details
Object Name: ENI_PROD_DENORM_HRCHY_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 is based on the ENI_DENORM_HIERARCHIES tables, and contains the de-normalized Product hierarchy.


[View Source]

Columns
Name Datatype Length Mandatory Comments
CATEGORY_SET_ID NUMBER

The Object Identifier for the Category Set Object Type
PARENT_ID NUMBER

The Parent Catalog Category Identifier
IMM_CHILD_ID NUMBER

The Immediate Child Catalog Category Identifier
CHILD_ID NUMBER

The Child Catalog Category Identifier
TOP_NODE_FLAG VARCHAR2 (1)
This flag determines whether the catalog category is a Top Node in the Hierarchy
LEAF_NODE_FLAG VARCHAR2 (1)
This flag determines whether the catalog category is a Leaf Node in the Hierarchy
OLTP_FLAG VARCHAR2 (1)
This flag is used for OLTP/NON-DBI environments
DBI_FLAG VARCHAR2 (1)
This flag is used for DBI environments
CREATION_DATE DATE

The Creation Date for the row
LAST_UPDATE_DATE DATE

The Last Update Date for the row
Query Text

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


SELECT CATEGORY_SET_ID
,      PARENT_ID
,      IMM_CHILD_ID
,      CHILD_ID
,      TOP_NODE_FLAG
,      LEAF_NODE_FLAG
,      OLTP_FLAG
,      DBI_FLAG
,      CREATION_DATE
,      LAST_UPDATE_DATE
FROM APPS.ENI_PROD_DENORM_HRCHY_V;

Dependencies

[top of page]

APPS.ENI_PROD_DENORM_HRCHY_V references the following:

SchemaAPPS
SynonymENI_DENORM_HIERARCHIES
SynonymMTL_DEFAULT_CATEGORY_SETS
APPS.ENI_PROD_DENORM_HRCHY_V is referenced by following:

SchemaAPPS
ViewAST_LM_LEADS_QUICK_INT_PC_V
ViewAST_LM_OPP_QUICK_INTTYPES_V
ViewAS_FRCST_MGR_OPP_LINES_V
ViewAS_FRCST_REP_OPP_LINES_V
Package BodyOZF_ALLOCATION_ENGINE_PVT - show dependent code
Package BodyOZF_CUST_FACTS_PVT - show dependent code
Package BodyOZF_SCHEDULE_DENORM_PVT - show dependent code
Package BodyPV_CHECK_MATCH_PUB - show dependent code
Package BodyPV_CONTEXT_VALUES - show dependent code
Package BodyPV_REFERRAL_COMP_PUB - show dependent code