View: IGS_FI_GL_PERIODS_V

Product:	IGS - Student System
Description:	Used to retrieve the Accounting Periods created in Oracle Financials (General Ledger Module) for Oracle Student System.
Implementation/DBA Data:	APPS.IGS_FI_GL_PERIODS_V

View Text

SELECT PER.ROWID
, PER.APPLICATION_ID
, PER.SET_OF_BOOKS_ID
, PER.PERIOD_NAME
, PER.LAST_UPDATE_DATE
, PER.LAST_UPDATED_BY
, PER.CLOSING_STATUS
, LKP.MEANING
, PER.START_DATE
, PER.END_DATE
, PER.YEAR_START_DATE
, PER.QUARTER_NUM
, PER.QUARTER_START_DATE
, PER.PERIOD_TYPE
, PER.PERIOD_YEAR
, PER.EFFECTIVE_PERIOD_NUM
, PER.PERIOD_NUM
, PER.ADJUSTMENT_PERIOD_FLAG
, PER.CREATION_DATE
, PER.CREATED_BY
, PER.LAST_UPDATE_LOGIN
, PER.ELIMINATION_CONFIRMED_FLAG
, PER.ATTRIBUTE1
, PER.ATTRIBUTE2
, PER.ATTRIBUTE3
, PER.ATTRIBUTE4
, PER.ATTRIBUTE5
, PER.CONTEXT
FROM GL_PERIOD_STATUSES PER
, IGS_LOOKUP_VALUES LKP
WHERE PER.APPLICATION_ID = 8405
AND PER.ADJUSTMENT_PERIOD_FLAG = 'N'
AND PER.CLOSING_STATUS = LKP.LOOKUP_CODE
AND LKP.LOOKUP_TYPE = 'IGS_FI_CLOSING_STATUS'

Columns