To find RDF location using concurrent program or execution file name
SELECT Fa.APPLICATION_NAME,'$'
||Fa.BASEPATH
||'/'
||'reports/US' REPORTS_PATH
from FND_CONCURRENT_PROGRAMS_TL FC,
FND_APPLICATION_VL Fa
where 1 =1
and FA.APPLICATION_ID =FC.APPLICATION_ID
AND USER_CONCURRENT_PROGRAM_NAME = 'Past Due Invoice Report' ;
SELECT Fa.APPLICATION_NAME,
'$'
||Fa.BASEPATH
||'/'
||'reports/US' REPORTS_PATH,
FE.EXECUTION_FILE_NAME
from APPS.FND_EXECUTABLES_VL FE,
APPS.FND_APPLICATION_VL FA
WHERE FE.EXECUTION_METHOD_CODE='P'
and FA.APPLICATION_ID =FE.APPLICATION_ID
and FE.EXECUTION_FILE_NAME ='ARXPDI';
No comments:
Post a Comment