pivot test report2

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