[Home] [Help]
241:
242: BEGIN
243: select nvl(sum(mmt.primary_quantity),0) into complete_quantity
244: from
245: mtl_material_transactions mmt,
246: wip_entities we,
247: wip_discrete_jobs wdj
248:
249: where mmt.transaction_source_type_id = 5
270: -- for all the discrete jobs completed after the completion date
271: BEGIN
272: select nvl(sum(mmt.primary_quantity),0) into complete_quantity
273: from
274: mtl_material_transactions mmt,
275: wip_entities we,
276: wip_discrete_jobs wdj
277:
278: where mmt.transaction_source_type_id = 5
300: -- For all the flow schedules complete on schedule
301: BEGIN
302: select nvl(sum(mmt.primary_quantity),0) into complete_quantity
303: from
304: mtl_material_transactions mmt,
305: wip_entities we,
306: wip_flow_schedules wfs
307: where mmt.transaction_source_type_id = 5
308: and mmt.transaction_action_id in (31,32)
327: -- for all the flow schedules completed after the completion date
328: BEGIN
329: select nvl(sum(mmt.primary_quantity),0) into complete_quantity
330: from
331: mtl_material_transactions mmt,
332: wip_entities we,
333: wip_flow_schedules wfs
334:
335: where mmt.transaction_source_type_id = 5
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
365: and mmt.transaction_action_id in (31,32)
366: and wrs.organization_id = perf_rec.organization_id
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
397: and mmt.transaction_action_id in (31,32)
398: and wrs.organization_id = perf_rec.organization_id