Query to fetch list of Custom Reports

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


Post a Comment

0 Comments