Wednesday 19 June 2013

PO Lookups

SELECT a.lookup_type
,      lookup_code  "Codes"
,      b.user_name
,      to_char(trunc(a.creation_date)) created
FROM po_lookup_codes 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.INACTIVE_DATE,SYSDATE+1) > SYSDATE
ORDER BY a.lookup_type
,      lookup_code
,        b.user_name
,      trunc(a.creation_date)

No comments:

Post a Comment