Sunday 1 January 2012

which responsibility user has ran

select distinct

user_concurrent_program_name,

responsibility_name,

user_name,

request_date,

argument_text,

request_id,

requested_by,

phase_code,

status_code,

a.concurrent_program_id,

a.responsibility_id,

logfile_name,

outfile_name

from fnd_concurrent_requests a,

fnd_concurrent_programs_tl b,

fnd_responsibility_tl c,

fnd_user d

where a.CONCURRENT_PROGRAM_ID = b.concurrent_program_id

and a.responsibility_id = c.responsibility_id

and a.requested_by = d.user_id

and user_name like 'ELANGO'

No comments:

Post a Comment