DBA Data[Home] [Help]

APPS.GMD_FORMULA_ANALYSIS dependencies on MTL_CATEGORIES_B

Line 291: mtl_categories_b mc

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
295: AND mic.category_set_id = mdc.category_set_id