# View: releases_deliverable_to_direct_shot_and_wheels

**View Name:** releases_deliverable_to_direct_shot_and_wheels
**Table Source:** `Derived from: Art_Relations_Prod_Art_Relations.Delivery_History, Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Art_Relations_Prod_Art_Relations`
**File Path:** `releases_deliverable_to_direct_shot_and_wheels.view.lkml`

## Overview

- **File Size:** 766 bytes
- **Lines of Code:** 27
- **Dimensions:** 2
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- - filter: filter_customer_master_master_id
- type: number

## Dimensions

| Name | Type |
|------|------|
| `upc` | string |
| `deliverable` | string |

## Derived Table

```sql
sql: SELECT distinct dh.upc as upc
              FROM orchard_app_reporting_v2.art_relations_prod_art_relations.delivery_history dh
              WHERE dh.customer_master_master_id IN (738,739)
              GROUP BY 1
              HAVING COUNT(distinct dh.customer_master_master_id) = 2
               ;;
```