Executable location in Oracle apps server

SELECT
fcpp.concurrent_request_id req_id, fcp.node_name, fcp.logfile_name
FROM fnd_conc_pp_actions fcpp, fnd_concurrent_processes fcp
WHERE fcpp.processor_id = fcp.concurrent_process_id
 AND fcpp.action_type = 6
 AND fcpp.concurrent_request_id = &request_id;


 SELECT
APPLICATION_NAME,'$'||BASEPATH||'/'||'reports/US'
Reports_Path,EXECUTION_FILE_NAME
FROM APPS.FND_EXECUTABLES_VL A,
APPS.FND_APPLICATION_VL B
WHERE EXECUTION_METHOD_CODE='P'
AND A.APPLICATION_ID=B.APPLICATION_ID
AND EXECUTION_FILE_NAME ='XXU_CUSTOMER_DETAIL'