356: -- For all the repetitive schedules completed on schedule
357: BEGIN
358: select nvl(sum(mmta.primary_quantity),0) into complete_quantity
359: from
360: wip_repetitive_schedules wrs,
361: wip_entities we,
362: mtl_material_transactions mmt,
363: mtl_material_txn_allocations mmta
364: where mmt.transaction_source_type_id = 5
388: -- for all the repetitive schedules completed after the completion date
389: BEGIN
390: select nvl(sum(mmta.primary_quantity),0) into complete_quantity
391: from
392: wip_repetitive_schedules wrs,
393: wip_entities we,
394: mtl_material_transactions mmt,
395: mtl_material_txn_allocations mmta
396: where mmt.transaction_source_type_id = 5