-- $Id: ADDRESS_USAGES.sql /main/1 2009/07/25 16:53:55 tfisher Exp $

REM INSERT INTO ADDRESS_USAGES VALUES(
REM    ADDRESS_USAGES_ID,
REM    ASSOCIATED_OWNER_ID,
REM    OWNER_TYPE_CODE,
REM    ADDRESS_ID,
REM    USAGE_TYPE_CODE,
REM    EXPIRED_FLAG,
REM    CREATED_BY,
REM    CREATION_DATE,
REM    LAST_UPDATED_BY,
REM    LAST_UPDATE_DATE,
REM    OBJECT_VERSION_ID
REM );

INSERT INTO ADDRESS_USAGES VALUES(
    1,
    106,
    'CUST',
    1,
    'SH',
    'N',
    0,
    SYSDATE,
    0,
    SYSDATE,
    0
);

INSERT INTO ADDRESS_USAGES VALUES(
    2,
    107,
    'CUST',
    2,
    'SH',
    'N',
    0,
    SYSDATE,
    0,
    SYSDATE,
    0
);

INSERT INTO ADDRESS_USAGES VALUES(
    7,
    111,
    'CUST',
    7,
    'SH',
    'N',
    0,
    SYSDATE,
    0,
    SYSDATE,
    0
);

INSERT INTO ADDRESS_USAGES VALUES(
    8,
    111,
    'CUST',
    8,
    'SH',
    'N',
    0,
    SYSDATE,
    0,
    SYSDATE,
    0
);

INSERT INTO ADDRESS_USAGES VALUES(
    9,
    110,
    'CUST',
    9,
    'SH',
    'N',
    0,
    SYSDATE,
    0,
    SYSDATE,
    0
);

INSERT INTO ADDRESS_USAGES VALUES(
    10,
    110,
    'CUST',
    9,
    'IN',
    'N',
    0,
    SYSDATE,
    0,
    SYSDATE,
    0
);

INSERT INTO ADDRESS_USAGES VALUES(
    11,
    111,
    'CUST',
    10,
    'IN',
    'N',
    0,
    SYSDATE,
    0,
    SYSDATE,
    0
);

INSERT INTO ADDRESS_USAGES VALUES(
    12,
    111,
    'CUST',
    10,
    'SH',
    'N',
    0,
    SYSDATE,
    0,
    SYSDATE,
    0
);

INSERT INTO ADDRESS_USAGES VALUES(
    13,
    112,
    'CUST',
    11,
    'SH',
    'N',
    0,
    SYSDATE,
    0,
    SYSDATE,
    0
);

INSERT INTO ADDRESS_USAGES VALUES(
    14,
    112,
    'CUST',
    11,
    'IN',
    'N',
    0,
    SYSDATE,
    0,
    SYSDATE,
    0
);

INSERT INTO ADDRESS_USAGES VALUES(
    15,
    113,
    'CUST',
    12,
    'IN',
    'N',
    0,
    SYSDATE,
    0,
    SYSDATE,
    0
);

INSERT INTO ADDRESS_USAGES VALUES(
    16,
    113,
    'CUST',
    13,
    'SH',
    'N',
    0,
    SYSDATE,
    0,
    SYSDATE,
    0
);

INSERT INTO ADDRESS_USAGES VALUES(
    17,
    114,
    'CUST',
    14,
    'SH',
    'N',
    0,
    SYSDATE,
    0,
    SYSDATE,
    0
);

INSERT INTO ADDRESS_USAGES VALUES(
    18,
    114,
    'CUST',
    15,
    'IN',
    'N',
    0,
    SYSDATE,
    0,
    SYSDATE,
    0
);

INSERT INTO ADDRESS_USAGES VALUES(
    19,
    115,
    'CUST',
    16,
    'IN',
    'N',
    0,
    SYSDATE,
    0,
    SYSDATE,
    0
);

INSERT INTO ADDRESS_USAGES VALUES(
    20,
    115,
    'CUST',
    16,
    'SH',
    'N',
    0,
    SYSDATE,
    0,
    SYSDATE,
    0
);

INSERT INTO ADDRESS_USAGES VALUES(
    21,
    116,
    'CUST',
    17,
    'SH',
    'N',
    0,
    SYSDATE,
    0,
    SYSDATE,
    0
);

INSERT INTO ADDRESS_USAGES VALUES(
    22,
    117,
    'CUST',
    18,
    'SH',
    'N',
    0,
    SYSDATE,
    0,
    SYSDATE,
    0
);

INSERT INTO ADDRESS_USAGES VALUES(
    24,
    119,
    'CUST',
    20,
    'SH',
    'N',
    0,
    SYSDATE,
    0,
    SYSDATE,
    0
);

INSERT INTO ADDRESS_USAGES VALUES(
    25,
    120,
    'CUST',
    21,
    'SH',
    'N',
    0,
    SYSDATE,
    0,
    SYSDATE,
    0
);

