APPS.CSD_SC_DOMAINS_PVT dependencies on MTL_CATEGORY_SETS_VL

Line 242: from mtl_category_sets_vl

238: l_dummy := null;
239:
240: select 'X'
241: into l_dummy
242: from mtl_category_sets_vl
243: where category_set_id = p_sc_domain_rec.category_set_id;
244:
245: Exception
246:

Line 271: from mtl_category_sets_vl

267:
268: Begin
269: select validate_flag
270: into l_valid_cat_flag
271: from mtl_category_sets_vl
272: where category_set_id = p_sc_domain_rec.category_set_id;
273:
274: Exception
275:

Line 325: from mtl_category_sets_vl mcs, mtl_categories_v mc

321: end if;
322:
323: select 'X'
324: into l_dummy
325: from mtl_category_sets_vl mcs, mtl_categories_v mc
326: where mcs.category_set_id = p_sc_domain_rec.category_set_id
327: and mcs.structure_id = mc.structure_id
328: and mc.category_id = p_sc_domain_rec.category_id;
329: END IF;

Line 1123: from mtl_category_sets_vl

1119:
1120: Begin
1121: select category_set_id
1122: into l_category_set_id
1123: from mtl_category_sets_vl
1124: where category_set_id = p_sc_domain_rec.category_set_id;
1125:
1126: Exception
1127:

Line 1156: from mtl_category_sets_vl

1152: -- Get the validate flag for the category set
1153: Begin
1154: select validate_flag
1155: into l_valid_cat_flag
1156: from mtl_category_sets_vl
1157: where category_set_id = l_category_set_id;
1158:
1159: Exception
1160:

Line 1248: from mtl_category_sets_vl mcs, mtl_categories_v mc

1244: end if;
1245:
1246: select 'X'
1247: into l_dummy
1248: from mtl_category_sets_vl mcs, mtl_categories_v mc
1249: where mcs.category_set_id = l_category_set_id
1250: and mcs.structure_id = mc.structure_id
1251: and mc.category_id = l_category_id;
1252: END IF;