The following lines contain the word 'select', 'insert', 'update' or 'delete':
DELETE FROM fnd_registrations
WHERE registration_id IN
(SELECT registration_id
FROM fnd_registration_details frd
WHERE field_name = 'Supplier Number'
AND not exists
(select vendor_id from ap_suppliers where vendor_id= frd.field_value_number) )
AND registration_status <> 'APPROVED';
DELETE FROM fnd_registration_details
WHERE registration_id not IN
(SELECT registration_id
FROM fnd_registrations
);