DBA Data[Home] [Help]

APPS.QA_FLEX_UTIL dependencies on MTL_ITEM_CATEGORIES

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;