SELECT msor.SOURCE_ID ,  
  msor.SOURCE_STATUS ,  
  msor.CREATED_DATE,  
  msor.FILE_RECID ,  
  (SELECT mv.LICN_CON_NO  
  FROM MOSAL_USER.NMP_LICNFILE_V mv ,  
    INS_SOURCE_ORDER_DTL dtl  
  WHERE dtl.lf_recid = mv.LF_RECID  
  AND dtl.SOURCE_ID  = msor.SOURCE_ID  
  ) LICN_civil_NO  
FROM INS_SOURCE_ORDER msor  
WHERE msor.SOURCE_TYPE in ( 1,5,6)  
AND msor.SOURCE_ID    IN  
  ( SELECT SOURCE_ID FROM INS_SOURCE_ORDER_DTL WHERE INSPECTION_TYPE_ID IN (4,5))  
AND msor.FILE_RECID = :b_fileRecid