Performance Test2

Description
Columns: Period Name, Je Category, Segment1, Segment2, Segment3, Segment4, Description, Accounted Dr, Accounted Cr, Currency Code ...
select
gjl.period_name,
gjh.je_category,
gcc.segment1,
gcc.segment2,
gcc.segment3,
gcc.segment4,
gjl.description,
gjl.accounted_dr,
gjl.accounted_cr,
gjh.currency_code
from
gl_je_headers gjh,
gl_je_lines gjl,
gl_code_combinations gcc
where
1=1 and
gjh.status='P' and
gjh.je_header_id=gjl.je_header_id and
gjl.code_combination_id=gcc.code_combination_id
Parameter Name SQL text Validation
Rownum Limit
rownum<=:rownum_limit
Number