SELECT DISTINCT
TOP 100 PERCENT EncoreCompanyK.dbo.WipMaster.Job, dbo.tbl_ReleaseStatus.MaterialComplete, dbo.tbl_ReleaseStatus.WaterSpiderComplete,
EncoreCompanyK.dbo.WipMaster.JobDeliveryDate AS JOB_DELIVERY_DATE, EncoreCompanyK.dbo.WipMaster.CustomerName AS CUSTOMER,
EncoreCompanyK.dbo.WipMaster.JobDescription AS JOB_DESCRIPTION, EncoreCompanyK.dbo.WipMaster.StockCode AS STOCK_CODE,
dbo.tbl_ReleaseStatus.PercentComplete, ISNULL(dbo.tbl_SplitJobs.Qty, EncoreCompanyK.dbo.WipMaster.QtyToMake) AS QTY_TO_MAKE,
ISNULL(dbo.tbl_SplitJobs.PullDueDate, CONVERT(DATETIME, '1900-01-01 00:00:00', 102)) AS PullDueDate,
ISNULL(CAST(dbo.tbl_SplitJobs.ReleaseNumber AS nvarchar(8)), CAST(EncoreCompanyK.dbo.WipMaster.Job AS nvarchar(8))) AS ReleaseNumber,
dbo.view_MaxReleasePerJob.EXPR1 AS LastRelease, EncoreCompanyK.dbo.WipMaster.QtyManufactured AS QTY_MANUFACTURED,
dbo.tbl_ReleaseStatus.CellAssignedTo, dbo.tbl_ReleaseStatus.FoamStatus, dbo.tbl_SplitJobs.Cell AS CellNumber,
dbo.view_ECOSForPM.StockCode AS ECODStockCode, dbo.tbl_WOSA.EXPR1 AS WOSA, ISNULL(CONVERT(nvarchar(10),
dbo.view_MaxEngineeringPass.PassedDate, 101), N' ') AS PassedDate, dbo.view_MaxEngineeringPass.PassedDate AS EngineeringReleased,
ISNULL(dbo.view_JobsWithFAI.EXPR1, '') AS FOM, ISNULL(dbo.tbl_ReleaseStatus.WC7PercentComplete, 0) AS WC7PercentComplete,
ISNULL(dbo.tbl_ReleaseStatus.WC11PercentComplete, 0) AS WC11PercentComplete, ISNULL(dbo.tbl_ReleaseStatus.FoamLocation,
N'<font color=red>N/S</font>') AS FoamLocation, dbo.tbl_AEROJobs.Salesperson, CONVERT(nvarchar(10), ISNULL(dbo.tbl_SplitJobs.Qty,
EncoreCompanyK.dbo.WipMaster.QtyToMake)) + N' of ' + CONVERT(nvarchar(10), CAST(EncoreCompanyK.dbo.WipMaster.QtyToMake AS integer))
AS NumberOfReleases, dbo.tbl_SplitJobs.Cell, EncoreCompanyK.dbo.WipMaster.Customer AS CustomerName,
ISNULL(ISNULL(REPLACE(dbo.tbl_QC_Narrations.ASRequired, EncoreCompanyK.dbo.WipMaster.StockCode, 'QC'), dbo.tbl_QC_Narrations.EXPR1), '')
AS QC, dbo.tbl_SplitJobs.QCed, dbo.tbl_SplitJobs.QCedBy, ISNULL
((SELECT DisplayQCed
FROM view_JobIsSplit
WHERE Job = tbl_SplitJobs.Job), 'none') AS DisplayQC, 'PL Printed, Click Here To Remove' + REPLACE(EncoreCompanyK.dbo.WipMaster.Job,
PrintCenter.dbo.tblPackSlipHistory.Job, '') AS PL, dbo.tbl_ReleaseStatus.QCScheduleTagPrinted, dbo.tbl_ReleaseStatus.QCScheduleTagPrintedBy,
ISNULL(CAST(RTRIM(CAST(MONTH(AIP.dbo.tbl_ToQC.ToQC) AS nvarchar(2))) + '/' + RTRIM(CAST(DAY(AIP.dbo.tbl_ToQC.ToQC) AS nvarchar(2)))
+ '/' + RTRIM(CAST(YEAR(AIP.dbo.tbl_ToQC.ToQC) AS nvarchar(4))) AS datetime), ISNULL(CAST(RTRIM(CAST(MONTH(dbo.tbl_ReleaseStatus.ToQC)
AS nvarchar(2))) + '/' + RTRIM(CAST(DAY(dbo.tbl_ReleaseStatus.ToQC) AS nvarchar(2))) + '/' + RTRIM(CAST(YEAR(dbo.tbl_ReleaseStatus.ToQC)
AS nvarchar(4))) AS datetime), EncoreCompanyK.dbo.WipMaster.JobDeliveryDate)) AS JobDeliveryDate, dbo.tbl_ReleaseStatus.WhoSentToQC,
'This Job Is On Hold Because:<br><br>''''' + dbo.tbl_JobsOnHold.Reason + '''''<br> By ' + dbo.tbl_JobsOnHold.PlacedBy + ' On ' + CONVERT(nvarchar(10),
dbo.tbl_JobsOnHold.PlacedOnHold, 101) AS Reason, CAST(ISNULL(dbo.view_NEWAEROQCExpRunTimesForSubJobsForSchedule.ExpRunTime,
dbo.view_ExpRunTimeForSchedule.ExpRunTime) AS float) / EncoreCompanyK.dbo.WipMaster.QtyToMake * ISNULL(dbo.tbl_SplitJobs.Qty,
EncoreCompanyK.dbo.WipMaster.QtyToMake) AS ExpRunTime, '' AS MaxReleaseNumber, AIP.dbo.tbl_ReleasedJobs.Job AS EXPR1,
AIP.dbo.tbl_ReleasedJobs.DateReleased, dbo.tbl_SplitJobs.ReleaseNumber AS EXPR2, AIP.dbo.tbl_ToQC.ToQC,
dbo.view_ExpRunTimeForSchedule.ExpRunTime AS EXPR3
FROM dbo.view_JobsWithFAI RIGHT OUTER JOIN
PrintCenter.dbo.tbl_JobStatus RIGHT OUTER JOIN
EncoreCompanyK.dbo.WipMaster INNER JOIN
dbo.tbl_AEROJobs ON EncoreCompanyK.dbo.WipMaster.Job = dbo.tbl_AEROJobs.Job LEFT OUTER JOIN
AIP.dbo.tbl_ReleasedJobs ON EncoreCompanyK.dbo.WipMaster.Job = AIP.dbo.tbl_ReleasedJobs.Job LEFT OUTER JOIN
dbo.view_NEWAEROQCExpRunTimesForSubJobsForSchedule ON
EncoreCompanyK.dbo.WipMaster.Job = dbo.view_NEWAEROQCExpRunTimesForSubJobsForSchedule.Job LEFT OUTER JOIN
dbo.view_ExpRunTimeForSchedule ON EncoreCompanyK.dbo.WipMaster.Job = dbo.view_ExpRunTimeForSchedule.Job LEFT OUTER JOIN
dbo.tbl_SplitJobs INNER JOIN
dbo.tbl_ReleaseStatus ON dbo.tbl_SplitJobs.ReleaseNumber = dbo.tbl_ReleaseStatus.ReleaseNumber ON
EncoreCompanyK.dbo.WipMaster.Job = dbo.tbl_SplitJobs.Job LEFT OUTER JOIN
AIP.dbo.tbl_ToQC ON EncoreCompanyK.dbo.WipMaster.Job = AIP.dbo.tbl_ToQC.Job LEFT OUTER JOIN
PackslipData.dbo.tbl_PackSlipInfo ON EncoreCompanyK.dbo.WipMaster.Job = PackslipData.dbo.tbl_PackSlipInfo.Job LEFT OUTER JOIN
dbo.tbl_JobsOnHold ON EncoreCompanyK.dbo.WipMaster.Job = dbo.tbl_JobsOnHold.Job LEFT OUTER JOIN
PrintCenter.dbo.tblPackSlipHistory ON EncoreCompanyK.dbo.WipMaster.Job = PrintCenter.dbo.tblPackSlipHistory.Job LEFT OUTER JOIN
dbo.view_MaxReleasePerJob ON EncoreCompanyK.dbo.WipMaster.Job = dbo.view_MaxReleasePerJob.Job LEFT OUTER JOIN
dbo.tbl_QC_Narrations ON EncoreCompanyK.dbo.WipMaster.Job = dbo.tbl_QC_Narrations.Job ON
PrintCenter.dbo.tbl_JobStatus.Job = EncoreCompanyK.dbo.WipMaster.Job LEFT OUTER JOIN
dbo.view_MaxEngineeringPass ON EncoreCompanyK.dbo.WipMaster.StockCode = dbo.view_MaxEngineeringPass.STOCK_CODE LEFT OUTER JOIN
dbo.view_ECOSForPM ON EncoreCompanyK.dbo.WipMaster.StockCode = dbo.view_ECOSForPM.StockCode ON
dbo.view_JobsWithFAI.Job = EncoreCompanyK.dbo.WipMaster.Job LEFT OUTER JOIN
dbo.tbl_WOSA ON EncoreCompanyK.dbo.WipMaster.Job = dbo.tbl_WOSA.Job
WHERE (PackslipData.dbo.tbl_PackSlipInfo.Shipped IS NULL OR
PackslipData.dbo.tbl_PackSlipInfo.Shipped <> 1) AND (EncoreCompanyK.dbo.WipMaster.Complete = 'N') AND
(PrintCenter.dbo.tbl_JobStatus.PassedQC IS NULL) AND (dbo.tbl_SplitJobs.Cell = 13 OR
dbo.tbl_SplitJobs.Cell = 20 OR
dbo.tbl_SplitJobs.Cell = 1 OR
dbo.tbl_SplitJobs.Cell = 27 OR
dbo.tbl_SplitJobs.Cell IS NULL) AND (NOT (AIP.dbo.tbl_ReleasedJobs.DateReleased IS NULL)) OR
(PackslipData.dbo.tbl_PackSlipInfo.Shipped IS NULL OR
PackslipData.dbo.tbl_PackSlipInfo.Shipped <> 1) AND (EncoreCompanyK.dbo.WipMaster.Complete = 'N') AND
(PrintCenter.dbo.tbl_JobStatus.PassedQC IS NULL) AND (dbo.tbl_SplitJobs.Cell = 13 OR
dbo.tbl_SplitJobs.Cell = 20 OR
dbo.tbl_SplitJobs.Cell = 1 OR
dbo.tbl_SplitJobs.Cell = 27 OR
dbo.tbl_SplitJobs.Cell IS NULL) AND (NOT (AIP.dbo.tbl_ReleasedJobs.DateReleased IS NULL)) AND
(ISNULL(dbo.tbl_ReleaseStatus.WC7PercentComplete, 0) = 1) OR
(PackslipData.dbo.tbl_PackSlipInfo.Shipped IS NULL OR
PackslipData.dbo.tbl_PackSlipInfo.Shipped <> 1) AND (EncoreCompanyK.dbo.WipMaster.Complete = 'N') AND
(PrintCenter.dbo.tbl_JobStatus.PassedQC IS NULL) AND (dbo.tbl_SplitJobs.Cell = 13 OR
dbo.tbl_SplitJobs.Cell = 20 OR
dbo.tbl_SplitJobs.Cell = 1 OR
dbo.tbl_SplitJobs.Cell = 27 OR
dbo.tbl_SplitJobs.Cell IS NULL) AND (NOT (AIP.dbo.tbl_ReleasedJobs.DateReleased IS NULL)) AND
(ISNULL(dbo.tbl_ReleaseStatus.WC11PercentComplete, 0) = 1) OR
(PackslipData.dbo.tbl_PackSlipInfo.Shipped IS NULL OR
PackslipData.dbo.tbl_PackSlipInfo.Shipped <> 1) AND (EncoreCompanyK.dbo.WipMaster.Complete = 'N') AND
(PrintCenter.dbo.tbl_JobStatus.PassedQC IS NULL) AND (NOT (AIP.dbo.tbl_ReleasedJobs.DateReleased IS NULL)) AND
(ISNULL(dbo.tbl_ReleaseStatus.WC7PercentComplete, 0) = 1) OR
(PackslipData.dbo.tbl_PackSlipInfo.Shipped IS NULL OR
PackslipData.dbo.tbl_PackSlipInfo.Shipped <> 1) AND (EncoreCompanyK.dbo.WipMaster.Complete = 'N') AND
(PrintCenter.dbo.tbl_JobStatus.PassedQC IS NULL) AND (dbo.tbl_SplitJobs.Cell = 1) OR
(PackslipData.dbo.tbl_PackSlipInfo.Shipped IS NULL OR
PackslipData.dbo.tbl_PackSlipInfo.Shipped <> 1) AND (EncoreCompanyK.dbo.WipMaster.Complete = 'N') AND
(PrintCenter.dbo.tbl_JobStatus.PassedQC IS NULL) AND (dbo.tbl_SplitJobs.Cell = 13 OR
dbo.tbl_SplitJobs.Cell = 20 OR
dbo.tbl_SplitJobs.Cell = 27 OR
dbo.tbl_SplitJobs.Cell IS NULL) AND (NOT (AIP.dbo.tbl_ReleasedJobs.DateReleased IS NULL)) OR
(PackslipData.dbo.tbl_PackSlipInfo.Shipped IS NULL OR
PackslipData.dbo.tbl_PackSlipInfo.Shipped <> 1) AND (EncoreCompanyK.dbo.WipMaster.Complete = 'N') AND
(PrintCenter.dbo.tbl_JobStatus.PassedQC IS NULL) AND (dbo.tbl_SplitJobs.Cell = 13 OR
dbo.tbl_SplitJobs.Cell = 20 OR
dbo.tbl_SplitJobs.Cell = 27 OR
dbo.tbl_SplitJobs.Cell IS NULL) AND (ISNULL(dbo.tbl_SplitJobs.PullDueDate, '1/1/1900') <> '1/1/1900') OR
(PackslipData.dbo.tbl_PackSlipInfo.Shipped IS NULL OR
PackslipData.dbo.tbl_PackSlipInfo.Shipped <> 1) AND (EncoreCompanyK.dbo.WipMaster.Complete = 'N') AND
(PrintCenter.dbo.tbl_JobStatus.PassedQC IS NULL) AND (dbo.tbl_SplitJobs.Cell IS NULL) AND
(NOT (dbo.view_ExpRunTimeForSchedule.ExpRunTime IS NULL))