APPS.MRP_SOURCING_API_PK dependencies on WIP_DISCRETE_JOBS

Line 726: FROM wip_discrete_jobs jobs

722:
723: IF (arg_source_org = arg_org_id) THEN
724: SELECT NVL(SUM(NVL(jobs.quantity_completed,0)),0)
725: INTO x_job_alloc_qty
726: FROM wip_discrete_jobs jobs
727: WHERE jobs.primary_item_id = arg_item_id
728: AND jobs.organization_id = arg_org_id
729: AND DECODE(mps_consume_profile_value,
730: 1, jobs.mps_scheduled_completion_date,