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

Drilldown from GL to Inventory Transactions, Inv to gl Link Query R12,Inventory to General ledger links, r12 ,Inv to gl drill down

Drilldown from GL to Inventory Transactions, Inv to gl Link Query R12,Inventory to General ledger links, r12 ,Inv to gl drill down Link bet...