from inv.mtl_material_transactions a,
mtl_system_items b
where costed_flag in ('N','E')
and a.inventory_item_id=b.inventory_item_id
--待定事务
select b.segment1,b.description,costed_flag,transaction_group_id,a.inventory_item_id,a.creation_date
from inv.mtl_material_transactions a,
mtl_system_items b
where costed_flag in ('N','E')
and a.inventory_item_id=b.inventory_item_id
update inv.mtl_material_transactions
set costed_flag='N',transaction_group_id=NULL
WHERE COSTED_FLAG IN ('N','E')
务处理开放接口
接口表: MTL_TRANSACTIONS_INTERFACE
物料出入库可从这个表进行处理,如有批次控制,其信息写在
MTL_TRANSACTION_LOTS_INTERFACE接口表。
重新处理物料接口未处理数据:
update MTL_TRANSACTIONS_INTERFACE mti
set mti.transaction_mode=3,
mti.lock_flag=2,
mti.process_flag=1,
mti.error_code=null,
mti.error_explanation=null
where mti.transaction_interface_id=29369973
Update MTL_MATERIAL_TRANSACTIONS_TEMP
Set PROCESS_FLAG = 'Y',
LOCK_FLAG = 'N',
TRANSACTION_MODE = 3,
ERROR_CODE = NULL
Where transaction_header_id='24233328'
and transaction_temp_id='24238322'
and inventory_item_id=2916
delete WIP_COST_TXN_INTERFACE
where creation_date > '21-9月-2006'
and creation_date < '22-9月-2006'
and process_status=1
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/133041/viewspace-438525/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/133041/viewspace-438525/