Query to find the list of all acccounts associated/provisioned to a user in OIM

    SELECT USR.USR_LOGIN,APP_INSTANCE.APP_INSTANCE_NAME,OST.OST_STATUS,oiu.orc_key FROM OIU
    JOIN USR ON OIU.USR_KEY = USR.USR_KEY
    JOIN APP_INSTANCE ON OIU.APP_INSTANCE_KEY  = APP_INSTANCE.APP_INSTANCE_KEY
    JOIN OST ON OIU.OST_KEY = OST.OST_KEY
    WHERE USR.USR_LOGIN IN ('GIVE LOGIN ID HERE') ORDER BY USR.USR_LOGIN;