View: PA_PROJECT_INVOICE_RECEIVABLES

Product:	PA - Projects
Description:	Is a view of outstanding receivables for invoices transferred from Oracle Projects to Oracle Receivables
Implementation/DBA Data:	APPS.PA_PROJECT_INVOICE_RECEIVABLES

View Text

SELECT INV.PROJECT_ID
, INV.DRAFT_INVOICE_NUM
, INV.RA_INVOICE_NUMBER
, INV.SYSTEM_REFERENCE
, SUM(NVL(PS.AMOUNT_DUE_REMAINING
, 0))
FROM RA_CUSTOMER_TRX_ALL TRX
, AR_PAYMENT_SCHEDULES_ALL PS
, PA_DRAFT_INVOICES INV
WHERE INV.RA_INVOICE_NUMBER = TRX.TRX_NUMBER
AND INV.SYSTEM_REFERENCE = TRX.CUSTOMER_TRX_ID
AND PS.CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID GROUP BY INV.PROJECT_ID
, INV.SYSTEM_REFERENCE
, INV.DRAFT_INVOICE_NUM
, INV.RA_INVOICE_NUMBER

Columns