view: releases_deliverable_to_membran {
  derived_table: {
    sql: SELECT distinct upc as upc
      FROM orchard_app_reporting_v2.art_relations_prod_art_relations.delivery_history
      where customer_master_master_id = 740
       ;;
  }

  #   - filter: filter_customer_master_master_id
  #     type: number

  dimension: upc {
    hidden: yes
    label: "upc"
    type: string
    sql: ${TABLE}.upc ;;
  }

  dimension: deliverable {
    label: "Deliverable to Membran?"
    type: string
    sql: case when ${TABLE}.upc is null then 'No' else 'Yes' end ;;
  }
}