Query to get the flex structure oracle apps

Query to get the flex structure oracle apps

In this post, We will be discussing about the query to get the flex structure oracle apps. This Query will help to extract the complete Chart of Account Flex Structure in Oracle apps. We can get the flex structure for any module like GL , FA , Inventory , Purchasing in oracle apps. This is one of the Important sql query to extract the flex structures in oracle apps. Here , I will share the important DB tables relate to flex structures and the detail sql query to get the flex structure oracle apps.

Most Important Tables used by query to get the flex structure oracle apps

1.fnd_id_flex_structures

2.fnd_id_flexs

3.fnd_application_tl

4.fnd_id_flex_structures_tl

Detail query to get the flex structure oracle apps

SELECT fifs.id_flex_code Module_Name,fat.application_name Application_Name,

       fifs.id_flex_structure_code Flex_Structure_Code,

       fif.id_flex_name Flexfield_title,

       fifst.id_flex_structure_name Flex_Structure_Title,

       fifst.description Flex_Structure_Descr,

       decode(fifs.FREEZE_FLEX_DEFINITION_FLAG,'Y','Yes','N','No') Flex_Freeze_yes_no,

       decode(ENABLED_FLAG,'Y','Checked','N','Unchacked') Enabled,

     decode(FREEZE_STRUCTURED_HIER_FLAG,'Y','Yes','N','No') "Freeze Rollup Group" ,

       decode(DYNAMIC_INSERTS_ALLOWED_FLAG,'Y','Yes','N','No') "Allow Dyanamic Insert",

       CONCATENATED_SEGMENT_DELIMITER Flex_Segment_Separator,

       decode(CROSS_SEGMENT_VALIDATION_FLAG,'Y','Yes','N','No') "Cross-Validation Segment"

  FROM fnd_id_flex_structures fifs,

       fnd_id_flexs fif,

       fnd_application_tl fat,

       fnd_id_flex_structures_tl fifst

 WHERE fif.application_id = fat.application_id

   AND fifs.id_flex_code = fif.id_flex_code

   AND fifst.id_flex_num = fifs.id_flex_num

   AND fifst.id_flex_code = fifs.id_flex_code

   AND fifs.id_flex_code = 'GL#'