Oracle EBS Value Set Query, Lookup Query and DFF Query Generator

SELECT s.flex_value_set_id,
       s.flex_value_set_name,
       DECODE(s.validation_type,
              'I', 'Independent', 'D', 'Dependent', 'F', 'Table',
              'N', 'None', 'P', 'Pair', 'U', 'Special',
              'X', 'Translatable independent', 'Y', 'Translatable dependent',
              s.validation_type) AS validation_type,
       s.format_type,
       s.maximum_size,
       s.description
FROM   fnd_flex_value_sets s
WHERE  s.flex_value_set_name = 'XX_COMPANY_VS';

SELECT v.flex_value,
       v.description,
       v.enabled_flag,
       v.parent_flex_value_low,
       v.start_date_active,
       v.end_date_active,
       v.summary_flag
FROM   fnd_flex_values_vl v
JOIN   fnd_flex_value_sets s ON s.flex_value_set_id = v.flex_value_set_id
WHERE  s.flex_value_set_name = 'XX_COMPANY_VS'
ORDER  BY v.parent_flex_value_low, v.flex_value;

-- ADDITIONAL_WHERE_CLAUSE is selected on its own: it is a LONG column and cannot be concatenated
SELECT 'SELECT ' || t.value_column_name
       || NVL2(t.meaning_column_name, ', ' || t.meaning_column_name, '')
       || NVL2(t.id_column_name, ', ' || t.id_column_name, '')
       || ' FROM ' || t.application_table_name AS lov_select,
       t.additional_where_clause
FROM   fnd_flex_validation_tables t
JOIN   fnd_flex_value_sets s ON s.flex_value_set_id = t.flex_value_set_id
WHERE  s.flex_value_set_name = 'XX_COMPANY_VS';

SELECT lv.lookup_code,
       lv.meaning,
       lv.description,
       lv.tag,
       lv.view_application_id,
       lv.security_group_id
FROM   fnd_lookup_values lv
WHERE  lv.lookup_type = 'YES_NO'
AND    lv.language = 'US'
AND    lv.enabled_flag = 'Y'
AND    TRUNC(SYSDATE) BETWEEN NVL(lv.start_date_active, TRUNC(SYSDATE))
                          AND NVL(lv.end_date_active, TRUNC(SYSDATE))
ORDER  BY lv.lookup_code;

SELECT df.descriptive_flexfield_name,
       df.title,
       df.application_table_name,
       u.descriptive_flex_context_code,
       u.column_seq_num,
       u.application_column_name,
       u.end_user_column_name,
       u.form_left_prompt,
       u.enabled_flag,
       u.required_flag,
       s.flex_value_set_name
FROM   fnd_descriptive_flexs_vl df
JOIN   fnd_application fa
       ON fa.application_id = df.application_id
JOIN   fnd_descr_flex_col_usage_vl u
       ON u.application_id = df.application_id
      AND u.descriptive_flexfield_name = df.descriptive_flexfield_name
LEFT JOIN fnd_flex_value_sets s
       ON s.flex_value_set_id = u.flex_value_set_id
WHERE  fa.application_short_name = 'SQLAP'
AND   (df.descriptive_flexfield_name = 'AP_INVOICES' OR df.title = 'AP_INVOICES')
ORDER  BY u.descriptive_flex_context_code, u.column_seq_num;