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)
, 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