SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE [dbo].[WOR1](-- Removed the unimportant columns
   [DocEntry] [int] NOT NULL,
   [LineNum] [int] NOT NULL,
   [ItemCode] [nvarchar](50) NULL,
   [PlannedQty] [numeric](19, 6) NULL,
   [IssuedQty] [numeric](19, 6) NULL,
   [wareHouse] [nvarchar](8) NULL
  );

INSERT INTO [dbo].[WOR1]
VALUES(154  ,0  ,'A00001'   ,12.000000  ,0.000000,  '01')
     ,(154  ,1  ,'P10001'   ,12.000000  ,0.000000,  '01')
     ,(154  ,2  ,'L10001'   ,12.000000  ,0.000000,  '01')
     ,(155  ,0  ,'A00001'   ,17.000000  ,0.000000,  '01')
     ,(155  ,1  ,'P10001'   ,17.000000  ,0.000000,  '01')
     ,(155  ,2  ,'L10001'   ,17.000000  ,0.000000,  '01');

CREATE TABLE [dbo].[OWOR](-- Removed the unimportant columns
       [DocEntry] [int] NOT NULL,
       [DocNum] [int] NOT NULL,
       [Status] [char](1) NULL
     );

INSERT INTO [dbo].[OWOR]
VALUES( 154,    901903, 'R')
     ,( 155,    901904, 'R');

CREATE TABLE [dbo].[OIBQ](-- Removed the unimportant columns
        [ItemCode] [nvarchar](50) NOT NULL,
        [BinAbs] [int] NOT NULL,
        [OnHandQty] [numeric](19, 6) NULL,
        [WhsCode] [nvarchar](8) NULL
);

INSERT INTO [dbo].[OIBQ]
VALUES('A00001',    7,  15.000000,  '98')
     ,('A00001',    2,  7.000000,   '98')
     ,('A00001',    3,  6.000000,   '98')
     ,('A00001',    4,  12.000000,  '98')
     ,('P10001',    5,  50.000000,  '98');

CREATE TABLE [dbo].[OBIN](-- Removed the unimportant columns
        [AbsEntry] [int] NOT NULL,
        [BinCode] [nvarchar](228) NOT NULL,
        [WhsCode] [nvarchar](8) NULL
      );

INSERT INTO [dbo].[OBIN]
VALUES(1,   '98-SYSTEM-BIN-LOCATION',   '98')
     ,(2,   '98-A001',  '98')
     ,(3,   '98-A002',  '98')
     ,(4,   '98-A003',  '98')
     ,(5,   '98-A004',  '98')
     ,(6,   '98-A005',  '98')
     ,(7,   '98-A006',  '98');

20 rows affected

SELECT WOPICK.docNum, WOPICK.itemCode, WOPICK.plannedQty,
       BINSTOCK.whsCode, BINSTOCK.binCode,
       CASE WHEN WOPICK.prevTotalNeeded < BINSTOCK.prevTotalQuantity
                 AND WOPICK.runningTotalNeeded > BINSTOCK.runningTotalQuantity
            THEN BINSTOCK.quantity
            WHEN WOPICK.prevTotalNeeded >= BINSTOCK.prevTotalQuantity
                 AND WOPICK.runningTotalNeeded <= BINSTOCK.runningTotalQuantity
            THEN WOPICK.neededQuantity
            WHEN WOPICK.runningTotalNeeded <= BINSTOCK.runningTotalQuantity
            THEN WOPICK.runningTotalNeeded - BINSTOCK.prevTotalQuantity
            WHEN WOPICK.prevTotalNeeded >= BINSTOCK.prevTotalQuantity
            THEN BINSTOCK.runningTotalQuantity - WOPICK.prevTotalNeeded
            END AS quantityToPick

FROM (SELECT itemCode, whsCode, binCode, quantity,
             SUM(quantity) OVER (PARTITION BY itemCode 
                                 ORDER BY binCode) - quantity AS prevTotalQuantity, 
             SUM(quantity) OVER (PARTITION BY itemCode 
                                 ORDER BY binCode) AS runningTotalQuantity
      FROM (SELECT OIBQ.itemCode, OIBQ.whsCode, OBIN.binCode, SUM(OIBQ.onHandQty) AS quantity
            FROM OIBQ
            JOIN OBIN
              ON OBIN.absEntry = OIBQ.binAbs
            GROUP BY OIBQ.itemCode, OIBQ.whsCode, OBIN.binCode) TotalQuantity
) BINSTOCK
JOIN (SELECT OWOR.docNum, WOR1.itemCode, plannedQty, plannedQty - issuedQty AS neededQuantity,
             SUM(plannedQty - issuedQty) OVER (PARTITION BY WOR1.itemCode 
                                               ORDER BY OWOR.docEntry) - (plannedQty - issuedQty) AS prevTotalNeeded,
             SUM(plannedQty - issuedQty) OVER (PARTITION BY WOR1.itemCode 
                                               ORDER BY OWOR.docEntry) AS runningTotalNeeded
      FROM OWOR
      JOIN WOR1
        ON WOR1.docEntry = OWOR.docEntry
      WHERE OWOR.status = 'R') WOPICK
  ON WOPICK.itemCode = BINSTOCK.itemCode
     AND WOPICK.prevTotalNeeded <= BINSTOCK.runningTotalQuantity
     AND WOPICK.runningTotalNeeded >= BINSTOCK.prevTotalQuantity

docNum	itemCode	plannedQty	whsCode	binCode	quantityToPick
901903	A00001	12.000000	98	98-A001	7.000000
901903	A00001	12.000000	98	98-A002	5.000000
901904	A00001	17.000000	98	98-A002	1.000000
901904	A00001	17.000000	98	98-A003	12.000000
901904	A00001	17.000000	98	98-A006	4.000000
901903	P10001	12.000000	98	98-A004	12.000000
901904	P10001	17.000000	98	98-A004	17.000000