OIM Reports :Pending Approvals Tasks for Groups

Query for Pending Approvals Tasks for Groups:

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!!!