HOW TO USE THE ALL_TABLES AND ALL_OBJECTS

 TO FIND THE TABLE
 -------------------------------

select * from all_tables where TABLE_NAME like '%FND%CON%REQ%'

CHECK THE  REQUEST_ID
---------------------------------
select * from FND_CONCURRENT_REQUESTS where REQUEST_ID IN (8174289,8173618,8163467)




CHECK RESPONSIBILITY_ID
-----------------------------------------
select * from fnd_responsibility_vl where RESPONSIBILITY_ID=20634

CHECK APPLICATION_ID

---------------------------------------
select * from fnd_application where APPLICATION_ID=401


SIMPLE JOIN CONDITION
----------------------------------


select fev.RESPONSIBILITY_NAME from fnd_responsibility_vl fev,fnd_application fna
where fev.APPLICATION_ID = fna.APPLICATION_ID
and fev.APPLICATION_ID=401

 ALL_OBJECTS

-------------------------

select * from all_objects where OBJECT_TYPE ='TABLE' AND OBJECT_NAME='PO_HEADERS_ALL'