add

About Me

My photo
Oracle Apps - Techno Functional consultant

Saturday, September 10

Get the complete history of concurrent program.


SELECT DISTINCT fcpt.user_concurrent_program_name,
frg.request_group_name,
fcp.concurrent_program_name,
-- frt.responsibility_name,
-- uncommment the above to get the list of responsibility's
fat.application_name,
fa.APPLICATION_SHORT_NAME,
fa.BASEPATH
FROM fnd_request_group_units frgu,
fnd_concurrent_programs fcp,
fnd_concurrent_programs_tl fcpt,
fnd_request_groups frg,
fnd_executables fe,
fnd_responsibility fr,
fnd_responsibility_tl frt,
fnd_application_tl fat,
fnd_application fa
WHERE 1 = 1
AND fat.application_id = frgu.application_id
AND frgu.request_unit_id = fcp.concurrent_program_id
AND frgu.request_group_id = frg.request_group_id
AND fe.executable_id = fcp.executable_id
AND fcp.concurrent_program_id = fcpt.concurrent_program_id
AND frg.request_group_id = fr.request_group_id
AND fr.responsibility_id = frt.responsibility_id
AND fa.APPLICATION_ID = fat.APPLICATION_ID
AND fcpt.user_concurrent_program_name LIKE "&concurrent_program_name

No comments: