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'