[Home] [Help]
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
Name |
PROJECT_ID |
DRAFT_INVOICE_NUM |
RA_INVOICE_NUMBER |
CUSTOMER_TRX_ID |
OPEN_AMOUNT |