SELECT LIC_V.ONR_ID ,
  LIC_V.ONR_NAME,
  INS.STOP_DATE,
  INS.STOP_REASON,
  INS.STOP_NOTE,
  INS.CREATED_BY
FROM INS_AUTO_STOP_FILE INS ,
  NMP_LICNFILE_V LIC_V
WHERE LIC_V.lf_recid =INS.LICN_ID ;