Wednesday 19 June 2013

FND Lookups-2

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

No comments:

Post a Comment