Query to find EXEcutable name from concurrent program name



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';

1 Comments :

Post a Comment