VIEW: APPS.ENI_ITEM_VBH_NODES_V

Source

View Text - Preformatted

SELECT A.IMM_CHILD_ID ID, DECODE(A.IMM_CHILD_ID, -1, (SELECT DESCRIPTION || ' ('|| MEANING ||')' FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'ITEM_CATG' AND LOOKUP_CODE = '-1' AND LANGUAGE = USERENV('LANG')), CTL.DESCRIPTION || ' (' || CTL.CATEGORY_CONCAT_SEGS ||')') VALUE, A.TOP_NODE_FLAG, A.PARENT_ID, A.CHILD_ID, A.LEAF_NODE_FLAG, A.ITEM_ASSGN_FLAG FROM ENI_DENORM_HIERARCHIES A, MTL_CATEGORIES_V CTL, MTL_DEFAULT_CATEGORY_SETS B WHERE B.FUNCTIONAL_AREA_ID = 11 AND A.OBJECT_TYPE = 'CATEGORY_SET' AND A.OBJECT_ID = B.CATEGORY_SET_ID AND A.DBI_FLAG = 'Y' AND A.IMM_CHILD_ID = CTL.CATEGORY_ID (+)

View Text - HTML Formatted

SELECT A.IMM_CHILD_ID ID
, DECODE(A.IMM_CHILD_ID
, -1
, (SELECT DESCRIPTION || ' ('|| MEANING ||')'
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'ITEM_CATG'
AND LOOKUP_CODE = '-1'
AND LANGUAGE = USERENV('LANG'))
, CTL.DESCRIPTION || ' (' || CTL.CATEGORY_CONCAT_SEGS ||')') VALUE
, A.TOP_NODE_FLAG
, A.PARENT_ID
, A.CHILD_ID
, A.LEAF_NODE_FLAG
, A.ITEM_ASSGN_FLAG
FROM ENI_DENORM_HIERARCHIES A
, MTL_CATEGORIES_V CTL
, MTL_DEFAULT_CATEGORY_SETS B
WHERE B.FUNCTIONAL_AREA_ID = 11
AND A.OBJECT_TYPE = 'CATEGORY_SET'
AND A.OBJECT_ID = B.CATEGORY_SET_ID
AND A.DBI_FLAG = 'Y'
AND A.IMM_CHILD_ID = CTL.CATEGORY_ID (+)