GL_QUERY

select  jh.je_source,
jh.je_batch_id "Batch Number",
jb.name "Batch Name",
jb.creation_date "Batch Date",
jb.description "Batch Comment",
jl.je_line_num "Line Number",
gcc.segment2 "Account Number",
gcc.segment1 "Balancing Segment",
gcc.segment3 "Cost Center",
fds.type "Doc Type",
substr(jb.default_period_name, instr(jb.default_period_name,'-')+1,length(jb.default_period_name)) "Fiscal Year",
jb.posted_date "Posting Date",
jb.default_effective_date "Effective Date",
jb.default_period_name "Effective Period",
jl.accounted_dr,
jl.accounted_cr,
jh.currency_code "Currency Indicator",
jh.currency_conversion_rate ,
jh.description "Header Description",
jl.description "Line Description",
jh.accrual_rev_status "Reverse Indicator",
jh.accrual_rev_effective_date "Reverse Date",
jh.accrual_rev_period_name,
jh.created_by,
jb.creation_date,
jh.last_update_date
from gl_je_headers jh,
gl_je_batches jb,
gl_je_lines jl,
gl_code_combinations gcc,
fnd_document_sequences fds
where jh.je_batch_id = jb.je_batch_id
and jh.je_header_id = jl.je_header_id
and jl.code_combination_id = gcc.code_combination_id
and fds.doc_sequence_id =jh.doc_sequence_id
AND to_date(TO_CHAR(jb.creation_date,'dd-mon-rrrr') ,'dd-mon-rrrr') BETWEEN to_date('01-Jan-2012','dd-mon-rrrr') AND to_date('31-Dec-2012','dd-mon-rrrr');
--and jb.name ='E14 Purchasing 18290241: A 161476'
--and jl.je_line_num =1;