View: PA_BILLING_REV_DELETION_V

Product:	PA - Projects
Description:	Returns information about draft revenues that are eligible for deletion in current run for use in billing extensions.
Implementation/DBA Data:	APPS.PA_BILLING_REV_DELETION_V

View Text

SELECT DR.PROJECT_ID PROJECT_ID
, DR.DRAFT_REVENUE_NUM DRAFT_REVENUE_NUM
, DR.AGREEMENT_ID AGREEMENT_ID
FROM PA_DRAFT_REVENUES DR
WHERE DR.PROJECT_ID = NVL(PA_BILLING.GETPROJID
, DR.PROJECT_ID)
AND ( (DR.RELEASED_DATE||'' IS NULL
AND NVL(PA_BILLING.GETMASSGEN
, 'N') = 'N') OR (DR.GENERATION_ERROR_FLAG||'' = 'Y'
AND NVL(PA_BILLING.GETMASSGEN
, 'N') = 'Y') )

Columns