Simple concurrent program query to view scheduled and pending Noetix concurrent programs:
SELECT fcr.*
FROM applsys.fnd_concurrent_requests fcr,
applsys.fnd_application fa
WHERE 1 =1
AND fcr.program_application_id = fa.application_id
AND fa.application_short_name = 'XXNAO'
AND fcr.phase_code = 'P'
AND fcr.status_code = 'Q'
This is nice to check to monitor these programs through SQL.
SELECT fcr.*
FROM applsys.fnd_concurrent_requests fcr,
applsys.fnd_application fa
WHERE 1 =1
AND fcr.program_application_id = fa.application_id
AND fa.application_short_name = 'XXNAO'
AND fcr.phase_code = 'P'
AND fcr.status_code = 'Q'
This is nice to check to monitor these programs through SQL.
No comments:
Post a Comment