EBS:物料失效 检查

EBS  物料失效时，提示： 存在现有量，或者此物料未完成的交货事务处理。请先处理这些交货事务处理，然后更改此属性。 

解决方式：检查以下几个表是是否存在记录，如果存在请完成相关事务后， 再失效物料。 

select *
  from mtl_onhand_quantities_detail
where inventory_item_id = 188036
and organization_id = 101;

select *
  from mtl_material_transactions_temp
where inventory_item_id = &item_id
and organization_id = &org_id;

select *
  from mtl_supply ms
where item_id = &item_id
AND  (from_organization_id = &org_id OR to_organization_id = &org_id);

select *
  from mtl_demand
where inventory_item_id = &item_id
and organization_id = &org_id;

select *
  from mtl_txn_request_lines
where inventory_item_id = &item_id
   and organization_id = &org_id
   and line_status = 7;