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'
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8063844/viewspace-1033220/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8063844/viewspace-1033220/