View: EGO_PROD_CAT_SALES_MARKET_AGV

Product:	EGO - Advanced Product Catalog
Description:	This view is used to retrieve sales and marketing attribute group values for product catalog
Implementation/DBA Data:	APPS.EGO_PROD_CAT_SALES_MARKET_AGV

View Text

SELECT CATEGORY_SET_ID CATEGORY_SET_ID
, CATEGORY_ID CATEGORY_ID
, INCLUDE_IN_FORECAST INCLUDE_IN_FORECAST
, EXPECTED_PURCHASE EXPECTED_PURCHASE
, EXCLUDE_USER_VIEW EXCLUDE_USER_VIEW
FROM EGO_PRODUCT_CAT_SET_EXT
WHERE ATTR_GROUP_ID = (SELECT ATTR_GROUP_ID
FROM EGO_FND_DSC_FLX_CTX_EXT
WHERE APPLICATION_ID = 431
AND DESCRIPTIVE_FLEXFIELD_NAME = 'EGO_PRODUCT_CATEGORY_SET'
AND DESCRIPTIVE_FLEX_CONTEXT_CODE = 'SALESANDMARKETING')

Columns