SELECT FNDCON.USER_CONCURRENT_FNDCONRAM_NAME "program name",
FNDCON.CONCURRENT_FNDCONRAM_NAME "program short name",
FNDA.applICATION_NAME "programram application name",
FNDCON.DESCRIPTION "program description",
FNDEX.FNDEXCUTABLE_NAME "FNDEXcutable name",
FNDEX.FNDEXCUTION_FILE_NAME "FNDEXcutable file name",
DECODE( FNDEX.FNDEXCUTION_METHOD_CODE, 'I', 'PLSQL Stored Procedure', 'P', 'Report', 'L', 'SQL Loader','Q','SQL*Plus', FNDEX.FNDEXCUTION_METHOD_CODE) "FNDEXcution method"
FROM FND_FNDEXCUTABLES FNDEX,
FND_FNDAICATION_TL FNDA,
FND_CONCURRENT_PROGRAMS_VL FNDCON
WHERE FNDEX.FNDAICATION_ID = FNDA.FNDAICATION_ID
AND FNDEX.FNDEXCUTABLE_ID = FNDCON.FNDEXCUTABLE_ID
AND FNDA.LANGUAGE ='US'
AND FNDCON.USER_CONCURRENT_PROGRAM_NAME LIKE 'Amway Account Analysis Report';
No comments:
Post a Comment