VIEW: APPS.ENI_ITEM_PROD_LEAF_CAT_V

Source

View Text - Preformatted

SELECT child_id ID, mtl.description || '(' || mcat.segment1 || ')' VALUE FROM eni_denorm_hierarchies A, mtl_categories_b MCAT, mtl_categories_tl MTL WHERE object_type = 'CATEGORY_SET' and leaf_node_flag = 'Y' and parent_id = child_id and a.child_id = MCAT.category_id and MCAT.category_id = MTL.category_id and MTL.language = userenv('LANG') union all select to_number(lookup_code), description || '(' || meaning || ')' from fnd_lookup_values where lookup_type = 'ITEM_CATG' and lookup_code = '-1' and language = userenv('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT CHILD_ID ID
, MTL.DESCRIPTION || '(' || MCAT.SEGMENT1 || ')' VALUE
FROM ENI_DENORM_HIERARCHIES A
, MTL_CATEGORIES_B MCAT
, MTL_CATEGORIES_TL MTL
WHERE OBJECT_TYPE = 'CATEGORY_SET'
AND LEAF_NODE_FLAG = 'Y'
AND PARENT_ID = CHILD_ID
AND A.CHILD_ID = MCAT.CATEGORY_ID
AND MCAT.CATEGORY_ID = MTL.CATEGORY_ID
AND MTL.LANGUAGE = USERENV('LANG') UNION ALL SELECT TO_NUMBER(LOOKUP_CODE)
, DESCRIPTION || '(' || MEANING || ')'
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'ITEM_CATG'
AND LOOKUP_CODE = '-1'
AND LANGUAGE = USERENV('LANG') WITH READ ONLY