DBA Data[Home] [Help]

APPS.WIP_PERF_TO_PLAN dependencies on WIP_REPETITIVE_SCHEDULES

Line 360: wip_repetitive_schedules wrs,

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

Line 392: wip_repetitive_schedules wrs,

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