FND Design Data [Home] [Help]

View: EGO_FINANCIAL_REPORTING_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: ViewAPPS.EGO_FINANCIAL_REPORTING_AGV
View Text

SELECT CATEGORY_SET_ID CATEGORY_SET_ID
, CATEGORY_ID CATEGORY_ID
, TOP_NODE TOP_NODE
, VALUE_ID VALUE_ID
, FLEX_VALUE_SET_ID FLEX_VALUE_SET_ID
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 = 'FINANCIALREPORTING') OR 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 = 'FINANCIALREPORTINGVALUES')

Columns

Name
CATEGORY_SET_ID
CATEGORY_ID
TOP_NODE
VALUE_ID
FLEX_VALUE_SET_ID