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_DRAFT_REV_INV_TEMP

Object Details

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

The PA_DRAFT_REV_INV_TEMP temporary table used by UBR UER Summary concurrent Process.

Temporary Table Details

PA.PA_DRAFT_REV_INV_TEMP 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	Column
PA_DRAFT_REV_INV_TEMP_U1	NORMAL	UNIQUE	PROJECT_ID DRAFT_REV_INV_NUM
PA_DRAFT_REV_INV_TEMP_N1	NORMAL	NONUNIQUE	UBR_ACCOUNT_SEGMENT UBR_COST_CENTER_SEGMENT GL_PERIOD_START_DATE INSERT_UPDATE_FLAG
PA_DRAFT_REV_INV_TEMP_N2	NORMAL	NONUNIQUE	UER_ACCOUNT_SEGMENT UER_COST_CENTER_SEGMENT GL_PERIOD_START_DATE INSERT_UPDATE_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_ID	NUMBER		Yes	The identifier of the project for which the record is created.
DRAFT_REV_INV_NUM	NUMBER		Yes	The draft revenue or invoice number.
UBR_ACCOUNT_SEGMENT	VARCHAR2	(30)	Yes	The UBR account segment.
UBR_COST_CENTER_SEGMENT	VARCHAR2	(30)	Yes	The UBR cost center segment.
UER_ACCOUNT_SEGMENT	VARCHAR2	(30)	Yes	The UER account segment.
UER_COST_CENTER_SEGMENT	VARCHAR2	(30)	Yes	The UER cost center segment.
GL_PERIOD_START_DATE	DATE		Yes	The GL period start date.
GL_PERIOD_NAME	VARCHAR2	(15)	Yes	The GL period name.
INSERT_UPDATE_FLAG	VARCHAR2	(1)	Yes	The insert update flag.
UBR_SUMMARY_ID	NUMBER			The UBR summary Id.
UER_SUMMARY_ID	NUMBER			The UER summary Id.
UNBILLED_RECEIVABLE_DR	NUMBER			The unbilled receivable amount.
UNEARNED_REVENUE_CR	NUMBER			The unearned revenue amount.

Query Text

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


SELECT PROJECT_ID
,      DRAFT_REV_INV_NUM
,      UBR_ACCOUNT_SEGMENT
,      UBR_COST_CENTER_SEGMENT
,      UER_ACCOUNT_SEGMENT
,      UER_COST_CENTER_SEGMENT
,      GL_PERIOD_START_DATE
,      GL_PERIOD_NAME
,      INSERT_UPDATE_FLAG
,      UBR_SUMMARY_ID
,      UER_SUMMARY_ID
,      UNBILLED_RECEIVABLE_DR
,      UNEARNED_REVENUE_CR
FROM PA.PA_DRAFT_REV_INV_TEMP;

Dependencies

[top of page]

PA.PA_DRAFT_REV_INV_TEMP does not reference any database object

PA.PA_DRAFT_REV_INV_TEMP is referenced by following:

APPS: PA_DRAFT_REV_INV_TEMP