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: ViewEGO.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:

SchemaAPPS
SynonymEGO_FND_DSC_FLX_CTX_EXT
SynonymEGO_PRODUCT_CAT_SET_EXT
APPS.EGO_PROD_CAT_SALES_MARKET_AGV is referenced by following:

SchemaAPPS
Package BodyENI_DENORM_HRCHY - show dependent code
ViewENI_PROD_DEN_HRCHY_PARENTS_V