consultar transacciones por subinventario

esta consulta me enlista todas aquellas transacciones hechas en el modulo de inventarios para un subinventario en particular..

select
 mtt.transaction_type_name Tipo_Transaccion
,msi.segment1              Articulo
,msi.description           Descripcion
,mtp.organization_code     Organizacion
,gcc.concatenated_segments Cta_Contable
,mmt.subinventory_code     Subinventario
,mmt.transaction_quantity  Cantidad
,mmt.transaction_date      Fecha_Transaccion
,mmt.transaction_id
from mtl_material_transactions mmt
   , mtl_transaction_types     mtt
   , mtl_system_items_b        msi
   , mtl_parameters            mtp
   , gl_code_combinations_kfv  gcc
where mmt.source_code       ='Inventory'
and mmt.organization_id     = msi.organization_id
and mmt.inventory_item_id   = msi.inventory_item_id
and mtt.transaction_type_id = mmt.transaction_type_id
and mmt.organization_id     = mtp.organization_id
and mmt.distribution_account_id     = gcc.code_combination_id
and mmt.subinventory_code         = '&subinventory'
order by 2 ;

Advertisement