OIM Reports:Pending Approvals Tasks for Users

Query for Pending Approvals Tasks for Users :

SELECT "WFASSIGNEE"."ASSIGNEETYPE"   AS "ASSIGNEETYPE",

  "WFASSIGNEE"."ASSIGNEE"            AS "ASSIGNEE",

  "WFPRODUCTIVITY_VIEW"."TASKNAME"   AS "TASKNAME",

  "WFPRODUCTIVITY_VIEW"."TASKNUMBER" AS "TASKNUMBER",

  "WFPRODUCTIVITY_VIEW"."STATE"      AS "STATE",

  "WFTASK"."ASSIGNEDDATE"            AS "ASSIGNEDDATE"

   FROM "PROD_SOAINFRA"."WFPRODUCTIVITY_VIEW" "WFPRODUCTIVITY_VIEW",

  "PROD_SOAINFRA"."WFTASK" "WFTASK",

  "PROD_SOAINFRA"."WFASSIGNEE" "WFASSIGNEE"

WHERE "WFTASK"."TASKNUMBER"     ="WFPRODUCTIVITY_VIEW"."TASKNUMBER"

AND "WFASSIGNEE"."TASKID"       ="WFTASK"."TASKID"

AND "WFTASK"."STATE"            ="WFPRODUCTIVITY_VIEW"."STATE"

Thanks!!!