DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.PA_PROJ_INVOICE_SUMMARY_VIEW

Object Details
Object Name: PA_PROJ_INVOICE_SUMMARY_VIEW
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_PROJ_INVOICE_SUMMARY_VIEW
Subobject Name:
Status: VALID

View Type

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.


[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.PA_PROJ_INVOICE_SUMMARY_VIEW references the following:

SchemaAPPS
ViewPA_PROJ_INVOICE_BASE_VIEW

APPS.PA_PROJ_INVOICE_SUMMARY_VIEW is not referenced by any database object