SELECT flv.lookup_type "Type"
, flv.lookup_code "Code"
-- , flv.meaning "Meaning"
, to_char(flv.creation_date) "Created"
, fu.user_name "Created by"
FROM fnd_lookup_values flv
, fnd_user fu
WHERE enabled_flag = 'Y'
AND fu.user_id = flv.created_by
AND flv.created_by NOT IN (2,1,-1,0)
ORDER BY flv.lookup_type
, flv.lookup_code
, flv.lookup_code "Code"
-- , flv.meaning "Meaning"
, to_char(flv.creation_date) "Created"
, fu.user_name "Created by"
FROM fnd_lookup_values flv
, fnd_user fu
WHERE enabled_flag = 'Y'
AND fu.user_id = flv.created_by
AND flv.created_by NOT IN (2,1,-1,0)
ORDER BY flv.lookup_type
, flv.lookup_code
No comments:
Post a Comment