Use the following query to find the scheduled or on hold concurrent request:
select request_id
from fnd_concurrent_requests
where status_code in ('Q','I')
and requested_start_date > SYSDATE
and hold_flag = 'N';
SELECT prha . * FROM po_Requisition_headers_all prha , po_action_history pah WHERE 1 = 1 AND pah . object_id ...
No comments:
Post a Comment