The controlled-substance discovery view is the capability and compliance shortlist for scheduled-molecule sourcing. PharmaDB joins capability codes to inspection class and corporate-parent attribution at the plant level. The view is plant_capabilities filtered to capability_code = 'controlled_substance' joined to inspections and plants. Refresh cadence is quarterly for capability codes, weekly for inspections.