# View: red_essential_release_level_pricing

**View Name:** red_essential_release_level_pricing
**Table Source:** `Derived from: Art_Relations.Artist_Info, Art_Relations.Dms_Master_Pricing_Scheme, Art_Relations.Dms_Pricing_Tier, Art_Relations.Release_Custom_Pricing, Art_Relations.Release_Pricing_Tier + 3 more`
**File Path:** `red_essential_release_level_pricing.view.lkml`

## Overview

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

## Dimensions

| Name | Type |
|------|------|
| `upc` | number |
| `pricing_tier` | string |

## Derived Table

```sql
sql: SELECT
      rpt.upc
      , dpt.pricing_tier
      FROM  art_relations.releases r
      LEFT JOIN art_relations.release_pricing_tier rpt ON r.upc=rpt.upc
      INNER JOIN art_relations.artist_info ai ON ai.artist_id=r.artist_id
      INNER JOIN art_relations.vendor v ON v.`vendor_id`=ai.`vendor_id`
      LEFT JOIN art_relations.dms_pricing_tier dpt ON rpt.pricing_tier_id=dpt.pricing_tier_id
      LEFT JOIN art_relations.dms_master_pricing_scheme dmps ON dpt.pricing_scheme_id=dmps.pricing_scheme_id
      AND dmps.scheme_level = "release"
      LEFT JOIN art_relations.release_pricing_tier_country rptc ON rptc.release_pricing_tier_id=rpt.id AND rptc.country_id = 3
      LEFT JOIN art_relations.release_custom_pricing rcp ON rcp.release_pricing_tier_id=rptc.release_pricing_tier_id
      WHERE  rpt.active = "Y"
      AND v.owner = 'REDESSENT'
      AND  dmps.customer_master_master_id =1
      AND r.`release_status` = "in_content"
      GROUP BY r.upc;
       ;;
```