并发程序与模板的关系SQL

–并发程序与模板的关系
SELECT FC.USER_CONCURRENT_PROGRAM_NAME,
       FC.DESCRIPTION,
       FC.CONCURRENT_PROGRAM_NAME,
       UPPER(FE.EXECUTION_FILE_NAME),
       XTV.DEFAULT_OUTPUT_TYPE,
       FC.OUTPUT_FILE_TYPE
  FROM FND_CONCURRENT_PROGRAMS_VL FC,
       FND_EXECUTABLES_FORM_V     FE,
       FND_APPLICATION            FA,
       XDO_TEMPLATES_VL           XTV
 WHERE 1 = 1
   AND XTV.TEMPLATE_CODE = FC.CONCURRENT_PROGRAM_NAME
   AND XTV.APPLICATION_SHORT_NAME = FA.APPLICATION_SHORT_NAME
   AND FA.APPLICATION_ID = FC.APPLICATION_ID
   AND FC.CONCURRENT_PROGRAM_NAME = FE.EXECUTABLE_NAME
   AND FC.ENABLED_FLAG = 'Y'
   –AND FA.APPLICATION_SHORT_NAME = 'CUX'
   –AND FC.USER_CONCURRENT_PROGRAM_NAME = 'CUX:账户余额表'
 

发表评论

电子邮件地址不会被公开。 必填项已用*标注