singleLevelUsageAsPlanned-select-some.rq

# Copyright (c) 2023 SAP SE 
# Copyright (c) 2023 T-Systems International GmbH 
# Copyright (c) 2023 Contributors to the Eclipse Foundation
#
# See the NOTICE file(s) distributed with this work for additional
# information regarding copyright ownership.
#
# This program and the accompanying materials are made available under the
# terms of the Apache License, Version 2.0 which is available at
# https://www.apache.org/licenses/LICENSE-2.0.
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
# WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
# License for the specific language governing permissions and limitations
# under the License.
#
# SPDX-License-Identifier: Apache-2.0

PREFIX cx-common: <https://w3id.org/catenax/ontology/common#>
PREFIX cx-core: <https://w3id.org/catenax/ontology/core#>
PREFIX cx-vehicle: <https://w3id.org/catenax/ontology/vehicle#>
PREFIX cx-bom: <https://w3id.org/catenax/ontology/bill-of-material#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

# Select some bom information

SELECT ?catenaXId ?businessPartner ?parentCatenaXId ?parentQuantity ?billOfMaterialUnit ?productionEndDate ?productionStartDate
WHERE {

    VALUES(?catenaXId) {
        (%s)
    }

    ?bom rdf:type cx-bom:BillOfMaterial;
         cx-bom:assembly ?parentCatenaXId;
         cx-bom:component ?catenaXId;
         cx-bom:supplier ?businessPartner;
         cx-bom:quantityMeasure ?parentQuantity;
         cx-bom:quantityUnit ?billOfMaterialUnit;
         cx-bom:validityPeriodStart ?productionStartDate;
         cx-bom:validityPeriodEnd ?productionEndDate.
}
ORDER BY DESC(?catenaXId)