Monday, March 17, 2014

Query To Find Concurrent Program's Parameters and Value Sets



SELECT
  fcp.user_concurrent_program_name "Concurrent Program Name",
  fcp.concurrent_program_name "Short Name",
  fdfcuv.column_seq_num "Column Seq Number",
  fdfcuv.end_user_column_name "Parameter Name",
  fdfcuv.form_left_prompt "Prompt",
  fdfcuv.srw_param,
  ffvs.flex_value_set_name "Value Set Name",
  flv.meaning "Default Type",
  fdfcuv.DEFAULT_VALUE "Default Value"
FROM
  fnd_concurrent_programs_vl fcp,
  fnd_descr_flex_col_usage_vl fdfcuv,
  fnd_flex_value_sets ffvs,
  fnd_lookup_values flv
WHERE 1=1
  AND fdfcuv.descriptive_flexfield_name = '$SRS$.'||fcp.concurrent_program_name
  AND ffvs.flex_value_set_id = fdfcuv.flex_value_set_id
  AND flv.lookup_type(+) = 'FLEX_DEFAULT_TYPE'
  AND flv.lookup_code(+) = fdfcuv.default_type
--  AND fcp.user_concurrent_program_name like 'XXAA%Report'
--  AND ffvs.flex_value_set_name  LIKE '%JOB%'
ORDER BY
 fcp.user_concurrent_program_name
 ,fdfcuv.column_seq_num
;

1 comment:

Jitendra Kumer said...
This comment has been removed by the author.

Post a Comment

Best Blogger TipsGet Flower Effect