OracleAppsToday
All about Oracle Apps. API examples, Codes and tweaks, Commands, Tips and Tricks
Wednesday, January 28, 2015
Query to find the parent request id recursively
SELECT request_id,
description
FROM fnd_concurrent_requests
WHERE NVL (request_type, 'X') = 'M'
CONNECT BY PRIOR parent_request_id = request_id
START WITH request_id = &RequestID;
‹
›
Home
View web version