Query 5001 Locations from items Sales

// ------------------------------------------------------------------------------------------------
// Copyright (c) Microsoft Corporation. All rights reserved.
// Licensed under the MIT License. See License.txt in the project root for license information.
// ------------------------------------------------------------------------------------------------
namespace Microsoft.Sales.Document;

using Microsoft.Inventory.Location;

/// <summary>
/// Retrieves distinct location information from sales order lines for warehouse operations.
/// </summary>
query 5001 "Locations from items Sales"
{
    Caption = 'Locations from items Sales';

    elements
    {
        dataitem(Sales_Line; "Sales Line")
        {
            DataItemTableFilter = "Document Type" = const(Order), Type = const(Item), "Location Code" = filter(<> ''), "No." = filter(<> ''), Quantity = filter(<> 0);
            column(Document_No; "Document No.")
            {
            }
            column(Location_Code; "Location Code")
            {
            }
            dataitem(Location; Location)
            {
                DataItemLink = Code = Sales_Line."Location Code";
                DataItemTableFilter = "Use As In-Transit" = const(false);
                column(Require_Shipment; "Require Shipment")
                {
                }
                column(Require_Pick; "Require Pick")
                {
                }
            }
        }
    }
}