SQL Query to get failed provisioning tasks for an application in OIM

SQL Query to get failed provisioning tasks for an application in OIM

SELECT
    USR.USR_LOGIN,
    OSI.SCH_KEY,
    SCH.SCH_STATUS,
    STA.STA_BUCKET,
    MIL.MIL_NAME,
    OST.OST_STATUS
FROM
    OSI
JOIN SCH ON OSI.SCH_KEY = SCH.SCH_KEY
JOIN STA ON STA.STA_STATUS = SCH.SCH_STATUS
JOIN MIL ON OSI.MIL_KEY = MIL.MIL_KEY
JOIN TOS ON MIL.TOS_KEY = TOS.TOS_KEY
JOIN PKG ON TOS.PKG_KEY = PKG.PKG_KEY
JOIN OIU ON OSI.ORC_KEY = OIU.ORC_KEY
JOIN USR ON OIU.USR_KEY = USR.USR_KEY
JOIN OST ON OIU.OST_KEY = OST.OST_KEY
JOIN OBJ ON OST.OBJ_KEY = OBJ.OBJ_KEY
WHERE
    OBJ.OBJ_NAME = 'AD User'
    AND OST.OST_STATUS = 'Provisioning'
    AND STA.STA_BUCKET in ('Pending','Rejected')
    AND PKG.PKG_NAME = 'AD User';
    AND MIL.MIL_NAME = 'System Validation';