SQL Query to Find the Concurrent Request Session Id

 SELECT sess.sid,

       sess.serial#,

       fcr.request_id,

       fcpt.user_concurrent_program_name,

       fcr.requested_start_date,

       fcr.phase_code,

       fcr.status_code

  FROM apps.fnd_concurrent_requests     fcr,

               v$session   sess,

               apps.fnd_concurrent_programs_tl  fcpt

 WHERE     fcr.request_id = &request_id

       AND fcr.phase_code = 'R'

       AND fcr.status_code = 'R'

       AND fcr.oracle_session_id = sess.audsid(+)

       AND fcr.concurrent_program_id = fcpt.concurrent_program_id

Query to find the EBS Instance Refresh/Clone Date

SELECT name, creation_date FROM apps.fnd_apps_system;

SELECT resetlogs_time FROM v$database; 

Query to find the Oracle EBS Application Version

 SELECT RELEASE_NAME FROM apps.FND_PRODUCT_GROUPS

Find a file under specific directories in UNIX

Use below command to find Filename under sub directories of $AP_TOP

find /$AP_TOP -name "Filename*" -print