eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGS_FI_GL_PERIODS_V

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

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

Name
ROW_ID
APPLICATION_ID
SET_OF_BOOKS_ID
PERIOD_NAME
LAST_UPDATE_DATE
LAST_UPDATED_BY
CLOSING_STATUS
CLOSING_STATUS_MEANING
START_DATE
END_DATE
YEAR_START_DATE
QUARTER_NUM
QUARTER_START_DATE
PERIOD_TYPE
PERIOD_YEAR
EFFECTIVE_PERIOD_NUM
PERIOD_NUM
ADJUSTMENT_PERIOD_FLAG
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
ELIMINATION_CONFIRMED_FLAG
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
CONTEXT