SELECT [Vw_ApplicationRequestDetails].[ApplicationRequestDetailID] AS [ApplicationRequestDetailID], [Vw_ApplicationRequestDetails].[WorkflowInstanceID] AS [WorkflowInstanceID], [Vw_ApplicationRequestDetails].[ApplicationNumber] AS [ApplicationNumber], [Vw_ApplicationRequestDetails].[RequestType] AS [RequestType], [Vw_ApplicationRequestDetails].[Cost] AS [Cost], [Vw_ApplicationRequestDetails].[SurnameOrCompanyName] AS [SurnameOrCompanyName], [Vw_ApplicationRequestDetails].[FirstNames] AS [FirstNames], [Vw_ApplicationRequestDetails].[TradeName] AS [TradeName], [Vw_ApplicationRequestDetails].[Member] AS [Member], [Vw_ApplicationRequestDetails].[VerifiedMemberID] AS [VerifiedMemberID], [Vw_ApplicationRequestDetails].[IDNumberOrBusinessRegistrationNo] AS [IDNumberOrBusinessRegistrationNo], [Vw_ApplicationRequestDetails].[ApplicationRequestTypeID] AS [ApplicationRequestTypeID], [Vw_ApplicationRequestDetails].[SourceApplicationID] AS [SourceApplicationID], [Vw_ApplicationRequestDetails].[IsNewAssociationRequired] AS [IsNewAssociationRequired], [Vw_ApplicationRequestDetails].[IsNewMemberRequired] AS [IsNewMemberRequired], [Vw_ApplicationRequestDetails].[IsNewRouteRequired] AS [IsNewRouteRequired], [Vw_ApplicationRequestDetails].[IsExceptionRequired] AS [IsExceptionRequired], [Vw_ApplicationRequestDetails].[IsUpliftmentRequired] AS [IsUpliftmentRequired], [Vw_ApplicationRequestDetails].[IsAdjustmentRequired] AS [IsAdjustmentRequired], [Vw_ApplicationRequestDetails].[IsCancellationRequired] AS [IsCancellationRequired], [Vw_ApplicationRequestDetails].[GazetteNumber] AS [GazetteNumber], [Vw_ApplicationRequestDetails].[GazetteDetailID] AS [GazetteDetailID], [Vw_ApplicationRequestDetails].[MeetingDate] AS [MeetingDate], [Vw_ApplicationRequestDetails].[AdjudicationDetailID] AS [AdjudicationDetailID], [Vw_ApplicationRequestDetails].[PaymentTypeID] AS [PaymentTypeID], [Vw_ApplicationRequestDetails].[VehicleCount] AS [VehicleCount], [Vw_ApplicationRequestDetails].[ChassisNumber] AS [ChassisNumber], [Vw_ApplicationRequestDetails].[EngineNumber] AS [EngineNumber], [Vw_ApplicationRequestDetails].[VehicleRegNumber] AS [VehicleRegNumber], [Vw_ApplicationRequestDetails].[SeatedCapacity] AS [SeatedCapacity], [Vw_ApplicationRequestDetails].[VehicleMake] AS [VehicleMake], [Vw_ApplicationRequestDetails].[AdjudicationDecision] AS [AdjudicationDecision], [Vw_ApplicationRequestDetails].[ApplicationDescription] AS [ApplicationDescription], [Vw_ApplicationRequestDetails].[IsRenewal] AS [IsRenewal], [Vw_ApplicationRequestDetails].[AssociationName] AS [AssociationName], [Vw_ApplicationRequestDetails].[ModeID] AS [ModeID], [Vw_ApplicationRequestDetails].[TaxNumber] AS [TaxNumber], [Vw_ApplicationRequestDetails].[PrecheckDetailID] AS [PrecheckDetailID], [Vw_ApplicationRequestDetails].[IsStillToBeAcquired] AS [IsStillToBeAcquired], [Vw_ApplicationRequestDetails].[ProxyName] AS [ProxyName], [Vw_ApplicationRequestDetails].[IsCancelled] AS [IsCancelled], [Vw_ApplicationRequestDetails].[AdjudicationDecisionID] AS [AdjudicationDecisionID], [Vw_ApplicationRequestDetails].[AdjudicationComment] AS [AdjudicationComment], [Vw_ApplicationRequestDetails].[AdjudicationException] AS [AdjudicationException], [Vw_ApplicationRequestDetails].[TelCell] AS [TelCell], [Vw_ApplicationRequestDetails].[TelPhone] AS [TelPhone], [Vw_ApplicationRequestDetails].[RegionID] AS [RegionID], [Vw_ApplicationRequestDetails].[AdjudicationRegionID] AS [AdjudicationRegionID], [Vw_ApplicationRequestDetails].[ExistingLicenceHolder] AS [ExistingLicenceHolder], [Vw_ApplicationRequestDetails].[ExistingLicenceHolderID] AS [ExistingLicenceHolderID], [Vw_ApplicationRequestDetails].[Region] AS [Region], [Vw_ApplicationRequestDetails].[ExistingVehicleChassisNumber] AS [ExistingVehicleChassisNumber], [Vw_ApplicationRequestDetails].[ExistingVehicleRegNumber] AS [ExistingVehicleRegNumber], [Vw_ApplicationRequestDetails].[WorkflowStatus] AS [WorkflowStatus], [Vw_ApplicationRequestDetails].[IsAdjudicationBypassed] AS [IsAdjudicationBypassed], [Vw_ApplicationRequestDetails].[IsGazettingBypassed] AS [IsGazettingBypassed], [Vw_ApplicationRequestDetails].[IsAssessorApprovalRequired] AS [IsAssessorApprovalRequired], [Vw_ApplicationRequestDetails].[IsSeniorManagerApprovalRequired] AS [IsSeniorManagerApprovalRequired], [Vw_ApplicationRequestDetails].[HasNewRoute] AS [HasNewRoute], [Vw_ApplicationRequestDetails].[ExistingLicenceNumber] AS [ExistingLicenceNumber], [Vw_ApplicationRequestDetails].[IsAutoVerificationRequired] AS [IsAutoVerificationRequired], [Vw_ApplicationRequestDetails].[IsLtpsConversion] AS [IsLtpsConversion], [Vw_ApplicationRequestDetails].[ProxyIDNumber] AS [ProxyIDNumber], [Vw_ApplicationRequestDetails].[StandingCapacity] AS [StandingCapacity], [Vw_ApplicationRequestDetails].[AdjudicationCount] AS [AdjudicationCount], [Vw_ApplicationRequestDetails].[PhysicalAddress] AS [PhysicalAddress], [Vw_ApplicationRequestDetails].[PhysicalAddressCode] AS [PhysicalAddressCode], [Vw_ApplicationRequestDetails].[PostalAddress] AS [PostalAddress], [Vw_ApplicationRequestDetails].[PostalAddressCode] AS [PostalAddressCode] FROM [App].[Vw_ApplicationRequestDetails] AS [Vw_ApplicationRequestDetails] 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] FROM [App].[Vw_NewRouteRequestDetails] AS [Vw_NewRouteRequestDetails] SELECT [Vw_OperatingLicenceDetails].[LicenceID] AS [LicenceID], [Vw_OperatingLicenceDetails].[ApplicationRequestDetailID] AS [ApplicationRequestDetailID], [Vw_OperatingLicenceDetails].[AssociationName] AS [AssociationName], [Vw_OperatingLicenceDetails].[OperatingLicenceNumber] AS [OperatingLicenceNumber], [Vw_OperatingLicenceDetails].[ApplicationNumber] AS [ApplicationNumber], [Vw_OperatingLicenceDetails].[IDNumberOrBusinessRegistrationNo] AS [IDNumberOrBusinessRegistrationNo], [Vw_OperatingLicenceDetails].[NameOnLicence] AS [NameOnLicence], [Vw_OperatingLicenceDetails].[PostalAddress] AS [PostalAddress], [Vw_OperatingLicenceDetails].[RegistrationNumber] AS [RegistrationNumber], [Vw_OperatingLicenceDetails].[GrossMass] AS [GrossMass], [Vw_OperatingLicenceDetails].[EngineNumber] AS [EngineNumber], [Vw_OperatingLicenceDetails].[VIN] AS [VIN], [Vw_OperatingLicenceDetails].[VehicleMake] AS [VehicleMake], [Vw_OperatingLicenceDetails].[SeatedCapacity] AS [SeatedCapacity], [Vw_OperatingLicenceDetails].[StandingCapacity] AS [StandingCapacity], [Vw_OperatingLicenceDetails].[VehicleType] AS [VehicleType], [Vw_OperatingLicenceDetails].[CertificateNumber] AS [CertificateNumber], [Vw_OperatingLicenceDetails].[DateOfIssue] AS [DateOfIssue], [Vw_OperatingLicenceDetails].[DateOfExpiry] AS [DateOfExpiry], [Vw_OperatingLicenceDetails].[CrossBorder] AS [CrossBorder], [Vw_OperatingLicenceDetails].[LicensingBoard] AS [LicensingBoard], [Vw_OperatingLicenceDetails].[YearOfFirstReg] AS [YearOfFirstReg], [Vw_OperatingLicenceDetails].[ApplicationRequestTypeID] AS [ApplicationRequestTypeID], [Vw_OperatingLicenceDetails].[LicenceExceptions] AS [LicenceExceptions], [Vw_OperatingLicenceDetails].[LicenceStatus] AS [LicenceStatus], [Vw_OperatingLicenceDetails].[VehicleID] AS [VehicleID], [Vw_OperatingLicenceDetails].[AssociationID] AS [AssociationID], [Vw_OperatingLicenceDetails].[LicenceStatusID] AS [LicenceStatusID], [Vw_OperatingLicenceDetails].[MemberID] AS [MemberID] FROM [Verified].[Vw_OperatingLicenceDetails] AS [Vw_OperatingLicenceDetails] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore]