APPS.OE_BULK_PROCESS_LINE dependencies on MTL_ITEM_CATEGORIES
Line 55: FROM mtl_item_categories mic,
51: l_category_id NUMBER := 0;
52: BEGIN
53: SELECT mic.category_id
54: INTO l_category_id 55: FROM mtl_item_categories mic, 56: mtl_default_category_sets mdc
57: WHERE mic.inventory_item_id = p_item_id
58: AND mic.organization_id = oe_sys_parameters.Value('MASTER_ORGANIZATION_ID') --13653352
59: AND mdc.functional_area_id =7