View: PA_BILLING_INV_DELETION_V

Product:	PA - Projects
Description:	Returns information about draft invoices that may be deleted in current run.
Implementation/DBA Data:	APPS.PA_BILLING_INV_DELETION_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.RELEASED_BY_PERSON_ID IS NULL
AND NVL(DI.CANCEL_CREDIT_MEMO_FLAG
, 'N') = 'N'

Columns