INSERT INTO ADDRESS_USAGES VALUES(
    26,
    121,
    'CUST',
    22,
    'SH',
    'N',
    0,
    SYSDATE,
    0,
    SYSDATE,
    0
);

INSERT INTO ADDRESS_USAGES VALUES(
    27,
    122,
    'CUST',
    23,
    'SH',
    'N',
    0,
    SYSDATE,
    0,
    SYSDATE,
    0
);

INSERT INTO ADDRESS_USAGES VALUES(
    28,
    123,
    'CUST',
    24,
    'SH',
    'N',
    0,
    SYSDATE,
    0,
    SYSDATE,
    0
);

INSERT INTO ADDRESS_USAGES VALUES(
    29,
    123,
    'CUST',
    25,
    'SH',
    'N',
    0,
    SYSDATE,
    0,
    SYSDATE,
    0
);

INSERT INTO ADDRESS_USAGES VALUES(
    30,
    124,
    'CUST',
    26,
    'SH',
    'N',
    0,
    SYSDATE,
    0,
    SYSDATE,
    0
);

INSERT INTO ADDRESS_USAGES VALUES(
    31,
    125,
    'CUST',
    27,
    'SH',
    'N',
    0,
    SYSDATE,
    0,
    SYSDATE,
    0
);

INSERT INTO ADDRESS_USAGES VALUES(
    32,
    125,
    'CUST',
    27,
    'IN',
    'N',
    0,
    SYSDATE,
    0,
    SYSDATE,
    0
);

INSERT INTO ADDRESS_USAGES VALUES(
    33,
    126,
    'CUST',
    28,
    'IN',
    'N',
    0,
    SYSDATE,
    0,
    SYSDATE,
    0
);

INSERT INTO ADDRESS_USAGES VALUES(
    34,
    126,
    'CUST',
    28,
    'SH',
    'N',
    0,
    SYSDATE,
    0,
    SYSDATE,
    0
);

INSERT INTO address_usages
VALUES
(37,108,'CUST',3,'IN','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(3,108,'CUST',3,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(40,108,'CUST',20,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(41,108,'CUST',21,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(38,109,'CUST',4,'IN','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(4,109,'CUST',4,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(42,109,'CUST',22,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(43,109,'CUST',23,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(39,110,'CUST',5,'IN','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(5,110,'CUST',5,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(6,110,'CUST',6,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(44,110,'CUST',24,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(45,110,'CUST',25,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(50,114,'CUST',2,'IN','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(51,114,'CUST',2,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(52,114,'CUST',29,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(53,114,'CUST',30,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(54,114,'CUST',31,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(49,118,'CUST',1,'IN','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(23,118,'CUST',19,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(46,118,'CUST',26,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(47,118,'CUST',27,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(48,118,'CUST',28,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(55,108,'CUST',97,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(56,109,'CUST',54,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(57,110,'CUST',37,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(58,111,'CUST',42,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(59,112,'CUST',55,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(60,113,'CUST',14,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(61,114,'CUST',22,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(62,115,'CUST',63,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(63,116,'CUST',74,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(64,117,'CUST',15,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(65,118,'CUST',24,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(66,119,'CUST',28,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(67,120,'CUST',69,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(68,121,'CUST',73,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(69,122,'CUST',45,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(70,123,'CUST',47,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(71,124,'CUST',32,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(72,125,'CUST',83,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(73,126,'CUST',91,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(74,127,'CUST',75,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(75,128,'CUST',10,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(76,129,'CUST',58,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

----------------------------------


INSERT INTO address_usages
VALUES
(77,100,'STAFF',33,'IN','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(78,101,'STAFF',34,'IN','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(79,102,'STAFF',35,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(80,103,'STAFF',36,'IN','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(81,104,'STAFF',38,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(82,105,'STAFF',39,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(83,106,'STAFF',40,'IN','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(84,107,'STAFF',41,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(85,200,'SUPP',43,'IN','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(86,201,'SUPP',44,'IN','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(87,202,'SUPP',46,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(88,203,'SUPP',48,'IN','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(89,204,'SUPP',49,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(90,205,'SUPP',50,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(91,206,'SUPP',51,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(92,207,'SUPP',52,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(93,208,'SUPP',53,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(94,209,'SUPP',56,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(95,210,'SUPP',57,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(96,211,'SUPP',59,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(97,212,'SUPP',60,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(98,213,'SUPP',61,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(99,214,'SUPP',62,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(100,215,'SUPP',64,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(101,216,'SUPP',65,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(102,217,'SUPP',66,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(103,218,'SUPP',67,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(104,219,'SUPP',68,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);

INSERT INTO address_usages
VALUES
(105,220,'SUPP',70,'SH','N', 0, SYSDATE, 0, SYSDATE, 0);
