created_by or last_updated_by - how to find username on those fields
Summary
created_by or last_updated_by - how to find username on those fieldsContent
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
0