[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PA_PROJ_UNBILLED_SUMMARY_VIEW |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  PA.PA_PROJ_UNBILLED_SUMMARY_VIEW
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
PA_PROJ_UNBILLED_SUMMARY_VIEW is a view that shows summary unbilled
amounts for a project. These amounts include items that are unbilled,
items on hold, and events that are unbilled.
.
.
You can easily review the unbilled summary status of your project
using this view.
.
.
| Name | Datatype | Length | Mandatory | 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 |
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_SUMMARY_VIEW;
APPS
PA_PROJ_UNBILLED_BASE_VIEW
APPS.PA_PROJ_UNBILLED_SUMMARY_VIEW is not referenced by any database object
|
|
|
|