DELETE O/S DOC SPOORING

DELETE FROM fi_invoice_ar_cost WHERE invoice_ar_id IN (
    SELECT invoice_ar_id FROM fi_invoice_ar WHERE status_doc <> 'R' AND SUBSTR(doc_date, 1, 4) IN ('2015', '2016')
)

DELETE FROM fi_invoice_ar_tax WHERE invoice_ar_id IN (
    SELECT invoice_ar_id FROM fi_invoice_ar WHERE status_doc <> 'R' AND SUBSTR(doc_date, 1, 4) IN ('2015', '2016')
)

DELETE FROM fi_invoice_ar_cost WHERE invoice_ar_id NOT IN (
    SELECT invoice_ar_id FROM fi_invoice_ar
)

DELETE FROM fi_invoice_ar_tax WHERE invoice_ar_id NOT IN (
    SELECT invoice_ar_id FROM fi_invoice_ar
)