# View: gfk_view

**View Name:** gfk_view
**Table Source:** `Derived from: Art_Relations_Prod_Art_Relations.Artist_Info, Art_Relations_Prod_Art_Relations.Delivery_History, Art_Relations_Prod_Art_Relations.Distribution_Format, Art_Relations_Prod_Art_Relations.Releases, Orchard_App_Reporting_V2 + 3 more`
**File Path:** `gfk_view.view.lkml`

## Overview

- **File Size:** 2854 bytes
- **Lines of Code:** 67
- **Dimensions:** 3
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 1

## Dimensions

| Name | Type |
|------|------|
| `display_upc` | string |
| `release_id` | number |
| `vendor_id` | number |

## Filters

- `vendor_id_filter`

## Derived Table

```sql
sql:

      WITH releases_deliverable_to_membran AS
      (SELECT distinct upc as upc
      FROM orchard_app_reporting_v2.art_relations_prod_art_relations.delivery_history
      where customer_master_master_id = 740)

SELECT
  releases_snowflake.display_upc,
  releases_snowflake.release_id,
  vendor_snowflake.vendor_id
FROM orchard_app_reporting_v2.art_relations_prod_art_relations.releases  AS releases_snowflake
LEFT JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.artist_info  AS artist_info_snowflake ON releases_snowflake.artist_id=artist_info_snowflake.artist_id
LEFT JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.distribution_format  AS distribution_format_snowflake ON distribution_format_snowflake.distribution_format_id=releases_snowflake.distribution_format_id
LEFT JOIN royalty_accounting_reporting.prod.vw_dim_abacus_ar_vendor  AS vendor_snowflake ON vendor_snowflake.vendor_id = artist_info_snowflake.vendor_id
LEFT JOIN releases_deliverable_to_membran ON releases_snowflake.upc=releases_deliverable_to_membran.upc
LEFT JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.delivery_history  AS delivery_history_snowflake ON releases_snowflake.upc= delivery_history_snowflake.upc
        AND customer_master_master_id = 740

WHERE  (releases_snowflake.sale_start_date  IS NOT NULL)
       AND (distribution_format_snowflake.context_type = 'physical')
       AND (releases_deliverable_to_membran.upc is not null )
       AND (delivery_history_snowflake.date_delivered  IS NOT NULL)



UNION


SELECT
  releases_snowflake.display_upc,
  releases_snowflake.release_id,
  vendor_snowflake.vendor_id
FROM orchard_app_reporting_v2.art_relations_prod_art_relations.releases  AS releases_snowflake
LEFT JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.artist_info  AS artist_info_snowflake ON releases_snowflake.artist_id=artist_info_snowflake.artist_id
LEFT JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.distribution_format  AS distribution_format_snowflake ON distribution_format_snowflake.distribution_format_id=releases_snowflake.distribution_format_id
LEFT JOIN royalty_accounting_reporting.prod.vw_dim_abacus_ar_vendor  AS vendor_snowflake ON vendor_snowflake.vendor_id = artist_info_snowflake.vendor_id

WHERE  (distribution_format_snowflake.context_type = 'physical')
       AND  ({% condition vendor_id_filter %
```