DBA Data[Home] [Help]

APPS.INV_ITEM_CATEGORY_OI dependencies on MTL_CATEGORIES_B_KFV

Line 663: FROM Mtl_Categories_B_Kfv

659: END IF;
660: BEGIN
661: SELECT Category_id
662: INTO l_old_category_id
663: FROM Mtl_Categories_B_Kfv
664: WHERE Structure_Id = ( SELECT Structure_Id
665: FROM mtl_category_sets_vl
666: WHERE category_set_id = l_category_set_id )
667: AND Concatenated_Segments = icoi_rec.old_category_name;

Line 739: FROM mtl_categories_b_kfv

735: FROM mtl_category_sets_b
736: WHERE category_set_id = l_category_set_id;
737: END IF;
738: SELECT category_id INTO l_category_id
739: FROM mtl_categories_b_kfv
740: WHERE concatenated_segments = icoi_rec.category_name
741: -- bug 3500492
742: AND structure_id = l_structure_id
743: AND NVL(disable_date,SYSDATE+1) > SYSDATE;