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

VIEW: APPS.PA_BILLING_INV_DELETION_V

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

View Type

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


PA_BILLING_INV_DELETION_V returns information about draft invoices
that may be deleted in the current run of invoice generation. When
this view is used in a billing extension, the rows returned are
limited to the project/task being processed for the current
request_id.
This view should only be used in billing
extensions called during invoice deletion.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER (15) Yes Identifier of the project for which the invoice is generated
DRAFT_INVOICE_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_INVOICE_NUM
,      AGREEMENT_ID
FROM APPS.PA_BILLING_INV_DELETION_V;

Dependencies

[top of page]

APPS.PA_BILLING_INV_DELETION_V references the following:

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

SchemaAPPS
Package BodyGMS_BILLING_ADJUSTMENTS - show dependent code