Thursday, April 22, 2010

Flexfield List

This query can give list of all flexfields for given modules.


SELECT fa.application_short_name "Application"
, fdft.title "Flex Field Title"
, fdf.descriptive_flexfield_name "Flex Field Name"
, fdf.application_table_name "Table"
, fdf.freeze_flex_definition_flag "Freeze"
, fdf.protected_flag "Protected"
, fdf.context_column_name "Context Column"
, fdft.form_context_prompt "Form Context Prompt"
, fdf.default_context_field_name "Default Context Field"
, fdf.context_required_flag "Required"
, fdf.context_user_override_flag "Display Flag"
, ffvs.flex_value_set_name "Conext Value Set"
FROM applsys.fnd_descriptive_flexs fdf
, applsys.fnd_descriptive_flexs_tl fdft
, applsys.fnd_application fa
, applsys.fnd_flex_value_sets ffvs
WHERE fdf.application_id = fdft.application_id
AND fdf.descriptive_flexfield_name = fdft.descriptive_flexfield_name
AND fa.application_id = fdf.application_id
AND fa.application_short_name in ('AR', 'SQLAP', 'PO', 'SQLGL', 'PA')
and fdf.context_override_value_set_id = ffvs.flex_value_set_id (+)
and fdft.title not like '$SRS$%'
ORDER BY 1,2

3 comments:

  1. Hi Sanjai,

    It is very valuable script! Thank you so much. Just mention that this is descriptive flexfields which will be fetched (key flexfields are also flexfields).
    I just wanted to clarify why there is a part
    'fdft.title not like '$SRS$%''
    in this querry. I have stopped because when I querry all from fnd_descriptive_flexs, there are more than 8000 of those flexfields which starts with $SRS$.
    Do you know what this means?

    Thanks,
    Zane (z_berzina (a) yahoo.com)

    ReplyDelete
  2. The flex fields that starts with “$SRS$.” are used by concurrent programs. For example, flex field $SRS$.APXPBASL is used for accepting parameters for concurrent program “Payment Process Request Program”. I hope this helps.

    ReplyDelete