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'

to cancel CWO112012
to close  CWO112011

-- CWO112012, (Duplicate) CWO112011, (Correct) -- WR: WKR110657
-- CWO111948, (Duplicate) CWO111949, (Correct) -- WR: WKR110594

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

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 ='WKR110657'
AND wkr_mst.site_cd ='RFI'

update wkr_det SET wkr_det.wkr_det_wo ='CWO112011'
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 ='WKR110657'
AND wkr_mst.site_cd ='RFI'

--- CWO112012

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

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

update wko_mst SET wko_mst_status ='A02' where RowID = 143674 and wko_mst_wo_no ='CWO112012' and site_cd = 'RFI'

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

delete from wko_sts where RowID = 502284
delete from wko_sts where RowID = 502336
delete from wko_sts where RowID = 502337
delete from wko_sts where RowID = 502479
delete from wko_sts where RowID = 502833

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

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

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

Select wko_det_wr_no, * from wko_det where mst_RowID = 143674

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

-- WKR110657

********************************************************************************************************************** 2nd issue

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

Select wko_det_wr_no, * from wko_det where mst_RowID = 143433

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

-- WKR110594


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

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

update wko_mst SET wko_mst_status ='A06' where RowID = 143434 and wko_mst_wo_no ='CWO111949' and site_cd = 'RFI'

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

delete from wko_sts where RowID = 501597
delete from wko_sts where RowID = 501598
delete from wko_sts where RowID = 501601
delete from wko_sts where RowID = 501733
delete from wko_sts where RowID = 502364
delete from wko_sts where RowID = 502569

update wko_sts SET wko_sts_end_date = NULL where wko_sts_status ='A06' and RowID = 501983