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

TABLE: AR.AR_PERIODS

Object Details
Object Name: AR_PERIODS
Object Type: TABLE
Owner: AR
FND Design Data: TableAR.AR_PERIODS
Subobject Name:
Status: VALID


The AR_PERIODS table is a denormalized table that Receivables uses to improve performance in the AutoInvoice and Revenue Recognition programs. This table is populated from the GL_PERIOD_STATUSES table, and includes rows where the ADJUSTMENT_PERIOD_FLAG column in the GL_PERIOD_STATUSES table is N.
.
The NEW_PERIOD_NUM column stores the sequence of the period if ordered by accounting period start date within an accounting period type.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AR_PERIODS_U1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPERIOD_SET_NAME
ColumnPERIOD_TYPE
ColumnNEW_PERIOD_NUM
AR_PERIODS_U2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPERIOD_SET_NAME
ColumnPERIOD_TYPE
ColumnEND_DATE
ColumnSTART_DATE
AR_PERIODS_U3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPERIOD_SET_NAME
ColumnPERIOD_NAME
AR_PERIODS_U4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPERIOD_TYPE
ColumnPERIOD_SET_NAME
ColumnSTART_DATE
Columns
Name Datatype Length Mandatory Comments
PERIOD_SET_NAME VARCHAR2 (30) Yes Accounting set name
PERIOD_TYPE VARCHAR2 (30) Yes Accounting period type
START_DATE DATE
Yes Date when accounting period begins
END_DATE DATE
Yes Date when accounting period ends
NEW_PERIOD_NUM NUMBER

Maintains the next nonadjusting period within the same period set name and period type
PERIOD_NAME VARCHAR2 (30) Yes System-generated accounting period name
Query Text

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


SELECT PERIOD_SET_NAME
,      PERIOD_TYPE
,      START_DATE
,      END_DATE
,      NEW_PERIOD_NUM
,      PERIOD_NAME
FROM AR.AR_PERIODS;

Dependencies

[top of page]

AR.AR_PERIODS does not reference any database object

AR.AR_PERIODS is referenced by following:

SchemaAR
ViewAR_PERIODS#