APPS.POS_SUP_PROF_PRG_GRP SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 8

   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';

Line: 18

   DELETE FROM fnd_registration_details
     WHERE registration_id not IN
     (SELECT registration_id
      FROM fnd_registrations
      );