Query to fond RDF Path
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 ='FILENAME' --Pass ur RDF file name
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 ='FILENAME' --Pass ur RDF file name
No comments:
Post a Comment