sozsoft-platform/configs/seeds/postgres/object/Stk_V_StockMove.sql

-- Hareketler: bütün operasyon türlerinin satırları ortak kolonlarla, lot/seri dağılımı varsa lot başına bir satır.
-- Miktar yapılan miktardır (lotlu satırda lotun miktarı); Talep satırın talep miktarıdır.
CREATE OR REPLACE VIEW public."Stk_V_StockMove" AS
SELECT COALESCE(z."Id", l."Id") AS "Id", l."TenantId", t."Id" AS "TransferId", t."TransferNo", t."OperationKind", t."OperationTypeId", t."Status",
       COALESCE(t."EffectiveDate", t."ScheduledDate") AS "MoveDate", t."BranchId", t."WarehouseId",
       t."SourceLocationId", t."DestinationLocationId", t."PartnerId", t."SourceDocument",
       l."ProductId", COALESCE(z."LotNo", '') AS "LotNo", l."DemandQuantity", COALESCE(z."Quantity", l."Quantity") AS "Quantity", l."UomId"
  FROM "Stk_T_TransferLine" l
  INNER JOIN "Stk_T_Transfer" t ON t."Id" = l."TransferId"
  LEFT JOIN "Stk_T_TransferLineLot" z ON z."TransferLineId" = l."Id" AND z."IsDeleted" = false
 WHERE l."IsDeleted" = false AND t."IsDeleted" = false;