EBS:物料失效 检查

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

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

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25

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;