# View: dt_physical_delivery_flags

**View Name:** dt_physical_delivery_flags
**Table Source:** `Derived from: Art_Relations_Prod_Art_Relations.Artist_Info, Art_Relations_Prod_Art_Relations.Releases, Art_Relations_Prod_Art_Relations.Vendor_Dms_Master_Restriction, Dbt_Prod.Active_Vendor_Contracts, Intelligence.Dbt_Prod + 2 more`
**File Path:** `dt_physical_delivery_flags.view.lkml`

## Overview

- **File Size:** 2387 bytes
- **Lines of Code:** 60
- **Dimensions:** 4
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 1

## Dimensions

| Name | Type |
|------|------|
| `release_id` | number |
| `is_deliverable` | yesno |
| `is_delivered` | yesno |
| `delivery_discrepancy` | yesno |

## Filters

- `store_id`

## Derived Table

```sql
sql:
WITH delivery_restrictions AS (
    SELECT r.release_id, vdmr.customer_master_master_id
    FROM orchard_app_reporting_v2.art_relations_prod_art_relations.releases r
        INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.artist_info ai ON r.artist_id = ai.artist_id
        INNER JOIN intelligence.dbt_prod.active_vendor_contracts vw ON ai.vendor_id = vw.vendor_id
        INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.vendor_dms_master_restriction vdmr ON vw.vendor_contract_id = vdmr.vendor_contract_id
        WHERE {% condition store_id %
```