22 lines
835 B
SQL
22 lines
835 B
SQL
CREATE OR REPLACE VIEW public.vw_utility_instructed_lots AS
|
|
WITH stock_move AS (
|
|
SELECT DISTINCT mvt_1."intLotId",
|
|
mvt_1."intShipmentId",
|
|
mvt_1."dblQuantity",
|
|
mvt_1."strUnit",
|
|
mvt_1."dblQuantityKg"
|
|
FROM vw_utility_stock_movements mvt_1
|
|
WHERE ((1 = 1) AND (mvt_1."strMovementType" = ANY (ARRAY['Inbound'::text, 'Dropship'::text])))
|
|
)
|
|
SELECT mvt."intLotId",
|
|
mvt."intShipmentId",
|
|
lot."intPurchaseLineId",
|
|
mvt."dblQuantity",
|
|
mvt."strUnit",
|
|
mvt."dblQuantityKg",
|
|
lot."intSaleLineId"
|
|
FROM ((stock_move mvt
|
|
JOIN vw_utility_shipment_in spt ON ((mvt."intShipmentId" = spt."intShipmentId")))
|
|
JOIN vw_utility_lot lot ON ((mvt."intLotId" = lot."intLotId")))
|
|
WHERE ((1 = 1) AND ((spt."strState")::text = 'draft'::text));;
|