HR Lookup

SELECT a.lookup_type
,      lookup_code "Codes"
,      b.user_name
,      to_char(trunc(a.creation_date)) created
FROM hr_lookups a
,    fnd_user b
WHERE trunc(a.creation_date) > to_date('09-NOV-1995','dd-mon-yyyy')
AND   a.created_by = b.user_id
and   a.created_by NOT IN (2,1,-1,0)
AND NVL(a.END_DATE_ACTIVE,SYSDATE+1) > SYSDATE
AND NVL(a.ENABLED_FLAG,'Y') = 'Y'
ORDER BY a.lookup_type
,      lookup_code
,        b.user_name
,      trunc(a.creation_date)