Monday, 28 March 2016

Query for to get Standard Concurrent Programs with arguments and valuesets in oracle apps R12

SELECT FCPL.USER_CONCURRENT_PROGRAM_NAME USER_CONCURRENT_PROGRAM_NAME,
       FDFCUV.COLUMN_SEQ_NUM COLUMN_SEQ_NUM,
       FDFCUV.END_USER_COLUMN_NAME PARAMETER_NAME,
       FDFCUV.FORM_LEFT_PROMPT PROMPT, FDFCUV.ENABLED_FLAG ENABLED_FLAG,
       FDFCUV.REQUIRED_FLAG REQUIRED_FLAG,
       FDFCUV.DISPLAY_FLAG DISPLAY_FLAG,
       FFVS.FLEX_VALUE_SET_NAME FLEX_VALUE_SET_NAME
  FROM fnd_concurrent_programs fcp,
       fnd_concurrent_programs_tl fcpl,
       fnd_descr_flex_col_usage_vl fdfcuv,
       fnd_flex_value_sets ffvs,
       fnd_lookup_values flv
 WHERE 1 = 1
   AND fcp.concurrent_program_id = fcpl.concurrent_program_id
   AND fdfcuv.descriptive_flexfield_name =
                                       '$SRS$.' || fcp.concurrent_program_name
   AND ffvs.flex_value_set_id = fdfcuv.flex_value_set_id
   AND flv.lookup_code(+) = fdfcuv.default_type
   AND flv.lookup_type(+) = 'FLEX_DEFAULT_TYPE'
   AND fcpl.LANGUAGE = USERENV ('LANG')
   AND flv.LANGUAGE(+) =
          USERENV
             ('LANG')
--AND    fcpl.user_concurrent_program_name LIKE 'XXENEUR%'
AND ffvs.flex_value_set_name NOT LIKE 'XX%'
And fcp.CONCURRENT_PROGRAM_NAME in(
'APXAAREP',
'APXCRRCR'
))

No comments:

Post a Comment