ECS, CSG Mutation getting weird
Last log of Validate with this query select h.reference, d.model_id, d.qty_rlz, d.qty_return from (select * from csg_rlz_sub_dtl where job_id in ( select job_id from CSG_RLZ_HDR where reference in ('CSP/012016/0019', 'CSP/012016/0020', 'CSP/012016/0021', 'CSP/012016/0022', 'CSP/012016/0023', 'CSP/012016/0024', 'CSP/012016/0027', 'CSP/012016/0031') ) AND model_id='12V-7AH SMF') d, ( select job_id, reference from CSG_RLZ_HDR where reference in ('CSP/012016/0019', 'CSP/012016/0020', 'CSP/012016/0021', 'CSP/012016/0022', 'CSP/012016/0023', 'CSP/012016/0024', 'CSP/012016/0027', 'CSP/012016/0031') ) h where h.job_id = d.job_id order by h.reference ; And there is field that maintain the remain at the CSG_RLZ_SUB_DTL.QTY_RETURN_TO_CONS but i think it