Useful Queries in EBS instance

Identify responsibilities assigned to an user:

SELECT fu.user_name                "User Name",
       frt.responsibility_name     "Responsibility Name",
       furg.start_date             "Start Date",
       furg.end_date               "End Date",    
       fr.responsibility_key       "Responsibility Key",
       fa.application_short_name   "Application Short Name"
  FROM fnd_user_resp_groups_direct        furg,
       fnd_user                   fu,
       fnd_responsibility_tl      frt,
       fnd_responsibility         fr,
       fnd_application_tl         fat,
       fnd_application            fa
 WHERE furg.user_id             =  fu.user_id
   AND furg.responsibility_id   =  frt.responsibility_id
   AND fr.responsibility_id     =  frt.responsibility_id
   AND fa.application_id        =  fat.application_id
   AND fr.application_id        =  fat.application_id
   AND frt.language             =  USERENV('LANG')
   AND UPPER(fu.user_name)      =  UPPER('&user_name')
 ORDER BY frt.responsibility_name;

Index related queries:

select * from ALL_CONSTRAINTS where table_name like '%AR_TRANSMISSION%';

select * from ALL_INDEXES where table_name like '%AR_TRANSMISSION%';

select * from ALL_IND_COLUMNS where table_name like '%AR_TRANSMISSION%';