Thursday 26 July 2012

Query to find Concurrent Executables in Oracle Apps

Query to find Concurrent Programs Name & Executables in Oracle Apps

SELECT
t.concurrent_program_id, t.user_concurrent_program_name,
b.concurrent_program_name, fet.user_executable_name,
fe.execution_file_name, fat.application_name,
fa.application_short_name, fa.product_code
FROM fnd_concurrent_programs_tl t,
fnd_concurrent_programs b,
fnd_executables_tl fet,fnd_executables fe
,fnd_application_tl fat
,
fnd_application fawhERE b.application_id = t.application_id
AND b.concurrent_program_id = t.concurrent_program_id
AND t.LANGUAGE = USERENV ('LANG')
AND fet.executable_id = fe.executable_id
AND fet.application_id = fe.application_id
AND fet.LANGUAGE = USERENV ('LANG')
AND fat.application_id = fa.application_id
AND fat.LANGUAGE = USERENV ('LANG')
AND fa.application_id = fe.application_id
AND b.executable_application_id = fe.application_id
AND b.executable_id = fe.executable_id
AND concurrent_program_name = 'SONA_TKML_SPR_CUST_SCH_DTLS'

No comments:

Post a Comment