APPS.ENI_PROD_VALUESET dependencies on MTL_CATEGORIES_KFV

Line 18: FROM MTL_CATEGORY_SET_VALID_CATS T, MTL_CATEGORIES_KFV V, MTL_CATEGORIES_KFV V1, FND_FLEX_VALUES F

14: SELECT
15: V.CONCATENATED_SEGMENTS PARENT_CODE,
16: V1.CONCATENATED_SEGMENTS CHILD_CODE,
17: DECODE(F.SUMMARY_FLAG, 'Y', 'P', 'C') RANGE_ATTRIBUTE
18: FROM MTL_CATEGORY_SET_VALID_CATS T, MTL_CATEGORIES_KFV V, MTL_CATEGORIES_KFV V1, FND_FLEX_VALUES F
19: WHERE T.CATEGORY_SET_ID = g_catset_id
20: AND T.CATEGORY_ID = V1.CATEGORY_ID
21: AND T.PARENT_CATEGORY_ID = V.CATEGORY_ID
22: AND V1.CONCATENATED_SEGMENTS = F.FLEX_VALUE

Line 38: mtl_categories_kfv b, fnd_flex_values f

34: select l_top_node parent_code,
35: concatenated_segments child_code,
36: decode(f.summary_flag,'Y','P','C') range_attribute
37: from mtl_category_set_valid_cats a,
38: mtl_categories_kfv b, fnd_flex_values f
39: where parent_category_id is null
40: and category_set_id = g_catset_id
41: and a.category_id = b.category_id
42: and b.structure_id = l_struct_id

Line 64: FROM mtl_category_set_valid_cats a, mtl_categories_kfv b

60: -- value set with a circular reference
61:
62: CURSOR c_hierarchy_loop(l_top_node VARCHAR2) IS
63: SELECT b.concatenated_segments nodes
64: FROM mtl_category_set_valid_cats a, mtl_categories_kfv b
65: WHERE a.category_set_id = g_catset_id
66: AND a.category_id = b.category_id
67: AND b.structure_id = l_struct_id
68: INTERSECT

Line 325: FROM MTL_CATEGORIES_KFV V,

321: NVL((SELECT ''Y'' FROM MTL_CATEGORY_SET_VALID_CATS C
322: WHERE C.CATEGORY_SET_ID = H.CATEGORY_SET_ID
323: AND C.PARENT_CATEGORY_ID = V.CATEGORY_ID
324: AND ROWNUM = 1), ''N'') SUMMARY_FLAG
325: FROM MTL_CATEGORIES_KFV V,
326: MTL_CATEGORIES_TL T,
327: MTL_CATEGORY_SET_VALID_CATS H
328: WHERE V.STRUCTURE_ID = :l_struct_id
329: AND V.CATEGORY_ID = T.CATEGORY_ID

Line 428: FROM MTL_CATEGORIES_KFV V, MTL_CATEGORIES_TL T,

424: NVL((SELECT ''Y'' FROM MTL_CATEGORY_SET_VALID_CATS C
425: WHERE C.CATEGORY_SET_ID = H.CATEGORY_SET_ID
426: AND C.PARENT_CATEGORY_ID = V.CATEGORY_ID
427: AND ROWNUM = 1), ''N'') NEW_SUMMARY_FLAG
428: FROM MTL_CATEGORIES_KFV V, MTL_CATEGORIES_TL T,
429: FND_FLEX_VALUES F,
430: FND_FLEX_VALUES_TL FT,
431: MTL_CATEGORY_SET_VALID_CATS H
432: WHERE V.STRUCTURE_ID = :l_struct_id

Line 665: from mtl_categories_kfv a,

661: where v.category_set_id = c.category_set_id
662: and v.parent_category_id = b.category_id
663: and rownum = 1), 'C')
664: -- decode(b.summary_flag,'Y','P','C')
665: from mtl_categories_kfv a,
666: mtl_categories_kfv b,
667: mtl_category_set_valid_cats c
668: where a.structure_id(+) = l_struct_id
669: and b.structure_id = l_struct_id

Line 666: mtl_categories_kfv b,

662: and v.parent_category_id = b.category_id
663: and rownum = 1), 'C')
664: -- decode(b.summary_flag,'Y','P','C')
665: from mtl_categories_kfv a,
666: mtl_categories_kfv b,
667: mtl_category_set_valid_cats c
668: where a.structure_id(+) = l_struct_id
669: and b.structure_id = l_struct_id
670: and c.category_set_id = g_catset_id