Thursday 26 December 2013

GL Chart of Accounts

SELECT   flex_value_set_name
       , fnd_value.flex_value account_code
       , fnd_value_tl.description
       , fnd_value.enabled_flag
       , fnd_value.creation_date
       , fu2.description created_by
       , fnd_value.last_update_date
       , fu2.description updated_by
    FROM applsys.fnd_flex_value_sets fnd_set
       , applsys.fnd_flex_values fnd_value
       , applsys.fnd_flex_values_tl fnd_value_tl
       , applsys.fnd_user fu
       , applsys.fnd_user fu2
   WHERE fnd_value.flex_value_set_id = fnd_set.flex_value_set_id
     AND fnd_value_tl.flex_value_id = fnd_value.flex_value_id
     AND fnd_value.last_updated_by = fu.user_id
     AND fnd_value.created_by = fu2.user_id
     AND fnd_value.last_update_date >= '12-FEB-2008'
     AND flex_value_set_name = :set_name
ORDER BY fnd_value.flex_value;

No comments:

Post a Comment