196: END IF;
197:
198: SELECT Nvl(Sum(mmt.transaction_quantity),0)
199: INTO l_received_quantity
200: FROM mtl_material_transactions mmt,
201: mtl_kanban_card_activity mkca,
202: mtl_kanban_cards mkc
203: WHERE mkca.kanban_card_id = kanban_rec.Kanban_Card_Id
204: AND mkca.document_type IS NOT NULL