You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

created_by or last_updated_by - how to find username on those fields

edited Oct 15, 2019 4:02PM in Financials – General (READ ONLY) 6 comments

Summary

created_by or last_updated_by - how to find username on those fields

Content

in gl.created_by and gl.last_updated_by I get a number or email address. How do i get the user name?
 
SELECT gl.segment1||'-'||gl.segment2||'-'||gl.segment3||'-'||gl.segment4||'-'||gl.segment5||'-'||gl.segment6||'-'||gl.segment7||'-'||gl.segment8 code_combination, gl.enabled_flag, gl.last_updated_by, TO_CHAR(gl.last_update_date,'MM-DD-YYYY:HH24:MI') last_update_date,gl.CREATED_BY,TO_CHAR(gl.CREATION_DATE,'MM-DD-YYYY:HH24:MI') Creation_date
FROM GL_CODE_COMBINATIONS gl 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!