/*检查库存接口表*/
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