sorry for the delay.,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')