SQL CODE ЗА СКЛАДА

SELECT
    AKOPF.AUFTRAGSNUMMER AS "Order number",
    LKWKZ AS "Truck number",
    ANHAENGERKZ AS "Trailer number",
    TOURNUMMER AS "Tour number",
    SKUN.NAME1 AS "GOPET LOGISTICS EOOD as Sender",
            CASE WHEN SKUN.KUNDENNR = 23164813 THEN LOADINGDATEPLANNEDSTART END AS "Loading date when Sender is GOPET LOGISTICS EOOD",

    SKU.NAME1 AS "GOPET LOGISTICS EOOD as Receiver",
            CASE WHEN SKU.KUNDENNR = 23164813 THEN DELIVERYDATEPLANNEDSTART END AS "Unloading date when Receiver is GOPET LOGISTICS EOOD"

FROM ATOUR
JOIN ATASEND ON ATOUR.NR = ATASEND.TOURNR
JOIN ASENDUNG ON ASENDUNG.SENDUNGID = ATASEND.ASENDUNGID
LEFT JOIN SKUNDEN SKUN ON SKUN.NR = ATASEND.ABSNR
LEFT JOIN SKUNDEN SKU ON SKU.NR = ATASEND.EMPFNR
LEFT JOIN AKOPF ON AKOPF.NR = ASENDUNG.AKOPFNR
LEFT JOIN SHIERARCHIE ON SHIERARCHIE.ID = AKOPF.HIERARCHIE

WHERE
    (
        (LOADINGDATEPLANNEDSTART >= TO_DATE('01-01-2025', 'dd-mm-yyyy')
        AND LOADINGDATEPLANNEDSTART <= TO_DATE('31-01-2025', 'dd-mm-yyyy')
        AND SKUN.KUNDENNR = 23164813)
    OR
        (DELIVERYDATEPLANNEDSTART >= TO_DATE('01-01-2025', 'dd-mm-yyyy')
        AND DELIVERYDATEPLANNEDSTART <= TO_DATE('31-01-2025', 'dd-mm-yyyy')
        AND SKU.KUNDENNR = 23164813)
    )
AND SHIERARCHIE.NR = 21001;