Follow us: Subscribe via RSS Feed Connect on YouTube Connect on YouTube

Pages

Thursday, 5 May 2016

Segments used in DFF Query

SELECT t.title, t2.descriptive_flex_context_code, t3.application_column_name
  FROM fnd_descriptive_flexs_tl t,
       fnd_descriptive_flexs b,
       fnd_descr_flex_contexts_tl t2,
       fnd_descr_flex_contexts b2,
       fnd_descr_flex_col_usage_tl t3,
       fnd_descr_flex_column_usages b3
 WHERE b.application_id = t.application_id
   AND b.descriptive_flexfield_name = t.descriptive_flexfield_name
   AND t.LANGUAGE = USERENV ('LANG')
 ---  AND t.title = 'Vendor Sites'
   AND b.descriptive_flexfield_name = b2.descriptive_flexfield_name
   AND b2.application_id = t2.application_id
   AND b2.descriptive_flexfield_name = t2.descriptive_flexfield_name
   AND b2.descriptive_flex_context_code = t2.descriptive_flex_context_code
   AND t2.LANGUAGE = USERENV ('LANG')
   AND b2.application_id = b3.application_id
   AND b2.descriptive_flexfield_name = b3.descriptive_flexfield_name
   AND b2.descriptive_flex_context_code = b3.descriptive_flex_context_code
   AND b3.application_id = t3.application_id
   AND b3.descriptive_flexfield_name = t3.descriptive_flexfield_name
   AND b3.descriptive_flex_context_code = t3.descriptive_flex_context_code
   AND b3.application_column_name = t3.application_column_name

   AND t3.LANGUAGE = USERENV ('LANG');
Share this article :

0 comments:

Post a Comment