FND_Tables_For_Reports

select * from fnd_concurrent_programs where CONCURRENT_PROGRAM_NAME='POXRQOBO'

select * from all_objects where object_name like'FND_CONCURRENT_P%' --AND OBJECT_TYPE='TABLE%'

FND_CONCURRENT_COMPLEX_LINES_S

OWNER,OBJECT_NAME,OBJECT_TYPE

select OWNER,OBJECT_NAME,OBJECT_TYPE from all_objects where object_name like'FND_CONCURRENT_P%' --AND OBJECT_TYPE='TABLE%'

select OWNER,OBJECT_NAME,OBJECT_TYPE from all_objects where  OBJECT_TYPE='TABLE' AND object_name like'FND_CONCURRENT_P%'--OBJECT_TYPE='TABLE%'

SELECT * FROM FND_EXECUTABLES

SELECT EXECUTABLE_NAME,EXECUTION_FILE_NAME FROM FND_EXECUTABLES

SELECT * FROM FND_CONCURRENT_REQUESTS

SELECT * FROM FND_REQUEST_GROUPS

SELECT REQUEST_GROUP_NAME,DESCRIPTION FROM FND_REQUEST_GROUPS

SELECT * FROM FND_RESPONSIBILITY   NATURAL JOIN FND_REQUEST_GROUPS

select * from all_objects where object_name like'FND_RES%'

select OWNER,OBJECT_NAME,OBJECT_TYPE from all_objects where  OBJECT_TYPE='TABLE' AND object_name like'FND_RES%'

FND_RESPONSIBILITY,REQUEST_GROUP_NAME

SELECT B.FND_RESPONSIBILITY,B.REQUEST_GROUP_NAME FROM FND_RESPONSIBILITY  A NATURAL JOIN FND_REQUEST_GROUPS B