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

VIEW: APPS.PA_PROJ_INVOICE_BASE_VIEW

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

View Type

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


PA_PROJ_INVOICE_BASE_VIEW is a base view that shows the project revenue and invoice summary information that you may want to review when reviewing a project invoice. 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_INVOICE_BASE_VIEW is a union of the project baselined budget, total revenue amount, total invoice amount, and amount on hold. You can review this summary information in the view PA_PROJ_INVOICE_SUMMARY_VIEW which is built upon this base view. The PA_PROJ_INVOICE_SUMMARY_VIEW displays one record per 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_OFF_REVENUE_AMOUNT NUMBER

Total Write-Off event revenue amount accrued for revenue events that are classified as Revenue Write-Offs
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
INVOICED_AMOUNT NUMBER

Total amount of released invoices, including retentions
TOTAL_RETENTION_AMOUNT NUMBER

Invoice retention amount on released invoices. The retention amount is reported as a positive amount
TOTAL_INVOICE_AMOUNT NUMBER

Net invoice amount, which excludes 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)
WRITE_OFF_INVOICE_AMOUNT NUMBER

Total amount invoiced on write-off invoices
PFC_INVOICED_AMOUNT NUMBER

Total amount on released invoices in project functional currency, including retentions
PFC_TOTAL_INVOICE_AMOUNT NUMBER

Net amount on released invoices in project functional currency, which excludes 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_OFF_REVENUE_AMOUNT
,      WRITE_ON_REVENUE_AMOUNT
,      INVOICED_AMOUNT
,      TOTAL_RETENTION_AMOUNT
,      TOTAL_INVOICE_AMOUNT
,      ON_HOLD_AMOUNT
,      ON_HOLD_QUANTITY
,      WRITE_OFF_INVOICE_AMOUNT
,      PFC_INVOICED_AMOUNT
,      PFC_TOTAL_INVOICE_AMOUNT
,      PFC_WRITE_OFF_INVOICE_AMOUNT
,      UNBILLED_RETENTION
FROM APPS.PA_PROJ_INVOICE_BASE_VIEW;

Dependencies

[top of page]

APPS.PA_PROJ_INVOICE_BASE_VIEW references the following:

SchemaAPPS
SynonymPA_CUST_EVENT_REV_DIST_LINES
SynonymPA_CUST_REV_DIST_LINES
SynonymPA_DRAFT_INVOICES
SynonymPA_DRAFT_INVOICE_ITEMS
SynonymPA_DRAFT_REVENUES
SynonymPA_DRAFT_REVENUE_ITEMS
SynonymPA_EVENTS
SynonymPA_EVENT_TYPES
SynonymPA_EXPENDITURE_ITEMS_ALL
SynonymPA_SUMMARY_PROJECT_FUNDINGS
APPS.PA_PROJ_INVOICE_BASE_VIEW is referenced by following:

SchemaAPPS
ViewPA_PROJ_INVOICE_SUMMARY_VIEW