Insufficient memory to parse this request,during optimizer phase....

Database
l_k
Enthusiast

Insufficient memory to parse this request,during optimizer phase....

Hi,
When i execute this query in teradata V2R12,it is generating errors as "Insufficient memory to parse this request,during optimizer phase".But the same query is working fine in Teradata V2R6 Version.In my DBS control Max ParseTree setting is 6000.we have collected statistics for all the index columns.

SELECT DIM_PRODUCT.PRODUCT_CODE,DIM_PRODUCT.PRODUCT_DESCRIPTION|| '-'
||trim(PRODUCT_STYLE_DESC)|| '-' ||trim(PRODUCT_SIZE) "Product",
DIM_PRODUCT.EAN_NUMBER"C627", DIM_PRODUCT.PRODUCT_DESCRIPTION"C157",
DIM_PRODUCT.PRODUCT_STYLE_DESC"C153", DIM_PRODUCT.PRODUCT_SIZE"C156",
DIM_PRODUCT.PRODUCT_UOM"C604", DIM_PRODUCT.CREATED_DATE"C998",
(case when ATTRIB2_DESC IN('ZAP' , 'KIL' , 'DEL' , 'zap' , 'kil' , 'del') THEN 'D' ELSE 'A' END)
"C659", DIM_PRODUCT.ATTRIB2_DESC"C712", DIM_PRODUCT.ATTRIB1_DESC"C648",
DIM_PRODUCT.ATTRIB3_DESC"C628", DIM_PRODUCT.PRODUCT_DETAIL_CODE"C146",
DIM_PRODUCT.DEPARTMENT_CODE"C134", DIM_PRODUCT.DEPARTMENT_DESC"C135",
DIM_PRODUCT.CLASS_CODE"C136", DIM_PRODUCT.CLASS_DESC"C137",
DIM_PRODUCT.SUBCLASS_CODE"C138", DIM_PRODUCT.SUBCLASS_DESC"C139",
DIM_PRODUCT.ACCT_DEPT_CODE"C606", DIM_PRODUCT.SUB_DEPT_CODE"C608", ' '
"C761", ' ' "C732", SUM(SALE_TOT_QTY)"C1", SUM(SALE_TOT_QTY_LY)"C2", ' ' "C1254", ' '
"C688", SUM(SALE_NET_VAL)"C3", SUM(SALE_NET_VAL_LY)"C4", ' ' "C1253", ' ' "C100",
SUM(SALE_TOT_VAL_AT_PP)"C29", SUM(ACCRUED_REBATE_VAL)"C735", ' ' "C772", ' '
"C97", ' ' "C101", SUM(SALE_TOT_VAL_AT_PP_LY)"C30", SUM(ACCRUED_REBATE_VAL_LY)
"C736", ' ' "C773", ' ' "C98", ' ' "C102", ' ' "C1255", ' ' "C103" FROM arcprod.AGG_MLY_STR_PROD,DIM_STORE,
DIM_PRODUCT,ADMIN_USER_STORE,ADMIN_USER_DEPARTMENT WHERE
AGG_MLY_STR_PROD.DATE_KEY >=1212 AND AGG_MLY_STR_PROD.DATE_KEY <=1295
AND DIM_STORE.ACTIVE = 1 AND DIM_PRODUCT.PRODUCT_CODE IN
('5150004007','48000355501','4180000012','4180000025','72698419000','1122542185',
'48000354501','72698419050','48000355601','72698419051','48000703801','4180000017',
'4180000028','5150001316','4180000036','48000307501','72698419001','72698419003','5150000683',
'5150000163','5150004008','5150001687','48000502401','72698419053','5150002219','72698419002',
'1122542184','5150000690','72698419004','48000300801','48000354701','5150000682','48000417301',
'4129201216','5150000006','48000355701','48000417501','75512200012','75512200007',
'5150003259','5150003258','48000356601','48000497301','5150028604','48000417901',
'48000521801','5150003363','8870200952','48000511801','48000511901','48000512001',
'48000684201','5150003069','48000355001','48000355201','5964424617','48000355301',
'48000355401','48000497401','48000497401','5150003056','48000354901','48000400501','5964420217',
'48000400601','8186720009','8186720018','48000369701','48000098701','8186720010','48000488001',
'48000701201','48000680301','48000279601','48000369801','4364738001','4364768003','48000316501',
'48000611101','4164202670','48000105501','48000357301','48000595101','48000357401','3680018151',
'48000356101','5150024320','48000336801','5150024334','48000216401','48000356201','5150024322',
'48000357701','48000337701','48000595001','48000357601','48000684501','48000684601','1122504180',
'72698419020','1870000078','72698419022','1870000040','1870000314','72698419021','1122542189',
'72698419024','72663512152','48000609001','48000608901','72663512153','73753919049','48000744601',
'980089500','66780300195','4179500098','48000738501','48000695801','72698428050','48000596201',

'7299949303','48000424301','4125300905','72698428065','72698428064','7372320040','7372320041',
'7372320042','72698428066','72698428061','72698428062','7299924103','7299927203','72698428063',
'7067000555','7321400107','7321400803','8915684010','7107201250','4125300926','4125300933',
'48000280801','8915680109','48000424401','4125300910','8915680100','8915680123','8915680101',
'8915680122','8915680112','7299924203','3727908001','7321400604','8915680111','7321400604',
'3727908005','48000427901','8915680113','7321400587','7647963616','48000504401','48000424201',
'8915680128','48000704401','3727908002','3727908003','8915600136','7321406350','7321406350',
'48000427801','48000427801','48000512601','48000428001','7321400618','7321406332','4122471470',
'4122471488','3285100005','1121000835','72698428005','48000596301','7157911002','48000302501',
'5410000360','72698428042','72698428019','72698428043','48000302101','48000302301','48000302201',
'7157910817','7157911003','7157977000','48000596401','4182006045','7157911011','72698428041',
'48000596501','5410000450','4182010506','4182010509','4182010616','48000302401','4182007038',
'48000696601','48000301901','48000302001','48000405501','48000405601','48000365201','48000596601','
1122542167','48000301801','48000405401','7157911004','7157944005','4182003090','2370900407',
'4125300007','7321400402','7321400403','2370900403','4122470006','4122470090','2370911042',
'4125300960','48000427701','7321400129','48000427701','7321400162','74815941660','74815941274',
'4125310400','48000281101','4125337100','48000280901','7067000088','7067000452','4125300200',
'7321400104','5150028661','7321400146','7321400146','7067000554','1121002555','1122506354',
'48000357001','4125300066','7321400103','4182006033','3727908008','48000509001','7057355555',
'7057366666','1122506355','18372300001','18372300002','1121002555','7321400160','72698408139',
'72698408133','72698408140','72698408134','7040400100','72698408142','72698408141','1300000854',
'1300000814','7321000240','7040400135','7040400136','48000676901','7321003325','48000427601',
'48000427501','5150028640','48000417401','48000430901','3915341305','3915341306','48000392601',
'7241282001','7086060250','7107201141','7107201141','48000721001','7079690008','7241200035',
'48000395501','7241282001','4125300180','48000390501','7067000957','1786942007','1362860893',
'1362860900','7224826354','3915341300','4125300183','7107201132','73449270130','7321000200',
'48000577101','48000577201','8186750010','3915341308','3915341310','8186750002','8186750001',
'4364651023','4364651020','7224827755','7224827751','7067000289','4125300185','1786942003',
'1786942004','48000417001','3915341302','5152806015','73449270135','48000113001','64850535250',
'48000731501','1362860887','48000268601','8634157120','48000504301','8634157120','3915341355',
'48000567101','1362860887','64850533250','64850530250','6726420000','6726420000','4122470548',
'64850530250','3915310130','80824500013','1362860850','1362860850','8423859013199','48000150101',
'48000179201','48000441201','48000114101','48000146401','48000665601','48000115701','48000194601',
'7460907233','1340935231','5160000004','4150080502','48000098801','48000098601','1121000609',
'1121000001','7047501064','4150001310','5160000501','72698408110','5160000001','1300000264',
'48000284201','48000148801','48000153401','48000365701','48000158101','48000441101','48000334001',
'1122506307','1122506309','1122506316','4749600054','2400037396','4142117745','7110000052',
'74815910732','7507610016','48000445601','74815910730','1121000825','1121000825','5150028651',
'7507610007','48000356901','48000356801','48000585101','7067000460','48000417801','7067000430',
'7124038504','48000098901','48000607901','48000607801','73475600108','48000608001','48000608101',
'73475600208','73475600209','3979600221','48000269701','7124038520','48000356701','77610011349',
'77610092375','7067000459','48000630501','1121002010','7067000025','5150028620','48000608801',
'7356200510','48000695901','7215500005','4973380011','48000613001','8186780012','4973309101',
'7067060108','48000103701','48000103801','48000147601','48000630701','2013813604','2013813630',
'6970250002','4973312345','79285135657','48000523001','75449600122','1121002010','72698408906',
'72698408907','1121002150','72698408111','2700038249','72698408112','2700038354','72698408108',
'1300000121','72698408301','4150000025','72698408304','48000114001','72698408303','72698408305',
'6414432160','48000724201','4150000031','4150000700','48000365601','48000365801','5440060050',
'7113701209','7182800212','48000678601','1300000112','1300000113','48000709301','48000715101',
'48000203301','4132101438','2100064947','7182800127','7182800228','7182800149','1300001520',
'48000408201','7182800238','48000408101','48000099001','48000443001','1048100200','48000099001',
'48000408301','48000408401','1300001530','48000102701','7182801108','48000408501','7020050232',
'48000382101','4364651018','7182800277','7182801405','7245788011','66780300217','66780300218',
'7182801106','4364651018','4364670777','4364670777','7142907617','48000306001','66780300005',
'48000747501','48000747601','48000628801','48000103901','4364646301','4364646101','48000316401',
'4364646301','48000316401','4364646101','48000654501','48000523101','4364620137','2250613806',
'7430500016','3680012045','2250628032','48000237501','3680004341','48000238201','9232522223',
'48000148701','48000516501','48000240201','7110028654','48000631801','2548400041','2250600235',
'2250620232','2250620132','2250680006','2250613410','3680004313','3680012042','2250600200',
'48000561101','48000305601','72698430003','7180083850','72698430001','4800100147','72698430000',
'48000337101','2100064507','4800126552','72698430004','2100064504','2100064591','48000597201',
'48000282001','48000149501','48000148201','48000148901','48000151701','7110000550','48000274701',
'48000396301','4100000610','48000275001','48000275501','48000361201','48000719601','7110021015',
'48000378101','48000312701','48000672701','48000396201','48000378001','7110000465','4300097940',
'4300097825','7052800631','48000387901','48000455201','48000630801','48000631001','1600040060',
'48000242901','7038110014','48000630901','4470002773','4470002966','48000261801','5210015530',
'4300097868','4760002334','4760009136','3760026426','73007622100','48000201201','7182800211',
'48000724301','4132101331','48000450401','7038110027','48000404401','48000182001','48000417701',
'48000380501','48000203201','48000515501','48000384701','1121002300','1121002300','48000664901',
'48000504101','7020011001','48000696001','48000630601','7468300445','48000442901','7147500013',
'48000731201','48000442801','7147501082','7147501082','4760005004','48000382301','48000504001',
'8634112401','8817742487','48000503901','48000503901','48000749001','8634112112','48000664101',
'78640900001','48000121601','72698420120','1480058204','72698420013','48000637501','1480058226',
'7045011864','1122561723','72698420044','1480064608','48000428401','48000595401','1122541602',
'48000447201','4175500106','48000595501','72698420600','4175500900','48000509401','2870000308',
'72698420024','72698420080','7535511181','7535511182','48000595301','72698420029','48000447101',
'48000595601','48000595201','48000745201','2870011305','48000202701','48000299401','4175500267',
'48000350501','48000744701','4175500808','48000566101','48000202401','48000202501','48000351501',
'48000202601','48000203001','48000447001','48000202801','48000301401','48000301201','4175500119',
'5100001293','48000351003','48000000101','48000364901','48000498001','8105705407','3680300109',
'48000248801','4124400152','48000285201','4277430070','48000280401','7990000461','4124400253',
'4124499030','4180070652','4180070752','7000551012','48000100701','48000683601','48000683501'
,'48000359701','48000360301','48000696201','48000341902','48000360101','48000359601','48000706501',
'48000360001','48000360201','48000667102','48000193901','48000193801','48000184901','48000508201',
'48000170301','48000185201','48000301601','4180021450','48000508301','3400031300','48000623201',
'48000202201','48000442301','48000202101','4124446256','4180020850','48000339601','3610000224',
'72698420031','72698420032','2870000024','5100000366','5100000007','3890000947','72698420040',
'3610000222','3610000122','2870000027','5100000336','5100011977','48000347801','5100006992',
'48000301301','48000348301','3680007903','3680004311','48000442401','48000441901','48000226901',
'48000442101','3680016750','48000227201','7468210301','48000307401','7468210327','3619212216',
'3680014411','3680016748','48000709201','7468210731','3619212259','48000227101','7468210717'
,'48000691401','3619212215','3680016749','48000711101','48000711201','48000590101','48000584201',
'48000560001','48000520001','48000590001','48000650801','48000201501','48000590701','48000653601',
'68596000001','76059010076','48000569901','7334700800','48000570101','48000744301','3997800461',
'3997800452','73788096055','48000522401','48000609601','9370930060','9370930040','48000644701',
'9370930030','9370930010','48000512401','8912531800','5137615111','5137611101','48000731901',
'48000732501','7511964724','48000732401','48000516601','48000732601','48000201001','1120600034',
'48000732001','48000665101','48000732701','62168302135','48000744801','7581000125','48000594701',
'48000194201','48000594601','4175550000','7020055600','7020000227','48000268101','48000167801',
'48000594801','48000194101','1122541574','72698414110','7372385507','48000594301','72698414111',
'72698414090','72698414091','48000202301','3890009081','2400001092','48000245001','3890003096',
'3890004000','48000268201','3890004205','48000167901','3890004215','1122541571','72698414010',
'72698414115','48000153001','1119418754','48000168301','48000594401','48000098001','2400001062',
'2400001745','2400006096','72698414108','48000594501','48000168201','48000267901','48000421401',
'48000268001','48000167601','3120001005','48000242101','3680014409','72698414126','4134536512',
'7372300103','72698414127','4134531712','7045016160','2400016700','72698414133','48000282801',
'4134515512','72698414128','3732313909','48000478701','1122506350','7707523059','7707523059',
'7075900005','73755003005','7372340081','48000105201','1119434819','48000340701','72698441009',
'72698441043','48000599801','72698441011','48000168001','48000260401','48000098301','48000168101',
'48000320201','72698441018','48000098101','72698441017','72698441016','72698441015','2400016299',
'48000167501','48000600201','48000260301','2000010453','2000010546','72698441042','72698441045',
'48000599901','2400001544','2000010419','48000098201','7372300010','48000248601','3680091114',
'48000431101','3680092314','1122541586','2400016308','1119431740','1119432755','72698441044',
'4125336003','2000010165','72698441047','2400016312','3470009612','3470009411','48000230601',
'48000260501','2418230011','48000243701','3680004307','3680004306','3680009720','48000592401',
'3680005609','3680009711','3680009719','72534228371','72534228571','72534229111','72534229121',
'72534238171','72534228103','72534228193','48000592301','72534229043','72534229373','48000234401',
'48000231901','7487316322','7487316325','2418200259','48000241401','48000241501','48000223701',
'48000305801','48000240301','48000234501','48000305901','4125300634','72698441040','4125300601',
'7372301015','4182000005','1119434041','72698441151','2400016320','7372399917','48000600301','72698441034','4182020110','48000280701','72698441046','7157955000','3710005816','4125300490','72698441230','4182001090','3900004512','48000677901','1122503963','3900004512','4125300400','3710005810','48000120601','4125300410','3900004504','3900004504','48000100501','2230000002','48000286901','48000103501','7182800160','7067000033','7321400608','7047500045','48000220701','7067000935','7372301510','7372310205','78532801995','4125336001','78532801987','7032084410','7067000524','7067000536','7067000507','7819204608','1122506358','48000129501','48000708101','48000196601','48000597001','72698429090','48000127901','2970000114','1600041610','48000128501','1600017799','72698441007','72698441029','48000600401','48000099201','48000599601','1122541590','48000600101','48000599701','48000098401','48000372201','1119432383','1119436871','1119437089','2700037831','48000179001','1119436508','48000707201','2700037837','2700037882','48000707301','48000707401','48000179101','2700038040','72698441023','48000600001','1122541593','48000599501','1122541592','2700039104','2700039023','2700039014','2700039005','2700039103','2700038807',
'72698441004','72698441003','2700038963','2700038815','48000179301','2700038811','7067000583',
'63898200044','48000391701','48000391701','7079630001','4125336005','7321400607','7321400606','7321400607','48000169401','79921098001','8775412031','7075912611','72698442014','72698442004','72698442006','72698442020','72698442012','72698442001','72698442002','72698442008','72698442009','72698442018','72698442005','72698442013','72698442019','3940005500','48000269201','48000233201','48000330601','4780033044','48000269101','48000269601','5200001248','4780034004','3940001617','48000268901','48000269301','48000098501','48000599401','72698441041','48000269401','48000269501','72698441024','48000260601','3680007250','3680007249','3680007254','3680007253','3680018145','7032080139','7032080171','48000383301','4119602035','72698442016','72698442073','72698442071','72698442015','48000137401','7276912226','48000137401','7276960508','5480001008','72698442072','74050094156','1740011840','1740011845','1740011840','1740011845','48000682401','48000682401','48000682501','72698442070','48000682501','1740010695','5480034429','1740011810','1740011810','48000403001','48000403201','48000275301','4600082341','1530043000','48000366401','48000366501','48000727301','48000594001','4300028521','48000312301','7317600150','48000625801','48000395101','2857100407','7107201303','48000742901','48000742901','7440111041','7440131041','48000438301','7440131041','7440191041','2857100448','7440191041','7440170432','7440141041','7440161041','48000415701','48000395601','48000415601','48000415901','2857100461','7440176033','7440199041','7440173432','7317600158','7613201010','48000415801','7067001022','7613201004','7613201005','7613295048','4239911016','48000100401','7323402008','3760026701','1700001686','48000335901','4800001191','48000336601','4800001197','4800001475','4800000086','8660000098','4800001480','82916920031','1122502084','7478510210','7478510280','5100010348','7478505280','5100002379','4800000062','4800000071','4800000072','7175934104','7175901170','4800000396','4800000303','48000336401','48000504801','48000336501','48000675401','4800000120','4800000195','48000336301','8660011451','8660011451','4800000399','8660010251','48000675301','48000722501','4800000523','8000049525','4800000009','48000675501','8660000025','48000703901','4800000095','48000504601','48000688801','72698412100','48000504701','8660025021','72698412103','4800000262','8000000145','4800000245','4256300600','8660000012','8660000011','4800001164','8660000031','8660000001','4800000189','48000336001','48000636601','7175902110','4800000065','4800000061','4800000191','3900008589','3760027554','4125300313','4125300250','4800000672','48000407401','48000147401','48000336701','7175902112','4800000068','7175900201','3480000400','48000336201','7175902111','48000280601','4125300314','4125300315','4125300290','4122417120','7067000785','4122460304','4122424620','4780000027','7067000643','4122415220','79852516320','7067000642','48000403301','7071800092','7071800101','7020023015','7020023035','5239148150','1122506314','7323000846','48000372001','5100002523','48000729701','48000349301','48000349401','48000371801','48000371901','4132124105','48000371501','48000396401','7110672007','4132124178','48000269001','48000282201','6414402115','7110672040','48000262501','4132124022','3760024687','48000262401','3900008568','3760018888','3760000001','48000261901','3760021629','4132124718','48000282301','48000346701','4132124830','2700044118','2700044110','2898901900','2898902310','75764567130','75764567130','48000656701','48000656801','48000656901','48000657001','78087208306','48000657101','70115937700','70115937704','1122502326','82927445117','7860141007','48000473901','48000075501','5000001489','5000005140','1780045324','2310021673','2310007103','3680008059','3680008062','48000235101','78087208506','78087208515','3680008025','78087208503','3680008024','48000145201','48000235401','8660000050','5000004060','48000345001','48000162901','48000343401','48000163801','48000644101','48000163301','48000164101','3680008692','48000235501','48000345301','48000345401','48000627901','48000163401','48000622501','48000197101','48000139101','3000008180','48000643901','48000343701','2310008541','48000369501','1780002063','48000138301','48000164001','2310021764','70115914702','48000715701','48000099801','48000070401','48000074901','48000234801','48000078101','48000235001','48000075101','48000139501','48000723001','48000069901','1780012631','7910049298','3810033346','3680008045','48000163601','1780001448','3810033022','3680008043','1780041124','1780011030','1780010164','1780040400','75764566010','75764566120','3680008015','75764566010','78087208015','78087208315','48000234701','48000726401','48000726501','78087208006','48000138901','3680008676','48000235301','48000162801','48000236201','48000163001','48000138501','48000715901','48000096701','48000097101','48000097201','5000036358','5000057211','48000344801','48000162701','48000096901','48000163101','48000410801','48000715001','48000144901','48000139201','1780013285','48000163901','48000698301','78087207802','78087207807','75764561200','75764561205','48000622401','78087207801','78087207805','75764561200','75764561205','3810011912','5000057475','3000007450','48000113201','48000235201','48000197501','1262373480','1122502519','48000113101','2310030705','1113200188','48000096801','3270001849','3810012853','48000375601','48000716901','3810010655','7910049300','1780012889','1113200681','3810012891','3000008360','48000502301','48000266201','48000163701','7910052300','7910090207','7000218006','1780050542','7910070010','1780029955','7910045127','3810010815','48000266101','5849670116','2310027795','48000475001','48000700701','2310027789','48000660601','48000574801','48000695601','65922324060','70115914117','48000582601','70115914200','48000627801','48000566701','48000628001','1262371012','48000072301','48000070601','48000072501','4133400103','1122502292','3680008660','7023010710','4133400102','1262399910','7023000071','48000072601','4460002001','3320002140','4133400154','3320015020','4460003073','4460002031','4460001311','48000069101','48000282701','48000070501','48000236101','3320002200','48000071701','48000072201','48000209101','48000073001','48000382701','76437581556','48000382601','7023010782','7023001606','7290400012','3680090217','48000673701','48000343001','3680011965','5000001051','48000573201','7107900005','4175600300','4175604012','3680095512','5000010152','48000234601','48000231401','2529360086','2529360088','7487396810','7487396860','48000296901','48000363701','6195400037','48000644201','48000105001','48000235601','48000240101','48000236601','48000122101','48000124101','68635280175','48000318901','48000123901','48000678901','48000687201','48000123101','48000123501','1500001341','48000123201','48000124301','48000113801','48000716001','48000716201','48000121901','48000241701','3680013295','48000240401','48000682201','5100001021','5100001047','5100001437','48000348501','48000351801','72698437002','72698437005','72698437004','72698437010','72698437011','72698437012','5100000660','5100001081','5100001621','5100004937','48000350701','72698437001','48000598801','5100000618','5100005887','5100005897','5100001291','5100001051','48000348401','5100001031','5100001161','5100001231','48000636501','72698437023','72698437033','48000599001','48000599101','72698437019','72698437021','48000598901','1122503482','1122503699','48000348101','48000718201','1122503696','48000346501','48000279101','48000572601','1122504151','1122503698','1122503483','48000279201','48000349101','48000351701','48000351901','48000352401','48000351601','48000350901','48000350801','48000351201','48000351401','48000346401','48000390701','48000390701','48000395901','48000395901','48000571901','7154020005','48000300601','48000390301','48000726301','7423544100','48000275201','72698437028','7423528451','48000274801','48000281201','4100000324','4100000332','48000390401','48000208301','9830800209','48000337801','48000409101','4318200394','4318200391','4318200393','4318200392','4125875119','4125875120','48000281301','48000281401','72698437016','1122541610','5100002107','72698437017','48000703701','48000349201','48000572701','48000279301','48000350401','48000352001','48000562901','48000352301','48000678501','5100002430','5100015634','48000727201','48000390201','48000609301','48000652901','48000609301','48000484801','48000484901','8105705633','8105705635','48000484601','48000484701','48000395301','48000185801','48000744401','48000690401','48000690401','48000337401','9830800210','9830822581','48000623801','48000185901','48000365901','48000395801','48000521201','48000589301','48000239001','48000223501','48000223601','3574222103','3574222104','3574222401','48000592701','48000655901','48000363301','48000242401','48000363501','5260305400','48000626301','72698405017','3680014970','72698405015','3680014972','3680055816','3680021179','72698405030','72698405014','3680013696','3000007840','3680014597','3680008506','72698405012','72698405029','48000238901','72698405028','48000131301','48000234201','3800000810','48000239901','3800043031','48000310801','3680014977','1600027511','48000129801','48000130001','48000130801','48000130901','1600026344','48000709101','4300018059','3800001411','48000129701','48000410201','48000130201','3800039116','3800039125','3800039132','3800000110','48000130301','1600027554','48000308801','48000198001','4300018050','48000309201','3800004530','3800042875','3800043239','48000131401','3800001932','48000263801','4300011460','4300018005','4300018062','4300018160','4300018170','48000129601','3800027357','3800030400','48000710601','3800039492','1600027472','1600027538','3800022775','3800024490','3800030402','3800037399','1600042973','4300001786','4300002639','48000310601','3000006860','3000006150','48000198101','3800005332','3800003530','1600040945','3800031844','3800001302','48000310401','48000310301','3800000828','48000131601','3800000600','3800031834','3800031846','48000132001','3800031829','3800039134','3800087010','48000197901','3800060160','3800066330','48000306301','48000593501','3000026335','48000593401','4144940006','48000593301','1313000698','48000681901','48000198901','48000115501','48000115601','3000001554','48000306201','48000197201','5000029155','3000002190','4144905055','7246300021','8634133001','5900003975','7246300026','7246300024','7246300032','7246300020','7246300020','48000244201','48000132701','48000264301','78928098118','78928099118','48000099601','4240091378','4240091078','4240090478','48000306501','48000306401','4240091678','4240009764','48000306601','4240091278','48000306701','4240009769','4240093978','48000375501','4240009772','48000344901','48000345201','5000053172','3680015117','48000584101','3680003456','3680007511','3680015119','3680006257','3680006259','48000369201','3680006258','3680012008','48000368501','5571206701','6667629008','6667699032','3997800105','3997850103','3680014117','48000143901','3680014168','48000241301','1862701234','48000230301','5844943002','48000475301','48000143001','48000705601','48000691101','48000154201','48000475401','5844941000','5844941001','7130000023','48000402101','48000402201','7130000023','48000402101','48000402201','48000402001','3340007010','48000215401','48000215501','48000215701','48000215801','48000402001','3340007010','48000215401','48000215501','48000215701','48000215801','3340006508','48000215601','48000402401','48000402501','3340006508','7130000080','7130000081','48000215601','48000402301','48000402401','48000402501','48000595801','7130000080','7130000081','48000402301','48000407301','48000595901','48000720401','48000407201','3340007011','48000402601','3340007011','72698423028','48000402601','7130000090','48000331001','7680851558','48000456001','72698423009','7130000090','48000710901','48000456101','48000595701','48000100601','48000101101','48000719101','48000330801','48000456201','48000330901','48000402701','48000455901','48000402701','48000456301','48000663701','48000168501','48000281001','2409407001','48000404801','8147571412','8147572543','8147590123','48000486801','8147540556','8147571688','7151800017','48000700101','2409427012','48000404601','8147594567','7038110015','48000404701','7140303210','7140303210','48000583601','48000610201','2409421101','2800069180','39153211605','39153211643','2409407078','2409407118','83292400570','48000104901','48000231701','48000231601','48000507301','2706457011','48000490601','79921066661','79921054540','48000704601','48000231501','48000708901','48000709001','48000152201','48000149401','1122502881','72698423501','48000596001','2100001373','2100001254','48000149601','48000149801','2100001721','2100065321','2100065655','2100065894','48000099401','48000357901','48000666401','48000132801','48000128401','48000346301','48000650001','48000403101','48000432201','48000423701','7293469248','7293469266','48000628901','48000698501','48000234001','7341605091','75928340003','48000115801','48000116201','48000623301','48000228001','48000462201','48000593701','48000100301','48000148401','5100017345','48000348601','48000352101','48000227501','48000227901','48000148601','48000276601','3620003800','48000227701','7248600130','3620000550','1700000389','63898200010','63898200013','48000103601','7071800108','7071800109','7071800110','48000428101','4119607105','48000395401','48000610001','48000664001','4119606082','48000486901','48000572101','48000612801','48000594101','48000594201','48000401901','48000127201','5150020441','1600018980','48000127301','4163100056','5150042000','1600010710','1600013310','48000273501','1792900028','3320001155','72698403050','3320001710','3320001110','76172098818','3320001140','7985100424','1990000320','4161700220','1990000385','48000624601','5000025045','5000027045','3997800309','85756500000','3997800304','3997800125','3997800462','3997800454','3997800456','3997800467','48000272101','3997800464','3997802987','3997801381','73041600009','73041600005','73041600007','73041600010','7511912448','73041600001','3680018646','3680018647','3680020170','3680020171','48000308701','4144930015','48000308301','48000279501','48000308201','4144900140','3800007010','4300095802','8449303124','48000268701','48000380701','3915600004','7142902434','4123470911','7065100200','4123441611','3915600007','48000726801','1122504195','48000354301','1600045410','1600044030','48000285501','1090000383','74599890101','48000128901','72698401000','5150076642','5150000285','72698401001','48000127801','48000356501','4144930006','48000129201','48000357501','48000285601','1600014797','48000129101','48000285401','48000128201','48000099701','48000140301','48000354401','48000418001','48000418101','4144930011','4144930129','48000285301','48000132501','1600027184','5150065330','48000127401','1600044530','48000132201','7596810504','48000451301','48000285701','4144940028','5833601501','70875800101','48000583801','5833615300','5833615250','70842308011','48000656001','70559901117','48000748901','1122507501','1122507503','1122507502','48000368401','1122507500','5446700431','5446730254','5446730250','5446730256','5446730258','1600042940','3680009876','4144900135','4144940024','3680083880','48000474701','7891318606','7891317028','5110007903','5110007930','3900004521','3900004521','48000352701','5110007927','5110007915','4164200111','48000298001','48000298001','76848810019','70210104533','70210104543','48000366001','70210104503','70210104794','4164200149','7065000005','70210104513','70210104523','7065000006','6970230011','6970230013','48000573301','73449217561','73449270339','48000354801','48000105601','76172005140','48000178801','72698439000','48000624501','72698439003','48000723501','72698439001','48000263301','5150000956','4300000037','64420929047','48000570601','48000705301','48000705201','71028232832','71028242832','1600019426','48000285101','2996800189','72698402201','1600028282','3979600270','4144900202','4144905000','4144905010','48000285001','3000005300','4144900160','48000284901','48000168401','1480071249','5390000031','48000197001','7245788066','48000442701','4163100055','70559901112','48000488101','4144905005','7468300551','3905955112','73449287005','73449287005','7489000112','48000506901','5446700461','6827000301','6827000302','72698439100','3905972984','7222080594','7222080545','7222080546','7222080570','7222080571','7222080574','7222080575','7222080576','7222080577','7222080587','7222080597','48000415101','48000415201','48000415301','48000119701','7222080555','7222080567','48000182701','48000182901','48000182801','48000182601','4245605052','4400001837','48000318201','4400004557','4400004558','3010038387','48000168801','3010010135','48000128701','3680011962','48000200001','48000676501','4400000365','4400000068','48000099101','48000231301','6731200525','6731200551','48000367401','4400000379','48000373901','48000237701','8201118371','8201191257','8201198466','48000738401','48000219201','48000318101','48000319001','2410041429','48000318501','48000318401','48000199001','4400000699','4400004631','48000199401','3010046445','4400000335','48000199101','48000318001','48000319301','4400000159','48000681401','48000680901','3010090011','48000681301','48000119901','48000319401','48000168901','48000199801','48000318601','48000320001','48000189001','48000318301','48000119201','48000119301','48000712401','48000119001','48000681201','48000681701','48000731401','5565366930','3361741001','48000365401','48000365401','7107200307','48000367501','48000306801','48000672801','3361759628','48000391901','48000208801','48000582101','7056910220','7056920030','7056935040','74988013090','5929057218','48000268401','48000672001','70175068433','48000684001','48000613901','7056981430','7056981340','39047014589','3904701458','48000683801','48000683901','48000623101','48000388901','48000234101','75928320008','3680015124','3680015126','3680015123','48000622101','48000622301','1410007487','1410008932','1410008943','1410008947','48000119801','1410007447','48000319601','48000241101','72698409120','48000317701','3680010220','72698409122','48000319101','48000264401','48000712301','48000199201','48000199701','4400000118','48000317601','72698409102','48000485701','48000319501','48000317201','48000199901','48000119401','48000119601','3680012218','48000168701','48000168601','48000319201','48000690901','48000673801','48000296701','48000501401','75928310046','48000661301','48000661401','48000116001','48000691201','75928310005','7341600023','4165104000','48000631301','48000395701','48000395701','48000587801','7110500001','48000102601','48000614001','48000103401','48000515601','48000164501','48000380601','48000439001','7731400202','7846642300','48000215901','48000164601','48000710801','48000380801','48000592201','7067000956','48000704201','74988011079','48000299301','48000367601','48000299301','60587000117','7581000015','7581000016','48000319701','48000561601','5929034237','48000369601','5929057461','48000631201','48000198701','48000723201','48000198601','48000198801','48000198501','1122502056','3680031032','72698409101','4400000064','4400000386','48000317301','72698409100','3010000133','4400000501','2020008511','4400002006','48000593901','3010018201','48000199501','3010042945','3010042950','48000317801','48000599201','48000599301','48000126401','48000126501','1580003048','48000002401','72698438000','1580003058','1122541560','1580003636','4480000101','48000591101','48000591201','4480000145','4480000102','30025810950','4480040250','4480000103','1580005012','4480045002','4480000107','4480075005','72277622701','4480045006','72277620180','72277620002','72277621002','72277623032','72277621004','72277620003','4480000144','1580008861','73449228730','48000607701','1580008913','72277623001','81097900120','71706723000','7180082830','72698432026','72698432027','2700061226','48000180101','48000356001','3377609500','72698432002','2700061286','72698432009','72698432012','3377609140','5150025362','5150025151','2700069086','5150099283','5150016948','2700069061','48000371601','72698432003','72698432040','2900007827','48000597701','72698432022','48000355901','6414403009','48000371701','6414403031','6414403017','5150023913','5010050350','48000385901','48000356401','72698432000','48000356301','72698432035','5150024275','4125311106','7040400022','72698432028','48000427401','48000597601','87358900016','48000357801','7040400008','7321000009','7321000017','7321000011','7321000018','72698432036','7321000054','87358900014','7321000051','7321000015','7321000013','7629000206','7040400116','7224826660','3915350045','85719000031','48000577001','48000577001','48000415501','48000606101','2325411121','85719000001','3915301006','48000342401','4125300037','2409448002','2409448002','4125300039','3915310019','85719000041','74504207016','3915310078','7321400635','48000654701','85719000021','2920500051','73449245590','48000103101','85719000011','82466200002','74747900050','3915310016','1122506025','72698432100','48000731301','3915301010','64850501500','4122470664','3915341279','3915341279','7067001111','3915301002','3915301002','4122470660','64850501500','70827151017','64850503500','2409448001','48000567001','85719000057','85719000067','3915310040','82680400777','3680013203','48000236001','48000234301','48000494901','3680008158','3680008491','7724150070','1251110500','48000459001','7724159128','72958201281','48000676001','71612312591','1251144641','3680013434','3680013435','48000718001','85832000005','1251144471','1251140600','1251160000','85832000002','4161700225','4161700225','48000501501','48000236301','3004290519','7638400097','3680014320','48000236401','3680009746','48000227401','48000227001','7724150050','3680007949','1730090791','1730090794','48000385701','7045024891','48000386101','7045074391','48000385801','7045084891','1730090792','1730090795','7045084191','7045004441','7045004151','48000386001','7045004231','1730090678','1730090680','7045014251','7045014231','7045004210','72698403010','4300027678','48000217401','48000613101','4300025235','48000312101','3400005200','3400005300','48000312201','3400014600','48000717201','48000185701','3400014830','4000002931','48000218401','48000613201','72698403000','7570003208','3120029451','4114309071','74759962018','48000673201','2800010233','2800010238','4114302956','4114308956','4114302570','72698415108','72698415101','88428404015','4114302870','4114302010','72698402146','4114302900','4114302460','88428404025','4114305160','4114308808','4114308908','80276333120','4114304100','48000637301','4114307020','48000276801','48000276901','3120000159','48000739101','4114307240','4180058050','4114307170','4114307125','48000431301','3120029450','48000637401','80276302880','48000637201','88428404220','4180058200','4180058290','80276307330','4180058000','4180058019','48000719001','2460004212','2460000039','2460000050','2460001086','48000597501','72698431147','2460001841','48000169501','48000103301','2460001093','2460001097','2460001700','2460001058','2460001041','2460001987','2460001981','1122502032','4760001012','48000361801','1122502287','2150000070','4760001006','4760002326','4760054961','5210000232','5210000257','5210000428','5210000843','5210074603','5210074604','5210000534','5210000696','5210000283','5210000438','5210000355','5210000284','5210082791','5210000352','5210000320','5210000332','5210000295','5210000626','5210000381','5210000448','5210000418','5210050102','5210082790','5210000298','5210000375','5210007091','5210007092','5210000426','5210000286','5210000838','5210000647','5210000698','4760062420','5210000236','8105702032','8105702035','4760003094','48000334501','5210000241','4760003113','4760003114','4760062409','5210007073','5210007078','5210000218','5210000251','5210000247','48000334601','5210000508','5210000261','5210000258','4760003180','4760003089','5210000292','5210000326','5210007450','5210052338','5210066585','5210082328','5210000442','4760003120','4760003134','5210000233','5210007107','5210016025','4760023055','48000334401','5210058187','4760003056','4010000392','1122502879','4760003118','4010000391','72698431103','8105702038','4760003099','3600651929','72698431100','4760003054','4010000268','4010000266','4010000351','4010000352','48000273401','4010000257','4010000241','4010000263','4010000262','4010000224','4010000303','4010000272','4010000294','4010000293','4010000211','4010000225','4010000273','4010000274','4010000275','4010000217','4010000356','4010000208','4010000282','4010000226','4010000237','4010000345','4010000349','4010000347','4010000223','4010000280','4010000357','4010000348','4010000204','4010000289','4010000249','4010000291','4010000325','4010000353','4010000270','4010000281','4010000233','4010000292','4010000339','4010000298','4010000304','4010000251','4010000284','4010000243','4010000267','4010000385','4010000234','4010000277','4010000319','4010000206','4010000231','4010000236','4010000309','4010000269','4010000260','4010000307','4010000297','4010000202','4010000229','4010000244','48000273201','4010000216','4010000315','4010000283','4010000258','4010000316','4010000271','4010000230','4010000302','4010000485','4010000218','4010000215','4010000288','4010000279','4010000207','4010000312','4010000227','4010000295','4010000209','4010000228','4760062107','4010000354','4760009152','4760062204','48000335101','4760062109','4760062186','48000335401','4760062114','4760062215','4760062217','4760062211','4760062112','4760002208','4760062111','4760062105','4760062218','4760002240','4760001015','4760009070','4760062404','4760002253','4760009015','4760002205','4760009020','4760002365','4760015050','4760015051','4760002289','4760062305','4760062401','4760062222','4760062206','4760062108','4760002280','4760002327','4760054967','4760062101','4760062302','4760009080','4760062208','4760062110','4760062219','4760062209','4760002314','4760062205','4760009065','4760002332','4760002335','4760002331','4760062202','4760002364','4760002251','4760002274','4760001013','4760012277','4760062207','4760002276','4760062213','4760012368','4760012369','4760002213','4760062220','4760062201','4760002168','4760002353','4760002112','4760002027','4760062102','4760002037','4760002254','4760002269','4760002019','4760002185','4760002318','4760012330','4760002216','4760002337','4760002333','1122502873','7199800001','4480000022','4480000401','4480000402','7038110009','48000157801','4010000622','4010000623','4010000617','4010000618','4010000615','4010000619','4010000624','4010000625','4010000626','48000243101','4010000296','4010000621','4010000620','4010000616','73402790160','48000360601','5210000245','5210035224','5210069313','5210056922','5210056923','5210058500','48000335001','4760009134','5210025213','48000334101','48000739301','48000360801','2150005850','2150000074','2150000450','7038110011','5210005712','2150000300','2150000036','7038110000','2150000052','4780000054','5210012267','5210022534','5210022586','5210022598','5210025711','7142912100','5210000361','5210000423','5210000539','5210000627','48000360701','5210084733','5210044163','8105702024','8105702026','7142901565','8105702022','8105702023','48000673501','5210044339','48000450501','48000361901','48000361501','48000665701','3915600008','48000384601','48000104601','8105701870','4799712385','4799713020','48000704501','48000710501','48000342301','8105701510','4430009428','8105701640','48000484501','4127800005','8105701985','8105701965','4799712385','8105701275','4799713020','8105701180','8105701966','8105701080','8105701641','8105701937','8105701440','48000361301','48000443201','8105701081','82680400888','8105701165','8105701170','7142912430','8105701840','8105701218','48000478101','8105701205','8105701960','8105701830','8105701450','8105701720','8105701890','48000335201','8105701325','8105701531','8105701453','8105701012','8105701350','5210044518','5210044639','4799713010','8105701420','8105701636','8105701750','8105701451','8105701421','8105701745','8105701650','8105701540','3600601408','8105701400','8105701240','8105701470','48000484401','7067000523','8105701250','8105701745','8105701245','8105701324','8105701090','7142910525','48000576901','8105701940','8105701611','7435000002','8105701653','8105701610','7067000511','7067000512','8105701095','48000441301','8105701310','66780300070','8105701260','1878810109','7435000003','8105701155','67236100030','8105701265','1878810250','48000666901','89954900049','4010000314','4010000317','4010000318','4010000334','4010000335','4010000336','4010000337','4010000338','4010000340','4010000341','4010000342','48000334301','8105702088','48000597401','4760009030','5210008980','4760009035','4150005834','48000277001','5210009860','4760008157','4150005802','5210060605','4150005848','4150005711','4150005712','4150005811','4760008242','4760008116','4150005845','2150020205','48000597301','5210009160','5210009180','5210027462','5210076067','48000361001','2150020208','2150022600','5210014260','48000334201','48000335301','4150008010','5210094269','48000360901','4150005773','2150011700','2150020200','2840000239','2150022500','5210065128','5210065188','4150005864','48000327501','48000327601','48000327701','3900000820','4150005890','7488200100','7239610000','7488200100','5210044288','7109200069','4600028874','4150103010','48000287001','4150008005','2150011100','4150005807','5210009140','4150005710','2150011300','48000521301','4760008192','48000334801','48000334901','48000335501','5210015733','5210051598','4760008252','7038180068','7038100068','4760008104','4760008283','4760008102','4760008274','5210052178','48000349501','48000114301','48000349001','5100015032','48000514501','48000514401','48000514601','48000361401','48000361601','48000361701','48000334701','3620006405','5210068452','48000361101','7038110100','48000104701','48000338001','4114901182','48000337901','48000338101','48000444501','48000521401','7488820201','48000337501','48000337501','3804125600','6205813984','1121000400','5150000025','5150002118','5150002501','72698410100','48000354201','48000423901','48000217201','5150002123','5150002511','5150002512','3400031500','3400000017','3400000125','3619212077','48000217001','3680064606','3010012724','3010029835','48000199301','48000417601','48000593201','48000559701','60069966073','4164200500','72698404005','60069966145','48000100001','4300021200','48000311301','48000311401','48000311601','48000179501','48000100101','48000311701','48000311801','4300021100','4300021363','48000309401','48000149701','48000150901','48000179401','48000179601','2070042701','48000312001','48000311901','4300022802','4100003500','7067000400','5833614111','5833600006','5833602220','48000368301','7334735500','4300025953','87251300602','2550006319','2550081121','2550081122','2550000365','2550006764','4300071085','72698407023','72698407026','48000256201','76211172857','76211172859','76211172857','76211172859','48000593601','72698407063','72698407062','48000615001','48000629901','48000629801','48000576801','48000620801','7056810010','48000623901','48000113501','48000569601','48000569701','48000716401','48000579201','48000624701','48000624801','48000624901','48000624901','48000445801','48000445701','1291912615','48000233601','48000113601','48000607401','7447100079','7447100075','2550000032','48000677301','2550000034','48000677201','2550000080','65272912955','72698425045','48000173101','48000343201','48000244401','1122542286','72698425032','5000030302','5000030162','48000241201','72698425030','5000030212','48000512301','48000512101','48000308101','48000310101','48000512201','48000406401','4300070700','48000185601','2800059643','7447100091','74599840105','74599840405','74599840300','4195302703','48000686901','71612312353','68995171225','68995111020','48000686801','68995131070','68995191000','68995171010','68995112020','68995112005','68995131010','68995111000','68995131060','48000235901','48000333601','48000390901','48000391001','7073407049','48000457001','7073405372','4744591921','4744591991','48000457101','7695045063','70708270008','7695045018','7695045036','48000685401','48000579101','63243296201','63243296801','48000566601','48000583201','48000749301','48000678301','72698407057','72698407060','72698407059','72698407054','72698407058','72698407056','72698407055','72698407061','48000248701','3680096672','5000060012','48000605301','3680096314','48000244701','48000126001','48000343801','1570005551','2800081320','48000126201','48000344001','48000343501','48000102801','75174603212','75174603361','1570005517','48000126101','48000241901','48000219101','48000689401','1122502882','1115605152','4100000845','4100000286','72698440000','2070000500','4100000271','2070000319','4100000267','1115605450','4100000287','4100000753','2800033980','4100000873','48000275101','68995111035','68995171140','68995171100','4100000847','48000366701','48000462301','48000149101','48000462401','48000416001','48000416301','48000416201','48000381501','48000381601','48000180301','7073400403','4100000848','4100000843','48000103201','48000416101','48000381401','7231007248','2040107640','48000663001','48000639601','7369562770','66780300090','48000683401','48000664801','3680014443','3680014444','89672300002','3680044017','48000104201','48000101501','7829121926','48000210501','3700043516','3700043515','7048101101','4460001151','81793900060','48000256801','48000475201','2570023223','48000641501','2570023223','48000321901','4460000604','1920000888','1920077182','48000321801','48000321501','48000321601','1920078914','4460030209','4460000450','4460030311','48000739201','48000210601','48000370901','48000640701','3700004249','81143500190','3680077382','1122502613','1980070110','48000146801','4191100050','4460000454','48000147001','1980010122','3680077638','3680077639','1122504044','1750004403','2340000240','79271600064','67811219497','3320035240','79271621050','1750004403','2570023338','4460001260','67811219490','79271600064','3320035240','67811256032','79271621050','48000164901','2570022172','4460001263','67811219492','2570070164','4460008033','4460030057','48000164801','48000174001','2570022174','4460001580','48000321701','4460001195','48000174801','4460001204','1920002699','4173726076','2570070079','75703735018','75703735015','3680011341','4650022220','3700032695','3700034285','3680011342','3680011343','1920005432','4650000182','4460014901','4460014902','3680011344','3700008441','48000257001','48000257601','4460014903','3700030942','3680077379','3320000855','1122542356','1121804645','4650026363','4129440174','4159816018','48000281601','6233801863','4460000453','4650012128','48000329101','4650070350','48000328301','1112410014','4460000229','1980000116','1980012738','4460000221','1980000111','4460000228','48000697401','4460000214','1920080306','1122505476','4173726901','3680013510','2120097852','2120097878','4460014882','48000321401','48000146101','4460000451','48000174701','2570021548','1980000117','4191100824','6233800178','48000370501','3320006800','48000096601','1112100040','7161811510','7829116911','4159814038','48000470801','48000255801','4331813022','7829131082','48000255401','4159800054','4159800052','4159800050','5113197289','5113197296','5113197270','5113197271','4159880807','81793900401','81793900084','81793900731','81793900732','48000640801','48000640401','81793900562','81793900008','85695400000','85695400002','85695400004','85695400003','48000242601','48000242801','5908021002','72899721000','71725600053','72899722000','73291322714','73291355501','73291355503','4650014324','48000329601','48000146001','4650061577','4650061581','48000330101','48000707101','48000174401','4650061829','48000255001','4650070340','4650070341','6233878047','6233880339','4650000684','4650070342','4650017888','48000370701','4650023314','48000329301','2340033045','48000707001','4650017598','48000328001','48000328101','4650015877','3700012587','48000250901','4650070349','4650070533','2340033042','48000370601','6233805768','48000165101','48000328201','48000329401','48000146901','48000253501','48000165001','4650061649','48000641101','48000329201','48000329701','48000330201','48000641301','48000641201','7954222007','48000520301','48000641001','48000688201','48000711301','4650015476','48000329501','48000209701','1112000534','74267830014','48000330301','1112000399','1920000601','1920000619','74267810002','7973800032','48000688101','48000209301','3700035535','3500033860','48000258401','3700035534','3700032368','48000099901','48000221301','3500043300','48000233901','48000640501','88596743528','48000254301','3700000614','48000249801','3700011094','48000254201','3700042902','3700014389','48000322501','48000220801','3500046902','48000254001','48000254101','3700000080','48000244601','48000254501','5170078234','48000248201','48000257301','48000257401','48000248101','5170075708','48000221201','3500047805','48000358501','3700000634','3700000635','5170080312','48000358401','5170036565','48000242701','5908012022','5908020002','48000104801','48000518201','7261301107','48000244001','48000243801','48000258201','48000096001','48000209501','48000209601','88304906690','3700013844','48000326601','3700012873','3700012786','48000247501','3680022049','4460001692','4460002450','48000322101','4460002901','48000322001','48000247701','4460030036','4460003096','2420000981','2340000201','80575225547','4460004690','48000322301','4460030038','3700001870','75703751555','3680077645','3496937816','4650002274','48000328901','48000697301','3680013363','75703751244','75703751693','75703751515','75703751299','6233877667','3680077641','4460030218','3700019737','3700019743','48000256301','79922800903','48000250101','48000709401','68727311106','48000704301','7044491208','4650002246','6233800006','6233800230','48000169301','48000257801','48000250801','48000258901','48000247901','48000242201','48000247801','3680077410','48000248001','48000209801','3320014271','48000251001','48000259301','48000660701','2240000441','3700033697','48000370801','7061000501','7061000503','7061000500','7061000105','7061000518','7061000115','7061000519','1440082000','1440083000','1440083000','1440061171','1440061171','1440061162','1440061162','1440061170','1440061175','7061000087','7061000070','7061000088','7061000071','48000120501','1440061180','1440071400','1440024100','4300029343','1440071200','4300029320','4300029106','4300029322','7851212001','48000077101','4460030059','4460071724','48000076901','1122505740','3680017433','4460071254','48000102901','48000103001','48000276701','4460030215','1122504224','4460073137','4460071711','4460071701','4460071723','4460071700','4460071706','4460071176','48000070901','1122504610','48000071101','48000101701','48000071001','4878911003','48000287701','48000069801','48000008801','48000070001','4878904530','4878902122','48000002301','2460001500','1122542304','3680077301','3680077303','3680077299','1090000024','3680077302','1090000114','1090000021','3680077327','2570000130','3680077326','48000246601','3680011394','1258700020','1090000531','1258770441','1090001331','1090000392','48000112501','3680077307','3680014164','1122542314','48000174101','48000246001','3680011397','48000112701','3680077306','48000245901','48000173801','48000246701','48000246801','48000246901','1258770707','3680077314','3680077310','3680077311','48000246201','48000246101','3680077319','48000173901','3680077324','48000246401','48000246501','1370081222','1370081417','48000116501','48000174901','2570015621','48000174301','48000173501','48000173601','48000698401','48000094801','2570001143','3680077312','3680077313','3680077317','1090000510','1090000590','1122505784','3680077325','3680077354','3680077365','3680077353','3680077350','48000247001','1258760172','1258760933','1258770067','3680017420','3680077375','3680077355','3680077363','48000247401','3680077349','3680014272','48000116401','48000247201','3680077352','48000247101','1370020920','48000112901','3680013345','1370000662','1121798611','1121798610','48000173701','3680077332','3680033592','48000243001','1258770129','48000174201','48000174501','1258778082','1258778082','1258770108','1258770108','1258770240','48000112801','1258770240','48000112801','48000174601','1122564124','3680077269','1122502099','3680017498','48000243301','3680077270','4200014207','48000243401','4116501739','3680077446','48000248301','48000709501','48000709801','3770032279','48000262901','48000729301','48000244901','48000303001','3770032226','3680077272','3680013437','3680017501','48000243501','3770032348','3680013761','48000240901','48000241001','4142600991','3680013756','3680013757','3680013758','48000238101','3680010923','48000340801','4878941860','3680013753','4878941265','3680077440','3680077449','48000248501','4200015627','4200043295','3680077448','48000248401','3680077267','3770038254','3680017502','1122502320','3680077265','4200015613','48000277201','3680077273','4200014011','4200043900','4116539020','3680014334','3680077268','4116508799','48000727601','48000727401','3600025152','3680077284','3700007548','3600028110','72698426005','72698426006','3700007545','48000226001','3700033549','3600028100','48000225901','3600028200','3600028201','3600029490','48000226101','3600029440','48000677601','72698426013','3770033334','72698426012','7331045200','3680077292','48000709601','3600046150','4200035501','1122508032','1122536952','48000252201','72698426703','72698426015','4200096031','3600072484','48000200501','4200096042','4200086532','3040076103','3040076388','48000200401','3600072442','48000252101','5400042401','3600067207','1122504403','72698426009','72698426011','4200044711','72698426285','4200044702','4200044811','4200044845','3700016821','48000255701','3700021359','48000365001','5400016445','3600019208','3600019266','48000225201','3600014190','6366835104','3680018007','3680018009','3680018008','48000230401','48000311201','3680014725','48000712701','3800034352','48000265101','48000244301','4300001760','1600029860','1600066450','48000263701','48000197701','48000263401','48000264201','48000718301','48000128601','48000714301','48000714401','1600014624','48000127701','48000265201','48000265301','3800044548','48000197801','3000045130','1122502047','48000242501','48000264801','48000127601','48000264501','1600017314','48000128101','48000128801','7912600830','48000712601','48000674701','48000598201','48000107201','48000190201','48000192701','48000598001','4886731216','48000724601','48000431801','48000598401','48000468101','48000729401','48000188901','48000192301','2840007096','2840007097','72698429085','71921210105','2100001374','2100001376','48000190401','2840007089','2840002658','2840007835','48000189801','48000191401','48000253901','7492340527','48000128001','48000129001','48000132401','48000262801','48000522301','1600028370','1566560104','48000125901','75535500210','75535500214','48000429001','7698254501','48000722301','48000727801','8411410597','48000495101','48000126601','48000495201','48000495001','72822901315','48000126801','1122541633','48000597901','48000186501','48000452101','48000452201','48000717901','48000729001','2700048089','48000179801','48000129401','6414415050','48000129301','48000180001','48000148301','48000186301','48000216301','48000179901','48000597801','72698433001','48000186401','72698433061','2900007337','2620000710','1122502827','48000296801','72698433072','72698433073','72698433079','72698433070','72698433071','48000598101','48000195801','72698433076','1122502828','2900007280','72698433062','72698433063','48000296501','48000195901','48000296601','7299204002','72698433055','72698433060','2900007345','48000195201','72698433054','72698433075','2900007215','2900007328','48000195601','48000195701','48000195401','7299204019','48000424101','72698433056','72698433058','72698433057','72698433059','48000176401','48000092001','2620046878','48000092101','48000176501','1030080321','48000195301','2900007313','2900007329','1411373406','9510817100','1030093621','1030086301','1030033601','1030033301','48000233801','7038110040','3000027163','48000372101','6414410974','48000576201','2700060716','48000521901','3000002913','48000620901','18033245108','8558204111','85685600103','85685600104','4256300876','4256300923','72698433065','72698433068','48000683701','72698433067','72698433066','48000312401','48000738901','4300095350','4300095353','48000309801','48000312501','48000308901','7239285100','48000388001','48000664501','4300090248','4300010340','48000310201','48000309301','48000312601','48000309601','48000309901','48000310001','48000171601','48000303201','48000565301','4900003075','48000565201','7800001840','48000468304','48000469106','48000469803','48000690804','48000469403','48000468402','48000710002','48000568701','48000568802','48000568804','48000568805','3410066805','9879431304','5096833001','48000703501','48000469602','48000469502','48000703401','48000598701','7800014545','8634191240','7065596030','7065596030','48000598601','7065599478','48000389901','1660000074','1660000071','7065590412','48000390101','48000134401','48000134401','7065590121','7184509830','48000415401','48000104301','7065593521','48000390001','48000101801','48000394501','48000628301','48000628402','7246300027','48000387301','48000571101','48000628302','48000134501','48000134501','7549600040','7065591221','48000672601','65487104901','48000620701','65487100903','48000645601','87917400011','7514000515','48000603201','48000001601','48000001701','48000003601','72698461506','3768800010','48000070301','72698461505','48000428301','48000072801','7114222439','7114242378','7114200948','48000568601','48000134306','3049488122','78616250700','48000569202','63256500002','63671110107','63256500001','48000068901','18473900013','48000598501','48000662703','48000662803','48000662709','63791011389','63791021773','48000104501','48000104401','48000452802','48000569102','48000705405','48000452602','48000109101','48000641809','48000392002','48000392006','48000392103','48000392105','48000568904','48000641610','48000562505','48000562506','48000562510','48000392005','48000392104','48000641611','48000641612','48000564909','48000718105','48000562804','48000562805','48000562809','48000109206','48000108104','48000108106','48000109204','48000392302','48000392306','48000392305','72698477027','72698477029','72698477030','7294570544','7222010070','7222010071','7313035200','7222000006','7294560133','7294560154','7294561012','7313038005','72698477120','72698477121','72698477122','72698477123','72698477124','72698477126','72698477216','72698477031','48000603801','3149324242','3149382888','3149302160','3149354371','3149324242','7294571589','7294571588','48000495401','8421300078','8421300662','48000495501','7313000161','71873800051','71873800052','71873800054','48000588401','7067001101','7056985240','2018200310','7304015410','7304000205','7304006210','7304006250','48000425201','7304006215','76011614610','7294511305','7102505723','7294555065','7304006305','48000425301','76011600050','7222000077','76011600050','2415212377','7294576444','7294535066','7294535068','7294535069','7294535070','7294561003','7294576431','7294576430','72698477110','72698477111','72698477113','48000604101','72698477112','72698477226','72698477228','5960800800','72698477108','7304015400','7294555044','7222000193','72698477104','72698477218','72698477220','72698477224','7313000036','7313000078','7313000079','48000426301','7294576146','7222000233','7222000234','7294560146','72698477106','48000604001','5040075116','72698477116','72698477131','72698477401','7294575116','7294576145','7304000558','7222000235','7222000271','7222000232','7222000296','48000443301','48000443301','48000678101','48000678201','48000119101','72698477009','72698477009','7432309501','7432309523','7432309104','48000437801','4500000001','4500000001','4500000002','4500000002','4500000014','4500000014','4500000025','4500000025','4500000028','4500000028','4500000029','4500000029','4500000031','4500000031','4500000037','4500000037','4500000039','4500000039','4500000041','4500000041','4500000096','4500000097','4500000098','4500000139','4500000139','48000325001','7432309104','7432309113','7432309122','7432309123','7432309145','7432309157','7432309173','7432309501','7432309535','7432309585','7432309103','7432309182','7432309183','7432309506','5739140002','48000398201','5739140002','7432309524','48000373101','7432309971','7432301061','7432305156','7432304704','48000430101','7182800105','48000429901','7349012383','7270020038','8468500009','8468500005','7022750125','7754478930','7022750181','7754482600','7022750008','7270010188','7270010217','7042000801','7022750064','7022750166','7754480620','7270010128','48000274901','7270010404','48000421001','7022750063','7022750051','7270000007','7270000011','7270010413','7693700285','48000420901','7270000048','48000420701','48000420801','7270000738','7270010202','48000382401','7270000064','7270006235','7349000000','7270000099','7270000037','8468517007','8468540004','7270010084','7270010181','7270010208','7349013104','7349012833','48000430001','7270000473','7030302216','7270010079','7270010096','7270000041','7693799000','7349012501','7270000003','73537560125','7270005606','7270010180','7270000090','7270000091','7270020001','7270000173','48000189301','48000596801','48000320301','48000320401','72698429082','2840000417','4600027918','4600081101','48000268301','7488201060','48000191501','48000432001','48000192201','48000189901','48000596901','48000596701','48000480301','48000280101','48000280201','48000280101','48000280201','48000148501','48000588901','48000294701','48000295301','48000295101','48000411501','48000411701','48000294801','48000295201','48000411601','48000411401','48000287101','48000411301','7210101265','72698429083','48000280301','48000280301','3900001039','7210101270','3900001001','3900001021','4150101006','4600083251','7210104620','3900001010','7210104650','3900001011','48000597101','48000411801','48000327801','4430010645','4150110008','4150100898','4600086031','48000287201','7210101519','4150111008','8062141163','48000731601','48000560901','48000100201','48000560801','3390750012','48000216701','48000216501','48000216601','71921210102','2013813611','48000147701','48000295501','8634113140','8634190112','8634190212','48000713201','4856422012','7373100766','48000702401','7373100419','48000702501','48000702201','48000724701','7373100116','7111700109','7111700112','7885802018','7885852039','48000686601','7934106008','7373100240','7373100118','48000724801','48000340301','48000708701','48000431701','7373100205','48000708601','3723200104','7934101176','67979000026','48000578401','48000578501','48000578601','67979000559','67979009026','67979000030','67979000915','67979000053','67979000683','67979003910','48000717301','67979001054','67979002642','48000710301','67979002662','67979002673','67979001601','67979001631','67979001661','67979001651','67979001653','67979001672','67979001685','7698242410','48000578701','67979002652','67979005634','67979005663','4856400118','48000701701','48000726001','48000701901','4150584108','4150584109','4150581200','4150581201','4150581202','4150583001','4150583017','4150583101','4150583104','4150583115','4150583119','4150583124','4150583125','4150583142','4150583223','1238800005','48000109601','1200500572','3508412116','3508412111','3508412104','3508412107','3508412107','7124001166','48000222801','3508412150','3508412151','3508412151','73508412152','3508460416','3508412216','3508412204','3508461022','3508461022','3508461016','4133102146','3508412122','48000071401','48000071401','3508460422','3508412222','3508460422','3508412222','9733900002','68670010124','3862900112','68670010125','48000580201','3862900113','68670010140','68670010123','68670010134','68670010150','68670010130','68670010133','48000580101','68670010141','68670010139','48000337201','48000615801','1238800008','48000615901','3046700001','2800092112','2800015785','48000205601','48000453501','48000453601','8766606616','9047821627','2986000301','72986000101','8615475139','48000515301','48000306101','48000515201','8615415131','2800051720','7885300305','68670010129','48000002201','2800051780','7239200309','48000608201','72486900019','48000693401','4800171127','48000693301','48000423001','61994210101','4122470806','4345607690','4345607700','4800171104','4800171103','4800171111','4800171138','4800171112','48000337301','7013207012','4800171108','4800171128','7538604986','7538604968','7538604975','7538604967','7423499113','7639700112','7639700312','7287828533','7538604974','7236000084','7423498113','7287828536','7639700212','7639700307','7538604701','7639700511','7287828543','7423499115','7423498115','7013200500','7538604966','7538604858','7423499112','7639700107','7538605643','7639700907','7639700128','7639700207','7639700328','7423498112','7639700828','7639700528','7538604976','7639701028','7423495113','7538604965','72745200011','7639700412','7639700412','7423459215','7639700228','72745200031','7538604973','72745200270','7538605124','7287828538','7287828548','7538604868','7013200603','48000398701','48000398601','7013200600','7013200100','48000380901','48000381001','7013200700','7013200750','5239185150','5239185151','7287851524','7287851527','7124000865','7124001132','7639720218','7124001167','7165100200','7165100202','4886711006','1587801250','5150016640','3729791447','4886711007','3729794447','5010050511','5010050365','5010050438','1200500007','4150112008','4150112017','7287827526','7788588200','7788571061','4973300005','48000436401','9733900003','9733900001','7013200501','9733900005','1295710001','48000228101','7236000208','9733900004','9733900006','7788589202','48000157601','7013200461','7287850523','48000324501','7538604995','48000447901','7236000005','7287827523','7287827533','7287827543','48000453401','48000453401','7236000202','7287827558','48000423101','7236000203','48000416601','7287827557','48000338301','1060962862','4886730305','1060980299','48000436301','7013209911','48000196101','4430012171','4430012330','48000743201','48000742301','48000743501','48000742801','48000742701','4430012350','48000743401','4430012111','4261407006','4261407005','72155746081','1115209939','7613205002','1115203194','7482103008','1115223835','7613205022','48000742501','73805551691','1115203851','64595600102','73762801700','7613205015','7613205023','7613205024','7613217021','1115245304','48000678701','7613217033','48000431201','7613299000','48000451901','7613217007','7613218001','7613217008','1115209633','1115204283','7254618138','7065080038','4783400005','1115220508','48000743901','7889513656','7889513655','48000743601','7889513654','7889513646','7889513652','7613209003','7889513657','4139000001','1121000918','7889513651','4139001052','4139002150','7356200090','18250300010','7581002125','7613209240','18250300004','7613205016','48000451701','7613209020','48000743101','7613209022','7613209034','7613209026','4139002045','1121000818','7389955250','4139004760','72233781904','1115206828','7613209029','1115209645','7613209025','2446306107','7613209030','7613205019','7613209021','7389901175','7613205018','4473807231','7980971945','4139000191','7613209030','7581002325','2446306104','7980947240','48000444401','4430012513','7581011225','7581014025','7505000616','48000445301','48000738301','48000284001','4139000002','4139000005','4139002060','48000743701','48000743801','1115209627','1115228647','18250300035','48000743301','48000742401','7627700986','7627700989','2800051212','48000184401','48000284101','3739831025','8817701104','48000239801','7581000425','4473807234','48000743001','73762800300','2446306116','7627700992','73762800300','2800023529','48000283901','8634180416','74281231012','73762800510','4139000110','74281231012','48000509501','4139000145','73762800510','4139000140','6970210003','7357554300','4139004200','48000284601','4139004120','7613213001','7613213003','48000430701','7356200230','48000451801','7613213002','48000444201','1115281760','2540780310','2540780350','4139003086','48000444101','4783400006','7737704830','7737711302','48000444101','48000444301','7357527725','73796400025','7357529539','73796400025','48000389501','7613211201','7613211001','7613211002','7613209012','7064100005','7357529550','7064100008','4139000460','7627700867','1115204730','48000097401','7627700983','7613209010','7613209015','7627700856','1115202140','1115203263','7613209007','1115206759','1115203260','7357597039','48000659001','7937700100','7356200055','7114631111','1115201057','1115202780','48000742601','4122483700','1115229100','7314115004','7314115005','1115285174','7314115083','1115285168','1115285171','73796400040','48000089101','73796400060','73796400060','48000678801','4139000802','3114627060','48000452901','7618600018','7114600014','3114615060','3114615030','7336610084','3114615030','3114615060','2446306109','4139002050','7737736196','4139003084','48000284501','7336610082','7336610089','4139000160','7441045509','7441025025','7482300114','48000609401','48000609401','7613216006','48000742201','48000652801','48000652701','7065080005','7065080013','48000609501','48000609501','73762802660','7065080082','73762802530','73762802525','73762802530','7065080009','73762802540','48000609201','73762802540','48000609201','73762800100','73762800400','73762800400','7065080021','48000389601','7065080031','73762800500','6264606075','4139005004','4122487500','1122506709','73762807950','1115245343','1115203362','1115203023','1115202023','73762800600','73762800600','1115208335','1115227641','7175703001','1115217475','7281029358','7281029360','48000137201','7182800192','48000571801','7356200500','7093500700','7488002002','7114600011','7093500711','48000625701','48000653001','48000609101','48000609101','48000366601','4139001556','48000097301','7482300021','4139002081','7613213010','1115202401','7488002002','48000121501','80453111025','1115205043','7065080012','1115201249','4139003082','7613204004','4473801843','48000284401','7314115003','48000644401','67810817111','1115201096','7441056523','3114615691','7613213012','3114615691','1115202786','48000284301','84190502011','84190502021','84190502031','84190502041','84190502051','84190502061','6468427010','78888926504','78888926506','78888926507','78888926508','78888926511','78888926512','48000375301','78888910520','78888910365','78888910405','78888928406','78888928439','84190501061','78888910201','6927604012','78888910295','78888926505','48000375401','6927601200','6927601205','81818700004','48000375201','6927601260','6927601215','6927603217','81818700002','78888910200','48000650501','48000650501','48000375101','6927603200','48000375001','48000650701','48000650701','6205821024','78888910091','80599300021','80599300051','80599300111','80599300131','80599300151','6205816462','6205816470','48000650601','48000650601','6840080413','48000374401','78888910001','78888910076','48000650401','48000650401','78888910112','78888910048','78888910277','85361000112','78888910211','85361000101','78888910113','6205881640','85361000100','78888910210','78888928521','6840056311','85361000102','85361000119','48000722101','78888910220','6840056241','78888910046','6840056371','78888910181','85361000106','78888910007','78888910019','85361000117','48000721801','48000721901','78888910172','78888910082','78888910123','85361000109','78888910083','6840056291','78888910115','4371728010','4371728050','4371727730','4371728150','4371750640','4371728120','48000266901','3827479545','7550200001','4371729485','4371729510','7819205055','4371728240','48000326101','7127000729','7819204056','7819204883','4371728760','4371728790','48000564701','4371727740','48000520401','48000520501','48000388201','4371732680','3827451611','61661800241','9783100500','3827473601','3827442528','3827441505','4371732690','61896477152','63898200060','7107201136','7107201136','63898200009','63898200011','2682501853','2682501854','2682500968','2682500879','48000125401','1522937519','1522937749','48000125401','7079670001','48000629701','48000629701','78532801991','48000744501','48000744501','2682500409','48000416701','48000416801','48000416901','78532801991','2682500409','8440757103','8440757104','74747900003','2682500403','2682500404','2682500405','2682501500','2682501200','2682501201','2682501202','2682501203','2682500892','2682500891','2682500893','2682500889','2682500890','3915313037','8939710881','2682500772','2682500111','48000417201','3915311003','3915311013','3915311015','74747900005','74747900009','3534280006','3534285006','3534287006','74747900008','74747900014','3915321163','3915311001','3915312019','3915314031','74747900026','74747900029','74747900031','74747900034','74747900036','74747900075','48000612901','2682500959','2682500967','2682500963','8440757100','8440757101','3915321160','3915321164','2682500400','2682500402','2682500407','8440757106','48000417101','2682500401','7067001116','75512200003','75512200020','79285135441','48000621001','79285135690','79285135580','79285135595','79285135596','79285135633','5150028663','79285135461','79285135464','7241711314','79285135556','7241711315','48000633501','79285135592','79285135591','7241711316','48000633601','79285135654','5100015134','78996800002','75678100056','79285135686','79285135565','79285135566','7241708540','79285135471','79285135546','79285135593','79285135594','79285135517','75678100055','79285135630','79285135632','79285135514','79285135493','79285135500','79285135515','48000633401','48000582401','79285135687','69963200066','92069692233','7241743173','9128223464','7241723042','5018919529517','69963200067','72069691235','66780300213','66780300212','7350060000148','66780300095','79285135473','79285135497','79285135522','20670200000','20672000000','20672400000','20672100000','20670100000','20673600000','20671600000','20671100000','20671400000','20671500000','20671300000','20671900000','20672200000','20672300000','20673700000','20671200000','20670900000','20671000000','20670800000','70378900735','70378900735','70378900735','48000121001','48000745001','7347200167','6098821203','2529360011','4111600271','2200000926','2800017825','2018205703','89014600147','75764502253','83611000011','66706320001','66706320009','72958211620','72958211630') AND DIM_PRODUCT.ACTIVE = 1 AND DIM_STORE.LATEST = 1 AND DIM_PRODUCT.LATEST = 1 AND AGG_MLY_STR_PROD.STORE_CODE=DIM_STORE.STORE_CODE AND AGG_MLY_STR_PROD.PRODUCT_CODE=DIM_PRODUCT.PRODUCT_CODE AND DIM_STORE.STORE_CODE=ADMIN_USER_STORE.STORE_CODE AND ADMIN_USER_STORE.USER_ID=37 AND DIM_PRODUCT.DEPARTMENT_CODE=ADMIN_USER_DEPARTMENT.DEPARTMENT_CODE AND ADMIN_USER_DEPARTMENT.USER_ID=37 GROUP BY DIM_PRODUCT.PRODUCT_CODE,DIM_PRODUCT.PRODUCT_DESCRIPTION|| '-' ||trim(PRODUCT_STYLE_DESC)|| '-' ||trim(PRODUCT_SIZE),DIM_PRODUCT.EAN_NUMBER,DIM_PRODUCT.PRODUCT_DESCRIPTION,DIM_PRODUCT.PRODUCT_STYLE_DESC,DIM_PRODUCT.PRODUCT_SIZE,DIM_PRODUCT.PRODUCT_UOM,DIM_PRODUCT.CREATED_DATE, (case when ATTRIB2_DESC IN('ZAP' , 'KIL' , 'DEL' , 'zap' , 'kil' , 'del') THEN 'D' ELSE 'A' END),DIM_PRODUCT.ATTRIB2_DESC,DIM_PRODUCT.ATTRIB1_DESC,DIM_PRODUCT.ATTRIB3_DESC,DIM_PRODUCT.PRODUCT_DETAIL_CODE,DIM_PRODUCT.DEPARTMENT_CODE,DIM_PRODUCT.DEPARTMENT_DESC,DIM_PRODUCT.CLASS_CODE,DIM_PRODUCT.CLASS_DESC,DIM_PRODUCT.SUBCLASS_CODE,DIM_PRODUCT.SUBCLASS_DESC,DIM_PRODUCT.ACCT_DEPT_CODE,DIM_PRODUCT.SUB_DEPT_CODE ORDER BY DIM_PRODUCT.PRODUCT_CODE asc

How to fix this kind of issues?
2 REPLIES
Enthusiast

Re: Insufficient memory to parse this request,during optimizer phase....

You may be able to evaluate the MaxParseTreeSegs setting in the DBSControls, but I would consider reducing the number of items in your IN list or placing them into a table (permanent, global temp, or volatile) and use a subquery in your IN list instead.
Enthusiast

Re: Insufficient memory to parse this request,during optimizer phase....

You can insert those values in the IN clause into a volatile table. Then join the volatile table with the existing table. I think this may be helpful. correct me if i am wrong.

Regards,
Sathish.