Whether GL Period is open or not as of sysdate?
Posted by
Jay 17 June, 2008 600 views
- Current Period Status of Application (oracle 11i)
- GL Handy SQL’s –
- How To Add Responsibility to USER using pl/sql? – Oracle Applications
- GL Date Move for Lockbox Records – Oracle Applications tips – SQL
- Oracle Applications: The Concurrent Jobs Ran Yesterday and Failed – SQL script & Unix Shell Script
select gls.name, gps.closing_status from
apps.GL_PERIOD_STATUSES gps, gl_sets_of_books gls
where 1=1
and gps.start_date <= sysdate
and gps.end_date >= sysdate
and gps.set_of_books_id = gls.set_of_books_id
and gps.set_of_books_id >= &Set_of_books_id
and gps.application_id=&Application_id — 101 = GL, 222 = AR
and gls.chart_of_accounts_id=&chart_of_accounts_id
and gls.name in ( ‘&OperatingUnit’ )
Categories :
11i Scripts, Scripts Oracle
Comments
No comments yet.