FND Lookups-1

SELECT   fcl.lookup_type            "Type"
,        fcl.lookup_code            "Code"
-- ,        fcl.meaning                "Meaning"
,        to_char(fcl.creation_date)          "Created"
,        fu.user_name               "Created by"
FROM     fnd_common_lookup_types     fclt
,        fnd_common_lookups          fcl
,        fnd_user                    fu
WHERE    trunc(NVL(end_date_active
                  ,sysdate))
>=       trunc(SYSDATE)
AND      fcl.lookup_type           = fclt.lookup_type(+)
AND      fu.user_id                = fcl.created_by
AND      fcl.created_by            NOT IN (2,1,-1)
ORDER BY fcl.lookup_type
,        fcl.lookup_code