select * from wko_mst, wko_det 
where	wko_mst.RowID = wko_det.mst_RowID
AND	wko_mst.site_cd = wko_det.site_cd
AND	wko_det.wko_det_wo_open ='N'
AND	wko_mst.wko_mst_status <> 'A06'
UNION ALL
select * from wko_mst, wko_det 
where	wko_mst.RowID = wko_det.mst_RowID
AND	wko_mst.site_cd = wko_det.site_cd
AND	wko_det.wko_det_wo_open ='C'
AND	wko_mst.wko_mst_status <> 'A07'

847 to use
848 to cancel

-- CWO111848, (Duplicate) CWO111847, (Correct) -- WR: WKR110511

**********************************************************************************************************************

select wkr_det.wkr_det_wo, * from wkr_mst, wkr_det
where	wkr_mst.site_cd = wkr_det.site_cd
AND	wkr_mst.rowid = wkr_det.mst_rowid
AND	wkr_mst.wkr_mst_wr_no ='WKR110511'
AND wkr_mst.site_cd ='RFI'

update wkr_det SET wkr_det.wkr_det_wo ='CWO111847'
from wkr_mst, wkr_det
where	wkr_mst.site_cd = wkr_det.site_cd
AND	wkr_mst.rowid = wkr_det.mst_rowid
AND	wkr_mst.wkr_mst_wr_no ='WKR110511'
AND wkr_mst.site_cd ='RFI'

**********************************************************************************************************************

Select RowID, * from wko_mst where wko_mst_wo_no ='CWO111848' and site_cd ='RFI'

update wko_mst SET wko_mst_status ='A02' where RowID = 142825 and wko_mst_wo_no ='CWO111848' and site_cd = 'RFI'

Select RowID, * from wko_sts where mst_RowID = 142825 order by wko_sts.rowid

delete from wko_sts where RowID = 498857
delete from wko_sts where RowID = 499032
delete from wko_sts where RowID = 499033
delete from wko_sts where RowID = 499577
delete from wko_sts where RowID = 499752
delete from wko_sts where RowID = 500158
delete from wko_sts where RowID = 500889

update wko_sts SET wko_sts_end_date = NULL where wko_sts_status ='A02' and RowID = 498831

**********************************************************************************************************************

Select RowID, * from wko_mst where wko_mst_wo_no ='CWO111848' and site_cd ='RFI'

Select wko_det_wr_no, * from wko_det where mst_RowID = 142825

update wko_det SET wko_det_wr_no = NULL where mst_rowid = 142825 and site_cd ='RFI'

-- WKR110511