Retrieving project and supplier relationships. Conditional filtering based on supplier status or shipment details. Multi-level aggregations and comparisons between projects and parts. Updating and ...