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

VIEW: APPS.PA_BILLING_REV_DELETION_V

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

View Type

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


PA_BILLING_REV_DELETION_V returns information about draft revenues
that are eligible for deletion in the current run of revenue
generation. When this view is used in billing extensions, the rows
returned are limited to the rows for the specific request_id and
project being processed.
This view should only be used from within a billing extension called
during the revenue generation process.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER (15) Yes Identifier of the project for which the invoice is generated.
DRAFT_REVENUE_NUM NUMBER (15) Yes Sequential number that identifies the draft invoice within a project
AGREEMENT_ID NUMBER (15) Yes Identifier of the agreement that funds the invoice
Query Text

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


SELECT PROJECT_ID
,      DRAFT_REVENUE_NUM
,      AGREEMENT_ID
FROM APPS.PA_BILLING_REV_DELETION_V;

Dependencies

[top of page]

APPS.PA_BILLING_REV_DELETION_V references the following:

SchemaAPPS
PL/SQL PackagePA_BILLING - show dependent code
SynonymPA_DRAFT_REVENUES
APPS.PA_BILLING_REV_DELETION_V is referenced by following:

SchemaAPPS
Package BodyGMS_BILLING_ADJUSTMENTS - show dependent code