Table related to account alias

Select Ood. organization_code organization, MSI. segment1 material code, MSI. description: The description of the material. transaction_date: the transaction processing date. transaction_quantity number of transactions processed, MT. transaction_uom Transaction Processing Unit, MT. primary_quantity main quantity, MSI. primary_uom_code, the main unit is Mt. subinventory_code sub-stock, -- Mt. transfer_subinventory transfers sub-inventory, MT. transaction_id transaction processing identifier, mtst. transaction_source_type_name source type, MGD. segment1 source, -- Mt. transaction_source_name source, MTT. transaction_type_name transaction processing type, -- ml. meaning transaction_action, MT. transaction_reference reference, fu1.user _ name creator, -- Mt. created_by, MT. creation_date: creation date. It is the last updated by fu2.user _ name, and is called "MT. last_updated_by, MT. last_update_date: Last Updated Date: From nation Mt, mtl_transaction_types MTT, mtl_system_items_ B MSI, Region mtst, Region MGD, mfg_lookups ml, fnd_user FU1, fnd_user FU2, destination Ood where 1 = 1 -- and Mt. costed_flag in ('n', 'E') -- And to_date ('2017-07-28 ', 'yyyy-MM-DD') <= Mt. transaction_date -- and Mt. transaction_date <= to_date ('1970-07-31 ', 'yyyy-MM-DD') and Mt. transaction_type_id = MTT. transaction_type_id and Mt. organization_id = MSI. organization_id and Mt. inventory_item_id = MSI. inventory_item_id and Mt. transaction_source_type_id = mtst. transaction_source_type_id and ML. lookup_type = 'mtl _ transaction_action 'and Mt. transaction_action_id = ML. lookup_code and mtst. transaction_source_type_name = 'account alias' and MGD. disposition_id = Mt. transaction_source_id and Mt. organization_id = Ood. organization_id and Mt. created_by = fu1.user _ id and Mt. last_updated_by = FU2.USER_ID--AND MSI. segment1 = '1380ft1_271 '-- and Mt. transaction_id = 1018704--order by mt. transaction_date