VIEW: APPS.ENI_ITEM_PROD_CAT_LOOKUP_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 || ' (' || MCF.CONCATENATED_SEGMENTS||')') VALUE, A.TOP_NODE_FLAG TOP_NODE_FLAG, A.PARENT_ID PARENT_ID, A.CHILD_ID CHILD_ID, A.LEAF_NODE_FLAG LEAF_NODE_FLAG, A.ITEM_ASSGN_FLAG ITEM_ASSGN_FLAG FROM ENI_DENORM_HIERARCHIES A, MTL_CATEGORIES_TL CTL, MTL_CATEGORIES_B_KFV MCF, 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 (+) AND CTL.LANGUAGE(+) = userenv('LANG') AND MCF.CATEGORY_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 || ' (' || MCF.CONCATENATED_SEGMENTS||')') VALUE
, A.TOP_NODE_FLAG TOP_NODE_FLAG
, A.PARENT_ID PARENT_ID
, A.CHILD_ID CHILD_ID
, A.LEAF_NODE_FLAG LEAF_NODE_FLAG
, A.ITEM_ASSGN_FLAG ITEM_ASSGN_FLAG
FROM ENI_DENORM_HIERARCHIES A
, MTL_CATEGORIES_TL CTL
, MTL_CATEGORIES_B_KFV MCF
, 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 (+)
AND CTL.LANGUAGE(+) = USERENV('LANG')
AND MCF.CATEGORY_ID(+) = CTL.CATEGORY_ID