APPS.FLM_KANBANCARD_PUB dependencies on MTL_MATERIAL_TRANSACTIONS

Line 1054: FROM mtl_material_transactions mmt,

1050: -- In this SQL locator is not added. If needed we can also add it.
1051: select nvl(sum(qty),0)
1052: into l_total_received_quantity
1053: from ( SELECT nvl(mmt.primary_quantity,0) qty
1054: FROM mtl_material_transactions mmt,
1055: mtl_kanban_card_activity mkca,
1056: mtl_kanban_cards mkc
1057: WHERE mkca.kanban_card_id = p_Kanban_Card_Id
1058: AND mkca.document_type IS NOT NULL

Line 1081: from mtl_material_transactions mmt,

1077: If nvl(l_intransit_type,-1) = 1 then
1078: mydebug('Direct Trf Parameters: orgid='||l_kanban_card_rec.organization_id||', inv_item_id='||l_kanban_card_rec.inventory_item_id||', subinv_code='||l_kanban_card_rec.subinventory_name||', txn_src_type='||l_transaction_source_type_id);
1079: select nvl(sum(mmt.primary_quantity),0)
1080: into l_total_received_quantity
1081: from mtl_material_transactions mmt,
1082: oe_order_lines_all ool,
1083: (select mkca.document_header_id,mkca.document_detail_id
1084: from mtl_kanban_cards mkc,mtl_kanban_card_activity mkca
1085: where mkc.kanban_card_id = p_Kanban_Card_Id

Line 1128: FROM mtl_material_transactions mmt,

1124:
1125: select nvl(sum(qty),0)
1126: INTO l_total_received_quantity
1127: from ( SELECT nvl(mmt.primary_quantity,0) qty
1128: FROM mtl_material_transactions mmt,
1129: mtl_kanban_card_activity mkca,
1130: mtl_kanban_cards mkc
1131: WHERE mkca.kanban_card_id = p_Kanban_Card_Id
1132: AND mkca.document_type IS NOT NULL