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