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


Query for workers
--------------------------------------
SELECT distinct 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_CON_NO   ,   
  ( SELECT vdtl.visit_id FROM INS_SOURCE_ORDER_DTL dtl ,  INS_VISIT_ORDER_DTL VDTL     
  WHERE   msor.SOURCE_ID = dtl.SOURCE_ID    
  and dtl.ORDER_ID = VDTL.ORDER_ID   
  and    dtl.INSPECTION_TYPE_ID IN (3)   
  and VDTL.VISIT_STATUS =2 ) visit_id ,  
  (SELECT SYS_PKG.GET_LOOKUP_NAME(60,vm.LOCATION_STATUS)  
  FROM INS_SOURCE_ORDER_DTL dtl ,  
    INS_VISIT_ORDER_DTL VDTL ,  
    INS_VISIT_ORDER vm  
  WHERE msor.SOURCE_ID        = dtl.SOURCE_ID  
  AND VM.VISIT_ID             = VDTL.VISIT_ID  
  AND dtl.ORDER_ID            = VDTL.ORDER_ID  
  AND dtl.INSPECTION_TYPE_ID IN (3)  
  AND VDTL.VISIT_STATUS       =2  
  ) LOCATION_STATUS  
FROM INS_SOURCE_ORDER msor      
WHERE msor.SOURCE_TYPE = 5      
AND msor.SOURCE_ID    IN      
  ( SELECT SOURCE_ID FROM INS_SOURCE_ORDER_DTL WHERE INSPECTION_TYPE_ID IN (3)      
  )
  --------------------------------------