VIEW: APPS.IGS_FI_GL_PERIODS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'