714: into l_cat
715: from
716: mtl_categories mc,
717: mtl_default_category_sets mdc, 718: mtl_item_categories mic 719: where mic.inventory_item_id = p_inv_item_id
720: and mic.organization_id = p_inv_orgn_id
721: and mdc.functional_area_id+0 = 7
722: and mic.category_set_id = mdc.category_set_id