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.
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.
Comments