6465:
6466: SELECT u.user_name
6467: INTO x_planner_code
6468: FROM mtl_system_items_vl item 6469: ,mtl_planners p 6470: ,fnd_user u
6471: WHERE item.inventory_item_id = p_inventory_item_id
6472: and item.organization_id = p_organization_id
6473: and p.organization_id = item.organization_id