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;
, 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