APPS.INVPVDR6 dependencies on MTL_DEFAULT_CATEGORY_SETS

Line 41: ,mtl_default_category_sets_fk_v mdcs

37: --Bug: 3028216 Get the category sets which does not have default cat
38: CURSOR Func_Area_csr(cp_farea_id NUMBER) IS
39: SELECT FUNCTIONAL_AREA_DESC, mcs.category_set_name
40: FROM mtl_category_sets_vl mcs
41: ,mtl_default_category_sets_fk_v mdcs
42: WHERE mcs.category_set_id = mdcs.category_set_id
43: AND mcs.default_category_id IS NULL
44: AND mdcs.functional_area_id = cp_farea_id; --Bug 4654433
45:

Line 85: FROM mtl_default_category_sets dcs

81:
82: --Start 6531903:Default catalog to be run only once
83: CURSOR c_function_area_setup IS
84: SELECT functional_area_id
85: FROM mtl_default_category_sets dcs
86: ,mtl_category_sets_b cs
87: WHERE cs.category_set_id = dcs.category_set_id
88: AND cs.default_category_id IS NULL
89: AND dcs.functional_area_id IN (1,2,3,4,5,6,7,9,10);