select *from MOSAL_USER.NMP_LICNFILE_V_MV where ONR_ID = 264062501037  ; 

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 ,
  ins_pkg.GET_order_loc_status(dtl.order_id)
  
  
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 ,
    ins_pkg.GET_order_loc_status(dtl.order_id)
  
  (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)
  );
  --------------------------------------