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_ApplicationLicences].[ApplicationLicenceID] AS [ApplicationLicenceID], [Vw_ApplicationLicences].[ApplicationDetailID] AS [ApplicationDetailID], [Vw_ApplicationLicences].[ApplicationLicenceReferenceNumber] AS [ApplicationLicenceReferenceNumber], [Vw_ApplicationLicences].[OperatingLicenceNumber] AS [OperatingLicenceNumber], [Vw_ApplicationLicences].[LicencingBoard] AS [LicencingBoard], [Vw_ApplicationLicences].[OperatingLicenceIssueDate] AS [OperatingLicenceIssueDate], [Vw_ApplicationLicences].[OperatingLicenceExpiryDate] AS [OperatingLicenceExpiryDate], [Vw_ApplicationLicences].[ReasonForAmendment] AS [ReasonForAmendment], [Vw_ApplicationLicences].[SpecialLicenceDetails] AS [SpecialLicenceDetails], [Vw_ApplicationLicences].[SpecialLicenceDateFrom] AS [SpecialLicenceDateFrom], [Vw_ApplicationLicences].[SpecialLicenceDateTo] AS [SpecialLicenceDateTo], [Vw_ApplicationLicences].[LongDistanceReason] AS [LongDistanceReason], [Vw_ApplicationLicences].[VehicleType] AS [VehicleType], [Vw_ApplicationLicences].[IsAdjudicationFinalised] AS [IsAdjudicationFinalised], [Vw_ApplicationLicences].[ApplicationFormDocID] AS [ApplicationFormDocID], [Vw_ApplicationLicences].[OperatingLicenceDocID] AS [OperatingLicenceDocID] FROM [App].[Vw_ApplicationLicences] AS [Vw_ApplicationLicences] SELECT [Vw_ApplicationLicenceVehicleDetails].[ApplicationLicenceID] AS [ApplicationLicenceID], [Vw_ApplicationLicenceVehicleDetails].[IsStillToBeAcquired] AS [IsStillToBeAcquired], [Vw_ApplicationLicenceVehicleDetails].[VehicleMake] AS [VehicleMake], [Vw_ApplicationLicenceVehicleDetails].[VehicleMakeDescription] AS [VehicleMakeDescription], [Vw_ApplicationLicenceVehicleDetails].[VehicleType] AS [VehicleType], [Vw_ApplicationLicenceVehicleDetails].[CarryingCapacity] AS [CarryingCapacity], [Vw_ApplicationLicenceVehicleDetails].[VIN] AS [VIN], [Vw_ApplicationLicenceVehicleDetails].[EngineNumber] AS [EngineNumber], [Vw_ApplicationLicenceVehicleDetails].[YearOfManufacture] AS [YearOfManufacture], [Vw_ApplicationLicenceVehicleDetails].[VehicleRegistrationNumber] AS [VehicleRegistrationNumber], [Vw_ApplicationLicenceVehicleDetails].[SeatedCapacity] AS [SeatedCapacity], [Vw_ApplicationLicenceVehicleDetails].[StandingCapacity] AS [StandingCapacity], [Vw_ApplicationLicenceVehicleDetails].[GrossMass] AS [GrossMass], [Vw_ApplicationLicenceVehicleDetails].[Tare] AS [Tare], [Vw_ApplicationLicenceVehicleDetails].[CurrentOdometerReading] AS [CurrentOdometerReading], [Vw_ApplicationLicenceVehicleDetails].[VehicleModel] AS [VehicleModel] FROM [App].[Vw_ApplicationLicenceVehicleDetails] AS [Vw_ApplicationLicenceVehicleDetails] SELECT [Vw_ApplicationTags].[ApplicationTagID] AS [ApplicationTagID], [Vw_ApplicationTags].[TagID] AS [TagID], [Vw_ApplicationTags].[TagTypeID] AS [TagTypeID], [Vw_ApplicationTags].[FormTagTypeDescription] AS [FormTagTypeDescription], [Vw_ApplicationTags].[ReviewRequiredByRoleID] AS [ReviewRequiredByRoleID], [Vw_ApplicationTags].[ApplicationDetailID] AS [ApplicationDetailID], [Vw_ApplicationTags].[Title] AS [Title], [Vw_ApplicationTags].[Description] AS [Description], [Vw_ApplicationTags].[IsTagCleared] AS [IsTagCleared], [Vw_ApplicationTags].[ClearedByID] AS [ClearedByID], [Vw_ApplicationTags].[ClearedByName] AS [ClearedByName], [Vw_ApplicationTags].[ClearedDate] AS [ClearedDate], [Vw_ApplicationTags].[ClearedComments] AS [ClearedComments], [Vw_ApplicationTags].[CreatedByID] AS [CreatedByID], [Vw_ApplicationTags].[CreatedByName] AS [CreatedByName], [Vw_ApplicationTags].[CreatedDate] AS [CreatedDate], [Vw_ApplicationTags].[IsCancelled] AS [IsCancelled], [Vw_ApplicationTags].[ReviewRequiredByRoleName] AS [ReviewRequiredByRoleName] FROM [App].[Vw_ApplicationTags] AS [Vw_ApplicationTags] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore]