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_PROD_DEN_HRCHY_PARENTS_V

Object Details

Object Name:	ENI_PROD_DEN_HRCHY_PARENTS_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_HRCHY_PARENTS table. It displays all Product categories from the table, alongwith their 'Sales and Marketing' attribute values.

[View Source]

Columns

Name	Datatype	Length	Comments
CATEGORY_SET_ID	NUMBER		The Category Set Identifier
FORECASTABLE_FLAG	VARCHAR2	(1)	This flag indicates whether the catalog category is included in Forecast
PURCHASE_INTEREST	VARCHAR2	(1)	This flag indicates whether the Catalog Category has an expected Purchase
LANGUAGE	VARCHAR2	(3)	The Language Code Identifier
CATEGORY_ID	NUMBER		Catalog Category Identifier
CATEGORY_DESC	VARCHAR2	(240)	The Description Text of the Catalog Category
CONCAT_CAT_PARENTAGE	VARCHAR2	(4000)	The concatenated value which indicates all the Parent Catalog Categories including the current Catalog Category in the Hierarchy
CATEGORY_LEVEL_NUM	NUMBER		The Level Number of the Catalog Category in the Hierarchy
DISABLE_DATE	DATE		The Disable Date of the Catalog Category
CATEGORY_PARENT_ID	NUMBER		The Catalog Category Identifier of the Parent Catalog Category
CREATION_DATE	DATE		The Creation Date of the row
LAST_UPDATE_DATE	DATE		The Last Update of the row

Query Text

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


SELECT CATEGORY_SET_ID
,      FORECASTABLE_FLAG
,      PURCHASE_INTEREST
,      LANGUAGE
,      CATEGORY_ID
,      CATEGORY_DESC
,      CONCAT_CAT_PARENTAGE
,      CATEGORY_LEVEL_NUM
,      DISABLE_DATE
,      CATEGORY_PARENT_ID
,      CREATION_DATE
,      LAST_UPDATE_DATE
FROM APPS.ENI_PROD_DEN_HRCHY_PARENTS_V;

Dependencies

[top of page]

APPS.ENI_PROD_DEN_HRCHY_PARENTS_V references the following:

APPS: EGO_PROD_CAT_SALES_MARKET_AGV; ENI_DENORM_HRCHY_PARENTS; MTL_DEFAULT_CATEGORY_SETS

APPS.ENI_PROD_DEN_HRCHY_PARENTS_V is referenced by following:

APPS: AMS_ACTPRODUCT_PVT - show dependent code; AMS_DMSELECTION_PVT - show dependent code; AMS_MTL_CATG_LOADER_PVT - show dependent code; AMS_SCHEDULERULES_PVT - show dependent code; AST_CONT_CLASSIFICATION_INT_V; AST_INV_ITEM_LOV_V; AST_LM_LEADS_QUICK_INT_PC_V; AST_LM_OPP_QUICK_INTTYPES_V; AST_LS_CAMPAIGNS_V; AST_OPPORTUNITY_LINES_V; AST_SALES_LEAD_LINES_PC_V; AST_SALES_LEAD_LINES_V; AS_INTEREST_CODES_PUB - show dependent code; AS_INTEREST_TYPES_PUB - show dependent code; AS_INT_TYP_COD_MIGRATION - show dependent code; AS_OPPORTUNITY_LINES_V; AS_OPP_LINE_PVT - show dependent code; AS_SALES_LEAD_ENGINE_PVT - show dependent code; AS_SALES_LEAD_LINES_PVT - show dependent code; BIL_TX_PRODUCT_V; IGR_IMP_003 - show dependent code; IGR_I_A_LINES_V; IGR_I_PKGITM_ASSIGN_V; OZF_AP_INTERFACE_PVT - show dependent code; OZF_AR_INTERFACE_PVT - show dependent code; OZF_FUNDS_PUB - show dependent code; OZF_FUND_UTILIZED_PUB - show dependent code; OZF_PRICELIST_PVT - show dependent code; OZF_SD_PRODUCTS_V; OZF_SD_UTIL_PVT - show dependent code; OZF_TP_UTIL_QUERIES - show dependent code; PA_LEAD_CATEGORIES_V; PV_BENFT_STATUS_CHANGE - show dependent code; PV_CHECK_MATCH_PUB - show dependent code; PV_WORKFLOW_PUB - show dependent code; QP_ITEM_CATEGORIES_V; QP_PRICE_BOOK_UTIL - show dependent code