Finding the path Means AP/AR/GL

select variable_name, value

from   fnd_env_context

where  variable_name like '%\_TOP' escape '\'

and    concurrent_process_id =

     ( select max(concurrent_process_id) from fnd_env_context )

order by 1

/

col variable_name format a15

col value format a64

select variable_name, value

from   fnd_env_context

where  variable_name like '%\_TOP' escape '\'

and    concurrent_process_id =

     ( select max(concurrent_process_id) from fnd_env_context )

order by 1;

VARIABLE_NAME   VALUE

--------------- ----------------------------------------------------------------

AD_TOP          /d01/oracle/VIS/apps/apps_st/appl/ad/12.0.0

AF_JRE_TOP      /d01/oracle/VIS/apps/tech_st/10.1.3/appsutil/jdk/jre

AHL_TOP         /d01/oracle/VIS/apps/apps_st/appl/ahl/12.0.0

AK_TOP          /d01/oracle/VIS/apps/apps_st/appl/ak/12.0.0

ALR_TOP         /d01/oracle/VIS/apps/apps_st/appl/alr/12.0.0

AME_TOP         /d01/oracle/VIS/apps/apps_st/appl/ame/12.0.0

AMS_TOP         /d01/oracle/VIS/apps/apps_st/appl/ams/12.0.0

AMV_TOP         /d01/oracle/VIS/apps/apps_st/appl/amv/12.0.0

AMW_TOP         /d01/oracle/VIS/apps/apps_st/appl/amw/12.0.0

APPL_TOP        /d01/oracle/VIS/apps/apps_st/appl

AP_TOP          /d01/oracle/VIS/apps/apps_st/appl/ap/12.0.0

AR_TOP          /d01/oracle/VIS/apps/apps_st/appl/ar/12.0.0