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

Object Details

Object Name:	EGO_PROD_CAT_SALES_MARKET_AGV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	EGO.EGO_PROD_CAT_SALES_MARKET_AGV
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CATEGORY_SET_ID	NUMBER	(15)	Yes	This is one of the primary keys for category; foreign key to MTL_CATEGORY_SETS_B
CATEGORY_ID	NUMBER	(15)		This is one of the primary keys for category; foreign key to MTL_CATEGORIES_B
INCLUDE_IN_FORECAST	VARCHAR2	(1)		Specifies if this category should be included in forecast
EXPECTED_PURCHASE	VARCHAR2	(1)		Specifies if there is a purchase interest for this category
EXCLUDE_USER_VIEW	VARCHAR2	(1)		Used to know if a node needs to be skipped

Query Text

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


SELECT CATEGORY_SET_ID
,      CATEGORY_ID
,      INCLUDE_IN_FORECAST
,      EXPECTED_PURCHASE
,      EXCLUDE_USER_VIEW
FROM APPS.EGO_PROD_CAT_SALES_MARKET_AGV;

Dependencies

[top of page]

APPS.EGO_PROD_CAT_SALES_MARKET_AGV references the following:

APPS: EGO_FND_DSC_FLX_CTX_EXT; EGO_PRODUCT_CAT_SET_EXT

APPS.EGO_PROD_CAT_SALES_MARKET_AGV is referenced by following:

APPS: ENI_DENORM_HRCHY - show dependent code; ENI_PROD_DEN_HRCHY_PARENTS_V