FND tables for Reports
select * from fnd_concurrent_programs where CONCURRENT_PROGRAM_NAME='POXRQOBO'
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 OWNER,OBJECT_NAME,OBJECT_TYPE from all_objects where OBJECT_TYPE='TABLE' AND object_name like'FND_RES%'
SELECT B.FND_RESPONSIBILITY,B.REQUEST_GROUP_NAME FROM FND_RESPONSIBILITY A NATURAL JOIN FND_REQUEST_GROUPS B
No comments:
Post a Comment