View: PA_BILLING_INV_PROCESSED_V

Product:	PA - Projects
Description:	PA_BILLING_INV_PROCESSED_V returns information about invoices processed in the current run, for use with billing extensions.
Implementation/DBA Data:	APPS.PA_BILLING_INV_PROCESSED_V

View Text

SELECT DI.PROJECT_ID
, DI.DRAFT_INVOICE_NUM
, DI.AGREEMENT_ID
FROM PA_DRAFT_INVOICES DI
WHERE DI.PROJECT_ID = NVL(PA_BILLING.GETPROJID
, DI.PROJECT_ID)
AND DI.REQUEST_ID = NVL(PA_BILLING.GETREQID
, DI.REQUEST_ID)

Columns