TO FIND THE RESPONSIBILITY IN ORACLE APPLICATIONS

/* Formatted on 04-Jan-12 5:24:10 PM (QP5 v5.115.810.9015) */
select * from FND_RESPONSIBILITY_VL       where request_group_id in  (SELECT   request_group_id
  FROM   fnd_request_groups
 WHERE   request_group_id IN
               (SELECT   request_group_id
                  FROM   fnd_request_group_units
                 WHERE   request_unit_id =
                            (SELECT   concurrent_program_id
                               FROM   fnd_concurrent_programs_tl
                              WHERE   user_concurrent_program_name =
                                         'HMI Binning Pendency Report New')))
                                        
                                        
                                         
select * from FND_RESPONSIBILITY_TL       where application_id in(401,20003,385)    

select * from FND_RESPONSIBILITY_VL       where request_group_id in (1481 ,1370,1398)              

select * from all_objects where object_name like 'FND%RESPONS%'