How to display the GL Periods in order (like Jan,Feb,Mar…..)

Oracle Apps Interview QuestionsCategory: GLHow to display the GL Periods in order (like Jan,Feb,Mar…..)
Anonymous asked 4 years ago

I Want to show the period names in the list of values for a report.
For this i have taken period_name column from gl_period_statuses table.
but the periods are displayed in the alphabetical order.But i need in order like
(Jan-13,Feb-13,Mar-13……….Jan-14,Feb-14,Mar-14………….).

1 Answers
Challa Pavan Kumar answered 4 years ago

select period_name
from GL_PERIOD_STATUSES
where APPLICATION_ID = 222
and closing_status = ‘O’
and period_year not in (‘2013’)
ORDER BY PERIOD_YEAR DESC, PERIOD_NUM DESC;