Concurrent Program Parameters and their tables

Below query can be used to get the details about the parameters of a concurrent program from backend.

This query was tested in R12.1.1 Instance.

SELECT

  B.DESCRIPTIVE_FLEXFIELD_NAME   ,

  B.APPLICATION_COLUMN_NAME      ,

  B.END_USER_COLUMN_NAME         ,

  B.COLUMN_SEQ_NUM               ,

  B.ENABLED_FLAG                 ,

  B.REQUIRED_FLAG                ,

  B.SECURITY_ENABLED_FLAG        ,

  B.DISPLAY_FLAG                 ,

  B.DISPLAY_SIZE                 ,

  B.MAXIMUM_DESCRIPTION_LEN      ,

  B.CONCATENATION_DESCRIPTION_LEN,

  B.FLEX_VALUE_SET_ID            ,

  B.RANGE_CODE                   ,

  B.DEFAULT_TYPE                 ,

  B.DEFAULT_VALUE                ,

  B.SRW_PARAM                    ,

  T.FORM_LEFT_PROMPT             ,

  T.FORM_ABOVE_PROMPT            ,

  T.DESCRIPTION

FROM FND_DESCR_FLEX_COL_USAGE_TL  T,

     FND_DESCR_FLEX_COLUMN_USAGES B

WHERE B.APPLICATION_ID              = T.APPLICATION_ID

AND B.DESCRIPTIVE_FLEXFIELD_NAME    = T.DESCRIPTIVE_FLEXFIELD_NAME

AND B.DESCRIPTIVE_FLEX_CONTEXT_CODE = T.DESCRIPTIVE_FLEX_CONTEXT_CODE

AND B.APPLICATION_COLUMN_NAME       = T.APPLICATION_COLUMN_NAME

AND B.DESCRIPTIVE_FLEXFIELD_NAME    ='$SRS$.'||'&shortname_of_your_program';