select
pol.object_owner,
pol.object_name,
pol.policy,
pol.policy_group,
pom.pf_owner,
pom.package,
pom.function,
sql.last_active_time last_act_sql,
sql.sql_text,
pol.predicate,
pol.policy_function_owner
from
v$vpd_policy pol left join
v$sqlarea sql on pol.sql_id = sql.sql_id left join
dba_policies pom on pol.policy = pom.policy_name and
pol.policy_group = pom.policy_group and
pol.object_owner = pom.object_owner and
pol.object_name = pom.object_name
where
pol.object_name like 'TQ84%'
;