DBA Data[Home] [Help]

APPS.CSM_SETUP_PROFILE dependencies on MTL_CATEGORIES_VL

Line 68: mtl_categories_vl mcv,

64: cursor itemProfVal(itemCat in Number,
65: itemCatSet in Number) is
66: SELECT 'X'
67: FROM mtl_categories_kfv mck,
68: mtl_categories_vl mcv,
69: mtl_category_sets_vl mcs
70: WHERE mck.category_id = mcv.category_id
71: AND mcv.enabled_flag = 'Y'
72: AND NVL(mcv.disable_date, sysdate) >= SYSDATE

Line 81: mtl_categories_vl mcv,

77: UNION
78: SELECT 'X'
79: FROM mtl_category_set_valid_cats valid_cat,
80: mtl_categories_kfv mck,
81: mtl_categories_vl mcv,
82: mtl_category_sets_vl mcs
83: WHERE valid_cat.category_set_id = mcs.category_set_id
84: AND mcs.category_set_id = itemCatSet
85: AND mck.category_id = itemCat