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: AX.AX_PERIOD_STATUSES

Object Details

Object Name:	AX_PERIOD_STATUSES
Object Type:	TABLE
Owner:	AX
FND Design Data:	AX.AX_PERIOD_STATUSES
Subobject Name:
Status:	VALID

This table stores the number of Inventory organizations having opened
an accounting period. The period is considered closed if it is not
open for any organization and opened if it is open for at least
one organization.
Each row contains the period identifier in GL_PERIOD_STATUSES and a
counter for the number of Inventory organizations having the period
open.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: AX_PERIOD_STATUSES_PK

APPLICATION_ID
SET_OF_BOOKS_ID
PERIOD_NAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
AX_PERIOD_STATUSES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	APPLICATION_ID SET_OF_BOOKS_ID PERIOD_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
APPLICATION_ID	NUMBER	(15)	Yes	Application identifier
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Set of books identifier
PERIOD_NAME	VARCHAR2	(15)	Yes	Period name
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
INV_USAGE_COUNT	NUMBER	(15)		Number of Inventory organizations having the period open
BEGIN_BALANCE_DR	NUMBER			Begin balance accounted debit for the period as computed by the Journal Sequencing Program.
BEGIN_BALANCE_CR	NUMBER			Begin balance accounted credit for the period as computed by the Journal Sequencing Program
PERIOD_NET_DR	NUMBER			Period net accounted debit as computed by the Journal Sequencing Program.
PERIOD_NET_CR	NUMBER			Period net accounted credit as computed by the Journal Sequencing Program.

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
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      INV_USAGE_COUNT
,      BEGIN_BALANCE_DR
,      BEGIN_BALANCE_CR
,      PERIOD_NET_DR
,      PERIOD_NET_CR
FROM AX.AX_PERIOD_STATUSES;

Dependencies

[top of page]

AX.AX_PERIOD_STATUSES does not reference any database object

AX.AX_PERIOD_STATUSES is referenced by following:

APPS: AX_PERIOD_STATUSES