View: core.item_selector_view

 CREATE OR REPLACE VIEW core.item_selector_view
 AS
 SELECT items.item_id,
    items.item_code,
    items.item_name,
    items.item_group_id,
    items.item_type_id,
    items.brand_id,
    items.preferred_supplier_id,
    items.lead_time_in_days,
    items.weight_in_grams,
    items.width_in_centimeters,
    items.height_in_centimeters,
    items.length_in_centimeters,
    items.machinable,
    items.preferred_shipping_mail_type_id,
    items.shipping_package_shape_id,
    items.unit_id,
    items.hot_item,
    items.cost_price,
    items.cost_price_includes_tax,
    items.selling_price,
    items.selling_price_includes_tax,
    items.sales_tax_id,
    items.reorder_unit_id,
    items.reorder_level,
    items.reorder_quantity,
    items.maintain_stock,
    items.audit_user_id,
    items.audit_ts
   FROM core.items;