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

Posted by Sanjai Misra at 11:40 AM
Labels:

6 comments:

  1. ZaneThursday, November 11, 2010 at 6:26:00 AM CST

    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. Sanjai MisraThursday, November 11, 2010 at 12:36:00 PM CST

    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
  3. Enggar.PutriTuesday, July 28, 2015 at 3:38:00 AM CDT

    thanks tht code help a lot :D

    ReplyDelete
  4. OurbiMtinc_naSaturday, April 23, 2022 at 2:09:00 PM CDT

    OurbiMtinc_na Jared Ellenberg https://wakelet.com/wake/-P5-f31J80duX-1r1Sm4W
    coabestlugoo

    ReplyDelete
  5. OraclatempzuThursday, August 25, 2022 at 7:35:00 PM CDT

    Oraclatempzu Scott Moser Everest
    CorelDRAW
    Adobe Lightroom
    printalfethe

    ReplyDelete
  6. irtegsyng-paWednesday, November 30, 2022 at 1:53:00 PM CST

    irtegsyng-pa Erica Cain This is there

    scoutareshos

    ReplyDelete

Subscribe to: Post Comments (Atom)