While building a report, I was asked to print report title that matches the name of the concurrent program, date the report was executed, and the only report paremeter with its meaning.
The title of the report and execution date is simple. The parameter reads its values from an independent value set. So, I started to think how to get hold of the value set ID and what table do I need to read for the meaning, etc. And then!!! I recollected my own blog.
The resulting query is here without much explanations.
select fcr.actual_start_date report_start_date
, fcp.user_concurrent_program_name
, fu.user_name submitted_by
, fcr.argument1 parameter_code
, oe_sys_parameters_util.get_value(fdfcu.flex_value_set_id, fcr.argument1) parameter_description
from fnd_concurrent_requests fcr
, fnd_concurrent_programs_vl fcp
, fnd_user fu
, FND_DESCR_FLEX_COL_USAGE_VL fdfcu
where fcr.concurrent_program_id = fcp.concurrent_program_id
and fcr.requested_by = fu.user_id
and fdfcu.descriptive_flexfield_name = ‘$SRS$.’|| fcp.concurrent_program_name
and fdfcu.application_column_name = ‘ATTRIBUTE1′
and fcr.request_id = fnd_global.conc_request_id