Query to fetch Mtl Material Transactions screen Query. SELECT mmt.transaction_id, mmt.transaction_date, msi.segment1 AS item, msi.description AS item_description, mtst.transaction_source_type_name AS source_type, NVL(mgd.segment1, NVL(we.wip_entity_name, TO_CHAR(mmt.transaction_source_id))) AS source, mtt.transaction_type_name AS transaction_type, mmt.primary_quantity, mmt.transaction_uom, mmt.subinventory_code, mmt.locator_id, mmt.revision, mmt.creation_date FROM mtl_material_transactions mmt ...
Posts
Showing posts from February, 2026