Query to fetch list of Custom Reports
We can use below query to fetch list of custom reports which are registered under custom Module
In below query we are using application ID as 20003 which refers to custom application.
SELECT fcpt.user_concurrent_program_name
FROM apps.fnd_concurrent_programs fcp,
apps.fnd_concurrent_programs_tl fcpt,
apps.fnd_executables fe,
apps.fnd_executables_tl fet,
FND_APPLICATION_TL FAT
WHERE fe.executable_id = fet.executable_id
AND fcp.concurrent_program_id = fcpt.concurrent_program_id
AND fcpt.language = fet.language
AND fcp.executable_id = fe.executable_id
AND fcp.executable_application_id = fe.application_id
AND fcpt.language = 'US'
AND fe.application_id IN (20003)
AND fe.application_id =fat.application_id
AND fe.EXECUTION_METHOD_CODE ='P'
ORDER BY fat.APPLICATION_NAME DESC
0 Comments