Oracle EBS-SQL (INV-10):检查库存接口.sql

/*检查库存接口表*/

select

          msi.segment1                            项目编码,

          msi.description                          项目说明,

          msi.organization_id                 项目组织号,

          a.organization_id               事物处理组织号,

          a.transaction_quantity           事物处理数量,

          a.source_code                      事物处理来源,

          a.transaction_source_name   事物处理名称

from   inv.mtl_transactions_interface a

         ,inv.mtl_system_items_b      msi

where a.inventory_item_id = msi.inventory_item_id

   and msi.organization_id=X

-----------------------------------------------------------------

/*检查事务处理开放接口*/

select 
         MTI.*,
         msi.inventory_item_id,
         MTI.TRANSACTION_QUANTITY,
         mti.PRIMARY_QUANTITY,
         mti.SCHEDULE_NUMBER,
         msi.segment1,
         msi.description,
         mti.source_code,
         mti.transaction_uom,
         mti.transaction_date,
         mti.subinventory_code,
         mti.transaction_source_name,
         mti.error_explanation,
         mti.error_code,
         FU.USER_NAME,
         FU.DESCRIPTION
from
         inv.MTL_TRANSACTIONS_INTERFACE mti,
         INV.MTL_SYSTEM_ITEMS_B              MSI,
         APPLSYS.FND_USER                           FU
where
          msi.organization_id=X
   and msi.organization_id=mti.organization_id
   and msi.inventory_item_id=mti.inventory_item_id
   AND MTI.CREATED_BY=FU.USER_ID

posted on 2014-06-11 16:44  st.sun  阅读(416)  评论(0编辑  收藏  举报

导航