关库存会计期, 但是有很多未核算成本的事务处理方法

CREATE TABLE cux_mmt_0131
AS SELECT * FROM mtl_material_transactions mmt
WHERE mmt.costed_flag = 'E'
AND mmt.error_code = 'CST_INVALID_JOB_DATE'--事务处理日期早于任务或计划的发放日期。
AND mmt.transaction_source_type_id=5;
SELECT * FROM cux_mmt_0131
DECLARE
CURSOR cur_mmt IS
SELECT wdj.date_released,

mmt.transaction_date,

mmt.transaction_source_id,

mmt.transaction_id,

mmt.error_code,

mmt.error_explanation
FROM mtl_material_transactions mmt,wip_discrete_jobs wdj
WHERE mmt.costed_flag = 'E'
AND mmt.error_code = 'CST_INVALID_JOB_DATE'
AND mmt.transaction_source_type_id=5
AND wdj.wip_entity_id = mmt.transaction_source_id;
BEGIN
FOR rec_mmt IN cur_mmt LOOP
UPDATE mtl_material_transactions
SET transaction_date = rec_mmt.date_released,
costed_flag = 'N',
error_code = NULL,
error_explanation = NULL,
transaction_group_id = NULL
WHERE transaction_id = rec_mmt.transaction_id;
END LOOP;
COMMIT;
END;

SELECT * FROM mtl_material_transactions mmt
WHERE mmt.costed_flag = 'N'

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8063844/viewspace-1033220/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8063844/viewspace-1033220/