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)
309: and wfs.organization_id = perf_rec.organization_id
310: and wfs.primary_item_id = perf_rec.inventory_item_id
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
336: and mmt.transaction_action_id in (31,32)
337: and wfs.organization_id = perf_rec.organization_id