[Home] [Help]
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
Name |
CATEGORY_SET_ID |
CATEGORY_ID |
INCLUDE_IN_FORECAST |
EXPECTED_PURCHASE |
EXCLUDE_USER_VIEW |