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_WORKBENCH_TEMP

Object Details

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

The PA_BILL_WORKBENCH_TEMP temporary table used by Billingworkbench project under Billing Summary region.

Temporary Table Details

PA.PA_BILL_WORKBENCH_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.
PC_FUNDING	NUMBER		The Total baselined funding in project currency.
PC_REV_ACCRUED	NUMBER		The total accrued revenue in project currency.
PC_REV_BACKLOG	NUMBER		The diff between PC_Funding and PC_Rev_Accrued project currency.
PC_WRITEOFF	NUMBER		The total write off in project currency .
PC_UBR	NUMBER		The UBR amount in Proejct Currency.
PC_UER	NUMBER		The UER amount in Project currency.
PC_INVOICED	NUMBER		The Invoiced amount in project currency.
PC_INV_BACKLOG	NUMBER		The diff between PC_Funding and PC_Invoiced in project currency.
PC_PAID	NUMBER		The paid amount in project currency.
PC_DUE	NUMBER		The due amount in project currency.
PC_BILLABLE_COST	NUMBER		The billable cost in project curency.
PC_UNBILLED_COST	NUMBER		The unbilled cost in project currency.
PC_UNBILLED_EVENTS	NUMBER		The unbilled events amount in proejct currency.
PC_UNBILLED_RETENTION	NUMBER		The unbilled retention in project currency.
PC_UNAPPRO_INVOICES	NUMBER		The unapprove invoices in proejct currency.
PC_TAX	NUMBER		The tax amount in project currency.
PC_UBR_APPLICAB_FLAG	VARCHAR2	(1)	The UBR applicable flag in Proejct currency .
PC_UER_APPLICAB_FLAG	VARCHAR2	(1)	The UER applicable flag in proejct currency.
PC_UNBIL_EVE_APPLICAB_FLAG	VARCHAR2	(1)	The unbilled event applicable flag in project currency.
PFC_FUNDING	NUMBER		The Total baselined funding in project functional currency.
PFC_REV_ACCRUED	NUMBER		The total accrued revenue in project functional currency.
PFC_REV_BACKLOG	NUMBER		The diff between PFC_Funding and PFC_Rev_Accrued project functional currency.
PFC_WRITEOFF	NUMBER		The total write off in project functional currency .
PFC_UBR	NUMBER		The UBR amount in Proejct functional Currency.
PFC_UER	NUMBER		The UER amount in Project functional currency.
PFC_INVOICED	NUMBER		The Invoiced amount in project functional currency.
PFC_INV_BACKLOG	NUMBER		The diff between PFC_Funding and PFC_Invoiced in project functional currency.
PFC_PAID	NUMBER		The paid amount in project functional currency.
PFC_DUE	NUMBER		The due amount in project functional currency.
PFC_BILLABLE_COST	NUMBER		The billable cost in project functional curency.
PFC_UNBILLED_COST	NUMBER		The unbilled cost in project functional currency.
PFC_UNBILLED_EVENTS	NUMBER		The unbilled events amount in proejct functional currency.
PFC_UNBILLED_RETENTION	NUMBER		The unbilled retention in project functional currency.
PFC_UNAPPRO_INVOICES	NUMBER		The unapprove invoices in proejct functional currency.
PFC_TAX	NUMBER		The tax amount in project functional currency.
PFC_UNBIL_EVE_APPLICAB_FLAG	VARCHAR2	(1)	The unbilled event applicable flag in project functional currency.
NEXT_INVOICE_DATE	DATE		The next invoice date
MULTI_CUSTOMER_FLAG	VARCHAR2	(1)	The multi customer flag.

Query Text

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


SELECT PROJECT_ID
,      PC_FUNDING
,      PC_REV_ACCRUED
,      PC_REV_BACKLOG
,      PC_WRITEOFF
,      PC_UBR
,      PC_UER
,      PC_INVOICED
,      PC_INV_BACKLOG
,      PC_PAID
,      PC_DUE
,      PC_BILLABLE_COST
,      PC_UNBILLED_COST
,      PC_UNBILLED_EVENTS
,      PC_UNBILLED_RETENTION
,      PC_UNAPPRO_INVOICES
,      PC_TAX
,      PC_UBR_APPLICAB_FLAG
,      PC_UER_APPLICAB_FLAG
,      PC_UNBIL_EVE_APPLICAB_FLAG
,      PFC_FUNDING
,      PFC_REV_ACCRUED
,      PFC_REV_BACKLOG
,      PFC_WRITEOFF
,      PFC_UBR
,      PFC_UER
,      PFC_INVOICED
,      PFC_INV_BACKLOG
,      PFC_PAID
,      PFC_DUE
,      PFC_BILLABLE_COST
,      PFC_UNBILLED_COST
,      PFC_UNBILLED_EVENTS
,      PFC_UNBILLED_RETENTION
,      PFC_UNAPPRO_INVOICES
,      PFC_TAX
,      PFC_UNBIL_EVE_APPLICAB_FLAG
,      NEXT_INVOICE_DATE
,      MULTI_CUSTOMER_FLAG
FROM PA.PA_BILL_WORKBENCH_TEMP;

Dependencies

[top of page]

PA.PA_BILL_WORKBENCH_TEMP does not reference any database object

PA.PA_BILL_WORKBENCH_TEMP is referenced by following:

APPS: PA_BILL_WORKBENCH_TEMP