Pages

Thursday, May 9, 2013

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

1 comment:

  1. Your website is very good and nice information was provided in your site, thanks for sharing.

    Oracle Project Accounting Training in Ameerpet, Hyderabad

    ReplyDelete