view definition

# \d+ admin_views.sku_average_costs_in_our_possession 
                    View "admin_views.sku_average_costs_in_our_possession"
            Column            |           Type           | Modifiers | Storage  | Description 
------------------------------+--------------------------+-----------+----------+-------------
 sku_id                       | integer                  |           | plain    | 
 id                           | integer                  |           | plain    | 
 product_id                   | integer                  |           | plain    | 
 created_at                   | timestamp with time zone |           | plain    | 
 updated_at                   | timestamp with time zone |           | plain    | 
 size                         | character varying(100)   |           | extended | 
 location                     | character varying(12)    |           | extended | 
 upc_code                     | character varying(13)    |           | extended | 
 deactivated_at               | timestamp with time zone |           | plain    | 
 scn                          | bigint                   |           | plain    | 
 origin                       | character(1)             |           | extended | 
 product_look_id              | integer                  |           | plain    | 
 msrp_price                   | numeric(10,2)            |           | main     | 
 sale_price                   | numeric(10,2)            |           | main     | 
 vendor_bar_code              | character varying(50)    |           | extended | 
 shipping_surcharge           | numeric(10,2)            |           | main     | 
 force_ground_shipping        | smallint                 |           | plain    | 
 is_webstore_sku              | smallint                 |           | plain    | 
 webstore_sku_id              | integer                  |           | plain    | 
 foreign_msrp_price           | numeric(10,2)            |           | main     | 
 foreign_currency             | character varying(40)    |           | extended | 
 weight                       | numeric(10,2)            |           | main     | 
 length                       | numeric(10,2)            |           | main     | 
 width                        | numeric(10,2)            |           | main     | 
 height                       | numeric(10,2)            |           | main     | 
 is_exit_inventory            | boolean                  |           | plain    | 
 is_giveaway                  | boolean                  |           | plain    | 
 extra_weight                 | numeric(10,2)            |           | main     | 
 vendor_id                    | bigint                   |           | plain    | 
 is_sellable                  | boolean                  |           | plain    | 
 primary_size_chart_column_id | bigint                   |           | plain    | 
 size_id                      | bigint                   |           | plain    | 
 ship_alone_qty               | integer                  |           | plain    | 
 sku_attribute_set_id         | bigint                   |           | plain    | 
 ship_method_id               | integer                  |           | plain    | 
 vendor_style_number          | character varying(50)    |           | extended | 
 vendor_color                 | character varying(100)   |           | extended | 
 data_source_key              | character varying(100)   |           | extended | 
 country_of_origin_id         | bigint                   |           | plain    | 
 total_cost                   | numeric(10,2)            |           | main     | 
 total_average_cost           | numeric(10,2)            |           | main     | 
 total_units                  | bigint                   |           | plain    | 
 physical_cost                | numeric(10,2)            |           | main     | 
 physical_average_cost        | numeric(10,2)            |           | main     | 
 physical_units               | bigint                   |           | plain    | 
 virtual_cost                 | numeric(10,2)            |           | main     | 
 virtual_average_cost         | numeric(10,2)            |           | main     | 
 virtual_units                | bigint                   |           | plain    | 
 consignment_cost             | numeric(10,2)            |           | main     | 
 consignment_average_cost     | numeric(10,2)            |           | main     | 
 consignment_units            | bigint                   |           | plain    | 
View definition:
 SELECT skus.id AS sku_id,
    skus.id,
    skus.product_id,
    skus.created_at,
    skus.updated_at,
    skus.size,
    skus.location,
    skus.upc_code,
    skus.deactivated_at,
    skus.scn,
    skus.origin,
    skus.product_look_id,
    skus.msrp_price,
    skus.sale_price,
    skus.vendor_bar_code,
    skus.shipping_surcharge,
    skus.force_ground_shipping,
    skus.is_webstore_sku,
    skus.webstore_sku_id,
    skus.foreign_msrp_price,
    skus.foreign_currency,
    skus.weight,
    skus.length,
    skus.width,
    skus.height,
    skus.is_exit_inventory,
    skus.is_giveaway,
    skus.extra_weight,
    skus.vendor_id,
    skus.is_sellable,
    skus.primary_size_chart_column_id,
    skus.size_id,
    skus.ship_alone_qty,
    skus.sku_attribute_set_id,
    skus.ship_method_id,
    skus.vendor_style_number,
    skus.vendor_color,
    skus.data_source_key,
    skus.country_of_origin_id,
    sum(units.base_price)::numeric(10,2) AS total_cost,
    avg(units.base_price)::numeric(10,2) AS total_average_cost,
    count(DISTINCT units.id) AS total_units,
    sum(units.base_price) FILTER (WHERE NOT units.is_virtual)::numeric(10,2) AS physical_cost,
    avg(units.base_price) FILTER (WHERE NOT units.is_virtual)::numeric(10,2) AS physical_average_cost,
    count(DISTINCT units.id) FILTER (WHERE NOT units.is_virtual) AS physical_units,
    sum(units.base_price) FILTER (WHERE units.is_virtual)::numeric(10,2) AS virtual_cost,
    avg(units.base_price) FILTER (WHERE units.is_virtual)::numeric(10,2) AS virtual_average_cost,
    count(DISTINCT units.id) FILTER (WHERE units.is_virtual) AS virtual_units,
    sum(units.base_price) FILTER (WHERE units.is_consignment)::numeric(10,2) AS consignment_cost,
    avg(units.base_price) FILTER (WHERE units.is_consignment)::numeric(10,2) AS consignment_average_cost,
    count(DISTINCT units.id) FILTER (WHERE units.is_consignment) AS consignment_units
   FROM skus
     LEFT JOIN units ON units.webstore_sku_id = skus.id AND units.unit_disposition_id = 1
  GROUP BY skus.id;