APPS.QA_FLEX_UTIL dependencies on MTL_CATEGORIES_KFV

Line 177: from mtl_item_categories mic, mtl_categories_kfv mck

173:
174: CURSOR category_cur(p_org_id NUMBER, p_item_id NUMBER, p_category_set_id NUMBER) IS
175: select mck.concatenated_segments,
176: mck.category_id
177: from mtl_item_categories mic, mtl_categories_kfv mck
178: where mic.organization_id = p_org_id
179: and mic.category_id = mck.category_id
180: and mic.inventory_item_id =p_item_id
181: and mic.category_set_id = p_category_set_id;

Line 639: -- Return description from mtl_categories_kfv given category_id.

635:
636:
637: FUNCTION mtl_categories_description(x_category_id number) RETURN varchar2 IS
638: --
639: -- Return description from mtl_categories_kfv given category_id.
640: -- Return null if not found.
641: --
642: x_description varchar2(240) := null;
643: CURSOR c IS

Line 645: FROM mtl_categories_kfv

641: --
642: x_description varchar2(240) := null;
643: CURSOR c IS
644: SELECT description
645: FROM mtl_categories_kfv
646: WHERE category_id = x_category_id;
647: BEGIN
648: IF x_category_id IS NULL THEN
649: RETURN NULL;