Tuesday 2 April 2013

To Find The Segment Name in GL

/* Formatted on 4/2/2013 5:28:10 PM (QP5 v5.114.809.3010) */
SELECT   fifst.STRUCTURE_VIEW_NAME,
         fifst.CONCATENATED_SEGMENT_DELIMITER,
         fifs.application_column_name,
         fifs.segment_name,
         fifs.segment_num,
         ffs.flex_value_set_name
  FROM   fnd_id_flex_structures_vl fifst,
         fnd_id_flex_segments fifs,
         fnd_flex_value_sets ffs
 WHERE       1 = 1
         AND fifst.application_id = 101
         AND fifs.application_id = fifst.application_id
         AND fifs.id_flex_code = fifst.id_flex_code
         AND fifs.id_flex_num = fifst.id_flex_num
         AND ffs.flex_value_set_id = fifs.flex_value_set_id;

No comments:

Post a Comment