Query To Find All Reports Registered Within Given Application
SELECT fa.application_short_name,
fcpv.user_concurrent_program_name,
description,
Decode (fcpv.execution_method_code, ‘B’, ‘Request Set Stage Function’,
‘Q’, ‘SQLPLUS’,
‘H’, ‘Host’,
‘L’, ‘SQLLOADER’,
‘A’, ‘Spawned’,
‘I’, ‘PL/SQL Stored Procedure’,
‘P’, ‘Oracle Reports’,
‘S’, ‘Immediate’,
fcpv.execution_method_code)
exe_method,
output_file_type,
program_type,
printer_name,
minimum_width,
minimum_length,
concurrent_program_name,
concurrent_program_id
FROM fnd_concurrent_programs_vl fcpv,
fnd_application fa
WHERE fcpv.application_id = fa.application_id
AND fcpv.execution_method_code = ‘P’ –“Write execution code”
AND fa.application_short_name IN ( ‘SQLAP’, ‘PN’, ‘FA’, ‘CM’,
‘GL’, ‘AR’, ‘OM’ )
–“Write Application Short Name”
ORDER BY description
Read More Articles:
Query To Find Responsibility Name from a Concurrent Program
Query Count the number of reports registered In Each Module
Query To Find Scheduled Concurrent Request
Query To Check Scheduled Concurrent Requests
Query To Find All Reports Status With User Name
Query To Count Pending Request
Query To find Concurrent Program Name, Phase Code And Status Code for a given Request ID
Query To Find a Concurrent Program Enabled with Trace
Query To Find Request Submitted By User
Query To Find Pending Request in Oracle Apps dba
Query To Find the Reports Finished With Error Code In Oracle Apps DBA
Terminating Report From Backend