APPS.MRP_UPDATE_MRP_INFO_PK dependencies on WIP_DISCRETE_JOBS

Line 45: wip_discrete_jobs jobs,

41: SELECT jobs.rowid,
42: jobs.wip_entity_id,
43: jobs.organization_id
44: FROM wip_requirement_operations ops,
45: wip_discrete_jobs jobs,
46: mrp_relief_interface mrp
47: WHERE ops.wip_entity_id (+) = jobs.wip_entity_id
48: AND ops.organization_id (+) = jobs.organization_id
49: AND mrp.disposition_type = R_WORK_ORDER

Line 323: 'wip_discrete_jobs', 'N');

319: --
320:
321: var_watch_id := mrp_print_pk.start_watch(
322: 'GEN-updated', arg_request_id, arg_user_id, 'ENTITY',
323: 'wip_discrete_jobs', 'N');
324: var_row_count := 0;
325: SAVEPOINT jobs;
326: LOOP
327: BEGIN

Line 345: UPDATE wip_discrete_jobs jobs

341:
342: if (prev_wip_entity_id <> var_wip_entity_id OR
343: prev_org_id <> var_org_id)
344: then
345: UPDATE wip_discrete_jobs jobs
346: SET mps_scheduled_completion_date = scheduled_completion_date,
347: mps_net_quantity = net_quantity,
348: last_update_date = SYSDATE,
349: last_updated_by = arg_user_id