~~~BEGIN_MAIN_SECTION~~~
[PRODUCT]
table=SRC_HUB_DC_NAMES_TB
~~~END_MAIN_SECTION~~~


~~~BEGIN_VERSION_SECTION~~~
[VERSION]
version=2025-11-04

[SQL_SCRIPT___DEFAULT]


--------------------------------------------------------
--  DDL for Table SRC_HUB_DC_NAMES_TB
--------------------------------------------------------

CREATE TABLE "OTHQ_OWN"."SRC_HUB_DC_NAMES_TB" 
(
	"HUB_NAME" VARCHAR2(32 BYTE) COLLATE "USING_NLS_COMP", 
	"HUB_CODE" VARCHAR2(8 BYTE) COLLATE "USING_NLS_COMP", 
	"NAME" VARCHAR2(32 BYTE) COLLATE "USING_NLS_COMP", 
	"ID" VARCHAR2(16 BYTE) COLLATE "USING_NLS_COMP"
)
   

Insert into OTHQ_OWN.SRC_HUB_DC_NAMES_TB (HUB_NAME,HUB_CODE,NAME,ID) values ('AP Melbourne','mel3','Melbourne','mel-ap3');
Insert into OTHQ_OWN.SRC_HUB_DC_NAMES_TB (HUB_NAME,HUB_CODE,NAME,ID) values ('AP Osaka','kix4','Osaka','kix-ap4');
Insert into OTHQ_OWN.SRC_HUB_DC_NAMES_TB (HUB_NAME,HUB_CODE,NAME,ID) values ('AP Sydney','syd1','Sydney','syd-ap1');
Insert into OTHQ_OWN.SRC_HUB_DC_NAMES_TB (HUB_NAME,HUB_CODE,NAME,ID) values ('AP Tokyo','nrt2','Tokyo','nrt-ap2');
Insert into OTHQ_OWN.SRC_HUB_DC_NAMES_TB (HUB_NAME,HUB_CODE,NAME,ID) values ('CA Montreal','yul16','Montreal','yul-na16');
Insert into OTHQ_OWN.SRC_HUB_DC_NAMES_TB (HUB_NAME,HUB_CODE,NAME,ID) values ('CA Toronto','yyz17','Toronto','yyz-na17');
Insert into OTHQ_OWN.SRC_HUB_DC_NAMES_TB (HUB_NAME,HUB_CODE,NAME,ID) values ('EU Amsterdam 1','ams5','Amsterdam 1','ams-eu5');
Insert into OTHQ_OWN.SRC_HUB_DC_NAMES_TB (HUB_NAME,HUB_CODE,NAME,ID) values ('EU Amsterdam 2','ams8','Amsterdam 2','ams-eu8');
Insert into OTHQ_OWN.SRC_HUB_DC_NAMES_TB (HUB_NAME,HUB_CODE,NAME,ID) values ('EU Frankfurt 1','fra3','Frankfurt 1','fra-eu3');
Insert into OTHQ_OWN.SRC_HUB_DC_NAMES_TB (HUB_NAME,HUB_CODE,NAME,ID) values ('EU Frankfurt 2','fra7','Frankfurt 2','fra-eu7');
Insert into OTHQ_OWN.SRC_HUB_DC_NAMES_TB (HUB_NAME,HUB_CODE,NAME,ID) values ('UK London','lhr4','London','lhr-eu4');
Insert into OTHQ_OWN.SRC_HUB_DC_NAMES_TB (HUB_NAME,HUB_CODE,NAME,ID) values ('UK Newport','cwl6','Newport','cwl-eu6');
Insert into OTHQ_OWN.SRC_HUB_DC_NAMES_TB (HUB_NAME,HUB_CODE,NAME,ID) values ('US Ashburn 1','iad4','Ashburn 1','iad-na4');
Insert into OTHQ_OWN.SRC_HUB_DC_NAMES_TB (HUB_NAME,HUB_CODE,NAME,ID) values ('US Ashburn 2','iad6','Ashburn 2','iad-na6');
Insert into OTHQ_OWN.SRC_HUB_DC_NAMES_TB (HUB_NAME,HUB_CODE,NAME,ID) values ('US Ashburn 3','iad8','Ashburn 3','iad-na8');
Insert into OTHQ_OWN.SRC_HUB_DC_NAMES_TB (HUB_NAME,HUB_CODE,NAME,ID) values ('US Ashburn 4','iad10','Ashburn 4','iad-na10');
Insert into OTHQ_OWN.SRC_HUB_DC_NAMES_TB (HUB_NAME,HUB_CODE,NAME,ID) values ('US Ashburn 5','iad13','Ashburn 5','iad-na13');
Insert into OTHQ_OWN.SRC_HUB_DC_NAMES_TB (HUB_NAME,HUB_CODE,NAME,ID) values ('US Ashburn 6','iad18','Ashburn 6','iad-na18');
Insert into OTHQ_OWN.SRC_HUB_DC_NAMES_TB (HUB_NAME,HUB_CODE,NAME,ID) values ('US Ashburn 7','iad20','Ashburn 7','iad-na20');
Insert into OTHQ_OWN.SRC_HUB_DC_NAMES_TB (HUB_NAME,HUB_CODE,NAME,ID) values ('US Ashburn 8','iad22','Ashburn 8','iad-na22');
Insert into OTHQ_OWN.SRC_HUB_DC_NAMES_TB (HUB_NAME,HUB_CODE,NAME,ID) values ('US Ashburn 9','iad24','Ashburn 9','iad-na24');
Insert into OTHQ_OWN.SRC_HUB_DC_NAMES_TB (HUB_NAME,HUB_CODE,NAME,ID) values ('US Phoenix 1','phx5','Phoenix 1','phx-na5');
Insert into OTHQ_OWN.SRC_HUB_DC_NAMES_TB (HUB_NAME,HUB_CODE,NAME,ID) values ('US Phoenix 2','phx7','Phoenix 2','phx-na7');
Insert into OTHQ_OWN.SRC_HUB_DC_NAMES_TB (HUB_NAME,HUB_CODE,NAME,ID) values ('US Phoenix 3','phx9','Phoenix 3','phx-na9');
Insert into OTHQ_OWN.SRC_HUB_DC_NAMES_TB (HUB_NAME,HUB_CODE,NAME,ID) values ('US Phoenix 4','phx11','Phoenix 4','phx-na11');
Insert into OTHQ_OWN.SRC_HUB_DC_NAMES_TB (HUB_NAME,HUB_CODE,NAME,ID) values ('US Phoenix 5','phx15','Phoenix 5','phx-na15');
Insert into OTHQ_OWN.SRC_HUB_DC_NAMES_TB (HUB_NAME,HUB_CODE,NAME,ID) values ('US Phoenix 6','phx19','Phoenix 6','phx-na19');
Insert into OTHQ_OWN.SRC_HUB_DC_NAMES_TB (HUB_NAME,HUB_CODE,NAME,ID) values ('US Phoenix 7','phx21','Phoenix 7','phx-na21');
Insert into OTHQ_OWN.SRC_HUB_DC_NAMES_TB (HUB_NAME,HUB_CODE,NAME,ID) values ('US Phoenix 8','phx23','Phoenix 8','phx-na23');
Insert into OTHQ_OWN.SRC_HUB_DC_NAMES_TB (HUB_NAME,HUB_CODE,NAME,ID) values ('US Phoenix 9','phx25','Phoenix 9','phx-na25');
Insert into OTHQ_OWN.SRC_HUB_DC_NAMES_TB (HUB_NAME,HUB_CODE,NAME,ID) values ('US San Jose 1','sjc12','San Jose 1','sjc-na12');
Insert into OTHQ_OWN.SRC_HUB_DC_NAMES_TB (HUB_NAME,HUB_CODE,NAME,ID) values ('US San Jose 2','sjc14','San Jose 2','sjc-na14');
Insert into OTHQ_OWN.SRC_HUB_DC_NAMES_TB (HUB_NAME,HUB_CODE,NAME,ID) values ('US Phoenix 5','phx','Phoenix 5 NSX','phx-nsx1');
Insert into OTHQ_OWN.SRC_HUB_DC_NAMES_TB (HUB_NAME,HUB_CODE,NAME,ID) values ('US Ashburn 5','iad','Ashburn 5 NSX','iad-nsx1');
Insert into OTHQ_OWN.SRC_HUB_DC_NAMES_TB (HUB_NAME,HUB_CODE,NAME,ID) values ('US Chicago','ord','Chicago','ord-na26');
Insert into OTHQ_OWN.SRC_HUB_DC_NAMES_TB (HUB_NAME,HUB_CODE,NAME,ID) values ('AP Hyderabad','hyd','Hyderabad','hyd-ap7');
Insert into OTHQ_OWN.SRC_HUB_DC_NAMES_TB (HUB_NAME,HUB_CODE,NAME,ID) values ('AP Mumbai','bom','Mumbai','bom-ap8');

~~~END_VERSION_SECTION~~~