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: INV.ORG_ACCT_PERIODS

Object Details

Object Name:	ORG_ACCT_PERIODS
Object Type:	TABLE
Owner:	INV
FND Design Data:	INV.ORG_ACCT_PERIODS
Subobject Name:
Status:	VALID

ORG_ACCT_PERIODS holds the open and closed financial periods for
organizations. When a period is opened, the period open form
(INVTTGPO) pulls in the next available period from the GL table
GL_PERIODS. ORG_ACCT_PERIODS holds the relevant data, such as period
start, end and close dates. Note that only postable periods will be
brought over. You may create non-postable periods in Oracle General
Ledger or in the GL forms provided with Oracle Inventory. If data
exists in the PERIOD_CLOSE_DATE column, then the period has been
closed and no more transactions can be made against the closed period.
The combination of the PERIOD_CLOSE_DATE and OPEN_FLAG columns
reflects the status of a period. When OPEN_FLAG = 'P', it means the
period close is processing. When it equals 'N', the period
close process is completed. When OPEN_FLAG is 'Y' and
PERIOD_CLOSE_DATE is null, it means the period is open. Otherwise, it
implies the period close process has failed.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ORG_ACCT_PERIODS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID ACCT_PERIOD_ID
ORG_ACCT_PERIODS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID PERIOD_YEAR PERIOD_NUM PERIOD_NAME
ORG_ACCT_PERIODS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OPEN_FLAG ORGANIZATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ACCT_PERIOD_ID	NUMBER		Yes	Accounting period id
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
PERIOD_SET_NAME	VARCHAR2	(15)	Yes	GL period set name
PERIOD_YEAR	NUMBER		Yes	GL period year
PERIOD_NUM	NUMBER		Yes	GL period number
PERIOD_NAME	VARCHAR2	(15)	Yes	GL period name
DESCRIPTION	VARCHAR2	(50)		Description - (not currently used)
PERIOD_START_DATE	DATE		Yes	Start date of accounting period
SCHEDULE_CLOSE_DATE	DATE		Yes	Scheduled close date of the accounting period
PERIOD_CLOSE_DATE	DATE			Actual close date of the accounting period
OPEN_FLAG	VARCHAR2	(1)	Yes	Indicates the status of the period: 'P' if the period close is processing; 'N' if the period is closed; 'Y' if the period is either open (if period close date is NULL) or the period close has failed (if period close date is not NULL)
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Global descriptive flexfield structure defining column
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)		Global descriptive flexfield segment
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)		Global descriptive flexfield segment
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)		Global descriptive flexfield segment
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)		Global descriptive flexfield segment
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)		Global descriptive flexfield segment
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)		Global descriptive flexfield segment
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)		Global descriptive flexfield segment
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)		Global descriptive flexfield segment
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)		Global descriptive flexfield segment
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)		Global descriptive flexfield segment
GLOBAL_ATTRIBUTE11	VARCHAR2	(150)		Global descriptive flexfield segment
GLOBAL_ATTRIBUTE12	VARCHAR2	(150)		Global descriptive flexfield segment
GLOBAL_ATTRIBUTE13	VARCHAR2	(150)		Global descriptive flexfield segment
GLOBAL_ATTRIBUTE14	VARCHAR2	(150)		Global descriptive flexfield segment
GLOBAL_ATTRIBUTE15	VARCHAR2	(150)		Global descriptive flexfield segment
GLOBAL_ATTRIBUTE16	VARCHAR2	(150)		Global descriptive flexfield segment
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)		Global descriptive flexfield segment
GLOBAL_ATTRIBUTE18	VARCHAR2	(150)		Global descriptive flexfield segment
GLOBAL_ATTRIBUTE19	VARCHAR2	(150)		Global descriptive flexfield segment
GLOBAL_ATTRIBUTE20	VARCHAR2	(150)		Global descriptive flexfield segment
SUMMARIZED_FLAG	VARCHAR2	(1)		Indicates whether this period has been summarized.

Query Text

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


SELECT ACCT_PERIOD_ID
,      ORGANIZATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PERIOD_SET_NAME
,      PERIOD_YEAR
,      PERIOD_NUM
,      PERIOD_NAME
,      DESCRIPTION
,      PERIOD_START_DATE
,      SCHEDULE_CLOSE_DATE
,      PERIOD_CLOSE_DATE
,      OPEN_FLAG
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      SUMMARIZED_FLAG
FROM INV.ORG_ACCT_PERIODS;

Dependencies

[top of page]

INV.ORG_ACCT_PERIODS does not reference any database object

INV.ORG_ACCT_PERIODS is referenced by following:

INV: ORG_ACCT_PERIODS#