Description 

When clicking Refresh on an Item record in the GUI there's a pop-up message that says “Item, HOL linked to different Bibs”. In the item record you can see that there's an HOL link listed, but it doesn't show on the "HOL Links" tab of the Item record. 

It seems that this came about because of someone not properly moving Holdings records from one Bib to another.  

Resolution 

The following SQL looks for cases where the item is linked (via its ADM record) to bib record A, but the item's z30_hol_doc_number_x points to an HOL record which is linked to bib record B. 

SQL> select /*+ DYNAMIC_SAMPLING(2) ALL_ROWS */ unique 
substr (a.z103_rec_key_1,6,9), 
substr (b.z103_rec_key_1,6,9), 
substr (z30_rec_key,1,9), 
substr (b.z103_rec_key,6,9) 
from xxx01.z103 a, xxx01.z103 b, xxx50.z30 
where a.z103_lkr_type = 'ADM' and substr (a.z103_rec_key,6,9) = substr (z30_rec_key,1,9) 
and b.z103_lkr_type = 'HOL' and substr (b.z103_rec_key,6,9) = Z30_HOL_DOC_NUMBER_X 
and substr (a.z103_rec_key_1,6,9) ^= substr (b.z103_rec_key_1,6,9); 

-------------------------------------------------------------------------------------------- 
substr (a.z103_rec_key_1,6,9) is the bib record the item is linked to (via its ADM record) 
substr (b.z103_rec_key_1,6,9) is the bib record the HOL is linked to 
substr (z30_rec_key,1,9) is the ADM# of the item, and 
substr (b.z103_rec_key,6,9) is the HOL record#.