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