[Home] [Help] [Dependency Information]
Object Name: | PA_PROJ_INVOICE_SUMMARY_VIEW |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PA.PA_PROJ_INVOICE_SUMMARY_VIEW |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
PA_PROJ_INVOICE_SUMMARY_VIEW is a view that displays summary totals for a project which include baselined budget revenue amount, total revenue amount, total invoice amounts, and amounts on hold. This view displays one record per project.
You can use this information when reviewing project status, particularly when reviewing invoices for a project.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROJECT_ID | NUMBER | (15) | Identifier of the project | |
BUDGET_REVENUE_AMOUNT | NUMBER | Baselined budgeted revenue amount for the project | ||
TOTAL_REVENUE_AMOUNT | NUMBER | Total revenue amount for the project | ||
WRITE_ON_REVENUE_AMOUNT | NUMBER | Total event revenue amount accrued for revenue events that are not classified as Revenue Write-Offs. This includes Write-On and Manual revenue event type classifications | ||
WRITE_OFF_REVENUE_AMOUNT | NUMBER | Total Write-Off event revenue amount accrued for revenue events that are classified as Revenue Write-Offs | ||
TOTAL_INVOICED_AMOUNT | NUMBER | Total amount of released invoices, excluding retentions | ||
TOTAL_RETENTION_AMOUNT | NUMBER | Invoice retention amount on released invoices. The retention amount is reported as a positive amount | ||
INVOICED_AMOUNT | NUMBER | Net invoice amount, which includes retentions, for released invoices. Invoice Amount = Total Invoice Amount - Retentions | ||
ON_HOLD_AMOUNT | NUMBER | Total bill amount of expenditure items on hold (includes both permanent and one-time holds) | ||
ON_HOLD_QUANTITY | NUMBER | Number of expenditure items on hold (includes both permanent and one-time holds) | ||
UNBILLED_RECEIVABLES_AMOUNT | NUMBER | Project unbilled receivables amount, defined as the total project revenue - total released invoice amount | ||
WRITE_OFF_INVOICE_AMOUNT | NUMBER | Total amount invoiced on write-off invoices | ||
PFC_INVOICED_AMOUNT | NUMBER | Net amount on released invoices in project functional currency, which includes retentions. | ||
PFC_TOTAL_INVOICE_AMOUNT | NUMBER | Total amount on released invoices in project functional currency, excluding retentions and write-offs | ||
PFC_WRITE_OFF_INVOICE_AMOUNT | NUMBER | Total amount invoiced on write-off invoices in project functional currency | ||
UNBILLED_RETENTION | NUMBER | Total Unbilled Retention invoice amount for the project in project functional currency |
Cut, paste (and edit) the following text to query this object:
SELECT PROJECT_ID
, BUDGET_REVENUE_AMOUNT
, TOTAL_REVENUE_AMOUNT
, WRITE_ON_REVENUE_AMOUNT
, WRITE_OFF_REVENUE_AMOUNT
, TOTAL_INVOICED_AMOUNT
, TOTAL_RETENTION_AMOUNT
, INVOICED_AMOUNT
, ON_HOLD_AMOUNT
, ON_HOLD_QUANTITY
, UNBILLED_RECEIVABLES_AMOUNT
, WRITE_OFF_INVOICE_AMOUNT
, PFC_INVOICED_AMOUNT
, PFC_TOTAL_INVOICE_AMOUNT
, PFC_WRITE_OFF_INVOICE_AMOUNT
, UNBILLED_RETENTION
FROM APPS.PA_PROJ_INVOICE_SUMMARY_VIEW;
APPS.PA_PROJ_INVOICE_SUMMARY_VIEW is not referenced by any database object
|
|
|