PAMInspection

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 ;