INSERT INTO location
(location_code,
 site_id,
 location_description,
 last_user,
 archive_flag,
 group_name)
SELECT 'MBIBF',
       site_id,
       'Mobile IBF',
       1,
       1,
       'T'
FROM site_info
WHERE airport_code = 'XXX';

INSERT INTO location
(location_code,
 site_id,
 location_description,
 last_user,
 archive_flag)
SELECT 'MWS1',
       site_id,
       'Management Workstation 1',
       1,
       1
FROM site_info
WHERE airport_code = 'XXX';

INSERT INTO location
(location_code,
 site_id,
 location_description,
 last_user,
 archive_flag)
SELECT 'N/A',
       site_id,
       'Not Applicable',
       1,
       1
FROM site_info
WHERE airport_code = 'XXX';

INSERT INTO location
(location_code,
 site_id,
 location_description,
 last_user,
 archive_flag)
SELECT 'UNKNWN',
       site_id,
       'Unknown TC location',
       1,
       1
FROM site_info
WHERE airport_code = 'XXX';

INSERT INTO location
(location_code,
 site_id,
 location_description,
 last_user,
 archive_flag)
SELECT '-',
       site_id,
       'No Location',
       1,
       1
FROM site_info
WHERE airport_code = 'XXX';

INSERT INTO location
(location_code,
 site_id,
 location_description,
 last_user,
 archive_flag)
SELECT 'UNKMWS',
       site_id,
       'Unknown Management Workstation',
       1,
       1
FROM site_info
WHERE airport_code = 'XXX';

COMMIT;
