APPS.GMIVDBL dependencies on MTL_CATEGORY_SETS

Line 340: FROM mtl_category_sets

336: ROWNUM = 1;
337:
338: CURSOR get_mult_item_cat_assign_flag IS
339: SELECT mult_item_cat_assign_flag
340: FROM mtl_category_sets
341: WHERE category_set_id = l_category_set_id;
342:
343: l_inventory_item_id NUMBER;
344: l_mult_item_cat_assign_flag mtl_category_sets.mult_item_cat_assign_flag%TYPE;

Line 344: l_mult_item_cat_assign_flag mtl_category_sets.mult_item_cat_assign_flag%TYPE;

340: FROM mtl_category_sets
341: WHERE category_set_id = l_category_set_id;
342:
343: l_inventory_item_id NUMBER;
344: l_mult_item_cat_assign_flag mtl_category_sets.mult_item_cat_assign_flag%TYPE;
345: BEGIN
346: OPEN get_inventory_item_id(p_ic_item_mst_row.ITEM_NO);
347: FETCH get_inventory_item_id into l_inventory_item_id;
348: CLOSE get_inventory_item_id;

Line 421: mtl_category_sets mtl

417: IS
418: Cursor get_category_set_id(Vopm_class gmi_category_sets.opm_class%TYPE) IS
419: SELECT gmi.category_set_id,mtl.structure_id
420: FROM gmi_category_sets gmi,
421: mtl_category_sets mtl
422: WHERE gmi.opm_class = Vopm_class
423: AND mtl.category_set_id = gmi.category_set_id;
424:
425: l_category_set_id NUMBER;