531: from
532: fnd_application a,
533: fnd_concurrent_programs p,
534: fnd_descr_flex_column_usages f,
535: fnd_flex_value_sets v
536: WHERE
537: a.application_short_name = m_report.conc_appname AND
538: a.application_id = p.application_id AND
539: p.concurrent_program_name = m_report.concurrent_program_name AND
923: v.flex_value_set_id,
924: v.flex_value_set_name
925: from
926: fnd_descr_flex_col_usage_vl d,
927: fnd_flex_value_sets v,
928: fnd_concurrent_programs c,
929: fnd_concurrent_requests r
930: WHERE
931: r.request_id = l_request_id