DBA Data[Home] [Help]

APPS.MRP_UPDATE_MRP_INFO_PK dependencies on WIP_REQUIREMENT_OPERATIONS

Line 44: FROM wip_requirement_operations ops,

40: CURSOR jobs_cursor IS
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

Line 354: UPDATE wip_requirement_operations ops

350: WHERE rowid = var_rowid;
351:
352: var_row_count := var_row_count + NVL(SQL%ROWCOUNT, 0) ;
353:
354: UPDATE wip_requirement_operations ops
355: SET ops.mps_required_quantity = ops.required_quantity,
356: ops.mps_date_required = ops.date_required,
357: ops.last_update_date = SYSDATE,
358: ops.last_updated_by = arg_user_id