select js.*
  from D_V_LABMED_SAMPLES s
       join D_V_LBM_SAMPLE_DIRLINE sdl on sdl.PID = s.ID
            join D_V_LABMED_DIRECTION_LINE dl on dl.ID = sdl.DIRLINE
                 join D_V_LABMED_RESEARCH r on r.ID = dl.RESEARCH_ID
                      join D_V_LABMED_RSRCH_RES_LINK rl on rl.RESEARCH_ID = r.ID and rl.IS_ACTIVE = 1
                           join D_V_LABMED_RESEARCH_RES rr on rr.ID = rl.RES_RESULT
                                                              and rr.ID = 86915198
                           --left join D_V_LABMED_ALTER_MEASURE am on am.RSRCH_RES_LINK = rl.ID
                           left join D_V_LABMED_RSRCH_JOURSP js on js.RESULT_ID = rl.RES_RESULT
                                                                   and js.DIR_LINE = dl.ID
                                                                   and js.STR_VALUE is null
                                                                   and js.IS_ACTUAL = 1

                                                                   --and js.CONFIRM_STATUS in (0, 1)
                                                                   and dbms_lob.getlength(js.TEXT_VALUE) is null

                                                                   and js.CONFIRM_STATUS = 0

                           --left join D_V_LABMED_RES_VAL_LINK rvl on rvl.RSRCH_RES_LINK = rl.ID
                           --left join D_V_LABMED_RSRCH_RES_VAL rv on rv.ID = rvl.RSRCH_RES_VAL
 where dl.STATUS_ID in (3, 4)
   and sdl.IS_REJECTED = 0
   and s.LPU = :LPU
   --and ((s.RES_OTHER_LPU = 1 and rr.LPU_FROM is not null) or (s.RES_OTHER_LPU != 1 and rr.LPU_FROM is null))

   and s.ID = :LABMED_SAMPLE

   and exists(select null
                from D_V_LABMED_WL_RSRCH_METHODS v
                     join D_V_LABMED_RESEARCH_METHODS v2 on v2.ID = v.RMETHOD_ID
               where v.PID = :WORK_LIST
                 and v2.PID = r.ID
                 and v.AVAILABLE_FROM <= to_date('01.01.0001' || to_char(coalesce(to_date(D_PKG_SES.GETCONTEXT('MED', 'LOGON_DATE'), 'dd.mm.yyyy hh24:mi:ss'), sysdate), D_PKG_STD.FRM_T), D_PKG_STD.FRM_DT)
                 and v.AVAILABLE_TO >= to_date('01.01.0001' || to_char(coalesce(to_date(D_PKG_SES.GETCONTEXT('MED', 'LOGON_DATE'), 'dd.mm.yyyy hh24:mi:ss'), sysdate), D_PKG_STD.FRM_T), D_PKG_STD.FRM_DT))
   and ((exists(select null
                  from D_V_LABMED_WL_RSRCH_METHODS v
                       join D_V_LABMED_RESEARCH_METHODS v2 on v2.ID = v.RMETHOD_ID
                 where v.PID = :WORK_LIST
                   and v2.PID = r.ID)
         and not exists(select dw.WORKLIST_ID
                          from D_V_LBM_DIRLINE_WORKLIST dw
                         where dw.PID = dl.ID
                           and dw.WORKLIST_ID != :WORK_LIST))
        or exists(select dw.WORKLIST_ID
                    from D_V_LBM_DIRLINE_WORKLIST dw
                   where dw.PID = dl.ID
                     and dw.WORKLIST_ID = :WORK_LIST))

LPU		      10903
WORK_LIST     68759532
LABMED_SAMPLE 98703677