# View: dt_oa_max_date

**View Name:** dt_oa_max_date
**Table Source:** `Derived from: Art_Relations_Prod_Art_Relations.Artist_Info, Art_Relations_Prod_Art_Relations.Checkspaid, Art_Relations_Prod_Art_Relations.Releases, Art_Relations_Prod_Art_Relations.Vendor_Checkspaid, Orchard_App_Reporting_V2 + 3 more`
**File Path:** `dt_oa_max_date.view.lkml`

## Overview

- **File Size:** 1512 bytes
- **Lines of Code:** 64
- **Dimensions:** 1
- **Measures:** 1
- **Dimension Groups:** 1
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `vendor_id` | number |

## Measures

| Name | Type |
|------|------|
| `count` | count |

## Dimension Groups

| Name | Type |
|------|------|
| `maxcut` | time |

## Derived Table

```sql
sql: SELECT xy.vendor_id, MAX(maxcut) AS maxcut
      FROM
      (
          SELECT vc.vendor_id, MAX(vc.cut_date) AS maxcut
          FROM ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.vendor_checkspaid vc
          INNER JOIN royalty_accounting_reporting.prod.vw_dim_abacus_ar_vendor v
              ON v.vendor_id = vc.vendor_id
          GROUP BY vc.vendor_id

          UNION

          SELECT ai.vendor_id, MAX(cp.cut_date) AS maxcut
          FROM ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.checkspaid cp
          INNER JOIN ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.releases r
              ON r.upc = cp.upc
          INNER JOIN ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.artist_info ai
              ON ai.artist_id = r.artist_id
          GROUP BY ai.vendor_id
      ) AS xy
      GROUP BY xy.vendor_id ;;
```