170: l_user_id := FND_PROFILE.VALUE('USER_ID');
171: begin
172: select nvl(ORDERS_RELEASE_CONFIGS,'N')
173: into release_configs
174: from mrp_workbench_display_options
175: where user_id = l_user_id;
176: exception
177: when others then
178: release_configs := 'N';
638: update mrp_recommendations mr
639: set implement_status_code =
640: (select
641: orders_default_job_status
642: from mrp_workbench_display_options
643: WHERE user_id = l_user_id),
644: mr.created_by = l_user_id
645: where transaction_id IN
646: (SELECT number1 from mrp_form_query