El Blogcito de Ricardo Dufoo

Archivos de septiembre, 2012

Consulta para conocer el histórico de ejecuciones de los programas concurrentes en Oracle EBS

por en Sep.20, 2012, archivado en EBS, Oracle

SELECT DISTINCT
fcpt.user_concurrent_program_name,
frg.request_group_name,
fcp.concurrent_program_name,
fat.application_name,
fa.application_short_name,
fa.basepath,
fcpoi.last_run_date,
fcpoi.last_run_request_id,
fcpoi.outcome,
fcpoi.successful_completion,
fcpoi.warning_completion,
fcpoi.error_completion,
fcpoi.min_run_time,
fcpoi.max_run_time,
fcpoi.avg_run_time
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,
fnd_conc_prog_onsite_info fcpoi
WHERE 1 = 1
AND fcpoi.concurrent_program_id = fcp.concurrent_program_id
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

Escribir un Comentario mas...

Busca algo?

Escriba una palabra para buscar en el sitio:

Todavia no encontrando lo que usted esta buscando? Deje un comentario y entraremos en contacto con ud, para poderlo ayudar!

Visita a nuestros amigos!

Amigos recomendados...

Archivos

Entradas, ordenadas por mes...