MFG Lookups

SELECT a.lookup_type
,      to_char(lookup_code)  "Codes"
,      b.user_name
,      to_char(trunc(a.creation_date)) created
FROM mfg_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
,        to_char(lookup_code)
,        b.user_name