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]

VIEW: APPS.PA_PROJ_UNBILLED_BASE_VIEW

Object Details

Object Name:	PA_PROJ_UNBILLED_BASE_VIEW
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_PROJ_UNBILLED_BASE_VIEW
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

PA_PROJ_UNBILLED_BASE_VIEW is a base view that shows summary
unbilled amounts for a project. A base view is a view upon which
other views are built. We recommend that you do not use base views
for reporting and online query; instead, you can more easily use the
less complex views which are built upon the base views.
.
.
PA_PROJ_UNBILLED_BASE_VIEW is a union of unbilled and on hold
bill amounts of unbilled expenditure items and unbilled events.
.
.
You can use the PA_PROJ_UNBILLED_SUMMARY_VIEW view which is built
upon this view to report unbilled summary amounts for a project.

[View Source]

Columns

Name	Datatype	Length	Comments
PROJECT_ID	NUMBER	(15)	Identifier of the project
UNBILLED_ITEM_AMOUNT	NUMBER		Total bill amount of billable expenditure items that are not billed
UNBILLED_ITEM_QUANTITY	NUMBER		Total number of billable expenditure items that are not billed
ON_HOLD_AMOUNT	NUMBER		Total bill amount of billable expenditure items that are not billed and are on permanent billing hold
ON_HOLD_QUANTITY	NUMBER		Total number of billable expenditure items that are not billed and are on permanent billing hold
ONE_TIME_HOLD_AMOUNT	NUMBER		Total bill amount of billable expenditure items that are not billed and are on one-time billing hold
ONE_TIME_HOLD_QUANTITY	NUMBER		Total number of billable expenditure items that are not billed and are on one-time billing hold
UNBILLED_EVENT_AMOUNT	NUMBER		Total bill amount of billing events that are not billed
ITEM_CURRENCY_COUNT	NUMBER		Count of distinct bill trans currency code
ITEM_CURRENCY_CODE	VARCHAR2	(15)	Maximum of bill trans currency code
UB_ITEM_BILL_TRANS_AMOUNT	NUMBER		Total bill trans bill amount of billable expenditure items that are not billed
ON_HOLD_BILL_TRANS_AMOUNT	NUMBER		Total bill trans bill amount of billable expenditure items that are not billed and are on permanent billing hold
ONETIME_HLD_BILL_TRANS_AMOUNT	NUMBER		Total bill trans bill amount of billable expenditure items that are not billed and are on one-time billing hold

Query Text

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


SELECT PROJECT_ID
,      UNBILLED_ITEM_AMOUNT
,      UNBILLED_ITEM_QUANTITY
,      ON_HOLD_AMOUNT
,      ON_HOLD_QUANTITY
,      ONE_TIME_HOLD_AMOUNT
,      ONE_TIME_HOLD_QUANTITY
,      UNBILLED_EVENT_AMOUNT
,      ITEM_CURRENCY_COUNT
,      ITEM_CURRENCY_CODE
,      UB_ITEM_BILL_TRANS_AMOUNT
,      ON_HOLD_BILL_TRANS_AMOUNT
,      ONETIME_HLD_BILL_TRANS_AMOUNT
FROM APPS.PA_PROJ_UNBILLED_BASE_VIEW;

Dependencies

[top of page]

APPS.PA_PROJ_UNBILLED_BASE_VIEW references the following:

APPS: PA_CUST_REV_DIST_LINES; PA_CUST_REV_DIST_LINES_ALL; PA_DRAFT_INVOICE_ITEMS; PA_EVENTS; PA_EXPENDITURE_ITEMS_ALL

APPS.PA_PROJ_UNBILLED_BASE_VIEW is referenced by following:

APPS: PA_PROJ_UNBILLED_SUMMARY_VIEW