DBA Data[Home] [Help]

APPS.INV_ITEM_CATEGORY_OI dependencies on MTL_CATEGORIES_B_KFV

Line 670: FROM Mtl_Categories_B_Kfv

666: END IF;
667: BEGIN
668: SELECT Category_id
669: INTO l_old_category_id
670: FROM Mtl_Categories_B_Kfv
671: WHERE Structure_Id = ( SELECT Structure_Id
672: FROM mtl_category_sets_vl
673: WHERE category_set_id = l_category_set_id )
674: AND Concatenated_Segments = icoi_rec.old_category_name

Line 747: FROM mtl_categories_b_kfv

743: FROM mtl_category_sets_b
744: WHERE category_set_id = l_category_set_id;
745: END IF;
746: SELECT category_id INTO l_category_id
747: FROM mtl_categories_b_kfv
748: WHERE concatenated_segments = icoi_rec.category_name
749: -- bug 3500492
750: AND structure_id = l_structure_id
751: AND NVL(disable_date,SYSDATE+1) > SYSDATE;