[Home] [Help] [Dependency Information]

TABLE: PA.PA_PERIODS_ALL

Object Details

Object Name:	PA_PERIODS_ALL
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_PERIODS_ALL
Subobject Name:
Status:	VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_PERIODS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PERIOD_NAME ORG_ID
PA_PERIODS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	START_DATE END_DATE ORG_ID
PA_PERIODS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STATUS
PA_PERIODS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GL_PERIOD_NAME
PA_PERIODS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CURRENT_PA_PERIOD_FLAG
PA_PERIODS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	END_DATE START_DATE PERIOD_NAME

Columns

Query Text

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

SELECT PERIOD_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      START_DATE
,      END_DATE
,      STATUS
,      GL_PERIOD_NAME
,      CURRENT_PA_PERIOD_FLAG
,      ORG_ID
FROM PA.PA_PERIODS_ALL;

Dependencies

[top of page]

PA.PA_PERIODS_ALL does not reference any database object

PA.PA_PERIODS_ALL is referenced by following:

APPS

PA_PERIODS

PA_PERIODS_ALL