APPS.GMD_FORMULA_ANALYSIS dependencies on MTL_ITEM_CATEGORIES

Line 290: FROM mtl_category_sets mcs, mtl_default_category_sets mdc, mtl_item_categories mic,

286: X_item VARCHAR2(32);
287:
288: CURSOR Cur_get_class(V_item_id NUMBER, V_orgn_id NUMBER) IS
289: SELECT mc.segment1 technical_class, mc.segment2 technical_sub_class
290: FROM mtl_category_sets mcs, mtl_default_category_sets mdc, mtl_item_categories mic,
291: mtl_categories_b mc
292: WHERE mdc.functional_area_id = 16
293: AND mic.inventory_item_id = V_item_id
294: AND mic.organization_id = V_orgn_id