查询物料事务处理历史记录脚本

select OOD.ORGANIZATION_ID 组织id,
         OOD.ORGANIZATION_CODE 组织代码,
         OOD.ORGANIZATION_NAME 组织名称,
         MSIB.SEGMENT1 物料,
         MSIB.DESCRIPTION 物料名称,
         MTT.TRANSACTION_TYPE_ID 类型ID,
         MTT.TRANSACTION_TYPE_NAME 类型名称,
         MTST.TRANSACTION_SOURCE_TYPE_ID 来源ID,
         MTST.TRANSACTION_SOURCE_TYPE_NAME 来源名称,
         mmt.transaction_id 事务ID,
         MMT.TRANSACTION_DATE 日期,
         MMT.TRANSACTION_UOM 单位,
         MMT.TRANSACTION_QUANTITY 数量,
         msi.secondary_inventory_name 子库,
         msi.description 子库名称
 from 
mtl_system_items_b msib,
mtl_material_transactions mmt,
org_organization_definitions ood,
mtl_txn_source_types mtst,
mtl_transaction_types mtt,
mtl_secondary_inventories msi
where mmt.organization_id=ood.ORGANIZATION_ID
and mmt.organization_id=msib.organization_id
and mmt.inventory_item_id=msib.inventory_item_id
and mmt.transaction_type_id=mtt.transaction_type_id
and mmt.transaction_source_type_id=mtst.transaction_source_type_id
--and mmt.transaction_date>=to_date('2018-03-01 00:00:00','YYYY-MM-DD HH24:MI:SS')
and mmt.transaction_date<=to_date('2018-03-01 00:00:00','YYYY-MM-DD HH24:MI:SS')
AND ood.ORGANIZATION_CODE='NY7'
and mmt.organization_id=msi.organization_id(+)
and mmt.subinventory_code=msi.secondary_inventory_name(+)
and mmt.transaction_type_id!='10008';