Scribd
Upload
49 views1 page

CP Details With Exceutable Query

The document contains a SQL query that retrieves details about the 'Supplier Audit Report' concurrent program. It selects various attributes such as program names, application names, executable names, and execution methods from multiple related tables. The query uses specific conditions to filter results based on the user concurrent program name and joins several tables to gather the necessary information.

Uploaded by

Sudha Krishna
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
49 views1 page

CP Details With Exceutable Query

The document contains a SQL query that retrieves details about the 'Supplier Audit Report' concurrent program. It selects various attributes such as program names, application names, executable names, and execution methods from multiple related tables. The query uses specific conditions to filter results based on the user concurrent program name and joins several tables to gather the necessary information.

Uploaded by

Sudha Krishna
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 1

SELECT fcpt.

user_concurrent_program_name ,
fcp.concurrent_program_name short_name ,
fat.application_name program_application_name ,
fet.executable_name ,
fat1.application_name executable_application_name ,
[Link] execution_method ,
fet.execution_file_name ,
fcp.enable_trace
FROM fnd_concurrent_programs_tl fcpt ,
fnd_concurrent_programs fcp ,
fnd_application_tl fat ,
fnd_executables fet ,
fnd_application_tl fat1 ,
FND_LOOKUP_VALUES FLV
WHERE 1 =1
AND fcpt.user_concurrent_program_name='Supplier Audit Report'
AND fcpt.concurrent_program_id = fcp.concurrent_program_id
AND fcpt.application_id = fcp.application_id
AND fcp.application_id = fat.application_id
AND fcpt.application_id = fat.application_id
AND fcp.executable_id = fet.executable_id
AND fcp.executable_application_id = fet.application_id
AND fet.application_id = fat1.application_id
AND flv.lookup_code = fet.execution_method_code
AND FLV.LOOKUP_TYPE ='CP_EXECUTION_METHOD_CODE'
;

You might also like