El Blogcito de Ricardo Dufoo

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

No hay comentarios para esta entrada...

Comentarios estan cerrados.

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...