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_UNBILLED_REC_REPORTING

Object Details

Object Name:	PA_UNBILLED_REC_REPORTING
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_UNBILLED_REC_REPORTING
Subobject Name:
Status:	VALID

PA_UNBILLED_REC_REPORTING is used to report project unbilled
receivables aging in the MGT: Unbilled Receivables report.
No data exists in this report, since the data is temporarily stored
in the table during the processing of the report, but is never
committed.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	3
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_UNBILLED_REC_REPORTING_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROJECT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_ID	NUMBER	(15)	Yes	The identifier of the project that is reported
EI_BUCKET1	NUMBER	(22)		The first aging bucket for unbilled expenditure item revenue amounts
EI_BUCKET2	NUMBER	(22)		The second aging bucket for unbilled expenditure item revenue amounts
EI_BUCKET3	NUMBER	(22)		The third aging bucket for unbilled expenditure item revenue amounts
EI_BUCKET4	NUMBER	(22)		The fourth aging bucket for unbilled expenditure item revenue amounts
EVENT_BUCKET1	NUMBER	(22)		The first aging bucket for unbilled event revenue amounts
EVENT_BUCKET2	NUMBER	(22)		The second aging bucket for unbilled event revenue amounts
EVENT_BUCKET3	NUMBER	(22)		The third aging bucket for unbilled event revenue amounts
EVENT_BUCKET4	NUMBER	(22)		The fourth aging bucket for unbilled event revenue amounts
EVENT_INV_AMOUNT	NUMBER	(22)		The event amount billed on this project's invoices
COST_WORK_AMOUNT	NUMBER	(22)		The amount billed on this project's invoices for expenditure items in which the revenue amount != bill amount (particularly for projects with COST/WORK distribution rule)
INVOICE_REDUCTION	NUMBER	(22)		The amount of invoice reduction events that have been billed on this project's invoices
RETENTION	NUMBER	(22)		The amount of retention included on this project's invoices

Query Text

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


SELECT PROJECT_ID
,      EI_BUCKET1
,      EI_BUCKET2
,      EI_BUCKET3
,      EI_BUCKET4
,      EVENT_BUCKET1
,      EVENT_BUCKET2
,      EVENT_BUCKET3
,      EVENT_BUCKET4
,      EVENT_INV_AMOUNT
,      COST_WORK_AMOUNT
,      INVOICE_REDUCTION
,      RETENTION
FROM PA.PA_UNBILLED_REC_REPORTING;

Dependencies

[top of page]

PA.PA_UNBILLED_REC_REPORTING does not reference any database object

PA.PA_UNBILLED_REC_REPORTING is referenced by following:

APPS: PA_UNBILLED_REC_REPORTING