View: dbo.Reports_With_Accounting_Without_Workpapers_View
View definition
CREATE VIEW dbo.Reports_With_Accounting_Without_Workpapers_View
AS
SELECT report_definition_application_license_requirement_KEY
,report_definition_KEY
,accounting_application_KEY
,has_accounting
,has_compliance
,has_payroll
,has_workpapers
FROM dbo.Report_Definition_Application_License_Requirement
WHERE has_workpapers = 0 AND accounting_application_KEY = 1