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 ) )