[Home] [Help]
[Dependency Information]
| Object Name: | PA_GL_PA_PERIODS_TMP |
|---|---|
| Object Type: | TABLE |
| Owner: | PA |
| FND Design Data: | PA.PA_GL_PA_PERIODS_TMP
|
| Subobject Name: | |
| Status: | VALID |
PA.PA_GL_PA_PERIODS_TMP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.
| Tablespace: | ![]() |
|---|---|
| PCT Free: | 10 |
| PCT Used: | 40 |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PA_PERIOD_NAME | VARCHAR2 | (20) | ||
| GL_PERIOD_NAME | VARCHAR2 | (20) | ||
| PA_START_DATE | DATE | |||
| PA_END_DATE | DATE | |||
| GL_START_DATE | DATE | |||
| GL_END_DATE | DATE | |||
| MULTIPLIER | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT PA_PERIOD_NAME
, GL_PERIOD_NAME
, PA_START_DATE
, PA_END_DATE
, GL_START_DATE
, GL_END_DATE
, MULTIPLIER
FROM PA.PA_GL_PA_PERIODS_TMP;
PA.PA_GL_PA_PERIODS_TMP does not reference any database object
PA.PA_GL_PA_PERIODS_TMP is referenced by following:
APPS
PA_GL_PA_PERIODS_TMP
|
|
|
|