oracle ebs中并发程序定义查询sql

 

---concurrent program define
SELECT FCPV.CONCURRENT_PROGRAM_ID,
       FCPV.CONCURRENT_PROGRAM_NAME,
       FCPV.USER_CONCURRENT_PROGRAM_NAME,
       FCPV.EXECUTION_METHOD_CODE, ---p:report l:sql*loader h:host
             FEF.APPLICATION_NAME,
             FEF.DESCRIPTION,
             FEF.EXECUTION_FILE_NAME,
             FEF.SUBROUTINE_NAME,
             FEF.EXECUTION_FILE_PATH,
       ----FCPV.DESCRIPTION,      
       FCPV.OUTPUT_FILE_TYPE,
       FCPV.OUTPUT_PRINT_STYLE
  FROM FND_CONCURRENT_PROGRAMS_VL FCPV,
         FND_EXECUTABLES_FORM_V FEF
 WHERE FCPV.EXECUTABLE_ID = FEF.EXECUTABLE_ID
 AND   FCPV.APPLICATION_ID = FEF.APPLICATION_ID
 AND   FCPV.USER_CONCURRENT_PROGRAM_NAME =
       '&p1';
             
             ---parameter list       
SELECT FDFC.COLUMN_SEQ_NUM,
       FDFC.APPLICATION_COLUMN_NAME,
       FDFC.END_USER_COLUMN_NAME,
       FDFC.DESCRIPTION,
       FDFC.FORM_LEFT_PROMPT,
       FDFC.SRW_PARAM,
       ----FDFC.FLEX_VALUE_SET_ID,
       (SELECT FLEX_VALUE_SET_NAME
       FROM  FND_FLEX_VALUE_SETS
       WHERE FDFC.FLEX_VALUE_SET_ID  =FLEX_VALUE_SET_ID) FLEX_VALUE_SET_NAME,
       ----FDFC.DEFAULT_TYPE,
       (SELECT MEANING
       FROM FND_LOOKUP_VALUES_VL
       WHERE LOOKUP_TYPE = 'FLEX_DEFAULT_TYPE'
       AND   LOOKUP_CODE = FDFC.DEFAULT_TYPE
       ) DEFAULT_TYPE_NAME,
       FDFC.DEFAULT_VALUE,
       FDFC.RANGE_CODE,
       FDFC.DISPLAY_FLAG,
       FDFC.DISPLAY_SIZE
  FROM FND_DESCR_FLEX_COL_USAGE_VL FDFC,
         FND_CONCURRENT_PROGRAMS_VL FCPV
 WHERE FDFC.APPLICATION_ID = FCPV.APPLICATION_ID
   AND FDFC.DESCRIPTIVE_FLEXFIELD_NAME = '$SRS$.' || FCPV.CONCURRENT_PROGRAM_NAME
     AND FCPV.USER_CONCURRENT_PROGRAM_NAME =
       '&p1'
 ORDER BY FDFC.COLUMN_SEQ_NUM;