VIEW: APPS.PA_BILLING_REV_INV_DELETION_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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