Secured List Views and AOR

Philip Espia

The customer has a report that displays the total number of records per table.
When a logged-in user views the report, they should be able to see the count of records they can access based on their data access permissions.
The requirement is that when the user has multiple AORs (Areas of Responsibility), they want to see the count of records per AOR in the report.

Sample Output
Table Name AOR1 Count AOR2 Count Total
PER_ALL_PEOPLE_F 20 10 30
PER_PERSON_SECURED_LIST_V 12 30 42
HR_ALL_ORGANIZATION_UNITS_F 30 25 55

Is this possible? Thanks in advance!