Script to find Scheduled synchronous activities and requesting sets
By Jag - November 03, 2014
How to Script discover Scheduled simultaneous projects and solicitation sets
SELECT
A.request_id,
B.user_name,
C.user_concurrent_program_name,
C.argument_text
FROM
Fnd_concurrent_requests A,
Fnd_user B,
Fnd_conc_req_summary_v C
WHERE
B.user_id = A.requested_by
What's more A.request_id = C.request_id
What's more A.requested_start_date > SYSDATE
What's more A.hold_flag = "N"
What's more A.status_code IN ('Q','i')
What's more B.user_name LIKE "%"
What's more A.description LIKE "%"
Request BY
A.request_id
0 comments