text: -- TEST0012 serial number MHR almost match, AC test match data:
  -- draft statement CLOB empty for testing.
  INSERT INTO draft(draft_id, document_number, account_id, create_ts, registration_type_cl, registration_type_cd,
                    registration_number, update_ts, draft)
    VALUES(200000016, 'D-T-0012', 'PS12345', sysdate, 'PPSALIEN', 'SA', 'TEST0012', null, '{}');
  INSERT INTO financing_statement(financing_id, state_type_cd, expire_date, life, discharged, renewed, registration_number)
    VALUES(200000006, 'ACT', sysdate + 365, 1, null , null, 'TEST0012')
  ;
  INSERT INTO registration(registration_id, financing_id, registration_number, base_reg_number, registration_type_cd,
                           registration_type_cl, registration_ts, document_number, life, lien_value,
                           surrender_date, account_id, client_reference_id, pay_invoice_id, pay_path)
      VALUES(200000013, 200000006, 'TEST0012', null, 'SA', 'PPSALIEN', sysdate, 'D-T-0012', 1,
             null, null, 'PS12345', 'TEST-SA-0012', null, null)
  ;
  INSERT INTO trust_indenture(trust_id, registration_id, financing_id, trust_indenture, registration_id_end)
    VALUES(200000004, 200000013, 200000006, 'Y', null)
  ;
  INSERT INTO address_ppr(address_id, street_line_1, street_line_2, city, province_type_cd, postal_cd, country_type_cd)
    VALUES(200000015, 'TEST-0012', 'line 2', 'city', 'BC', 'V8R3A5', 'CA')
  ;
  INSERT INTO party(party_id, party_type_cd, registration_id, financing_id, registration_id_end, branch_id, first_name,
                    middle_name, last_name, business_name, birth_date, address_id)
      VALUES(200000031, 'RG', 200000013, 200000006, null, null, 'TEST', '12', 'REGISTERING', null,
             null, 200000015)
  ;
  INSERT INTO party(party_id, party_type_cd, registration_id, financing_id, registration_id_end, branch_id, first_name,
                    middle_name, last_name, business_name, birth_date, address_id, first_name_key, last_name_key)
      VALUES(200000032, 'DI', 200000013, 200000006, null, null, 'TEST IND', '12', 'DEBTOR', null,
             null, 200000015, search_key_pkg.lastname('TEST IND'), search_key_pkg.lastname('DEBTOR'))
  ;
  INSERT INTO party(party_id, party_type_cd, registration_id, financing_id, registration_id_end, branch_id, first_name,
                    middle_name, last_name, business_name, birth_date, address_id)
      VALUES(200000033, 'SP', 200000013, 200000006, null, null, null, null, null, 'TEST 12 SECURED PARTY',
             null, 200000015)
  ;
  INSERT INTO serial_collateral(serial_id, serial_type_cd, registration_id, financing_id, registration_id_end,
                                year, make, model, serial_number, mhr_number, srch_vin)
    VALUES(200000011, 'MH', 200000013, 200000006, null, 2012, 'HOMCO IND. LTD DIPLOMAT', null, '9999', '22000',
           search_key_pkg.mhr('22000'))
  ;
  INSERT INTO serial_collateral(serial_id, serial_type_cd, registration_id, financing_id, registration_id_end,
                                year, make, model, serial_number, mhr_number, srch_vin)
    VALUES(200000012, 'AC', 200000013, 200000006, null, 1998, 'CESSNA', '172R SKYHAWK', 'CFYX', null,
           search_key_pkg.aircraft('CFYX'))
  ;
  INSERT INTO serial_collateral(serial_id, serial_type_cd, registration_id, financing_id, registration_id_end,
                                year, make, model, serial_number, mhr_number, srch_vin)
    VALUES(200000013, 'AF', 200000013, 200000006, null, 1998, 'AIRFRAME make', 'AIRFRAME model', 'AF16031', null,
           search_key_pkg.aircraft('AF16031'))
  ;
  UPDATE draft
     SET registration_id = 200000013
   WHERE draft_id = 200000016
  ;
  -- TEST0012 end
  