1 Reply Latest reply on Feb 11, 2013 12:39 PM by Leoncio-Oracle

    OIM 10g Query

    958935
      I need a sql query to show approvals for a specific approver.
      These should be past approvals either approved or deny, or pending approvals. can somebody help
        • 1. Re: OIM 10g Query
          Leoncio-Oracle
          Get this SQL with the joins below and add your required conditions:

          Eg) All the pending approvals assigned to USERS

          SELECT SCH_KEY,OSI_ASSIGNED_TO_USR_KEY, OSI_ASSIGNED_DATE, REQ_KEY,USR_FIRST_NAME,USR_LAST_NAME,USR_MANAGER_KEY,USR_EMAIL,OBJ.OBJ_NAME AS OBJ_NAME FROM OTI
          INNER JOIN USR ON USR.USR_KEY = OTI.OSI_ASSIGNED_TO_USR_KEY
          INNER JOIN OBJ ON OBJ.OBJ_KEY = OTI.OBJ_KEY




          Eg:

          AND PKG_TYPE='Approval'
          If it is in approval type



          AND REQ_KEY IS NOT NULL
          If you want only request related

          the order by desc the date that was assigned:
          ORDER BY OSI_ASSIGNED_DATE DESC


          I hope this helps you,
          THiago Leoncio.
          1 person found this helpful