Oracle Ebs-sql (INV-10): Check the inventory interface. SQL

/* Check the Inventory interface table */

Select

Msi.segment1 Project Code,

Msi.description Project Description,

MSI.ORGANIZATION_ID Project organization number,

A.ORGANIZATION_ID the organization number of things to deal with,

A.transaction_quantity the number of things handled,

A.source_code the source of things to deal with,

A.transaction_source_name Thing handling 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

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

/* Check Transaction Open Interface */

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