Monday, May 9, 2016

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

No comments:

Post a Comment

How to improve blog performance

Improving the performance of a blog can involve a variety of strategies, including optimizing the website's technical infrastructure, im...