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

TABLE: AR.AR_CLOSED_GL_PERIODS

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


Used as a processing table for Cumulative Activity Balance Report.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
PERIOD_NAME VARCHAR2 (15) Yes Accounting period name
START_DATE DATE

Accounting period start date
END_DATE DATE

Accounting period end date
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column. foreign key to FND_USER.USER_ID.
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column. Foreign key to FND_USER.USER_ID.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column. Foreign key to FND_LOGINS.LOGIN_ID.
PERIOD_YEAR NUMBER (15)
Accounting period year
CLOSING_STATUS VARCHAR2 (1)
Accounting period status
Query Text

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


SELECT PERIOD_NAME
,      START_DATE
,      END_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PERIOD_YEAR
,      CLOSING_STATUS
FROM AR.AR_CLOSED_GL_PERIODS;

Dependencies

[top of page]

AR.AR_CLOSED_GL_PERIODS does not reference any database object

AR.AR_CLOSED_GL_PERIODS is referenced by following:

SchemaAPPS
SynonymAR_CLOSED_GL_PERIODS