VIEW: APPS.OPI_OPM_GL_CALENDAR_V

Source

View Text - Preformatted

SELECT co_code, period_type, period_year, quarter_num, period_num, period_name, start_date, end_date, GL_COST_MTHD from gl_periods gp,gl_sets_of_books gsb,gl_plcy_mst gpm WHERE gp.period_set_name =gsb.period_set_name and gsb.name=gpm.set_of_books_name and gp.period_type=gsb.accounted_period_type and gp.adjustment_period_flag <>'Y'

View Text - HTML Formatted

SELECT CO_CODE
, PERIOD_TYPE
, PERIOD_YEAR
, QUARTER_NUM
, PERIOD_NUM
, PERIOD_NAME
, START_DATE
, END_DATE
, GL_COST_MTHD
FROM GL_PERIODS GP
, GL_SETS_OF_BOOKS GSB
, GL_PLCY_MST GPM
WHERE GP.PERIOD_SET_NAME =GSB.PERIOD_SET_NAME
AND GSB.NAME=GPM.SET_OF_BOOKS_NAME
AND GP.PERIOD_TYPE=GSB.ACCOUNTED_PERIOD_TYPE
AND GP.ADJUSTMENT_PERIOD_FLAG <>'Y'