select form_name
, u1.user_name
, to_char(f.creation_date)
, u2.user_name
, to_char(f.last_update_date)
from fnd_form f
, fnd_user u1
, fnd_user u2
where ( f.created_by not in (1,-1,0,2,120)
or f.last_updated_by not in (1,-1,0,2,120))
and u1.user_id(+) = f.created_by
and u2.user_id(+) = f.last_updated_by
, u1.user_name
, to_char(f.creation_date)
, u2.user_name
, to_char(f.last_update_date)
from fnd_form f
, fnd_user u1
, fnd_user u2
where ( f.created_by not in (1,-1,0,2,120)
or f.last_updated_by not in (1,-1,0,2,120))
and u1.user_id(+) = f.created_by
and u2.user_id(+) = f.last_updated_by
No comments:
Post a Comment