View: PA_BILLING_REV_INV_DELETION_V

Product:	PA - Projects
Description:	Returns information about draft invoices that will be deleted in the current run of revenue generation.
Implementation/DBA Data:	APPS.PA_BILLING_REV_INV_DELETION_V

View Text

SELECT DR.PROJECT_ID PROJECT_ID
, DR.DRAFT_REVENUE_NUM DRAFT_REVENUE_NUM
, DI.DRAFT_INVOICE_NUM DRAFT_INVOICE_NUM
, DR.AGREEMENT_ID AGREEMENT_ID
FROM PA_DRAFT_REVENUES_ALL DR
, PA_DRAFT_INVOICES DI
WHERE DI.PROJECT_ID = NVL(PA_BILLING.GETPROJID
, DI.PROJECT_ID)
AND DI.RELEASED_DATE||'' IS NULL
AND (EXISTS (SELECT NULL
FROM PA_CUST_REV_DIST_LINES_ALL L
WHERE L.PROJECT_ID = DI.PROJECT_ID
AND L.DRAFT_REVENUE_NUM = DR.DRAFT_REVENUE_NUM
AND L.DRAFT_INVOICE_NUM = DI.DRAFT_INVOICE_NUM ) OR EXISTS (SELECT NULL
FROM PA_CUST_EVENT_RDL_ALL L
WHERE L.PROJECT_ID = DI.PROJECT_ID
AND L.DRAFT_REVENUE_NUM = DR.DRAFT_REVENUE_NUM
AND L.DRAFT_INVOICE_NUM = DI.DRAFT_INVOICE_NUM ) )

Columns