Item record review + push-back risk 3 · mediumOtherreflexion on

SELECT
  id, itemid, displayname, salesdescription, custitem_brand, custitem_pack_size, custitem_case_count, custitem_buyamerican, custitem_kosher, custitem_allergens, custitem_country_of_origin, custitem_storage_temp, reorderpoint, taxschedule, isinactive, lastmodifieddate
  FROM items
  WHERE UPPER(itemid) = UPPER(?1)
  LIMIT 1

SELECT
  spec_id, brand, item_name, pack_size, claims_json, nutritionals_json, allergens_json, spec_status, spec_version, last_updated
  FROM spec_items
  WHERE UPPER(item_code) = UPPER(?1)
  ORDER BY spec_version DESC
  LIMIT 1

SELECT
  customer_name, case_price, cost_basis, school_year, status, last_updated
  FROM pricing_master
  WHERE UPPER(item_code) = UPPER(?1)
  AND status='active'

SELECT
  vendor_name, vendor_item_code, unit_cost, effective_start, effective_end, status
  FROM vendor_costs vc
  JOIN vendor_items vi ON vi.vendor_item_id = vc.vendor_item_id
  WHERE UPPER(vi.item_code) = UPPER(?1)
  AND vc.status='active'

SELECT
  a.id, a.item_code AS assembly_code, a.description
  FROM assemblies a
  JOIN assembly_bom bom ON bom.assembly_id = a.id
  WHERE UPPER(bom.line_key) = UPPER(?1)
  AND a.deleted_at IS NULL
  AND bom.deleted_at IS NULL

SELECT
  bid_id, customer_name, proposed_price
  FROM bid_lines
  WHERE UPPER(item_code) = UPPER(?1)
  AND bid_id IN (SELECT id
  FROM bids
  WHERE status IN ('active','submitted'))

SELECT
  COUNT(*) AS so_count_30d
  FROM so_lines
  WHERE UPPER(item)=UPPER(?1)
  AND trandate >= date('now','-30 days')

Risk level 3 ≥ 3 — runner stages a proposed_actions row before fan-out runs. Mike must approve in proposed-actions.html before any side-effect step executes (real or stub).

SELECT
  lastmodifieddate
  FROM items
  WHERE UPPER(itemid)=UPPER(?1)
  AND lastmodifieddate > ?2

SELECT
  COUNT(*) AS broken
  FROM pricing_master
  WHERE UPPER(item_code)=UPPER(?1)
  AND status='active'
  AND case_price IS NULL

SELECT
  spec_id
  FROM spec_items
  WHERE UPPER(item_code)=UPPER(?1)
  ORDER BY spec_version DESC
  LIMIT 1