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

VIEW: APPS.PA_PROJECT_INVOICE_RECEIVABLES

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

View Type

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


PA_PROJECT_INVOICE_RECEIVABLES is a view of
outstanding receivables for invoices transferred from
Oracle Projects to Oracle Receivables.
For optimum performance in your reports and online
queries, always include PROJECT_ID in your selection
criteria.
.
.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER (15) Yes The identifier of the project for which the invoice receivable applies
DRAFT_INVOICE_NUM NUMBER (15) Yes The identifier of the draft invoice for which the receivable applies
RA_INVOICE_NUMBER VARCHAR2 (20)
The AR invoice number of the invoice for which the receivable applies
CUSTOMER_TRX_ID NUMBER (15)
The identifier of the invoice in Oracle Receivables for which the receivable applies
OPEN_AMOUNT NUMBER

The amount outstanding in Oracle Receivables. This value is blank if the draft invoice transfer status is not Accepted.
Query Text

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


SELECT PROJECT_ID
,      DRAFT_INVOICE_NUM
,      RA_INVOICE_NUMBER
,      CUSTOMER_TRX_ID
,      OPEN_AMOUNT
FROM APPS.PA_PROJECT_INVOICE_RECEIVABLES;

Dependencies

[top of page]

APPS.PA_PROJECT_INVOICE_RECEIVABLES references the following:

SchemaAPPS
SynonymAR_PAYMENT_SCHEDULES_ALL
SynonymPA_DRAFT_INVOICES
SynonymRA_CUSTOMER_TRX_ALL

APPS.PA_PROJECT_INVOICE_RECEIVABLES is not referenced by any database object