Liren Large Software Subsidy 5/05.iso/a/a522/6.ddi/ADVANCED.SQL

Text File | 1990-04-03 | 61.9 KB | 3,097 lines

/*
   This file contains SQL statements to create the following:
    Table: Lookup
    View:  Spell_Number
    View:  Account
    Table: Names
   History: Created 10/30/89   ... NMehta
*/
/*
   TABLE: LOOKUP
   This table is used to lookup spelled-out text for numbers in
   the Spelling Out Cash Amounts reports in the case book.
   Nimish Mehta Oct. 30th. 1989

   Warning: 1,001 records will be inserted into LOOKUP
*/
drop table lookup
/
create table lookup
(numbervalue number, numbertext char(30))
/
insert into lookup values
(0, 'ZERO')
/
insert into lookup values
(1, 'ONE')
/
insert into lookup values
(2,'TWO')
/
insert into lookup values
(3,'THREE')
/
insert into lookup values
(4,'FOUR')
/
insert into lookup values
(5,'FIVE')
/
insert into lookup values
(6,'SIX')
/
insert into lookup values
(7,'SEVEN')
/
insert into lookup values
(8,'EIGHT')
/
insert into lookup values
(9,'NINE')
/
insert into lookup values
(10,'TEN')
/
insert into lookup values
(11,'ELEVEN')
/
insert into lookup values
(12,'TWELVE')
/
insert into lookup values
(13,'THIRTEEN')
/
insert into lookup values
(14,'FOURTEEN')
/
insert into lookup values
(15,'FIFTEEN')
/
insert into lookup values
(16,'SIXTEEN')
/
insert into lookup values
(17,'SEVENTEEN')
/
insert into lookup values
(18,'EIGHTEEN')
/
insert into lookup values
(19,'NINETEEN')
/
insert into lookup values
(20,'TWENTY')
/
insert into lookup values
(21,'TWENTY ONE')
/
insert into lookup values
(22,'TWENTY TWO')
/
insert into lookup values
(23,'TWENTY THREE')
/
insert into lookup values
(24,'TWENTY FOUR')
/
insert into lookup values
(25,'TWENTY FIVE')
/
insert into lookup values
(26,'TWENTY SIX')
/
insert into lookup values
(27,'TWENTY SEVEN')
/
insert into lookup values
(28,'TWENTY EIGHT')
/
insert into lookup values
(29,'TWENTY NINE')
/
insert into lookup values
(30,'THIRTY')
/
insert into lookup values
(31,'THIRTY ONE')
/
insert into lookup values
(32,'THIRTY TWO')
/
insert into lookup values
(33,'THIRTY THREE')
/
insert into lookup values
(34,'THIRTY FOUR')
/
insert into lookup values
(35,'THIRTY FIVE')
/
insert into lookup values
(36,'THIRTY SIX')
/
insert into lookup values
(37,'THIRTY SEVEN')
/
insert into lookup values
(38,'THIRTY EIGHT')
/
insert into lookup values
(39,'THIRTY NINE')
/
insert into lookup values
(40,'FOURTY')
/
insert into lookup values
(41,'FOURTY ONE')
/
insert into lookup values
(42,'FOURTY TWO')
/
insert into lookup values
(43,'FOURTY THREE')
/
insert into lookup values
(44,'FOURTY FOUR')
/
insert into lookup values
(45,'FOURTY FIVE')
/
insert into lookup values
(46,'FOURTY SIX')
/
insert into lookup values
(47,'FOURTY SEVEN')
/
insert into lookup values
(48,'FOURTY EIGHT')
/
insert into lookup values
(49,'FOURTY NINE')
/
insert into lookup values
(50,'FIFTY')
/
insert into lookup values
(51,'FIFTY ONE')
/
insert into lookup values
(52,'FIFTY TWO')
/
insert into lookup values
(53,'FIFTY THREE')
/
insert into lookup values
(54,'FIFTY FOUR')
/
insert into lookup values
(55,'FIFTY FIVE')
/
insert into lookup values
(56,'FIFTY SIX')
/
insert into lookup values
(57,'FIFTY SEVEN')
/
insert into lookup values
(58,'FIFTY EIGHT')
/
insert into lookup values
(59,'FIFTY NINE')
/
insert into lookup values
(60,'SIXTY')
/
insert into lookup values
(61,'SIXTY ONE')
/
insert into lookup values
(62,'SIXTY TWO')
/
insert into lookup values
(63,'SIXTY THREE')
/
insert into lookup values
(64,'SIXTY FOUR')
/
insert into lookup values
(65,'SIXTY FIVE')
/
insert into lookup values
(66,'SIXTY SIX')
/
insert into lookup values
(67,'SIXTY SEVEN')
/
insert into lookup values
(68,'SIXTY EIGHT')
/
insert into lookup values
(69,'SIXTY NINE')
/
insert into lookup values
(70,'SEVENTY')
/
insert into lookup values
(71,'SEVENTY ONE')
/
insert into lookup values
(72,'SEVENTY TWO')
/
insert into lookup values
(73,'SEVENTY THREE')
/
insert into lookup values
(74,'SEVENTY FOUR')
/
insert into lookup values
(75,'SEVENTY FIVE')
/
insert into lookup values
(76,'SEVENTY SIX')
/
insert into lookup values
(77,'SEVENTY SEVEN')
/
insert into lookup values
(78,'SEVENTY EIGHT')
/
insert into lookup values
(79,'SEVENTY NINE')
/
insert into lookup values
(80,'EIGHTY')
/
insert into lookup values
(81,'EIGHTY ONE')
/
insert into lookup values
(82,'EIGHTY TWO')
/
insert into lookup values
(83,'EIGHTY THREE')
/
insert into lookup values
(84,'EIGHTY FOUR')
/
insert into lookup values
(85,'EIGHTY FIVE')
/
insert into lookup values
(86,'EIGHTY SIX')
/
insert into lookup values
(87,'EIGHTY SEVEN')
/
insert into lookup values
(88,'EIGHTY EIGHT')
/
insert into lookup values
(89,'EIGHTY NINE')
/
insert into lookup values
(90,'NINETY')
/
insert into lookup values
(91,'NINETY ONE')
/
insert into lookup values
(92,'NINETY TWO')
/
insert into lookup values
(93,'NINETY THREE')
/
insert into lookup values
(94,'NINETY FOUR')
/
insert into lookup values
(95,'NINETY FIVE')
/
insert into lookup values
(96,'NINETY SIX')
/
insert into lookup values
(97,'NINETY SEVEN')
/
insert into lookup values
(98,'NINETY EIGHT')
/
insert into lookup values
(99,'NINETY NINE')
/
insert into lookup values
(100, 'ONE HUNDRED')
/
insert into lookup values
(101, 'ONE HUNDRED ONE')
/
insert into lookup values
(102,'ONE HUNDRED TWO')
/
insert into lookup values
(103,'ONE HUNDRED THREE')
/
insert into lookup values
(104,'ONE HUNDRED FOUR')
/
insert into lookup values
(105,'ONE HUNDRED FIVE')
/
insert into lookup values
(106,'ONE HUNDRED SIX')
/
insert into lookup values
(107,'ONE HUNDRED SEVEN')
/
insert into lookup values
(108,'ONE HUNDRED EIGHT')
/
insert into lookup values
(109,'ONE HUNDRED NINE')
/
insert into lookup values
(110,'ONE HUNDRED TEN')
/
insert into lookup values
(111,'ONE HUNDRED ELEVEN')
/
insert into lookup values
(112,'ONE HUNDRED TWELVE')
/
insert into lookup values
(113,'ONE HUNDRED THIRTEEN')
/
insert into lookup values
(114,'ONE HUNDRED FOURTEEN')
/
insert into lookup values
(115,'ONE HUNDRED FIFTEEN')
/
insert into lookup values
(116,'ONE HUNDRED SIXTEEN')
/
insert into lookup values
(117,'ONE HUNDRED SEVENTEEN')
/
insert into lookup values
(118,'ONE HUNDRED EIGHTEEN')
/
insert into lookup values
(119,'ONE HUNDRED NINETEEN')
/
insert into lookup values
(120,'ONE HUNDRED TWENTY')
/
insert into lookup values
(121,'ONE HUNDRED TWENTY ONE')
/
insert into lookup values
(122,'ONE HUNDRED TWENTY TWO')
/
insert into lookup values
(123,'ONE HUNDRED TWENTY THREE')
/
insert into lookup values
(124,'ONE HUNDRED TWENTY FOUR')
/
insert into lookup values
(125,'ONE HUNDRED TWENTY FIVE')
/
insert into lookup values
(126,'ONE HUNDRED TWENTY SIX')
/
insert into lookup values
(127,'ONE HUNDRED TWENTY SEVEN')
/
insert into lookup values
(128,'ONE HUNDRED TWENTY EIGHT')
/
insert into lookup values
(129,'ONE HUNDRED TWENTY NINE')
/
insert into lookup values
(130,'ONE HUNDRED THIRTY')
/
insert into lookup values
(131,'ONE HUNDRED THIRTY ONE')
/
insert into lookup values
(132,'ONE HUNDRED THIRTY TWO')
/
insert into lookup values
(133,'ONE HUNDRED THIRTY THREE')
/
insert into lookup values
(134,'ONE HUNDRED THIRTY FOUR')
/
insert into lookup values
(135,'ONE HUNDRED THIRTY FIVE')
/
insert into lookup values
(136,'ONE HUNDRED THIRTY SIX')
/
insert into lookup values
(137,'ONE HUNDRED THIRTY SEVEN')
/
insert into lookup values
(138,'ONE HUNDRED THIRTY EIGHT')
/
insert into lookup values
(139,'ONE HUNDRED THIRTY NINE')
/
insert into lookup values
(140,'ONE HUNDRED FOURTY')
/
insert into lookup values
(141,'ONE HUNDRED FOURTY ONE')
/
insert into lookup values
(142,'ONE HUNDRED FOURTY TWO')
/
insert into lookup values
(143,'ONE HUNDRED FOURTY THREE')
/
insert into lookup values
(144,'ONE HUNDRED FOURTY FOUR')
/
insert into lookup values
(145,'ONE HUNDRED FOURTY FIVE')
/
insert into lookup values
(146,'ONE HUNDRED FOURTY SIX')
/
insert into lookup values
(147,'ONE HUNDRED FOURTY SEVEN')
/
insert into lookup values
(148,'ONE HUNDRED FOURTY EIGHT')
/
insert into lookup values
(149,'ONE HUNDRED FOURTY NINE')
/
insert into lookup values
(150,'ONE HUNDRED FIFTY')
/
insert into lookup values
(151,'ONE HUNDRED FIFTY ONE')
/
insert into lookup values
(152,'ONE HUNDRED FIFTY TWO')
/
insert into lookup values
(153,'ONE HUNDRED FIFTY THREE')
/
insert into lookup values
(154,'ONE HUNDRED FIFTY FOUR')
/
insert into lookup values
(155,'ONE HUNDRED FIFTY FIVE')
/
insert into lookup values
(156,'ONE HUNDRED FIFTY SIX')
/
insert into lookup values
(157,'ONE HUNDRED FIFTY SEVEN')
/
insert into lookup values
(158,'ONE HUNDRED FIFTY EIGHT')
/
insert into lookup values
(159,'ONE HUNDRED FIFTY NINE')
/
insert into lookup values
(160,'ONE HUNDRED SIXTY')
/
insert into lookup values
(161,'ONE HUNDRED SIXTY ONE')
/
insert into lookup values
(162,'ONE HUNDRED SIXTY TWO')
/
insert into lookup values
(163,'ONE HUNDRED SIXTY THREE')
/
insert into lookup values
(164,'ONE HUNDRED SIXTY FOUR')
/
insert into lookup values
(165,'ONE HUNDRED SIXTY FIVE')
/
insert into lookup values
(166,'ONE HUNDRED SIXTY SIX')
/
insert into lookup values
(167,'ONE HUNDRED SIXTY SEVEN')
/
insert into lookup values
(168,'ONE HUNDRED SIXTY EIGHT')
/
insert into lookup values
(169,'ONE HUNDRED SIXTY NINE')
/
insert into lookup values
(170,'ONE HUNDRED SEVENTY')
/
insert into lookup values
(171,'ONE HUNDRED SEVENTY ONE')
/
insert into lookup values
(172,'ONE HUNDRED SEVENTY TWO')
/
insert into lookup values
(173,'ONE HUNDRED SEVENTY THREE')
/
insert into lookup values
(174,'ONE HUNDRED SEVENTY FOUR')
/
insert into lookup values
(175,'ONE HUNDRED SEVENTY FIVE')
/
insert into lookup values
(176,'ONE HUNDRED SEVENTY SIX')
/
insert into lookup values
(177,'ONE HUNDRED SEVENTY SEVEN')
/
insert into lookup values
(178,'ONE HUNDRED SEVENTY EIGHT')
/
insert into lookup values
(179,'ONE HUNDRED SEVENTY NINE')
/
insert into lookup values
(180,'ONE HUNDRED EIGHTY')
/
insert into lookup values
(181,'ONE HUNDRED EIGHTY ONE')
/
insert into lookup values
(182,'ONE HUNDRED EIGHTY TWO')
/
insert into lookup values
(183,'ONE HUNDRED EIGHTY THREE')
/
insert into lookup values
(184,'ONE HUNDRED EIGHTY FOUR')
/
insert into lookup values
(185,'ONE HUNDRED EIGHTY FIVE')
/
insert into lookup values
(186,'ONE HUNDRED EIGHTY SIX')
/
insert into lookup values
(187,'ONE HUNDRED EIGHTY SEVEN')
/
insert into lookup values
(188,'ONE HUNDRED EIGHTY EIGHT')
/
insert into lookup values
(189,'ONE HUNDRED EIGHTY NINE')
/
insert into lookup values
(190,'ONE HUNDRED NINETY')
/
insert into lookup values
(191,'ONE HUNDRED NINETY ONE')
/
insert into lookup values
(192,'ONE HUNDRED NINETY TWO')
/
insert into lookup values
(193,'ONE HUNDRED NINETY THREE')
/
insert into lookup values
(194,'ONE HUNDRED NINETY FOUR')
/
insert into lookup values
(195,'ONE HUNDRED NINETY FIVE')
/
insert into lookup values
(196,'ONE HUNDRED NINETY SIX')
/
insert into lookup values
(197,'ONE HUNDRED NINETY SEVEN')
/
insert into lookup values
(198,'ONE HUNDRED NINETY EIGHT')
/
insert into lookup values
(199,'ONE HUNDRED NINETY NINE')
/
insert into lookup values
(200,'TWO HUNDRED')
/
insert into lookup values
(201, 'TWO HUNDRED ONE')
/
insert into lookup values
(202,'TWO HUNDRED TWO')
/
insert into lookup values
(203,'TWO HUNDRED THREE')
/
insert into lookup values
(204,'TWO HUNDRED FOUR')
/
insert into lookup values
(205,'TWO HUNDRED FIVE')
/
insert into lookup values
(206,'TWO HUNDRED SIX')
/
insert into lookup values
(207,'TWO HUNDRED SEVEN')
/
insert into lookup values
(208,'TWO HUNDRED EIGHT')
/
insert into lookup values
(209,'TWO HUNDRED NINE')
/
insert into lookup values
(210,'TWO HUNDRED TEN')
/
insert into lookup values
(211,'TWO HUNDRED ELEVEN')
/
insert into lookup values
(212,'TWO HUNDRED TWELVE')
/
insert into lookup values
(213,'TWO HUNDRED THIRTEEN')
/
insert into lookup values
(214,'TWO HUNDRED FOURTEEN')
/
insert into lookup values
(215,'TWO HUNDRED FIFTEEN')
/
insert into lookup values
(216,'TWO HUNDRED SIXTEEN')
/
insert into lookup values
(217,'TWO HUNDRED SEVENTEEN')
/
insert into lookup values
(218,'TWO HUNDRED EIGHTEEN')
/
insert into lookup values
(219,'TWO HUNDRED NINETEEN')
/
insert into lookup values
(220,'TWO HUNDRED TWENTY')
/
insert into lookup values
(221,'TWO HUNDRED TWENTY ONE')
/
insert into lookup values
(222,'TWO HUNDRED TWENTY TWO')
/
insert into lookup values
(223,'TWO HUNDRED TWENTY THREE')
/
insert into lookup values
(224,'TWO HUNDRED TWENTY FOUR')
/
insert into lookup values
(225,'TWO HUNDRED TWENTY FIVE')
/
insert into lookup values
(226,'TWO HUNDRED TWENTY SIX')
/
insert into lookup values
(227,'TWO HUNDRED TWENTY SEVEN')
/
insert into lookup values
(228,'TWO HUNDRED TWENTY EIGHT')
/
insert into lookup values
(229,'TWO HUNDRED TWENTY NINE')
/
insert into lookup values
(230,'TWO HUNDRED THIRTY')
/
insert into lookup values
(231,'TWO HUNDRED THIRTY ONE')
/
insert into lookup values
(232,'TWO HUNDRED THIRTY TWO')
/
insert into lookup values
(233,'TWO HUNDRED THIRTY THREE')
/
insert into lookup values
(234,'TWO HUNDRED THIRTY FOUR')
/
insert into lookup values
(235,'TWO HUNDRED THIRTY FIVE')
/
insert into lookup values
(236,'TWO HUNDRED THIRTY SIX')
/
insert into lookup values
(237,'TWO HUNDRED THIRTY SEVEN')
/
insert into lookup values
(238,'TWO HUNDRED THIRTY EIGHT')
/
insert into lookup values
(239,'TWO HUNDRED THIRTY NINE')
/
insert into lookup values
(240,'TWO HUNDRED FOURTY')
/
insert into lookup values
(241,'TWO HUNDRED FOURTY ONE')
/
insert into lookup values
(242,'TWO HUNDRED FOURTY TWO')
/
insert into lookup values
(243,'TWO HUNDRED FOURTY THREE')
/
insert into lookup values
(244,'TWO HUNDRED FOURTY FOUR')
/
insert into lookup values
(245,'TWO HUNDRED FOURTY FIVE')
/
insert into lookup values
(246,'TWO HUNDRED FOURTY SIX')
/
insert into lookup values
(247,'TWO HUNDRED FOURTY SEVEN')
/
insert into lookup values
(248,'TWO HUNDRED FOURTY EIGHT')
/
insert into lookup values
(249,'TWO HUNDRED FOURTY NINE')
/
insert into lookup values
(250,'TWO HUNDRED FIFTY')
/
insert into lookup values
(251,'TWO HUNDRED FIFTY ONE')
/
insert into lookup values
(252,'TWO HUNDRED FIFTY TWO')
/
insert into lookup values
(253,'TWO HUNDRED FIFTY THREE')
/
insert into lookup values
(254,'TWO HUNDRED FIFTY FOUR')
/
insert into lookup values
(255,'TWO HUNDRED FIFTY FIVE')
/
insert into lookup values
(256,'TWO HUNDRED FIFTY SIX')
/
insert into lookup values
(257,'TWO HUNDRED FIFTY SEVEN')
/
insert into lookup values
(258,'TWO HUNDRED FIFTY EIGHT')
/
insert into lookup values
(259,'TWO HUNDRED FIFTY NINE')
/
insert into lookup values
(260,'TWO HUNDRED SIXTY')
/
insert into lookup values
(261,'TWO HUNDRED SIXTY ONE')
/
insert into lookup values
(262,'TWO HUNDRED SIXTY TWO')
/
insert into lookup values
(263,'TWO HUNDRED SIXTY THREE')
/
insert into lookup values
(264,'TWO HUNDRED SIXTY FOUR')
/
insert into lookup values
(265,'TWO HUNDRED SIXTY FIVE')
/
insert into lookup values
(266,'TWO HUNDRED SIXTY SIX')
/
insert into lookup values
(267,'TWO HUNDRED SIXTY SEVEN')
/
insert into lookup values
(268,'TWO HUNDRED SIXTY EIGHT')
/
insert into lookup values
(269,'TWO HUNDRED SIXTY NINE')
/
insert into lookup values
(270,'TWO HUNDRED SEVENTY')
/
insert into lookup values
(271,'TWO HUNDRED SEVENTY ONE')
/
insert into lookup values
(272,'TWO HUNDRED SEVENTY TWO')
/
insert into lookup values
(273,'TWO HUNDRED SEVENTY THREE')
/
insert into lookup values
(274,'TWO HUNDRED SEVENTY FOUR')
/
insert into lookup values
(275,'TWO HUNDRED SEVENTY FIVE')
/
insert into lookup values
(276,'TWO HUNDRED SEVENTY SIX')
/
insert into lookup values
(277,'TWO HUNDRED SEVENTY SEVEN')
/
insert into lookup values
(278,'TWO HUNDRED SEVENTY EIGHT')
/
insert into lookup values
(279,'TWO HUNDRED SEVENTY NINE')
/
insert into lookup values
(280,'TWO HUNDRED EIGHTY')
/
insert into lookup values
(281,'TWO HUNDRED EIGHTY ONE')
/
insert into lookup values
(282,'TWO HUNDRED EIGHTY TWO')
/
insert into lookup values
(283,'TWO HUNDRED EIGHTY THREE')
/
insert into lookup values
(284,'TWO HUNDRED EIGHTY FOUR')
/
insert into lookup values
(285,'TWO HUNDRED EIGHTY FIVE')
/
insert into lookup values
(286,'TWO HUNDRED EIGHTY SIX')
/
insert into lookup values
(287,'TWO HUNDRED EIGHTY SEVEN')
/
insert into lookup values
(288,'TWO HUNDRED EIGHTY EIGHT')
/
insert into lookup values
(289,'TWO HUNDRED EIGHTY NINE')
/
insert into lookup values
(290,'TWO HUNDRED NINETY')
/
insert into lookup values
(291,'TWO HUNDRED NINETY ONE')
/
insert into lookup values
(292,'TWO HUNDRED NINETY TWO')
/
insert into lookup values
(293,'TWO HUNDRED NINETY THREE')
/
insert into lookup values
(294,'TWO HUNDRED NINETY FOUR')
/
insert into lookup values
(295,'TWO HUNDRED NINETY FIVE')
/
insert into lookup values
(296,'TWO HUNDRED NINETY SIX')
/
insert into lookup values
(297,'TWO HUNDRED NINETY SEVEN')
/
insert into lookup values
(298,'TWO HUNDRED NINETY EIGHT')
/
insert into lookup values
(299,'TWO HUNDRED NINETY NINE')
/
insert into lookup values
(300, 'THREE HUNDRED')
/
insert into lookup values
(301, 'THREE HUNDRED ONE')
/
insert into lookup values
(302,'THREE HUNDRED TWO')
/
insert into lookup values
(303,'THREE HUNDRED THREE')
/
insert into lookup values
(304,'THREE HUNDRED FOUR')
/
insert into lookup values
(305,'THREE HUNDRED FIVE')
/
insert into lookup values
(306,'THREE HUNDRED SIX')
/
insert into lookup values
(307,'THREE HUNDRED SEVEN')
/
insert into lookup values
(308,'THREE HUNDRED EIGHT')
/
insert into lookup values
(309,'THREE HUNDRED NINE')
/
insert into lookup values
(310,'THREE HUNDRED TEN')
/
insert into lookup values
(311,'THREE HUNDRED ELEVEN')
/
insert into lookup values
(312,'THREE HUNDRED TWELVE')
/
insert into lookup values
(313,'THREE HUNDRED THIRTEEN')
/
insert into lookup values
(314,'THREE HUNDRED FOURTEEN')
/
insert into lookup values
(315,'THREE HUNDRED FIFTEEN')
/
insert into lookup values
(316,'THREE HUNDRED SIXTEEN')
/
insert into lookup values
(317,'THREE HUNDRED SEVENTEEN')
/
insert into lookup values
(318,'THREE HUNDRED EIGHTEEN')
/
insert into lookup values
(319,'THREE HUNDRED NINETEEN')
/
insert into lookup values
(320,'THREE HUNDRED TWENTY')
/
insert into lookup values
(321,'THREE HUNDRED TWENTY ONE')
/
insert into lookup values
(322,'THREE HUNDRED TWENTY TWO')
/
insert into lookup values
(323,'THREE HUNDRED TWENTY THREE')
/
insert into lookup values
(324,'THREE HUNDRED TWENTY FOUR')
/
insert into lookup values
(325,'THREE HUNDRED TWENTY FIVE')
/
insert into lookup values
(326,'THREE HUNDRED TWENTY SIX')
/
insert into lookup values
(327,'THREE HUNDRED TWENTY SEVEN')
/
insert into lookup values
(328,'THREE HUNDRED TWENTY EIGHT')
/
insert into lookup values
(329,'THREE HUNDRED TWENTY NINE')
/
insert into lookup values
(330,'THREE HUNDRED THIRTY')
/
insert into lookup values
(331,'THREE HUNDRED THIRTY ONE')
/
insert into lookup values
(332,'THREE HUNDRED THIRTY TWO')
/
insert into lookup values
(333,'THREE HUNDRED THIRTY THREE')
/
insert into lookup values
(334,'THREE HUNDRED THIRTY FOUR')
/
insert into lookup values
(335,'THREE HUNDRED THIRTY FIVE')
/
insert into lookup values
(336,'THREE HUNDRED THIRTY SIX')
/
insert into lookup values
(337,'THREE HUNDRED THIRTY SEVEN')
/
insert into lookup values
(338,'THREE HUNDRED THIRTY EIGHT')
/
insert into lookup values
(339,'THREE HUNDRED THIRTY NINE')
/
insert into lookup values
(340,'THREE HUNDRED FOURTY')
/
insert into lookup values
(341,'THREE HUNDRED FOURTY ONE')
/
insert into lookup values
(342,'THREE HUNDRED FOURTY TWO')
/
insert into lookup values
(343,'THREE HUNDRED FOURTY THREE')
/
insert into lookup values
(344,'THREE HUNDRED FOURTY FOUR')
/
insert into lookup values
(345,'THREE HUNDRED FOURTY FIVE')
/
insert into lookup values
(346,'THREE HUNDRED FOURTY SIX')
/
insert into lookup values
(347,'THREE HUNDRED FOURTY SEVEN')
/
insert into lookup values
(348,'THREE HUNDRED FOURTY EIGHT')
/
insert into lookup values
(349,'THREE HUNDRED FOURTY NINE')
/
insert into lookup values
(350,'THREE HUNDRED FIFTY')
/
insert into lookup values
(351,'THREE HUNDRED FIFTY ONE')
/
insert into lookup values
(352,'THREE HUNDRED FIFTY TWO')
/
insert into lookup values
(353,'THREE HUNDRED FIFTY THREE')
/
insert into lookup values
(354,'THREE HUNDRED FIFTY FOUR')
/
insert into lookup values
(355,'THREE HUNDRED FIFTY FIVE')
/
insert into lookup values
(356,'THREE HUNDRED FIFTY SIX')
/
insert into lookup values
(357,'THREE HUNDRED FIFTY SEVEN')
/
insert into lookup values
(358,'THREE HUNDRED FIFTY EIGHT')
/
insert into lookup values
(359,'THREE HUNDRED FIFTY NINE')
/
insert into lookup values
(360,'THREE HUNDRED SIXTY')
/
insert into lookup values
(361,'THREE HUNDRED SIXTY ONE')
/
insert into lookup values
(362,'THREE HUNDRED SIXTY TWO')
/
insert into lookup values
(363,'THREE HUNDRED SIXTY THREE')
/
insert into lookup values
(364,'THREE HUNDRED SIXTY FOUR')
/
insert into lookup values
(365,'THREE HUNDRED SIXTY FIVE')
/
insert into lookup values
(366,'THREE HUNDRED SIXTY SIX')
/
insert into lookup values
(367,'THREE HUNDRED SIXTY SEVEN')
/
insert into lookup values
(368,'THREE HUNDRED SIXTY EIGHT')
/
insert into lookup values
(369,'THREE HUNDRED SIXTY NINE')
/
insert into lookup values
(370,'THREE HUNDRED SEVENTY')
/
insert into lookup values
(371,'THREE HUNDRED SEVENTY ONE')
/
insert into lookup values
(372,'THREE HUNDRED SEVENTY TWO')
/
insert into lookup values
(373,'THREE HUNDRED SEVENTY THREE')
/
insert into lookup values
(374,'THREE HUNDRED SEVENTY FOUR')
/
insert into lookup values
(375,'THREE HUNDRED SEVENTY FIVE')
/
insert into lookup values
(376,'THREE HUNDRED SEVENTY SIX')
/
insert into lookup values
(377,'THREE HUNDRED SEVENTY SEVEN')
/
insert into lookup values
(378,'THREE HUNDRED SEVENTY EIGHT')
/
insert into lookup values
(379,'THREE HUNDRED SEVENTY NINE')
/
insert into lookup values
(380,'THREE HUNDRED EIGHTY')
/
insert into lookup values
(381,'THREE HUNDRED EIGHTY ONE')
/
insert into lookup values
(382,'THREE HUNDRED EIGHTY TWO')
/
insert into lookup values
(383,'THREE HUNDRED EIGHTY THREE')
/
insert into lookup values
(384,'THREE HUNDRED EIGHTY FOUR')
/
insert into lookup values
(385,'THREE HUNDRED EIGHTY FIVE')
/
insert into lookup values
(386,'THREE HUNDRED EIGHTY SIX')
/
insert into lookup values
(387,'THREE HUNDRED EIGHTY SEVEN')
/
insert into lookup values
(388,'THREE HUNDRED EIGHTY EIGHT')
/
insert into lookup values
(389,'THREE HUNDRED EIGHTY NINE')
/
insert into lookup values
(390,'THREE HUNDRED NINETY')
/
insert into lookup values
(391,'THREE HUNDRED NINETY ONE')
/
insert into lookup values
(392,'THREE HUNDRED NINETY TWO')
/
insert into lookup values
(393,'THREE HUNDRED NINETY THREE')
/
insert into lookup values
(394,'THREE HUNDRED NINETY FOUR')
/
insert into lookup values
(395,'THREE HUNDRED NINETY FIVE')
/
insert into lookup values
(396,'THREE HUNDRED NINETY SIX')
/
insert into lookup values
(397,'THREE HUNDRED NINETY SEVEN')
/
insert into lookup values
(398,'THREE HUNDRED NINETY EIGHT')
/
insert into lookup values
(399,'THREE HUNDRED NINETY NINE')
/
insert into lookup values
(400, 'FOUR HUNDRED')
/
insert into lookup values
(401, 'FOUR HUNDRED ONE')
/
insert into lookup values
(402,'FOUR HUNDRED TWO')
/
insert into lookup values
(403,'FOUR HUNDRED THREE')
/
insert into lookup values
(404,'FOUR HUNDRED FOUR')
/
insert into lookup values
(405,'FOUR HUNDRED FIVE')
/
insert into lookup values
(406,'FOUR HUNDRED SIX')
/
insert into lookup values
(407,'FOUR HUNDRED SEVEN')
/
insert into lookup values
(408,'FOUR HUNDRED EIGHT')
/
insert into lookup values
(409,'FOUR HUNDRED NINE')
/
insert into lookup values
(410,'FOUR HUNDRED TEN')
/
insert into lookup values
(411,'FOUR HUNDRED ELEVEN')
/
insert into lookup values
(412,'FOUR HUNDRED TWELVE')
/
insert into lookup values
(413,'FOUR HUNDRED THIRTEEN')
/
insert into lookup values
(414,'FOUR HUNDRED FOURTEEN')
/
insert into lookup values
(415,'FOUR HUNDRED FIFTEEN')
/
insert into lookup values
(416,'FOUR HUNDRED SIXTEEN')
/
insert into lookup values
(417,'FOUR HUNDRED SEVENTEEN')
/
insert into lookup values
(418,'FOUR HUNDRED EIGHTEEN')
/
insert into lookup values
(419,'FOUR HUNDRED NINETEEN')
/
insert into lookup values
(420,'FOUR HUNDRED TWENTY')
/
insert into lookup values
(421,'FOUR HUNDRED TWENTY ONE')
/
insert into lookup values
(422,'FOUR HUNDRED TWENTY TWO')
/
insert into lookup values
(423,'FOUR HUNDRED TWENTY THREE')
/
insert into lookup values
(424,'FOUR HUNDRED TWENTY FOUR')
/
insert into lookup values
(425,'FOUR HUNDRED TWENTY FIVE')
/
insert into lookup values
(426,'FOUR HUNDRED TWENTY SIX')
/
insert into lookup values
(427,'FOUR HUNDRED TWENTY SEVEN')
/
insert into lookup values
(428,'FOUR HUNDRED TWENTY EIGHT')
/
insert into lookup values
(429,'FOUR HUNDRED TWENTY NINE')
/
insert into lookup values
(430,'FOUR HUNDRED THIRTY')
/
insert into lookup values
(431,'FOUR HUNDRED THIRTY ONE')
/
insert into lookup values
(432,'FOUR HUNDRED THIRTY TWO')
/
insert into lookup values
(433,'FOUR HUNDRED THIRTY THREE')
/
insert into lookup values
(434,'FOUR HUNDRED THIRTY FOUR')
/
insert into lookup values
(435,'FOUR HUNDRED THIRTY FIVE')
/
insert into lookup values
(436,'FOUR HUNDRED THIRTY SIX')
/
insert into lookup values
(437,'FOUR HUNDRED THIRTY SEVEN')
/
insert into lookup values
(438,'FOUR HUNDRED THIRTY EIGHT')
/
insert into lookup values
(439,'FOUR HUNDRED THIRTY NINE')
/
insert into lookup values
(440,'FOUR HUNDRED FOURTY')
/
insert into lookup values
(441,'FOUR HUNDRED FOURTY ONE')
/
insert into lookup values
(442,'FOUR HUNDRED FOURTY TWO')
/
insert into lookup values
(443,'FOUR HUNDRED FOURTY THREE')
/
insert into lookup values
(444,'FOUR HUNDRED FOURTY FOUR')
/
insert into lookup values
(445,'FOUR HUNDRED FOURTY FIVE')
/
insert into lookup values
(446,'FOUR HUNDRED FOURTY SIX')
/
insert into lookup values
(447,'FOUR HUNDRED FOURTY SEVEN')
/
insert into lookup values
(448,'FOUR HUNDRED FOURTY EIGHT')
/
insert into lookup values
(449,'FOUR HUNDRED FOURTY NINE')
/
insert into lookup values
(450,'FOUR HUNDRED FIFTY')
/
insert into lookup values
(451,'FOUR HUNDRED FIFTY ONE')
/
insert into lookup values
(452,'FOUR HUNDRED FIFTY TWO')
/
insert into lookup values
(453,'FOUR HUNDRED FIFTY THREE')
/
insert into lookup values
(454,'FOUR HUNDRED FIFTY FOUR')
/
insert into lookup values
(455,'FOUR HUNDRED FIFTY FIVE')
/
insert into lookup values
(456,'FOUR HUNDRED FIFTY SIX')
/
insert into lookup values
(457,'FOUR HUNDRED FIFTY SEVEN')
/
insert into lookup values
(458,'FOUR HUNDRED FIFTY EIGHT')
/
insert into lookup values
(459,'FOUR HUNDRED FIFTY NINE')
/
insert into lookup values
(460,'FOUR HUNDRED SIXTY')
/
insert into lookup values
(461,'FOUR HUNDRED SIXTY ONE')
/
insert into lookup values
(462,'FOUR HUNDRED SIXTY TWO')
/
insert into lookup values
(463,'FOUR HUNDRED SIXTY THREE')
/
insert into lookup values
(464,'FOUR HUNDRED SIXTY FOUR')
/
insert into lookup values
(465,'FOUR HUNDRED SIXTY FIVE')
/
insert into lookup values
(466,'FOUR HUNDRED SIXTY SIX')
/
insert into lookup values
(467,'FOUR HUNDRED SIXTY SEVEN')
/
insert into lookup values
(468,'FOUR HUNDRED SIXTY EIGHT')
/
insert into lookup values
(469,'FOUR HUNDRED SIXTY NINE')
/
insert into lookup values
(470,'FOUR HUNDRED SEVENTY')
/
insert into lookup values
(471,'FOUR HUNDRED SEVENTY ONE')
/
insert into lookup values
(472,'FOUR HUNDRED SEVENTY TWO')
/
insert into lookup values
(473,'FOUR HUNDRED SEVENTY THREE')
/
insert into lookup values
(474,'FOUR HUNDRED SEVENTY FOUR')
/
insert into lookup values
(475,'FOUR HUNDRED SEVENTY FIVE')
/
insert into lookup values
(476,'FOUR HUNDRED SEVENTY SIX')
/
insert into lookup values
(477,'FOUR HUNDRED SEVENTY SEVEN')
/
insert into lookup values
(478,'FOUR HUNDRED SEVENTY EIGHT')
/
insert into lookup values
(479,'FOUR HUNDRED SEVENTY NINE')
/
insert into lookup values
(480,'FOUR HUNDRED EIGHTY')
/
insert into lookup values
(481,'FOUR HUNDRED EIGHTY ONE')
/
insert into lookup values
(482,'FOUR HUNDRED EIGHTY TWO')
/
insert into lookup values
(483,'FOUR HUNDRED EIGHTY THREE')
/
insert into lookup values
(484,'FOUR HUNDRED EIGHTY FOUR')
/
insert into lookup values
(485,'FOUR HUNDRED EIGHTY FIVE')
/
insert into lookup values
(486,'FOUR HUNDRED EIGHTY SIX')
/
insert into lookup values
(487,'FOUR HUNDRED EIGHTY SEVEN')
/
insert into lookup values
(488,'FOUR HUNDRED EIGHTY EIGHT')
/
insert into lookup values
(489,'FOUR HUNDRED EIGHTY NINE')
/
insert into lookup values
(490,'FOUR HUNDRED NINETY')
/
insert into lookup values
(491,'FOUR HUNDRED NINETY ONE')
/
insert into lookup values
(492,'FOUR HUNDRED NINETY TWO')
/
insert into lookup values
(493,'FOUR HUNDRED NINETY THREE')
/
insert into lookup values
(494,'FOUR HUNDRED NINETY FOUR')
/
insert into lookup values
(495,'FOUR HUNDRED NINETY FIVE')
/
insert into lookup values
(496,'FOUR HUNDRED NINETY SIX')
/
insert into lookup values
(497,'FOUR HUNDRED NINETY SEVEN')
/
insert into lookup values
(498,'FOUR HUNDRED NINETY EIGHT')
/
insert into lookup values
(499,'FOUR HUNDRED NINETY NINE')
/
insert into lookup values
(500,'FIVE HUNDRED')
/
insert into lookup values
(501, 'FIVE HUNDRED ONE')
/
insert into lookup values
(502,'FIVE HUNDRED TWO')
/
insert into lookup values
(503,'FIVE HUNDRED THREE')
/
insert into lookup values
(504,'FIVE HUNDRED FOUR')
/
insert into lookup values
(505,'FIVE HUNDRED FIVE')
/
insert into lookup values
(506,'FIVE HUNDRED SIX')
/
insert into lookup values
(507,'FIVE HUNDRED SEVEN')
/
insert into lookup values
(508,'FIVE HUNDRED EIGHT')
/
insert into lookup values
(509,'FIVE HUNDRED NINE')
/
insert into lookup values
(510,'FIVE HUNDRED TEN')
/
insert into lookup values
(511,'FIVE HUNDRED ELEVEN')
/
insert into lookup values
(512,'FIVE HUNDRED TWELVE')
/
insert into lookup values
(513,'FIVE HUNDRED THIRTEEN')
/
insert into lookup values
(514,'FIVE HUNDRED FOURTEEN')
/
insert into lookup values
(515,'FIVE HUNDRED FIFTEEN')
/
insert into lookup values
(516,'FIVE HUNDRED SIXTEEN')
/
insert into lookup values
(517,'FIVE HUNDRED SEVENTEEN')
/
insert into lookup values
(518,'FIVE HUNDRED EIGHTEEN')
/
insert into lookup values
(519,'FIVE HUNDRED NINETEEN')
/
insert into lookup values
(520,'FIVE HUNDRED TWENTY')
/
insert into lookup values
(521,'FIVE HUNDRED TWENTY ONE')
/
insert into lookup values
(522,'FIVE HUNDRED TWENTY TWO')
/
insert into lookup values
(523,'FIVE HUNDRED TWENTY THREE')
/
insert into lookup values
(524,'FIVE HUNDRED TWENTY FOUR')
/
insert into lookup values
(525,'FIVE HUNDRED TWENTY FIVE')
/
insert into lookup values
(526,'FIVE HUNDRED TWENTY SIX')
/
insert into lookup values
(527,'FIVE HUNDRED TWENTY SEVEN')
/
insert into lookup values
(528,'FIVE HUNDRED TWENTY EIGHT')
/
insert into lookup values
(529,'FIVE HUNDRED TWENTY NINE')
/
insert into lookup values
(530,'FIVE HUNDRED THIRTY')
/
insert into lookup values
(531,'FIVE HUNDRED THIRTY ONE')
/
insert into lookup values
(532,'FIVE HUNDRED THIRTY TWO')
/
insert into lookup values
(533,'FIVE HUNDRED THIRTY THREE')
/
insert into lookup values
(534,'FIVE HUNDRED THIRTY FOUR')
/
insert into lookup values
(535,'FIVE HUNDRED THIRTY FIVE')
/
insert into lookup values
(536,'FIVE HUNDRED THIRTY SIX')
/
insert into lookup values
(537,'FIVE HUNDRED THIRTY SEVEN')
/
insert into lookup values
(538,'FIVE HUNDRED THIRTY EIGHT')
/
insert into lookup values
(539,'FIVE HUNDRED THIRTY NINE')
/
insert into lookup values
(540,'FIVE HUNDRED FOURTY')
/
insert into lookup values
(541,'FIVE HUNDRED FOURTY ONE')
/
insert into lookup values
(542,'FIVE HUNDRED FOURTY TWO')
/
insert into lookup values
(543,'FIVE HUNDRED FOURTY THREE')
/
insert into lookup values
(544,'FIVE HUNDRED FOURTY FOUR')
/
insert into lookup values
(545,'FIVE HUNDRED FOURTY FIVE')
/
insert into lookup values
(546,'FIVE HUNDRED FOURTY SIX')
/
insert into lookup values
(547,'FIVE HUNDRED FOURTY SEVEN')
/
insert into lookup values
(548,'FIVE HUNDRED FOURTY EIGHT')
/
insert into lookup values
(549,'FIVE HUNDRED FOURTY NINE')
/
insert into lookup values
(550,'FIVE HUNDRED FIFTY')
/
insert into lookup values
(551,'FIVE HUNDRED FIFTY ONE')
/
insert into lookup values
(552,'FIVE HUNDRED FIFTY TWO')
/
insert into lookup values
(553,'FIVE HUNDRED FIFTY THREE')
/
insert into lookup values
(554,'FIVE HUNDRED FIFTY FOUR')
/
insert into lookup values
(555,'FIVE HUNDRED FIFTY FIVE')
/
insert into lookup values
(556,'FIVE HUNDRED FIFTY SIX')
/
insert into lookup values
(557,'FIVE HUNDRED FIFTY SEVEN')
/
insert into lookup values
(558,'FIVE HUNDRED FIFTY EIGHT')
/
insert into lookup values
(559,'FIVE HUNDRED FIFTY NINE')
/
insert into lookup values
(560,'FIVE HUNDRED SIXTY')
/
insert into lookup values
(561,'FIVE HUNDRED SIXTY ONE')
/
insert into lookup values
(562,'FIVE HUNDRED SIXTY TWO')
/
insert into lookup values
(563,'FIVE HUNDRED SIXTY THREE')
/
insert into lookup values
(564,'FIVE HUNDRED SIXTY FOUR')
/
insert into lookup values
(565,'FIVE HUNDRED SIXTY FIVE')
/
insert into lookup values
(566,'FIVE HUNDRED SIXTY SIX')
/
insert into lookup values
(567,'FIVE HUNDRED SIXTY SEVEN')
/
insert into lookup values
(568,'FIVE HUNDRED SIXTY EIGHT')
/
insert into lookup values
(569,'FIVE HUNDRED SIXTY NINE')
/
insert into lookup values
(570,'FIVE HUNDRED SEVENTY')
/
insert into lookup values
(571,'FIVE HUNDRED SEVENTY ONE')
/
insert into lookup values
(572,'FIVE HUNDRED SEVENTY TWO')
/
insert into lookup values
(573,'FIVE HUNDRED SEVENTY THREE')
/
insert into lookup values
(574,'FIVE HUNDRED SEVENTY FOUR')
/
insert into lookup values
(575,'FIVE HUNDRED SEVENTY FIVE')
/
insert into lookup values
(576,'FIVE HUNDRED SEVENTY SIX')
/
insert into lookup values
(577,'FIVE HUNDRED SEVENTY SEVEN')
/
insert into lookup values
(578,'FIVE HUNDRED SEVENTY EIGHT')
/
insert into lookup values
(579,'FIVE HUNDRED SEVENTY NINE')
/
insert into lookup values
(580,'FIVE HUNDRED EIGHTY')
/
insert into lookup values
(581,'FIVE HUNDRED EIGHTY ONE')
/
insert into lookup values
(582,'FIVE HUNDRED EIGHTY TWO')
/
insert into lookup values
(583,'FIVE HUNDRED EIGHTY THREE')
/
insert into lookup values
(584,'FIVE HUNDRED EIGHTY FOUR')
/
insert into lookup values
(585,'FIVE HUNDRED EIGHTY FIVE')
/
insert into lookup values
(586,'FIVE HUNDRED EIGHTY SIX')
/
insert into lookup values
(587,'FIVE HUNDRED EIGHTY SEVEN')
/
insert into lookup values
(588,'FIVE HUNDRED EIGHTY EIGHT')
/
insert into lookup values
(589,'FIVE HUNDRED EIGHTY NINE')
/
insert into lookup values
(590,'FIVE HUNDRED NINETY')
/
insert into lookup values
(591,'FIVE HUNDRED NINETY ONE')
/
insert into lookup values
(592,'FIVE HUNDRED NINETY TWO')
/
insert into lookup values
(593,'FIVE HUNDRED NINETY THREE')
/
insert into lookup values
(594,'FIVE HUNDRED NINETY FOUR')
/
insert into lookup values
(595,'FIVE HUNDRED NINETY FIVE')
/
insert into lookup values
(596,'FIVE HUNDRED NINETY SIX')
/
insert into lookup values
(597,'FIVE HUNDRED NINETY SEVEN')
/
insert into lookup values
(598,'FIVE HUNDRED NINETY EIGHT')
/
insert into lookup values
(599,'FIVE HUNDRED NINETY NINE')
/
insert into lookup values
(600, 'SIX HUNDRED')
/
insert into lookup values
(601, 'SIX HUNDRED ONE')
/
insert into lookup values
(602,'SIX HUNDRED TWO')
/
insert into lookup values
(603,'SIX HUNDRED THREE')
/
insert into lookup values
(604,'SIX HUNDRED FOUR')
/
insert into lookup values
(605,'SIX HUNDRED FIVE')
/
insert into lookup values
(606,'SIX HUNDRED SIX')
/
insert into lookup values
(607,'SIX HUNDRED SEVEN')
/
insert into lookup values
(608,'SIX HUNDRED EIGHT')
/
insert into lookup values
(609,'SIX HUNDRED NINE')
/
insert into lookup values
(610,'SIX HUNDRED TEN')
/
insert into lookup values
(611,'SIX HUNDRED ELEVEN')
/
insert into lookup values
(612,'SIX HUNDRED TWELVE')
/
insert into lookup values
(613,'SIX HUNDRED THIRTEEN')
/
insert into lookup values
(614,'SIX HUNDRED FOURTEEN')
/
insert into lookup values
(615,'SIX HUNDRED FIFTEEN')
/
insert into lookup values
(616,'SIX HUNDRED SIXTEEN')
/
insert into lookup values
(617,'SIX HUNDRED SEVENTEEN')
/
insert into lookup values
(618,'SIX HUNDRED EIGHTEEN')
/
insert into lookup values
(619,'SIX HUNDRED NINETEEN')
/
insert into lookup values
(620,'SIX HUNDRED TWENTY')
/
insert into lookup values
(621,'SIX HUNDRED TWENTY ONE')
/
insert into lookup values
(622,'SIX HUNDRED TWENTY TWO')
/
insert into lookup values
(623,'SIX HUNDRED TWENTY THREE')
/
insert into lookup values
(624,'SIX HUNDRED TWENTY FOUR')
/
insert into lookup values
(625,'SIX HUNDRED TWENTY FIVE')
/
insert into lookup values
(626,'SIX HUNDRED TWENTY SIX')
/
insert into lookup values
(627,'SIX HUNDRED TWENTY SEVEN')
/
insert into lookup values
(628,'SIX HUNDRED TWENTY EIGHT')
/
insert into lookup values
(629,'SIX HUNDRED TWENTY NINE')
/
insert into lookup values
(630,'SIX HUNDRED THIRTY')
/
insert into lookup values
(631,'SIX HUNDRED THIRTY ONE')
/
insert into lookup values
(632,'SIX HUNDRED THIRTY TWO')
/
insert into lookup values
(633,'SIX HUNDRED THIRTY THREE')
/
insert into lookup values
(634,'SIX HUNDRED THIRTY FOUR')
/
insert into lookup values
(635,'SIX HUNDRED THIRTY FIVE')
/
insert into lookup values
(636,'SIX HUNDRED THIRTY SIX')
/
insert into lookup values
(637,'SIX HUNDRED THIRTY SEVEN')
/
insert into lookup values
(638,'SIX HUNDRED THIRTY EIGHT')
/
insert into lookup values
(639,'SIX HUNDRED THIRTY NINE')
/
insert into lookup values
(640,'SIX HUNDRED FOURTY')
/
insert into lookup values
(641,'SIX HUNDRED FOURTY ONE')
/
insert into lookup values
(642,'SIX HUNDRED FOURTY TWO')
/
insert into lookup values
(643,'SIX HUNDRED FOURTY THREE')
/
insert into lookup values
(644,'SIX HUNDRED FOURTY FOUR')
/
insert into lookup values
(645,'SIX HUNDRED FOURTY FIVE')
/
insert into lookup values
(646,'SIX HUNDRED FOURTY SIX')
/
insert into lookup values
(647,'SIX HUNDRED FOURTY SEVEN')
/
insert into lookup values
(648,'SIX HUNDRED FOURTY EIGHT')
/
insert into lookup values
(649,'SIX HUNDRED FOURTY NINE')
/
insert into lookup values
(650,'SIX HUNDRED FIFTY')
/
insert into lookup values
(651,'SIX HUNDRED FIFTY ONE')
/
insert into lookup values
(652,'SIX HUNDRED FIFTY TWO')
/
insert into lookup values
(653,'SIX HUNDRED FIFTY THREE')
/
insert into lookup values
(654,'SIX HUNDRED FIFTY FOUR')
/
insert into lookup values
(655,'SIX HUNDRED FIFTY FIVE')
/
insert into lookup values
(656,'SIX HUNDRED FIFTY SIX')
/
insert into lookup values
(657,'SIX HUNDRED FIFTY SEVEN')
/
insert into lookup values
(658,'SIX HUNDRED FIFTY EIGHT')
/
insert into lookup values
(659,'SIX HUNDRED FIFTY NINE')
/
insert into lookup values
(660,'SIX HUNDRED SIXTY')
/
insert into lookup values
(661,'SIX HUNDRED SIXTY ONE')
/
insert into lookup values
(662,'SIX HUNDRED SIXTY TWO')
/
insert into lookup values
(663,'SIX HUNDRED SIXTY THREE')
/
insert into lookup values
(664,'SIX HUNDRED SIXTY FOUR')
/
insert into lookup values
(665,'SIX HUNDRED SIXTY FIVE')
/
insert into lookup values
(666,'SIX HUNDRED SIXTY SIX')
/
insert into lookup values
(667,'SIX HUNDRED SIXTY SEVEN')
/
insert into lookup values
(668,'SIX HUNDRED SIXTY EIGHT')
/
insert into lookup values
(669,'SIX HUNDRED SIXTY NINE')
/
insert into lookup values
(670,'SIX HUNDRED SEVENTY')
/
insert into lookup values
(671,'SIX HUNDRED SEVENTY ONE')
/
insert into lookup values
(672,'SIX HUNDRED SEVENTY TWO')
/
insert into lookup values
(673,'SIX HUNDRED SEVENTY THREE')
/
insert into lookup values
(674,'SIX HUNDRED SEVENTY FOUR')
/
insert into lookup values
(675,'SIX HUNDRED SEVENTY FIVE')
/
insert into lookup values
(676,'SIX HUNDRED SEVENTY SIX')
/
insert into lookup values
(677,'SIX HUNDRED SEVENTY SEVEN')
/
insert into lookup values
(678,'SIX HUNDRED SEVENTY EIGHT')
/
insert into lookup values
(679,'SIX HUNDRED SEVENTY NINE')
/
insert into lookup values
(680,'SIX HUNDRED EIGHTY')
/
insert into lookup values
(681,'SIX HUNDRED EIGHTY ONE')
/
insert into lookup values
(682,'SIX HUNDRED EIGHTY TWO')
/
insert into lookup values
(683,'SIX HUNDRED EIGHTY THREE')
/
insert into lookup values
(684,'SIX HUNDRED EIGHTY FOUR')
/
insert into lookup values
(685,'SIX HUNDRED EIGHTY FIVE')
/
insert into lookup values
(686,'SIX HUNDRED EIGHTY SIX')
/
insert into lookup values
(687,'SIX HUNDRED EIGHTY SEVEN')
/
insert into lookup values
(688,'SIX HUNDRED EIGHTY EIGHT')
/
insert into lookup values
(689,'SIX HUNDRED EIGHTY NINE')
/
insert into lookup values
(690,'SIX HUNDRED NINETY')
/
insert into lookup values
(691,'SIX HUNDRED NINETY ONE')
/
insert into lookup values
(692,'SIX HUNDRED NINETY TWO')
/
insert into lookup values
(693,'SIX HUNDRED NINETY THREE')
/
insert into lookup values
(694,'SIX HUNDRED NINETY FOUR')
/
insert into lookup values
(695,'SIX HUNDRED NINETY FIVE')
/
insert into lookup values
(696,'SIX HUNDRED NINETY SIX')
/
insert into lookup values
(697,'SIX HUNDRED NINETY SEVEN')
/
insert into lookup values
(698,'SIX HUNDRED NINETY EIGHT')
/
insert into lookup values
(699,'SIX HUNDRED NINETY NINE')
/
insert into lookup values
(700, 'SEVEN HUNDRED')
/
insert into lookup values
(701, 'SEVEN HUNDRED ONE')
/
insert into lookup values
(702,'SEVEN HUNDRED TWO')
/
insert into lookup values
(703,'SEVEN HUNDRED THREE')
/
insert into lookup values
(704,'SEVEN HUNDRED FOUR')
/
insert into lookup values
(705,'SEVEN HUNDRED FIVE')
/
insert into lookup values
(706,'SEVEN HUNDRED SIX')
/
insert into lookup values
(707,'SEVEN HUNDRED SEVEN')
/
insert into lookup values
(708,'SEVEN HUNDRED EIGHT')
/
insert into lookup values
(709,'SEVEN HUNDRED NINE')
/
insert into lookup values
(710,'SEVEN HUNDRED TEN')
/
insert into lookup values
(711,'SEVEN HUNDRED ELEVEN')
/
insert into lookup values
(712,'SEVEN HUNDRED TWELVE')
/
insert into lookup values
(713,'SEVEN HUNDRED THIRTEEN')
/
insert into lookup values
(714,'SEVEN HUNDRED FOURTEEN')
/
insert into lookup values
(715,'SEVEN HUNDRED FIFTEEN')
/
insert into lookup values
(716,'SEVEN HUNDRED SIXTEEN')
/
insert into lookup values
(717,'SEVEN HUNDRED SEVENTEEN')
/
insert into lookup values
(718,'SEVEN HUNDRED EIGHTEEN')
/
insert into lookup values
(719,'SEVEN HUNDRED NINETEEN')
/
insert into lookup values
(720,'SEVEN HUNDRED TWENTY')
/
insert into lookup values
(721,'SEVEN HUNDRED TWENTY ONE')
/
insert into lookup values
(722,'SEVEN HUNDRED TWENTY TWO')
/
insert into lookup values
(723,'SEVEN HUNDRED TWENTY THREE')
/
insert into lookup values
(724,'SEVEN HUNDRED TWENTY FOUR')
/
insert into lookup values
(725,'SEVEN HUNDRED TWENTY FIVE')
/
insert into lookup values
(726,'SEVEN HUNDRED TWENTY SIX')
/
insert into lookup values
(727,'SEVEN HUNDRED TWENTY SEVEN')
/
insert into lookup values
(728,'SEVEN HUNDRED TWENTY EIGHT')
/
insert into lookup values
(729,'SEVEN HUNDRED TWENTY NINE')
/
insert into lookup values
(730,'SEVEN HUNDRED THIRTY')
/
insert into lookup values
(731,'SEVEN HUNDRED THIRTY ONE')
/
insert into lookup values
(732,'SEVEN HUNDRED THIRTY TWO')
/
insert into lookup values
(733,'SEVEN HUNDRED THIRTY THREE')
/
insert into lookup values
(734,'SEVEN HUNDRED THIRTY FOUR')
/
insert into lookup values
(735,'SEVEN HUNDRED THIRTY FIVE')
/
insert into lookup values
(736,'SEVEN HUNDRED THIRTY SIX')
/
insert into lookup values
(737,'SEVEN HUNDRED THIRTY SEVEN')
/
insert into lookup values
(738,'SEVEN HUNDRED THIRTY EIGHT')
/
insert into lookup values
(739,'SEVEN HUNDRED THIRTY NINE')
/
insert into lookup values
(740,'SEVEN HUNDRED FOURTY')
/
insert into lookup values
(741,'SEVEN HUNDRED FOURTY ONE')
/
insert into lookup values
(742,'SEVEN HUNDRED FOURTY TWO')
/
insert into lookup values
(743,'SEVEN HUNDRED FOURTY THREE')
/
insert into lookup values
(744,'SEVEN HUNDRED FOURTY FOUR')
/
insert into lookup values
(745,'SEVEN HUNDRED FOURTY FIVE')
/
insert into lookup values
(746,'SEVEN HUNDRED FOURTY SIX')
/
insert into lookup values
(747,'SEVEN HUNDRED FOURTY SEVEN')
/
insert into lookup values
(748,'SEVEN HUNDRED FOURTY EIGHT')
/
insert into lookup values
(749,'SEVEN HUNDRED FOURTY NINE')
/
insert into lookup values
(750,'SEVEN HUNDRED FIFTY')
/
insert into lookup values
(751,'SEVEN HUNDRED FIFTY ONE')
/
insert into lookup values
(752,'SEVEN HUNDRED FIFTY TWO')
/
insert into lookup values
(753,'SEVEN HUNDRED FIFTY THREE')
/
insert into lookup values
(754,'SEVEN HUNDRED FIFTY FOUR')
/
insert into lookup values
(755,'SEVEN HUNDRED FIFTY FIVE')
/
insert into lookup values
(756,'SEVEN HUNDRED FIFTY SIX')
/
insert into lookup values
(757,'SEVEN HUNDRED FIFTY SEVEN')
/
insert into lookup values
(758,'SEVEN HUNDRED FIFTY EIGHT')
/
insert into lookup values
(759,'SEVEN HUNDRED FIFTY NINE')
/
insert into lookup values
(760,'SEVEN HUNDRED SIXTY')
/
insert into lookup values
(761,'SEVEN HUNDRED SIXTY ONE')
/
insert into lookup values
(762,'SEVEN HUNDRED SIXTY TWO')
/
insert into lookup values
(763,'SEVEN HUNDRED SIXTY THREE')
/
insert into lookup values
(764,'SEVEN HUNDRED SIXTY FOUR')
/
insert into lookup values
(765,'SEVEN HUNDRED SIXTY FIVE')
/
insert into lookup values
(766,'SEVEN HUNDRED SIXTY SIX')
/
insert into lookup values
(767,'SEVEN HUNDRED SIXTY SEVEN')
/
insert into lookup values
(768,'SEVEN HUNDRED SIXTY EIGHT')
/
insert into lookup values
(769,'SEVEN HUNDRED SIXTY NINE')
/
insert into lookup values
(770,'SEVEN HUNDRED SEVENTY')
/
insert into lookup values
(771,'SEVEN HUNDRED SEVENTY ONE')
/
insert into lookup values
(772,'SEVEN HUNDRED SEVENTY TWO')
/
insert into lookup values
(773,'SEVEN HUNDRED SEVENTY THREE')
/
insert into lookup values
(774,'SEVEN HUNDRED SEVENTY FOUR')
/
insert into lookup values
(775,'SEVEN HUNDRED SEVENTY FIVE')
/
insert into lookup values
(776,'SEVEN HUNDRED SEVENTY SIX')
/
insert into lookup values
(777,'SEVEN HUNDRED SEVENTY SEVEN')
/
insert into lookup values
(778,'SEVEN HUNDRED SEVENTY EIGHT')
/
insert into lookup values
(779,'SEVEN HUNDRED SEVENTY NINE')
/
insert into lookup values
(780,'SEVEN HUNDRED EIGHTY')
/
insert into lookup values
(781,'SEVEN HUNDRED EIGHTY ONE')
/
insert into lookup values
(782,'SEVEN HUNDRED EIGHTY TWO')
/
insert into lookup values
(783,'SEVEN HUNDRED EIGHTY THREE')
/
insert into lookup values
(784,'SEVEN HUNDRED EIGHTY FOUR')
/
insert into lookup values
(785,'SEVEN HUNDRED EIGHTY FIVE')
/
insert into lookup values
(786,'SEVEN HUNDRED EIGHTY SIX')
/
insert into lookup values
(787,'SEVEN HUNDRED EIGHTY SEVEN')
/
insert into lookup values
(788,'SEVEN HUNDRED EIGHTY EIGHT')
/
insert into lookup values
(789,'SEVEN HUNDRED EIGHTY NINE')
/
insert into lookup values
(790,'SEVEN HUNDRED NINETY')
/
insert into lookup values
(791,'SEVEN HUNDRED NINETY ONE')
/
insert into lookup values
(792,'SEVEN HUNDRED NINETY TWO')
/
insert into lookup values
(793,'SEVEN HUNDRED NINETY THREE')
/
insert into lookup values
(794,'SEVEN HUNDRED NINETY FOUR')
/
insert into lookup values
(795,'SEVEN HUNDRED NINETY FIVE')
/
insert into lookup values
(796,'SEVEN HUNDRED NINETY SIX')
/
insert into lookup values
(797,'SEVEN HUNDRED NINETY SEVEN')
/
insert into lookup values
(798,'SEVEN HUNDRED NINETY EIGHT')
/
insert into lookup values
(799,'SEVEN HUNDRED NINETY NINE')
/
insert into lookup values
(800, 'EIGHT HUNDRED')
/
insert into lookup values
(801, 'EIGHT HUNDRED ONE')
/
insert into lookup values
(802,'EIGHT HUNDRED TWO')
/
insert into lookup values
(803,'EIGHT HUNDRED THREE')
/
insert into lookup values
(804,'EIGHT HUNDRED FOUR')
/
insert into lookup values
(805,'EIGHT HUNDRED FIVE')
/
insert into lookup values
(806,'EIGHT HUNDRED SIX')
/
insert into lookup values
(807,'EIGHT HUNDRED SEVEN')
/
insert into lookup values
(808,'EIGHT HUNDRED EIGHT')
/
insert into lookup values
(809,'EIGHT HUNDRED NINE')
/
insert into lookup values
(810,'EIGHT HUNDRED TEN')
/
insert into lookup values
(811,'EIGHT HUNDRED ELEVEN')
/
insert into lookup values
(812,'EIGHT HUNDRED TWELVE')
/
insert into lookup values
(813,'EIGHT HUNDRED THIRTEEN')
/
insert into lookup values
(814,'EIGHT HUNDRED FOURTEEN')
/
insert into lookup values
(815,'EIGHT HUNDRED FIFTEEN')
/
insert into lookup values
(816,'EIGHT HUNDRED SIXTEEN')
/
insert into lookup values
(817,'EIGHT HUNDRED SEVENTEEN')
/
insert into lookup values
(818,'EIGHT HUNDRED EIGHTEEN')
/
insert into lookup values
(819,'EIGHT HUNDRED NINETEEN')
/
insert into lookup values
(820,'EIGHT HUNDRED TWENTY')
/
insert into lookup values
(821,'EIGHT HUNDRED TWENTY ONE')
/
insert into lookup values
(822,'EIGHT HUNDRED TWENTY TWO')
/
insert into lookup values
(823,'EIGHT HUNDRED TWENTY THREE')
/
insert into lookup values
(824,'EIGHT HUNDRED TWENTY FOUR')
/
insert into lookup values
(825,'EIGHT HUNDRED TWENTY FIVE')
/
insert into lookup values
(826,'EIGHT HUNDRED TWENTY SIX')
/
insert into lookup values
(827,'EIGHT HUNDRED TWENTY SEVEN')
/
insert into lookup values
(828,'EIGHT HUNDRED TWENTY EIGHT')
/
insert into lookup values
(829,'EIGHT HUNDRED TWENTY NINE')
/
insert into lookup values
(830,'EIGHT HUNDRED THIRTY')
/
insert into lookup values
(831,'EIGHT HUNDRED THIRTY ONE')
/
insert into lookup values
(832,'EIGHT HUNDRED THIRTY TWO')
/
insert into lookup values
(833,'EIGHT HUNDRED THIRTY THREE')
/
insert into lookup values
(834,'EIGHT HUNDRED THIRTY FOUR')
/
insert into lookup values
(835,'EIGHT HUNDRED THIRTY FIVE')
/
insert into lookup values
(836,'EIGHT HUNDRED THIRTY SIX')
/
insert into lookup values
(837,'EIGHT HUNDRED THIRTY SEVEN')
/
insert into lookup values
(838,'EIGHT HUNDRED THIRTY EIGHT')
/
insert into lookup values
(839,'EIGHT HUNDRED THIRTY NINE')
/
insert into lookup values
(840,'EIGHT HUNDRED FOURTY')
/
insert into lookup values
(841,'EIGHT HUNDRED FOURTY ONE')
/
insert into lookup values
(842,'EIGHT HUNDRED FOURTY TWO')
/
insert into lookup values
(843,'EIGHT HUNDRED FOURTY THREE')
/
insert into lookup values
(844,'EIGHT HUNDRED FOURTY FOUR')
/
insert into lookup values
(845,'EIGHT HUNDRED FOURTY FIVE')
/
insert into lookup values
(846,'EIGHT HUNDRED FOURTY SIX')
/
insert into lookup values
(847,'EIGHT HUNDRED FOURTY SEVEN')
/
insert into lookup values
(848,'EIGHT HUNDRED FOURTY EIGHT')
/
insert into lookup values
(849,'EIGHT HUNDRED FOURTY NINE')
/
insert into lookup values
(850,'EIGHT HUNDRED FIFTY')
/
insert into lookup values
(851,'EIGHT HUNDRED FIFTY ONE')
/
insert into lookup values
(852,'EIGHT HUNDRED FIFTY TWO')
/
insert into lookup values
(853,'EIGHT HUNDRED FIFTY THREE')
/
insert into lookup values
(854,'EIGHT HUNDRED FIFTY FOUR')
/
insert into lookup values
(855,'EIGHT HUNDRED FIFTY FIVE')
/
insert into lookup values
(856,'EIGHT HUNDRED FIFTY SIX')
/
insert into lookup values
(857,'EIGHT HUNDRED FIFTY SEVEN')
/
insert into lookup values
(858,'EIGHT HUNDRED FIFTY EIGHT')
/
insert into lookup values
(859,'EIGHT HUNDRED FIFTY NINE')
/
insert into lookup values
(860,'EIGHT HUNDRED SIXTY')
/
insert into lookup values
(861,'EIGHT HUNDRED SIXTY ONE')
/
insert into lookup values
(862,'EIGHT HUNDRED SIXTY TWO')
/
insert into lookup values
(863,'EIGHT HUNDRED SIXTY THREE')
/
insert into lookup values
(864,'EIGHT HUNDRED SIXTY FOUR')
/
insert into lookup values
(865,'EIGHT HUNDRED SIXTY FIVE')
/
insert into lookup values
(866,'EIGHT HUNDRED SIXTY SIX')
/
insert into lookup values
(867,'EIGHT HUNDRED SIXTY SEVEN')
/
insert into lookup values
(868,'EIGHT HUNDRED SIXTY EIGHT')
/
insert into lookup values
(869,'EIGHT HUNDRED SIXTY NINE')
/
insert into lookup values
(870,'EIGHT HUNDRED SEVENTY')
/
insert into lookup values
(871,'EIGHT HUNDRED SEVENTY ONE')
/
insert into lookup values
(872,'EIGHT HUNDRED SEVENTY TWO')
/
insert into lookup values
(873,'EIGHT HUNDRED SEVENTY THREE')
/
insert into lookup values
(874,'EIGHT HUNDRED SEVENTY FOUR')
/
insert into lookup values
(875,'EIGHT HUNDRED SEVENTY FIVE')
/
insert into lookup values
(876,'EIGHT HUNDRED SEVENTY SIX')
/
insert into lookup values
(877,'EIGHT HUNDRED SEVENTY SEVEN')
/
insert into lookup values
(878,'EIGHT HUNDRED SEVENTY EIGHT')
/
insert into lookup values
(879,'EIGHT HUNDRED SEVENTY NINE')
/
insert into lookup values
(880,'EIGHT HUNDRED EIGHTY')
/
insert into lookup values
(881,'EIGHT HUNDRED EIGHTY ONE')
/
insert into lookup values
(882,'EIGHT HUNDRED EIGHTY TWO')
/
insert into lookup values
(883,'EIGHT HUNDRED EIGHTY THREE')
/
insert into lookup values
(884,'EIGHT HUNDRED EIGHTY FOUR')
/
insert into lookup values
(885,'EIGHT HUNDRED EIGHTY FIVE')
/
insert into lookup values
(886,'EIGHT HUNDRED EIGHTY SIX')
/
insert into lookup values
(887,'EIGHT HUNDRED EIGHTY SEVEN')
/
insert into lookup values
(888,'EIGHT HUNDRED EIGHTY EIGHT')
/
insert into lookup values
(889,'EIGHT HUNDRED EIGHTY NINE')
/
insert into lookup values
(890,'EIGHT HUNDRED NINETY')
/
insert into lookup values
(891,'EIGHT HUNDRED NINETY ONE')
/
insert into lookup values
(892,'EIGHT HUNDRED NINETY TWO')
/
insert into lookup values
(893,'EIGHT HUNDRED NINETY THREE')
/
insert into lookup values
(894,'EIGHT HUNDRED NINETY FOUR')
/
insert into lookup values
(895,'EIGHT HUNDRED NINETY FIVE')
/
insert into lookup values
(896,'EIGHT HUNDRED NINETY SIX')
/
insert into lookup values
(897,'EIGHT HUNDRED NINETY SEVEN')
/
insert into lookup values
(898,'EIGHT HUNDRED NINETY EIGHT')
/
insert into lookup values
(899,'EIGHT HUNDRED NINETY NINE')
/
insert into lookup values
(900, 'NINE HUNDRED')
/
insert into lookup values
(901, 'NINE HUNDRED ONE')
/
insert into lookup values
(902,'NINE HUNDRED TWO')
/
insert into lookup values
(903,'NINE HUNDRED THREE')
/
insert into lookup values
(904,'NINE HUNDRED FOUR')
/
insert into lookup values
(905,'NINE HUNDRED FIVE')
/
insert into lookup values
(906,'NINE HUNDRED SIX')
/
insert into lookup values
(907,'NINE HUNDRED SEVEN')
/
insert into lookup values
(908,'NINE HUNDRED EIGHT')
/
insert into lookup values
(909,'NINE HUNDRED NINE')
/
insert into lookup values
(910,'NINE HUNDRED TEN')
/
insert into lookup values
(911,'NINE HUNDRED ELEVEN')
/
insert into lookup values
(912,'NINE HUNDRED TWELVE')
/
insert into lookup values
(913,'NINE HUNDRED THIRTEEN')
/
insert into lookup values
(914,'NINE HUNDRED FOURTEEN')
/
insert into lookup values
(915,'NINE HUNDRED FIFTEEN')
/
insert into lookup values
(916,'NINE HUNDRED SIXTEEN')
/
insert into lookup values
(917,'NINE HUNDRED SEVENTEEN')
/
insert into lookup values
(918,'NINE HUNDRED EIGHTEEN')
/
insert into lookup values
(919,'NINE HUNDRED NINETEEN')
/
insert into lookup values
(920,'NINE HUNDRED TWENTY')
/
insert into lookup values
(921,'NINE HUNDRED TWENTY ONE')
/
insert into lookup values
(922,'NINE HUNDRED TWENTY TWO')
/
insert into lookup values
(923,'NINE HUNDRED TWENTY THREE')
/
insert into lookup values
(924,'NINE HUNDRED TWENTY FOUR')
/
insert into lookup values
(925,'NINE HUNDRED TWENTY FIVE')
/
insert into lookup values
(926,'NINE HUNDRED TWENTY SIX')
/
insert into lookup values
(927,'NINE HUNDRED TWENTY SEVEN')
/
insert into lookup values
(928,'NINE HUNDRED TWENTY EIGHT')
/
insert into lookup values
(929,'NINE HUNDRED TWENTY NINE')
/
insert into lookup values
(930,'NINE HUNDRED THIRTY')
/
insert into lookup values
(931,'NINE HUNDRED THIRTY ONE')
/
insert into lookup values
(932,'NINE HUNDRED THIRTY TWO')
/
insert into lookup values
(933,'NINE HUNDRED THIRTY THREE')
/
insert into lookup values
(934,'NINE HUNDRED THIRTY FOUR')
/
insert into lookup values
(935,'NINE HUNDRED THIRTY FIVE')
/
insert into lookup values
(936,'NINE HUNDRED THIRTY SIX')
/
insert into lookup values
(937,'NINE HUNDRED THIRTY SEVEN')
/
insert into lookup values
(938,'NINE HUNDRED THIRTY EIGHT')
/
insert into lookup values
(939,'NINE HUNDRED THIRTY NINE')
/
insert into lookup values
(940,'NINE HUNDRED FOURTY')
/
insert into lookup values
(941,'NINE HUNDRED FOURTY ONE')
/
insert into lookup values
(942,'NINE HUNDRED FOURTY TWO')
/
insert into lookup values
(943,'NINE HUNDRED FOURTY THREE')
/
insert into lookup values
(944,'NINE HUNDRED FOURTY FOUR')
/
insert into lookup values
(945,'NINE HUNDRED FOURTY FIVE')
/
insert into lookup values
(946,'NINE HUNDRED FOURTY SIX')
/
insert into lookup values
(947,'NINE HUNDRED FOURTY SEVEN')
/
insert into lookup values
(948,'NINE HUNDRED FOURTY EIGHT')
/
insert into lookup values
(949,'NINE HUNDRED FOURTY NINE')
/
insert into lookup values
(950,'NINE HUNDRED FIFTY')
/
insert into lookup values
(951,'NINE HUNDRED FIFTY ONE')
/
insert into lookup values
(952,'NINE HUNDRED FIFTY TWO')
/
insert into lookup values
(953,'NINE HUNDRED FIFTY THREE')
/
insert into lookup values
(954,'NINE HUNDRED FIFTY FOUR')
/
insert into lookup values
(955,'NINE HUNDRED FIFTY FIVE')
/
insert into lookup values
(956,'NINE HUNDRED FIFTY SIX')
/
insert into lookup values
(957,'NINE HUNDRED FIFTY SEVEN')
/
insert into lookup values
(958,'NINE HUNDRED FIFTY EIGHT')
/
insert into lookup values
(959,'NINE HUNDRED FIFTY NINE')
/
insert into lookup values
(960,'NINE HUNDRED SIXTY')
/
insert into lookup values
(961,'NINE HUNDRED SIXTY ONE')
/
insert into lookup values
(962,'NINE HUNDRED SIXTY TWO')
/
insert into lookup values
(963,'NINE HUNDRED SIXTY THREE')
/
insert into lookup values
(964,'NINE HUNDRED SIXTY FOUR')
/
insert into lookup values
(965,'NINE HUNDRED SIXTY FIVE')
/
insert into lookup values
(966,'NINE HUNDRED SIXTY SIX')
/
insert into lookup values
(967,'NINE HUNDRED SIXTY SEVEN')
/
insert into lookup values
(968,'NINE HUNDRED SIXTY EIGHT')
/
insert into lookup values
(969,'NINE HUNDRED SIXTY NINE')
/
insert into lookup values
(970,'NINE HUNDRED SEVENTY')
/
insert into lookup values
(971,'NINE HUNDRED SEVENTY ONE')
/
insert into lookup values
(972,'NINE HUNDRED SEVENTY TWO')
/
insert into lookup values
(973,'NINE HUNDRED SEVENTY THREE')
/
insert into lookup values
(974,'NINE HUNDRED SEVENTY FOUR')
/
insert into lookup values
(975,'NINE HUNDRED SEVENTY FIVE')
/
insert into lookup values
(976,'NINE HUNDRED SEVENTY SIX')
/
insert into lookup values
(977,'NINE HUNDRED SEVENTY SEVEN')
/
insert into lookup values
(978,'NINE HUNDRED SEVENTY EIGHT')
/
insert into lookup values
(979,'NINE HUNDRED SEVENTY NINE')
/
insert into lookup values
(980,'NINE HUNDRED EIGHTY')
/
insert into lookup values
(981,'NINE HUNDRED EIGHTY ONE')
/
insert into lookup values
(982,'NINE HUNDRED EIGHTY TWO')
/
insert into lookup values
(983,'NINE HUNDRED EIGHTY THREE')
/
insert into lookup values
(984,'NINE HUNDRED EIGHTY FOUR')
/
insert into lookup values
(985,'NINE HUNDRED EIGHTY FIVE')
/
insert into lookup values
(986,'NINE HUNDRED EIGHTY SIX')
/
insert into lookup values
(987,'NINE HUNDRED EIGHTY SEVEN')
/
insert into lookup values
(988,'NINE HUNDRED EIGHTY EIGHT')
/
insert into lookup values
(989,'NINE HUNDRED EIGHTY NINE')
/
insert into lookup values
(990,'NINE HUNDRED NINETY')
/
insert into lookup values
(991,'NINE HUNDRED NINETY ONE')
/
insert into lookup values
(992,'NINE HUNDRED NINETY TWO')
/
insert into lookup values
(993,'NINE HUNDRED NINETY THREE')
/
insert into lookup values
(994,'NINE HUNDRED NINETY FOUR')
/
insert into lookup values
(995,'NINE HUNDRED NINETY FIVE')
/
insert into lookup values
(996,'NINE HUNDRED NINETY SIX')
/
insert into lookup values
(997,'NINE HUNDRED NINETY SEVEN')
/
insert into lookup values
(998,'NINE HUNDRED NINETY EIGHT')
/
insert into lookup values
(999,'NINE HUNDRED NINETY NINE')
/
insert into lookup values
(1000, 'ONE THOUSAND')
/
create index numbervalue_index on lookup (numbervalue asc)
/
grant select on lookup to public
/
commit
/
/*
   VIEW: SPELL_NUMBER
   This view is used to lookup spelled-out text for numbers in
   the Spelling Out Cash Amounts reports in the case book.
   Nimish Mehta Oct. 30th. 1989
*/
drop view Spell_Number
/
create view Spell_Number as
(
select i.numbervalue input_number,
       t.numbertext Th_text,
       decode((trunc(i.numbervalue/1000)),0,'','THOUSAND') Th_sym,
       o.numbertext On_text,
       'AND '||(i.numbervalue-floor(i.numbervalue))||'/100' Dec_text
from   lookup t, lookup o, lookup i
where  (trunc(i.numbervalue/1000) = t.numbervalue
       and mod(i.numbervalue,1000) = o.numbervalue)
or     (o.numbervalue = i.numbervalue
       and t.numbervalue = -1)
)
/
grant select on Spell_Number to public
/
commit
/
/*
   VIEW: ACCOUNT
   This view is used in the Computations On Summaries: using SQL
   report in the case book.
   Nimish Mehta  Oct. 30th 1989
*/
drop view Account
/
create view account as
(select Item.Ordid Ordid, Item.Prodid Prodid, Qty*Stdprice List_Amount,
Itemtot Actual_Amt from Price, Item where Price.Prodid = Item.Prodid)
/
grant select on Account to public
/
commit
/
/*
   TABLE: NAMES
   This table is used in the Advanced Mailing Label Report report
   in the case book.
   Nimish Mehta  Oct. 30th 1989
*/
drop table names
/
create table names
       (custname char(30), address1 char(30), address2 char(30),
        address3 char(30), address4 char(30))
/
insert into names (custname, address1, address4)
       select substr(name,1,30),
              substr(address,1,30),
              substr(city||', '||state||', '||zip,1,30) from customer
/
update names set address2='SUITE 400-G'
where  custname like 'JOCKSPORTS%'
/
grant select on names to public
/
commit
/