Friday, 4 July 2014

Query to find KEY FLEX FIELDS (KFF)

/* Formatted on 7/4/2014 12:46:34 PM (QP5 v5.115.810.9015) */
SELECT fif.application_id,
       fif.id_flex_code,
       fif.id_flex_name,
       fif.application_table_name,
       fif.description,
       fifs.id_flex_num,
       fifs.id_flex_structure_code,
       fifse.segment_name,
       fifse.segment_num,
       fifse.flex_value_set_id
FROM fnd_id_flexs fif,
     fnd_id_flex_structures fifs,
     fnd_id_flex_segments fifse
WHERE     fif.application_id = fifs.application_id
      AND fif.id_flex_code = fifs.id_flex_code
      AND fifse.application_id = fif.application_id
      AND fifse.id_flex_code = fif.id_flex_code
      AND fifse.id_flex_num = fifs.id_flex_num
      AND fif.id_flex_code LIKE 'GL#'
      AND fif.id_flex_name LIKE 'Accounting Flexfield';

No comments:

Post a Comment