old   1: select * from ak.MMS_WELL_REPORTS where uwi = '&api_well_number'
new   1: select * from ak.MMS_WELL_REPORTS where uwi = '551710001000'

UWI                  INDEX_NUMBER REPORT_NAME                                   
-------------------- ------------ --------------------------------------------- 
551710001000                      BIOSTRATIGRAPHIC REPORT                       
551710001000                      CHECKSHOT SURVEY                              
551710001000                      CORRESPONDENCE                                
551710001000                      GEOCHEMICAL REPORT                            
551710001000                      PALEONTOLOGIC                                 
551710001000                      PETROGRAPHIC STUDY                            
551710001000                      SIDEWALL CORE REPORT                          
551710001000                      VERTICAL SEISMIC PROFILE                      
551710001000                      WELL COMPLETION REPORT                        
551710001000                      WELL SUMMARY                                  

10 rows selected.

SQL> spool off
