select * from apps.fnd_concurrent_requests
where concurrent_program_id in (select concurrent_program_id from apps.fnd_concurrent_programs where concurrent_program_name like 'XX_O2C_RAXINV')
order by request_id desc;
From the above query take the requested by and query below with user id to see the user name
select * from apps.fnd_user where user_id=1005316;
Take the responsibility id from above query and search below to find the responsibility name.
select * from apps.fnd_responsibility_vl where responsibility_id=54314;
The argument 1 to argument 15 from first query shows the parameters that are from querying the concurrent program name in system administrator ->program name-> parameters not while submitting passing parameters. Refer that with while submitting parameter names
where concurrent_program_id in (select concurrent_program_id from apps.fnd_concurrent_programs where concurrent_program_name like 'XX_O2C_RAXINV')
order by request_id desc;
From the above query take the requested by and query below with user id to see the user name
select * from apps.fnd_user where user_id=1005316;
Take the responsibility id from above query and search below to find the responsibility name.
select * from apps.fnd_responsibility_vl where responsibility_id=54314;
The argument 1 to argument 15 from first query shows the parameters that are from querying the concurrent program name in system administrator ->program name-> parameters not while submitting passing parameters. Refer that with while submitting parameter names
No comments:
Post a Comment