Friday, January 29, 2016

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 is not reliable.

No comments: