pivot test report2

Description
Columns: Je Header Id, Ledger Id, Code Combination Id, Period Name, Entered Dr, Entered Cr, Effective Date, Creation Date, Created By ...
select 
je_header_id,
ledger_id,
code_combination_id ,
period_name ,
entered_dr ,
entered_cr ,
effective_date,
creation_date,
created_by
from  
gl_je_lines a                
where 
rownum <500