PER Information Type Security

➜ Back to Library
Description
Categories: Enginatics
Repository: Github

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

select
fav.application_name,
frv.responsibility_name,
pitsv.info_type_table_name,
pitsv.information_type,
pitsv.context_name,
pitsv.legislation_code,
xxen_util.user_name(pitsv.created_by) created_by,
xxen_util.client_time(pitsv.creation_date) creation_date,
xxen_util.user_name(pitsv.last_updated_by) last_updated_by,
xxen_util.client_time(pitsv.last_update_date) last_update_date
from
fnd_application_vl fav,
fnd_responsibility_vl frv,
per_info_type_security_v pitsv
where
1=1 and
pitsv.application_id=fav.application_id and
pitsv.application_id=frv.application_id and
pitsv.responsibility_id=frv.responsibility_id
order by
fav.application_name,
frv.responsibility_name,
pitsv.info_type_table_name,
pitsv.information_type
Download
   
Related Blitz Reports
ECC Sourcing, Negotiations, SQL1 PON Solicitation data template Blitz Report Assignments and Responsibilities FND Responsibility Access FND Concurrent Requests 11i FND Concurrent Requests CAC WIP Material Relief FND Responsibility Access 11i FND User Login History
Blitz Report™

Blitz Report™ provides multiple benefits: