DBA Data[Home] [Help]

APPS.MRP_SELECT_ALL_FOR_RELEASE_PUB dependencies on MRP_WORKBENCH_DISPLAY_OPTIONS

Line 174: from mrp_workbench_display_options

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';

Line 642: from mrp_workbench_display_options

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