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: PA.PA_REV_AE_LINES_TMP

Object Details

Object Name:	PA_REV_AE_LINES_TMP
Object Type:	TABLE
Owner:	PA
Subobject Name:
Status:	VALID

The PA_REV_AE_LINES_TMP temporary table used by revenue xla upgrade.

Temporary Table Details

PA.PA_REV_AE_LINES_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.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_REV_AE_LINES_TMP_U1	NORMAL	UNIQUE		AE_HEADER_ID AE_LINE_NUM

Columns

Name	Datatype	Length	Comments
AE_HEADER_ID	NUMBER	(15)	The identifier of the xla header for which the record is created.
AE_LINE_NUM	NUMBER	(15)	The identifier of the xla line num for which the record is created.
GL_BATCH_NAME	VARCHAR2	(30)	The revenue GL Batch name.
CODE_COMBINATION_ID	NUMBER	(15)	The Revenue GL Code combination.
DIST_TYPE	VARCHAR2	(60)	The Revenue distribution type .

Query Text

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


SELECT AE_HEADER_ID
,      AE_LINE_NUM
,      GL_BATCH_NAME
,      CODE_COMBINATION_ID
,      DIST_TYPE
FROM PA.PA_REV_AE_LINES_TMP;

Dependencies

[top of page]

PA.PA_REV_AE_LINES_TMP does not reference any database object

PA.PA_REV_AE_LINES_TMP is referenced by following:

APPS: PA_REV_AE_LINES_TMP