# View: int_prod_vw_deleted_releases

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

## Overview

- **File Size:** 1088 bytes
- **Lines of Code:** 42
- **Dimensions:** 3
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- with deletions as (select vw.upc, vw.date_deleted, f.action
- from intelligence.prod.vw_deleted_releases vw
- left join orchard_app_reporting_v2.art_relations_prod_art_relations.FULL_DELETIONS f on vw.upc = f.upc),

## Dimensions

| Name | Type |
|------|------|
| `upc` | number |
| `has_deleted_date` | yesno |
| `date_deleted` | date |

## Derived Table

```sql
sql: SELECT upc, MAX(TO_DATE(date_deleted)) AS date_deleted
FROM orchard_app_reporting_v2.art_relations_prod_art_relations.full_deletions
WHERE action = 'delete'
GROUP BY 1
 ;;
```