APPS.CSD_DC_DOMAINS_PVT dependencies on MTL_CATEGORY_SETS_VL

Line 239: from mtl_category_sets_vl

235: l_dummy := null;
236:
237: select 'X'
238: into l_dummy
239: from mtl_category_sets_vl
240: where category_set_id = p_dc_domain_rec.category_set_id;
241:
242: Exception
243:

Line 268: from mtl_category_sets_vl

264:
265: Begin
266: select validate_flag
267: into l_valid_cat_flag
268: from mtl_category_sets_vl
269: where category_set_id = p_dc_domain_rec.category_set_id;
270:
271: Exception
272:

Line 322: from mtl_category_sets_vl mcs, mtl_categories_v mc

318: end if;
319:
320: select 'X'
321: into l_dummy
322: from mtl_category_sets_vl mcs, mtl_categories_v mc
323: where mcs.category_set_id = p_dc_domain_rec.category_set_id
324: and mcs.structure_id = mc.structure_id
325: and mc.category_id = p_dc_domain_rec.category_id;
326: END IF;

Line 1110: from mtl_category_sets_vl

1106:
1107: Begin
1108: select category_set_id
1109: into l_category_set_id
1110: from mtl_category_sets_vl
1111: where category_set_id = p_dc_domain_rec.category_set_id;
1112:
1113: Exception
1114:

Line 1143: from mtl_category_sets_vl

1139: -- Get the validate flag for the category set
1140: Begin
1141: select validate_flag
1142: into l_valid_cat_flag
1143: from mtl_category_sets_vl
1144: where category_set_id = l_category_set_id;
1145:
1146: Exception
1147:

Line 1235: from mtl_category_sets_vl mcs, mtl_categories_v mc

1231: end if;
1232:
1233: select 'X'
1234: into l_dummy
1235: from mtl_category_sets_vl mcs, mtl_categories_v mc
1236: where mcs.category_set_id = l_category_set_id
1237: and mcs.structure_id = mc.structure_id
1238: and mc.category_id = l_category_id;
1239: END IF;