ERPstuff - Oracle EBS Community

Hi Emanuel

If u r using gl_je_lines table in ur query
u can use gl_periods table also
and link in ur where clause gl_periods.period_name=gl_je_lines.period_name
and use gl_periods.start_date and gl_periods.end_date
as ur date parameters instead of periods.
hope this help u.


Thank You


Regards ...