OIM retry data query

SELECT * 
FROM OTI 
WHERE orc_key IN 
  (SELECT orc_key 
  FROM oiu 
  WHERE oiu_create      > sysdate -6 
  AND app_instance_key           IN ('12','13','11') 
  )