--Concurrent program is running more than once in same timing
SELECT prog.user_concurrent_program_name,
actual_start_date,
argument_text,
requested_by,
RESPONSIBILITY_ID,
COUNT(*)
FROM apps.fnd_concurrent_requests xx,apps.fnd_concurrent_programs_tl prog
WHERE status_code = 'C' and prog.concurrent_program_id =xx.concurrent_program_id
AND prog.language='US' AND TRUNC (actual_start_date) >= TRUNC (SYSDATE)-40
AND application_id=20003
AND prog.user_concurrent_program_name='Amway Inventory Adjustment Interface'
GROUP BY prog.user_concurrent_program_name,
actual_start_date,
argument_text,
requested_by,
RESPONSIBILITY_ID
HAVING COUNT(*) > 1
SELECT prog.user_concurrent_program_name,
actual_start_date,
argument_text,
requested_by,
RESPONSIBILITY_ID,
COUNT(*)
FROM apps.fnd_concurrent_requests xx,apps.fnd_concurrent_programs_tl prog
WHERE status_code = 'C' and prog.concurrent_program_id =xx.concurrent_program_id
AND prog.language='US' AND TRUNC (actual_start_date) >= TRUNC (SYSDATE)-40
AND application_id=20003
AND prog.user_concurrent_program_name='Amway Inventory Adjustment Interface'
GROUP BY prog.user_concurrent_program_name,
actual_start_date,
argument_text,
requested_by,
RESPONSIBILITY_ID
HAVING COUNT(*) > 1
No comments:
Post a Comment