eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MRP_UPDATE_MRP_INFO_PK dependencies on WIP_FLOW_SCHEDULES

Line 72: FROM wip_flow_schedules fs,

68: CURSOR flow_schedules_cursor IS
69: SELECT fs.rowid,
70: fs.wip_entity_id,
71: fs.organization_id
72: FROM wip_flow_schedules fs,
73: mrp_relief_interface mrp
74: WHERE mrp.disposition_type = R_FLOW_SCHEDULE
75: AND mrp.relief_type = MPS_RELIEF_TYPE
76: AND mrp.request_id = arg_request_id

Line 372: -- WIP Flow Schedules: set the completion_date and completion

368: CLOSE jobs_cursor;
369: mrp_print_pk.stop_watch(arg_request_id, var_watch_id,var_row_count);
370:
371: --
372: -- WIP Flow Schedules: set the completion_date and completion
373: -- quantities for all the flow schedules that we performed relief
374: --
375: var_watch_id := mrp_print_pk.start_watch(
376: 'GEN-updated', arg_request_id, arg_user_id, 'ENTITY',

Line 377: 'wip_flow_schedules', 'N');

373: -- quantities for all the flow schedules that we performed relief
374: --
375: var_watch_id := mrp_print_pk.start_watch(
376: 'GEN-updated', arg_request_id, arg_user_id, 'ENTITY',
377: 'wip_flow_schedules', 'N');
378: var_row_count := 0;
379: prev_wip_entity_id := -1;
380: prev_org_id := -1;
381: SAVEPOINT flow;

Line 403: UPDATE wip_flow_schedules fs

399:
400: IF (prev_wip_entity_id <> var_wip_entity_id OR
401: prev_org_id <> var_org_id)
402: THEN
403: UPDATE wip_flow_schedules fs
404: SET mps_scheduled_completion_date = scheduled_completion_date,
405: mps_net_quantity = planned_quantity,
406: last_update_date = SYSDATE,
407: last_updated_by = arg_user_id