eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PA_PROJECT_INVOICE_RECEIVABLES

Source

View Text - Preformatted


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

View Text - HTML Formatted

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