Fetch the pending ARs associated with the BR

SELECT

c.Name as AR,

TO_CHAR (TO_DATE ('19700101', 'YYYYMMDD') + (p.created / 1000 / 60 /60 / 24), 'DD/MM/YYYY HH24:MI') AS "P CREATED DATE",
TO_CHAR (TO_DATE ('19700101', 'YYYYMMDD') + (p.end_date / 1000 / 60 /60 / 24), 'DD/MM/YYYY HH24:MI') AS "P END DATE",
TO_CHAR (TO_DATE ('19700101', 'YYYYMMDD') + (c.created / 1000 / 60 /60 / 24), 'DD/MM/YYYY HH24:MI') AS "C CREATED DATE",
TO_CHAR (TO_DATE ('19700101', 'YYYYMMDD') + (c.end_date / 1000 / 60 /60 / 24), 'DD/MM/YYYY HH24:MI') AS "C CREATED DATE",

c.Name,
c.Value AS BR,
c.approver_name,
C.operation,
c.approval_state,
c.provisioning_state,
c.compilation_status,
c.identity_request_id 

FROM identityiq.spt_identity_request_item c
JOIN identityiq.spt_identity_request p ON p.id = c.identity_request_id

WHERE c.name = 'assignedRoles' AND
(VALUE IN ('IIQ Role', 'ISC Roles'));