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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: GL.GL_PERIOD_STATUSES

Object Details

Object Name:	GL_PERIOD_STATUSES
Object Type:	TABLE
Owner:	GL
FND Design Data:	SQLGL.GL_PERIOD_STATUSES
Subobject Name:
Status:	VALID

GL_PERIOD_STATUSES stores the statuses of your accounting periods. Each row includes the accounting period name and status. Many applications maintain their calendars in this table, so each row also includes the relevant application identifier. CLOSING_STATUS is either 'O' for open, 'F' for future enterable, 'C' for closed, 'P' for permanently closed, or 'N' for never opened. Note that you cannot successfully open a period in your Oracle General Ledger application by changing a period's status to 'O' if it has never been opened before. You must use the Open and Close Periods form or programs to properly open a period.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GL_PERIOD_STATUSES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	APPLICATION_ID SET_OF_BOOKS_ID PERIOD_NAME
GL_PERIOD_STATUSES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	APPLICATION_ID SET_OF_BOOKS_ID EFFECTIVE_PERIOD_NUM CLOSING_STATUS
GL_PERIOD_STATUSES_U3	NORMAL	UNIQUE	APPS_TS_TX_IDX	APPLICATION_ID LEDGER_ID PERIOD_NAME
GL_PERIOD_STATUSES_U4	NORMAL	UNIQUE	APPS_TS_TX_IDX	APPLICATION_ID LEDGER_ID EFFECTIVE_PERIOD_NUM CLOSING_STATUS
GL_PERIOD_STATUSES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CLOSING_STATUS

Columns

Name	Datatype	Length	Mandatory	Comments
APPLICATION_ID	NUMBER	(15)	Yes	Application defining column
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Ledger defining column
PERIOD_NAME	VARCHAR2	(15)	Yes	Accounting period name
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CLOSING_STATUS	VARCHAR2	(1)	Yes	Accounting period status
START_DATE	DATE		Yes	Date on which accounting period begins
END_DATE	DATE		Yes	Date on which accounting period ends
YEAR_START_DATE	DATE		Yes	Date on which the year containing this accounting period starts
QUARTER_NUM	NUMBER	(15)	Yes	Quarter number
QUARTER_START_DATE	DATE		Yes	Date on which the quarter containing this accounting period starts
PERIOD_TYPE	VARCHAR2	(15)	Yes	Accounting period type
PERIOD_YEAR	NUMBER	(15)	Yes	Accounting period year
EFFECTIVE_PERIOD_NUM	NUMBER	(15)	Yes	Denormalized period number (period_year*10000 + period_num)
PERIOD_NUM	NUMBER	(15)	Yes	Accounting period number
ADJUSTMENT_PERIOD_FLAG	VARCHAR2	(1)	Yes	Calendar adjustment period flag
CREATION_DATE	DATE			Standard Who column
CREATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
ELIMINATION_CONFIRMED_FLAG	VARCHAR2	(1)		Elimination confirmed flag
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
CONTEXT	VARCHAR2	(150)		Descriptive flexfield context
CHRONOLOGICAL_SEQ_STATUS_CODE	VARCHAR2	(1)		Chronological sequence maintenance status
LEDGER_ID	NUMBER	(15)	Yes	Ledger defining column
MIGRATION_STATUS_CODE	VARCHAR2	(30)		Migration status
TRACK_BC_YTD_FLAG	VARCHAR2	(1)		Track budgetary debit/credit accounts as balance sheet accounts

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT APPLICATION_ID
,      SET_OF_BOOKS_ID
,      PERIOD_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CLOSING_STATUS
,      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
,      CHRONOLOGICAL_SEQ_STATUS_CODE
,      LEDGER_ID
,      MIGRATION_STATUS_CODE
,      TRACK_BC_YTD_FLAG
FROM GL.GL_PERIOD_STATUSES;

Dependencies

[top of page]

GL.GL_PERIOD_STATUSES does not reference any database object

GL.GL_PERIOD_STATUSES is referenced by following:

APPS: GL_PERIOD_STATUSES