16 lines
391 B
TypeScript
16 lines
391 B
TypeScript
export const activeWarehouseLanes = `
|
|
select
|
|
w.IdWarenLager as warehouseId,
|
|
w.Bezeichnung as warehouseDescription,
|
|
IdLagerAbteilung as laneId,
|
|
b.Bezeichnung as laneDescription
|
|
--,*
|
|
from [AlplaPROD_test1].[dbo].[T_LagerAbteilungen] (nolock) b
|
|
|
|
left join
|
|
AlplaPROD_test1.dbo.T_WarenLager (nolock) as w
|
|
on b.IdWarenLager = w.IdWarenLager
|
|
|
|
where b.aktiv = 1 and w.idwarenlager not in (5,6)
|
|
`;
|