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_BILL_WRKBENCH_INV_TEMP

Object Details

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

The PA_BILL_WRKBENCH_INV_TEMP temporary table used by Billingworkbench project under Summary by customer region.

Temporary Table Details

PA.PA_BILL_WRKBENCH_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$SESSION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Columns

Name	Datatype	Length	Comments
PROJECT_ID	NUMBER		The identifier of the project for which the record is created.
AGREEMENT_ID	NUMBER		The identifier of the agreement.
CUSTOMER_ID	NUMBER		The identifier of the customer.
CUSTOMER_NAME	VARCHAR2	(2000)	The name of the customer .
PC_FUNDING	NUMBER		The Total baselined funding in project currency.
PC_INVOICED	NUMBER		The Invoiced amount in project currency.
PC_DUE_ACCEPTED	NUMBER		The due amount of accepted invoices in project currency.
PC_DUE_PENDING	NUMBER		The due amount of pending invoices in project currency.
PC_TAX	NUMBER		The tax amount in project currency.
PC_TAX_DUE	NUMBER		The tax amount due in project currency.
PFC_FUNDING	NUMBER		The Total baselined funding in project functional currency.
PFC_INVOICED	NUMBER		The Invoiced amount in project functional currency.
PFC_DUE_ACCEPTED	NUMBER		The due amount of accepted invoices in project functional currency.
PFC_DUE_PENDING	NUMBER		The due amount of pending invoices in project functional currency.
PFC_TAX	NUMBER		The tax amount in project functional currency.
PFC_TAX_DUE	NUMBER		The tax amount due in project functional currency.

Query Text

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


SELECT PROJECT_ID
,      AGREEMENT_ID
,      CUSTOMER_ID
,      CUSTOMER_NAME
,      PC_FUNDING
,      PC_INVOICED
,      PC_DUE_ACCEPTED
,      PC_DUE_PENDING
,      PC_TAX
,      PC_TAX_DUE
,      PFC_FUNDING
,      PFC_INVOICED
,      PFC_DUE_ACCEPTED
,      PFC_DUE_PENDING
,      PFC_TAX
,      PFC_TAX_DUE
FROM PA.PA_BILL_WRKBENCH_INV_TEMP;

Dependencies

[top of page]

PA.PA_BILL_WRKBENCH_INV_TEMP does not reference any database object

PA.PA_BILL_WRKBENCH_INV_TEMP is referenced by following:

APPS: PA_BILL_WRKBENCH_INV_TEMP