VIEW: APPS.EGO_PROD_CAT_SALES_MARKET_AGV

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')