View: PMI_GL_CALENDAR_V

Product:	PMI - Process Manufacturing Intelligence (Obsolete)
Description:	View to link GL Calendar to OPM Company
Implementation/DBA Data:	APPS.PMI_GL_CALENDAR_V

View Text

SELECT CO_CODE
, PERIOD_TYPE
, PERIOD_YEAR
, QUARTER_NUM
, PERIOD_NUM
, PERIOD_NAME
, START_DATE
, END_DATE
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'

Columns