Wednesday 13 April 2022

Query to find concurrent programs using a value set in its parameter list

SELECT
fcp.user_concurrent_program_name,
fat.application_name,
fdfc.column_seq_num,
fdfc.form_left_prompt parameter_name,
fdfc.enabled_flag
FROM
apps.fnd_descr_flex_col_usage_vl fdfc,
apps.fnd_flex_value_sets ffvs,
apps.fnd_concurrent_programs_vl fcp,
apps.fnd_application_tl fat
WHERE
1 = 1
AND ffvs.flex_value_set_id = fdfc.flex_value_set_id
AND fdfc.descriptive_flexfield_name = '$SRS$.' || fcp.concurrent_program_name
AND fcp.application_id = fat.application_id
AND ffvs.flex_value_set_name = 'JEIT_CALENDAR_MONTH' --value set name

No comments:

Post a Comment