...
WHERE a.collaborator_sample_id IN ('old_externalID_1','old_externalID_2')
Issue: When upstream data change, some BSP plating info in BSP_PLATED_SAMPLES might need to be refreshed.
Remedy: Request a refresh for BspPlatingRequestAgent by issuing SQL like this in GAP_PROD.ANALYTICS:
INSERT INTO bsp_plating_special_refreshes nologging VALUES('6E3K2');
Note there is no "SM-" prefix,
Issue: When upstream data change, some samples in PDO_STAR5 might need to be refreshed.
...