VIEW: APPS.ENI_PROD_DEN_HRCHY_PARENTS_V

Source

View Text - Preformatted

SELECT a.OBJECT_ID CATEGORY_SET_ID, b.INCLUDE_IN_FORECAST FORECASTABLE_FLAG, b.EXPECTED_PURCHASE PURCHASE_INTEREST, a.LANGUAGE, a.CATEGORY_ID, a.CATEGORY_DESC, a.CONCAT_CAT_PARENTAGE, a.CATEGORY_LEVEL_NUM, a.DISABLE_DATE, a.CATEGORY_PARENT_ID, a.CREATION_DATE, a.LAST_UPDATE_DATE FROM ENI_DENORM_HRCHY_PARENTS a, EGO_PROD_CAT_SALES_MARKET_AGV b, MTL_DEFAULT_CATEGORY_SETS d WHERE a.OBJECT_TYPE = 'CATEGORY_SET' AND a.LANGUAGE = USERENV('LANG') AND a.OBJECT_ID = b.CATEGORY_SET_ID AND a.CATEGORY_ID = b.CATEGORY_ID AND d.FUNCTIONAL_AREA_ID = 11 AND d.CATEGORY_SET_ID = a.OBJECT_ID

View Text - HTML Formatted

SELECT A.OBJECT_ID CATEGORY_SET_ID
, B.INCLUDE_IN_FORECAST FORECASTABLE_FLAG
, B.EXPECTED_PURCHASE PURCHASE_INTEREST
, A.LANGUAGE
, A.CATEGORY_ID
, A.CATEGORY_DESC
, A.CONCAT_CAT_PARENTAGE
, A.CATEGORY_LEVEL_NUM
, A.DISABLE_DATE
, A.CATEGORY_PARENT_ID
, A.CREATION_DATE
, A.LAST_UPDATE_DATE
FROM ENI_DENORM_HRCHY_PARENTS A
, EGO_PROD_CAT_SALES_MARKET_AGV B
, MTL_DEFAULT_CATEGORY_SETS D
WHERE A.OBJECT_TYPE = 'CATEGORY_SET'
AND A.LANGUAGE = USERENV('LANG')
AND A.OBJECT_ID = B.CATEGORY_SET_ID
AND A.CATEGORY_ID = B.CATEGORY_ID
AND D.FUNCTIONAL_AREA_ID = 11
AND D.CATEGORY_SET_ID = A.OBJECT_ID