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/
Simply go to the location and open any slot recreation you want to read its description and play it for free. While the gameplay is stellar, Ignition’s number of cell slots is restricted comparability with} the desktop version. However, the selection nonetheless features 우리카지노 the most popular video games.
ReplyDelete