view: gfk_view {
    derived_table: {
      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 %} vendor_snowflake.vendor_id {% endcondition %})

GROUP BY 1,2,3
 ;;
}

    filter: vendor_id_filter {
      label: "Vendor ID"
      type: number
    }

    dimension: display_upc {
      type: string
      sql: ${TABLE}.display_upc ;;
  }

    dimension: release_id {
      type: number
      sql: ${TABLE}.release_id ;;
    }

  dimension: vendor_id {
    type: number
    sql: ${TABLE}.vendor_id ;;
  }
  }