select req.request_id,
req.argument_text,
req.requested_start_date,
req.actual_start_date,
req.actual_completion_date,
(select meaning
from apps.fnd_lookup_values
where lookup_type = 'CP_STATUS_CODE'
AND lookup_code = req.phase_code
and start_date_active is not null) phase,
(select meaning
from apps.fnd_lookup_values
where lookup_type = 'CP_STATUS_CODE'
AND lookup_code = req.status_code
and start_date_active is not null) status,
(usr.user_name || ' - ' || usr.DESCRIPTION) requested_by,
fcpt.user_concurrent_program_name,
(SELECT responsibility_name
FROM apps.fnd_responsibility_tl
WHERE responsibility_id = req.responsibility_id) resp,
req.logfile_name,
req.outfile_name
from apps.fnd_concurrent_requests req,
apps.fnd_user usr,
apps.fnd_concurrent_programs_tl fcpt,
apps.fnd_concurrent_programs fcp
where req.concurrent_program_id = fcpt.concurrent_program_id
and fcp.concurrent_program_id = fcpt.concurrent_program_id
and usr.user_id = req.requested_by
and req.request_id in (&req_id);
req.argument_text,
req.requested_start_date,
req.actual_start_date,
req.actual_completion_date,
(select meaning
from apps.fnd_lookup_values
where lookup_type = 'CP_STATUS_CODE'
AND lookup_code = req.phase_code
and start_date_active is not null) phase,
(select meaning
from apps.fnd_lookup_values
where lookup_type = 'CP_STATUS_CODE'
AND lookup_code = req.status_code
and start_date_active is not null) status,
(usr.user_name || ' - ' || usr.DESCRIPTION) requested_by,
fcpt.user_concurrent_program_name,
(SELECT responsibility_name
FROM apps.fnd_responsibility_tl
WHERE responsibility_id = req.responsibility_id) resp,
req.logfile_name,
req.outfile_name
from apps.fnd_concurrent_requests req,
apps.fnd_user usr,
apps.fnd_concurrent_programs_tl fcpt,
apps.fnd_concurrent_programs fcp
where req.concurrent_program_id = fcpt.concurrent_program_id
and fcp.concurrent_program_id = fcpt.concurrent_program_id
and usr.user_id = req.requested_by
and req.request_id in (&req_id);
Thanks for the informative and useful blog!
ReplyDeleteWe have launched our Resources website with more than 300 SQL queries, case studies, whitepapers etc.
Please have a look at it and see if it would benefit your blog readers. We can also cross-promote your blog and content with us if you’re interested:
https://resource.neocortex.com/