Assembly build + BOM review risk 3 · mediumOtherreflexion on

SELECT
  id, item_code, description, custitem_brand, custitem_pack_size, custitem_case_count, custitem_yield, lastmodifieddate
  FROM assemblies
  WHERE (id = ?1
  OR UPPER(item_code) = UPPER(?2))
  AND deleted_at IS NULL
  LIMIT 1

SELECT
  bom_line_id, line_key, line_description, quantity, unit, source_vendor, unit_cost, line_total, deleted_at
  FROM assembly_bom
  WHERE assembly_id = ?1
  AND deleted_at IS NULL
  ORDER BY bom_line_id

SELECT
  raw_cost, packaging_cost, labor_cost, overhead_cost, freight_cost, fob_dock_cost, last_computed, drift_pct_vs_prior
  FROM assembly_cost_rollup
  WHERE assembly_id = ?1

SELECT
  ap.program_id, cp.customer_name, cp.program_name, cp.contract_price, cp.status
  FROM assembly_programs ap
  JOIN customer_programs cp ON cp.program_id = ap.program_id
  WHERE ap.assembly_id = ?1
  AND cp.status = 'active'

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

SELECT
  spec_id, spec_status, spec_version, claims_json, last_updated
  FROM spec_items
  WHERE UPPER(item_code) = (SELECT UPPER(item_code)
  FROM assemblies
  WHERE id = ?1)
  ORDER BY spec_version DESC
  LIMIT 1

SELECT
  COUNT(*) AS build_count_90d
  FROM transactions
  WHERE type='Build'
  AND entity_name LIKE '%'||(SELECT item_code
  FROM assemblies
  WHERE id=?1)||'%'
  AND trandate >= date('now','-90 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 assemblies
  WHERE id=?1
  AND lastmodifieddate > ?2

SELECT
  COUNT(*) AS line_count
  FROM assembly_bom
  WHERE assembly_id=?1
  AND deleted_at IS NULL

SELECT
  last_computed, drift_pct_vs_prior
  FROM assembly_cost_rollup
  WHERE assembly_id=?1

SELECT
  COUNT(*) AS orphans
  FROM pricing_master pm
  WHERE UPPER(pm.item_code) = (SELECT UPPER(item_code)
  FROM assemblies
  WHERE id=?1)
  AND pm.status='active'
  AND pm.cost_basis IS NULL