Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
Tree: 4a4c47dbed
Fetching contributors…

Cannot retrieve contributors at this time

executable file 12 lines (9 sloc) 9.518 kB
-- Start Pack Resources
-- Hilla MSISDN Resources 07707102090 to be loaded for Hilla Shop
Select msisdn From ccare.tmp_hilla_msisdns
Minus
Select t.msisdn From res_startpack t Where t.res_code In ('07707102000','07707102001','07707102002','07707102003','07707102004','07707102005','07707102006','07707102007','07707102008','07707102009','07707102010','07707102011','07707102012','07707102013','07707102014','07707102015','07707102016','07707102017','07707102018','07707102019','07707102020','07707102021','07707102022','07707102023','07707102024','07707102025','07707102026','07707102027','07707102028','07707102029','07707102030','07707102031','07707102032','07707102033','07707102034','07707102035','07707102036','07707102037','07707102038','07707102039','07707102040','07707102041','07707102042','07707102043','07707102044','07707102045','07707102046','07707102047','07707102048','07707102049','07707102050','07707102051','07707102052','07707102053','07707102054','07707102055','07707102056','07707102057','07707102058','07707102059','07707102060','07707102061','07707102062','07707102063','07707102064','07707102065','07707102066','07707102067','07707102068','07707102069','07707102070','07707102071','07707102072','07707102073','07707102074','07707102075','07707102076','07707102077','07707102078','07707102079','07707102080','07707102081','07707102082','07707102083','07707102084','07707102085','07707102086','07707102087','07707102088','07707102089','07707102090','07707102091','07707102092','07707102093','07707102094','07707102095','07707102096','07707102097','07707102098','07707102099','07707102100','07707102101','07707102102','07707102103','07707102104','07707102105','07707102106','07707102107','07707102108','07707102109','07707102110','07707102111','07707102112','07707102113','07707102114','07707102115','07707102116','07707102117','07707102118','07707102119','07707102120','07707102121','07707102122','07707102123','07707102124','07707102125','07707102126','07707102127','07707102128','07707102129','07707102130','07707102131','07707102132','07707102133','07707102134','07707102135','07707102136','07707102137','07707102138','07707102139','07707102140','07707102141','07707102142','07707102143','07707102144','07707102145','07707102146','07707102147','07707102148','07707102149','07707102150','07707102151','07707102152','07707102153','07707102154','07707102155','07707102156','07707102157','07707102158','07707102159','07707102160','07707102161','07707102162','07707102163','07707102164','07707102165','07707102166','07707102167','07707102168','07707102169','07707102170','07707102171','07707102172','07707102173','07707102174','07707102175','07707102176','07707102177','07707102178','07707102179','07707102180','07707102181','07707102182','07707102183','07707102184','07707102185','07707102186','07707102187','07707102188','07707102189','07707102190','07707102191','07707102192','07707102193','07707102194','07707102195','07707102196','07707102197','07707102198','07707102199','07707102200','07707102201','07707102202','07707102203','07707102204','07707102205','07707102206','07707102207','07707102208','07707102209','07707102210','07707102211','07707102212','07707102213','07707102214','07707102215','07707102216','07707102217','07707102218','07707102219','07707102220','07707102221','07707102222','07707102223','07707102224','07707102225','07707102226','07707102227','07707102228','07707102229','07707102230','07707102231','07707102232','07707102233','07707102234','07707102235','07707102236','07707102237','07707102238','07707102239','07707102240','07707102241','07707102242','07707102243','07707102244','07707102245','07707102246','07707102247','07707102248','07707102249','07707102250','07707102251','07707102252','07707102253','07707102254','07707102255','07707102256','07707102257','07707102258','07707102259','07707102260','07707102261','07707102262','07707102263','07707102264','07707102265','07707102266','07707102267','07707102268','07707102269','07707102270','07707102271','07707102272','07707102273','07707102274','07707102275','07707102276','07707102277','07707102278','07707102279','07707102280','07707102281','07707102282','07707102283','07707102284','07707102285','07707102286','07707102287','07707102288','07707102289','07707102290','07707102291','07707102292','07707102293','07707102294','07707102295','07707102296','07707102297','07707102298','07707102299','07707102300','07707102301','07707102302','07707102303','07707102304','07707102305','07707102306','07707102307','07707102308','07707102309','07707102310','07707102311','07707102312','07707102313','07707102314','07707102315','07707102316','07707102317','07707102318','07707102319','07707102320','07707102321','07707102322','07707102323','07707102324','07707102325','07707102326','07707102327','07707102328','07707102329','07707102330','07707102331','07707102332','07707102333','07707102334','07707102335','07707102336','07707102337','07707102338','07707102339','07707102340','07707102341','07707102342','07707102343','07707102344','07707102345','07707102346','07707102347','07707102348','07707102349','07707102350','07707102351','07707102352','07707102353','07707102354','07707102355','07707102356','07707102357','07707102358','07707102359','07707102360','07707102361','07707102362','07707102363','07707102364','07707102365','07707102366','07707102367','07707102368','07707102369','07707102370','07707102371','07707102372','07707102373','07707102374','07707102375','07707102376','07707102377','07707102378','07707102379','07707102380','07707102381','07707102382','07707102383','07707102384','07707102385','07707102386','07707102387','07707102388','07707102389','07707102390','07707102391','07707102392','07707102393','07707102394','07707102395','07707102396','07707102397','07707102398','07707102399','07707102400','07707102401','07707102402','07707102403','07707102404','07707102405','07707102406','07707102407','07707102408','07707102409','07707102410','07707102411','07707102412','07707102413','07707102414','07707102415','07707102416','07707102417','07707102418','07707102419','07707102420','07707102421','07707102422','07707102423','07707102424','07707102425','07707102426','07707102427','07707102428','07707102429','07707102430','07707102431','07707102432','07707102433','07707102434','07707102435','07707102436','07707102437','07707102438','07707102439','07707102440','07707102441','07707102442','07707102443','07707102444','07707102445','07707102446','07707102447','07707102448','07707102449','07707102450','07707102451','07707102452','07707102453','07707102454','07707102455','07707102456','07707102457','07707102458','07707102459','07707102460','07707102461','07707102462','07707102463','07707102464','07707102465','07707102466','07707102467','07707102468','07707102469','07707102470','07707102471','07707102472','07707102473','07707102474','07707102475','07707102476','07707102477','07707102478','07707102479','07707102480','07707102481','07707102482','07707102483','07707102484','07707102485','07707102486','07707102487','07707102488','07707102489','07707102490','07707102491','07707102492','07707102493','07707102494','07707102495','07707102496','07707102497','07707102498','07707102499','07707102500','07707102501','07707102502','07707102503','07707102504','07707102505','07707102506','07707102507','07707102508','07707102509','07707102510','07707102511','07707102512','07707102513','07707102514','07707102515','07707102516','07707102517','07707102518','07707102519','07707102520','07707102521','07707102522','07707102523','07707102524','07707102525','07707102526','07707102527','07707102528','07707102529','07707102530','07707102531','07707102532','07707102533','07707102534','07707102535','07707102536','07707102537','07707102538','07707102539','07707102540','07707102541','07707102542','07707102543','07707102544','07707102545','07707102546','07707102547','07707102548','07707102549','07707102550','07707102551','07707102552','07707102553','07707102554','07707102555','07707102556','07707102557','07707102558','07707102559','07707102560','07707102561','07707102562','07707102563','07707102564','07707102565','07707102566','07707102567','07707102568','07707102569','07707102570','07707102571','07707102572','07707102573','07707102574','07707102575','07707102576','07707102577','07707102578','07707102579','07707102580','07707102581','07707102582','07707102583','07707102584','07707102585','07707102586','07707102587','07707102588','07707102589','07707102590','07707102591','07707102592','07707102593','07707102594','07707102595','07707102596','07707102597','07707102598','07707102599','07707102600','07707102601','07707102602','07707102603','07707102604','07707102605','07707102606','07707102607','07707102608','07707102609','07707102610','07707102611','07707102612','07707102613','07707102614','07707102615','07707102616','07707102617','07707102618','07707102619','07707102620','07707102621','07707102622','07707102623','07707102624','07707102625','07707102626','07707102627','07707102628','07707102629','07707102630','07707102631','07707102632','07707102633','07707102634','07707102635','07707102636','07707102637','07707102638','07707102639','07707102640','07707102641','07707102642','07707102643','07707102644','07707102645','07707102646','07707102647','07707102648','07707102649');
-- create temp table to hold the resources range
Create Table tmp_hilla_msisdns (msisdn Varchar2(11));
Select * From ccare.tmp_hilla_msisdns t For Update;
Drop Table ccare.tmp_hilla_msisdns;-- table droped
Jump to Line
Something went wrong with that request. Please try again.