Thursday, July 21, 2016

Concurrent program is running more than once in same timing

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

No comments:

Post a Comment

Types of animations

Animation is a diverse and creative field with a variety of styles that artists and filmmakers use to bring their visions to life. Here are ...