Script to find the Usage of the Responisibilities and the Porduct License details in Oracle Apps R12 or 11i

Script to check the last login to the Reponsibilities by the users
==============================================

select max(flr.start_time), flr.responsibility_id ,fu.user_name, 
flt.responsibility_name 
from fnd_logins fl, fnd_login_Responsibilities flr, fnd_user fu , 
fnd_responsibility_tl flt 
where flr.login_id = fl.login_id 
and flt.responsibility_id = flr.responsibility_id 
and fu.user_id = fl.user_id 
group by fl.user_id, flr.RESPONSIBILITY_ID ,fu.user_name, 
flt.responsibility_name 
order by fl.user_id

Script to check the Products Installed and Shared in Oracle Apps
================================================

select a.application_short_name,a.APPLICATION_NAME,decode(fpi.status,'I', 'INSTALLED','S', 'SHARED','N', 'Inactive', 'N/A') status from apps.fnd_application_vl a, apps.fnd_product_installations fpi where fpi.application_id = a.application_id and fpi.status in ('I','S') order by 3,1;

SELECT a.application_name,DECODE (b.status, 'I', 'Installed', 'S', 'Shared', 'N/A') status,patch_level FROM apps.fnd_application_vl a, apps.fnd_product_installations b WHERE a.application_id = b.application_id and PATCH_LEVEL like '%&1%';