Code:
Predicate Information (identified by operation id):
---------------------------------------------------
   2 - access("P"."PERSON_NR"="VW_NSO_2"."$nso_col_1")
   3 - access("RP"."PERSON_NR"="P"."PERSON_NR" AND "RP"."REGIMEN_SEQUENCE"="VW_SQ_1"."VW_COL_1")
   4 - access("VW_SQ_1"."PERSON_NR"="P"."PERSON_NR")
   5 - filter("P"."EMAIL" NOT LIKE '%test%')
   8 - access("R"."REGIMEN_TYPE_CODE"='CD')
   9 - filter("RP"."REGIMEN_TYPE_CODE"='CD' AND "RP"."PRESCRIPTION_STATUS_CODE"='FNSH')
  11 - access("A"."PERSON_NR"="RP"."PERSON_NR")
  12 - access("A"."PERSON_NR"="B"."PERSON_NR")
  13 - filter("A"."STATUS_CODE"='ACTV' OR "A"."STATUS_CODE"='CHNG')
  14 - filter("B"."JOB_QUEUE_TYPE_NR"=4 AND "B"."STATUS_CODE"='FNSH')
sorry for the delay.,