SELECT [Vw_ApplicationDetails_Light].[ApplicationDetailID] AS [ApplicationDetailID], [Vw_ApplicationDetails_Light].[WorkflowInstanceID] AS [WorkflowInstanceID], [Vw_ApplicationDetails_Light].[WorkflowTemplateID] AS [WorkflowTemplateID], [Vw_ApplicationDetails_Light].[DivisionTypeID] AS [DivisionTypeID], [Vw_ApplicationDetails_Light].[ProvinceID] AS [ProvinceID], [Vw_ApplicationDetails_Light].[RegionID] AS [RegionID], [Vw_ApplicationDetails_Light].[LicenceCount] AS [LicenceCount], [Vw_ApplicationDetails_Light].[ApplicationNumber] AS [ApplicationNumber], [Vw_ApplicationDetails_Light].[ApplicationRequestTypeID] AS [ApplicationRequestTypeID], [Vw_ApplicationDetails_Light].[RequestType] AS [RequestType], [Vw_ApplicationDetails_Light].[IncludeRenewalType] AS [IncludeRenewalType], [Vw_ApplicationDetails_Light].[Member] AS [Member], [Vw_ApplicationDetails_Light].[TelCell] AS [TelCell], [Vw_ApplicationDetails_Light].[Email] AS [Email], [Vw_ApplicationDetails_Light].[IsCancelled] AS [IsCancelled], [Vw_ApplicationDetails_Light].[ApplicationDescription] AS [ApplicationDescription], [Vw_ApplicationDetails_Light].[IDNumberOrBusinessRegistrationNo] AS [IDNumberOrBusinessRegistrationNo], [Vw_ApplicationDetails_Light].[AdjudicationCount] AS [AdjudicationCount], [Vw_ApplicationDetails_Light].[AdjudicationOfficeLocationID] AS [AdjudicationOfficeLocationID], [Vw_ApplicationDetails_Light].[IsReceiptRequired] AS [IsReceiptRequired], [Vw_ApplicationDetails_Light].[IsAdjudicationRequired] AS [IsAdjudicationRequired], [Vw_ApplicationDetails_Light].[IsAdjustmentRequired] AS [IsAdjustmentRequired], [Vw_ApplicationDetails_Light].[IsGazettingRequired] AS [IsGazettingRequired], [Vw_ApplicationDetails_Light].[IsGazettingBypassed] AS [IsGazettingBypassed], [Vw_ApplicationDetails_Light].[IsInspectionRequired] AS [IsInspectionRequired], [Vw_ApplicationDetails_Light].[IsReferralRequired] AS [IsReferralRequired], [Vw_ApplicationDetails_Light].[IsBusAndContract] AS [IsBusAndContract], [Vw_ApplicationDetails_Light].[GazetteDetailID] AS [GazetteDetailID], [Vw_ApplicationDetails_Light].[IsLtpsConversion] AS [IsLtpsConversion], [Vw_ApplicationDetails_Light].[IsAdjudicationBypassed] AS [IsAdjudicationBypassed], [Vw_ApplicationDetails_Light].[WorkflowInstanceReference] AS [WorkflowInstanceReference], [Vw_ApplicationDetails_Light].[ApplicationStatusID] AS [ApplicationStatusID], [Vw_ApplicationDetails_Light].[ApplicationSubStatusID] AS [ApplicationSubStatusID], [Vw_ApplicationDetails_Light].[LiveryDocumentID] AS [LiveryDocumentID], [Vw_ApplicationDetails_Light].[IsNewRouteRequired] AS [IsNewRouteRequired], [Vw_ApplicationDetails_Light].[IsAssessorApprovalRequired] AS [IsAssessorApprovalRequired], [Vw_ApplicationDetails_Light].[IsSeniorManagerApprovalRequired] AS [IsSeniorManagerApprovalRequired], [Vw_ApplicationDetails_Light].[AdjudicationDetailID] AS [AdjudicationDetailID], [Vw_ApplicationDetails_Light].[LastAdjudicationDecisionID] AS [LastAdjudicationDecisionID], [Vw_ApplicationDetails_Light].[TotalVehicles] AS [TotalVehicles], [Vw_ApplicationDetails_Light].[IDType] AS [IDType], [Vw_ApplicationDetails_Light].[IsRenewal] AS [IsRenewal], [Vw_ApplicationDetails_Light].[IsFinalisationTasksRequired] AS [IsFinalisationTasksRequired], [Vw_ApplicationDetails_Light].[ProxyIDNumber] AS [ProxyIDNumber], [Vw_ApplicationDetails_Light].[IsApplicantIndividual] AS [IsApplicantIndividual], [Vw_ApplicationDetails_Light].[ApplicationIsObjected] AS [ApplicationIsObjected], [Vw_ApplicationDetails_Light].[OnlyExistingRoutesOnLicense] AS [OnlyExistingRoutesOnLicense], [Vw_ApplicationDetails_Light].[IsAllowedNewLicence] AS [IsAllowedNewLicence], [Vw_ApplicationDetails_Light].[ForceGazetting] AS [ForceGazetting], [Vw_ApplicationDetails_Light].[AdjudicationTypeID] AS [AdjudicationTypeID], [Vw_ApplicationDetails_Light].[PREDataReleased] AS [PREDataReleased], [Vw_ApplicationDetails_Light].[CopiedFromApplicationDetailID] AS [CopiedFromApplicationDetailID], [Vw_ApplicationDetails_Light].[RelatedTATApplicationRequestID] AS [RelatedTATApplicationRequestID], [Vw_ApplicationDetails_Light].[CreatedDate] AS [CreatedDate] FROM [App].[Vw_ApplicationDetails_Light] AS [Vw_ApplicationDetails_Light] SELECT [Vw_NewRouteRequestDetails].[NewRouteRequestDetailID] AS [NewRouteRequestDetailID], [Vw_NewRouteRequestDetails].[WorkflowInstanceID] AS [WorkflowInstanceID], [Vw_NewRouteRequestDetails].[VerifiedRouteID] AS [VerifiedRouteID], [Vw_NewRouteRequestDetails].[RouteOrigin] AS [RouteOrigin], [Vw_NewRouteRequestDetails].[RouteDestination] AS [RouteDestination], [Vw_NewRouteRequestDetails].[RouteDescription] AS [RouteDescription], [Vw_NewRouteRequestDetails].[NationalRouteNumber] AS [NationalRouteNumber], [Vw_NewRouteRequestDetails].[BoardRouteNumber] AS [BoardRouteNumber], [Vw_NewRouteRequestDetails].[RouteLength] AS [RouteLength], [Vw_NewRouteRequestDetails].[ReferenceNumber] AS [ReferenceNumber], [Vw_NewRouteRequestDetails].[WorkflowInstanceStatus] AS [WorkflowInstanceStatus], [Vw_NewRouteRequestDetails].[EntityID] AS [EntityID], [Vw_NewRouteRequestDetails].[ItemID] AS [ItemID], [Vw_NewRouteRequestDetails].[IsAssessorVerificationRequired] AS [IsAssessorVerificationRequired], [Vw_NewRouteRequestDetails].[DivisionTypeID] AS [DivisionTypeID], [Vw_NewRouteRequestDetails].[ProvinceID] AS [ProvinceID] FROM [App].[Vw_NewRouteRequestDetails] AS [Vw_NewRouteRequestDetails] [ScriptIgnore] [ScriptIgnore]