Friday, December 30, 2011
Concurrent Request Details in Oracle Apps R12 - Query
Below query will gather
details like Responsibility name, Application details, Submitted User,
Concurrent manager completion status and text. Etc…
I hope it will be helpful to
you..
SELECT r.request_id,
DECODE (r.description,
NULL, pt.user_concurrent_program_name,
r.description || ' ( ' || pt.user_concurrent_program_name
|| ' ) '
) program,
r.phase_code,
r.status_code,
fnd_amp_private.get_phase (r.phase_code,
r.status_code,
r.hold_flag,
p.enabled_flag,
r.requested_start_date,
r.request_id
) phase,
fnd_amp_private.get_status (r.phase_code,
r.status_code,
r.hold_flag,
p.enabled_flag,
r.requested_start_date,
r.request_id
) status,
u.user_name,
rt.responsibility_name,
AT.application_name,
r.requested_start_date,
r.actual_start_date,
r.actual_completion_date,
r.request_date,
r.argument_text,
r.oracle_session_id,
r.completion_text,
r.controlling_manager,
r.requested_by,
r.program_application_id,
r.concurrent_program_id,
r.is_sub_request,
r.parent_request_id,
r.queue_method_code,
r.cd_id,
r.hold_flag,
p.enabled_flag,
p.concurrent_program_name,
p.user_concurrent_program_name,
r.os_process_id,
r.nls_language,
r.nls_territory,
r.nls_numeric_characters,
r.description
FROM fnd_concurrent_programs_tl pt,
fnd_responsibility_tl rt,
fnd_application_tl AT,
fnd_concurrent_programs_vl p,
fnd_user u,
fnd_concurrent_requests r
WHERE r.program_application_id = p.application_id
AND r.concurrent_program_id = p.concurrent_program_id
AND pt.concurrent_program_id = p.concurrent_program_id
AND pt.application_id = p.application_id
AND pt.LANGUAGE = USERENV ('LANG')
AND u.user_id = r.requested_by
AND rt.application_id = r.responsibility_application_id
AND rt.responsibility_id = r.responsibility_id
AND rt.LANGUAGE = USERENV ('LANG')
AND AT.application_id = r.program_application_id
AND AT.LANGUAGE = USERENV ('LANG')
AND
r.request_id =
:request_id;
Do you think this Article is useful?
Subscribe to:
Post Comments (Atom)
0 Responses to “Concurrent Request Details in Oracle Apps R12 - Query”
Post a Comment