SELECT FS.seq ,     
  FS.FILE_RECID,     
  fs.RELEASE_SEQ ,     
  FS.FILE_SUSPEND_RECID FS_RECID,     
  (SELECT NF.ONR_ID     
  FROM NMP_FILE NF     
  WHERE NF.FILE_RECID = FS.FILE_RECID     
  ) FIL#LICN_RECID,     
  NVL(     
  (SELECT SR.SUSPEND_REASON_DESC     
  FROM NMP_SUSPEND_REASON SR     
  WHERE SR.SUSPEND_REASON_RECID = FS.SUSPEND_REASON_RECID     
  ),FS.SUSPEND_NOTE )SUSPEND_CAUSE ,     
  FS.SUSPEND_USER SUSPEND_USER,     
  FS.SUSPEND_DATE SUSPEND_DATE,     
  FS.RELEASED RELASE,     
  NVL(     
  (SELECT RR.RELEASE_REASON_DESC     
  FROM NMP_RELEASE_REASON RR     
  WHERE RR.RELEASE_REASON_RECID = FS.RELEASE_REASON_RECID     
  ), FS.RELEASE_NOTE) RELEASE_CAUSE,     
  FS.UNSUSPEND_USER RELASE_USER,     
  FS.UNSUSPEND_DATE RELASE_DATE ,     
  (SELECT DECODE( NF.FILE_STATUS, 'R','الملف في حاله الطلب', 'A','الملف ساري', 'S','الملف موقوف نهائيا''P','الملف موقوف جزئيا', 'C','الملف ملغي', 'I','الملف غير صحيح' )     
  FROM NMP_FILE NF     
  WHERE NF.FILE_RECID = FS.FILE_RECID     
  ) FINAL_STATUS ,     
  (SELECT F.SUSPEND_DESC     
  FROM nmp_suspend f     
  WHERE F.SUSPEND_RECID = fs.SUSPEND_RECID     
  ) suspend_desc,     
  (SELECT F.SUSPEND_code     
  FROM nmp_suspend f     
  WHERE F.SUSPEND_RECID = fs.SUSPEND_RECID     
  ) suspend_code     
FROM NMP_FILE_SUSPEND FS      
where FILE_RECID= :P_FILE_RECID  
order by SUSPEND_DATE;