Hi,
Due my experienced (so-called) seniors who designed the app and the
database, i have been given a task to learn more about ORA-4030. The
design of the application is such that, user will be allowed to set the
filter to exclude order information placed which inturn is converted to
LIKE statement.
It turned out to be that the end-user has set 640 filters. This
resulted to more than 2000 lines of SQL which is dynamically generated.
The major bottle neck is using NOT LIKE (...) statement. This being the
reason, the Oracle process throws Out of Process Memory.
I would like to know if I could be able to reframe the SQL in such a
way to avoid this error. I do know that it is because of the SQL and
not because of PGA_AGGREGATE_xxx parameter which is causing the
problem.
Any thoughts and suggestions is highly valuable.
Apologies for having this giagantic SQL posted.
Thanks in Advance,
Anu
----SQL Start
SELECT A.SRC_SYS_CD SRC_SYSTEM, A.INSTN_CD, A.STYL_NBR STYLE,
A.COLR_NBR COLOR, E.CATLG_CD CATALOG_ID, A.CAT_ID CATEGORY_ID,
A.GPC_CD GPC_CODE, A.GNDR_ID GENDER_ID, A.TECH_INFO TECH_INFO,
A.THMB_IMG_PATHNM THMB_NAIL_IMG, A.LRG_IMG_PATHNM ENLRG_IMG,
A.QUAL_CD QUAL_CD, A.PROD_DESC PROD_DESC, D.LNCH_DT LNCH_DT,
E.BEG_DT CAT_BEG_DT, E.END_DT CAT_END_DT, E.CATLG_NM CATALOG_NM,
F.PRC_LST_ID, F.LIST_PRC_FL LISTPRICE_FLAG, F.PRC_BEG_DT
PRC_BEG_DT, F.PRC_END_DT, F.PRC_AMT PRICE_AMT, H.GNDR_NM
GENDER_NM, I.TRSL_TXT GPC_NM, J.CAT_NM CATEGORY_NM, K.SRC_SESN_CD
SEASON_CD, K.SESN_NM SEASON_NM , U.SRC_UOM_CD UOM_CODE FROM
WOE_CATALOG_STYLE_COLOR B, WOE_STYLE_COLOR_INSTN A, WOE_STYLE_COLOR
C, WOE_STYLE D, WOE_CATALOG E, WOE_PRODUCT_PRICE F, WOE_GPC G,
WOE_GENDER H, WOE_WEB_CONTENT_TRANSLATIONS I, WOE_UOM U,WOE_CATEGORY
J, WOE_SEASON K WHERE A.SRC_SYS_CD = 'ARG' AND B.SRC_SYS_CD = 'ARG'
AND A.STYL_NBR = B.STYL_NBR AND A.COLR_NBR = B.COLR_NBR AND A.QUAL_CD =
B.QUAL_CD AND B.CATLG_CD = E.CATLG_CD AND A.SRC_SYS_CD = 'ARG'
AND C.SRC_SYS_CD = 'ARG' AND A.STYL_NBR = C.STYL_NBR AND A.COLR_NBR =
C.COLR_NBR AND A.QUAL_CD = C.QUAL_CD AND D.SRC_SYS_CD = 'ARG' AND
A.STYL_NBR = D.STYL_NBR AND A.INSTN_CD = '1' AND E.INSTN_CD = '1' AND
C.ACT_FL = 1 AND D.ACT_FL = 1 AND F.SRC_SYS_CD = 'ARG' AND
A.STYL_NBR = F.STYL_NBR AND A.COLR_NBR = F.COLR_NBR AND A.QUAL_CD =
F.QUAL_CD AND U.UOM_ID = D.UOM_ID AND (( F.PRC_BEG_DT BETWEEN
E.BEG_DT AND E.END_DT ) OR (NVL(F.PRC_END_DT, TO_DATE('01-01-2099',
'MM-DD-YYYY')) BETWEEN E.BEG_DT AND E.END_DT ) ) AND H.GNDR_ID =
A.GNDR_ID AND J.CAT_ID = A.CAT_ID AND G.GPC_CD = A.GPC_CD AND
K.SESN_ID = A.SESN_ID AND I.WEB_CTNT_CD = G.WEB_CTNT_CD AND
I.TRSL_LNG_ID = 3 AND F.LIST_PRC_FL = 1 AND A.SRC_SYS_CD = 'ARG'
AND A.INSTN_CD = 1 AND ( (A.GPC_CD = 03 AND F.PRC_LST_ID = 26 AND
F.PRC_AMT >= 0.0 AND F.PRC_AMT <=9999.0) OR (A.GPC_CD = 04 AND
F.PRC_LST_ID = 25 AND F.PRC_AMT >= 0.0 AND F.PRC_AMT <=9999.0) OR
(A.GPC_CD = 02 AND F.PRC_LST_ID = 24 AND F.PRC_AMT >= 0.0 AND
F.PRC_AMT <=9999.0)) AND A.GNDR_ID IN ( 8,10,9 ) AND A.CAT_ID IN
(852,773,390,377,940,564,440,929,846,946,435,458,373,847,943,380,407,382,941,384,565,388,374,557,403,375,765,372,768,559,562,942,443,441,387,767,386,760,437,359,775,381,362,406,436,843,763,947,930,370,450,385,700,814,439,740,701,376,412,698,424,761,364,922,845,558,766,389,563,454,383,764,848,396,699,419,442,379,849,378,908)
AND (( A.STYL_NBR = 'null' AND A.COLR_NBR = 'null' ) OR ( A.STYL_NBR =
'null' AND A.COLR_NBR = 'null' ) OR ( A.STYL_NBR = 'null' AND
A.COLR_NBR = 'null' ) OR ( A.STYL_NBR = 'null' AND A.COLR_NBR = 'null'
) OR ( A.STYL_NBR = 'null' AND A.COLR_NBR = 'null' )) AND C.LFCY_CD IN
(10,20) AND NOT (A.STYL_NBR LIKE '%294851%' OR A.STYL_NBR LIKE
'%307616%' OR A.STYL_NBR LIKE '306967%' OR A.STYL_NBR LIKE '%115912%'
OR A.STYL_NBR LIKE '%296345%' OR A.STYL_NBR LIKE '%117995%' OR
A.STYL_NBR LIKE '%308951%' OR A.STYL_NBR LIKE '%113646%' OR A.STYL_NBR
LIKE '%310229%' OR A.STYL_NBR LIKE '%117898%' OR A.STYL_NBR LIKE
'%117899%' OR A.STYL_NBR LIKE '%308718%' OR A.STYL_NBR LIKE '%241809%'
OR A.STYL_NBR LIKE '%ba0919%' OR A.STYL_NBR LIKE '%115645%' OR
A.STYL_NBR LIKE '%ba0391%' OR A.STYL_NBR LIKE '%gl0168%' OR A.STYL_NBR
LIKE '%595144%' OR A.STYL_NBR LIKE '%594524%' OR A.STYL_NBR LIKE
'%440460%' OR A.STYL_NBR LIKE '%114852%' OR A.STYL_NBR LIKE '%114857%'
OR A.STYL_NBR LIKE '%310225%' OR A.STYL_NBR LIKE '%310008%' OR
A.STYL_NBR LIKE '%BA0736%' OR A.STYL_NBR LIKE '%BA0856%' OR A.STYL_NBR
LIKE '%BA0737%' OR A.STYL_NBR LIKE '%116795%' OR A.STYL_NBR LIKE
'%125482%' OR A.STYL_NBR LIKE '%296958%' OR A.STYL_NBR LIKE '%116916%'
OR A.STYL_NBR LIKE '%193483%' OR A.STYL_NBR LIKE '%241862%' OR
A.STYL_NBR LIKE '%ba0704%' OR A.STYL_NBR LIKE '%sc0658%' OR A.STYL_NBR
LIKE '305414%' OR A.STYL_NBR LIKE '%117932%' OR A.STYL_NBR LIKE
'%440444%' OR A.STYL_NBR LIKE '311101%' OR A.STYL_NBR LIKE '%SP0114%'
OR A.STYL_NBR LIKE '%591405%' OR A.STYL_NBR LIKE '303919%' OR
A.STYL_NBR LIKE '%691472%' OR A.STYL_NBR LIKE '%225288%' OR A.STYL_NBR
LIKE '%225126%' OR A.STYL_NBR LIKE '%195153%' OR A.STYL_NBR LIKE
'%604139%' OR A.STYL_NBR LIKE '%118817%' OR A.STYL_NBR LIKE '210551%'
OR A.STYL_NBR LIKE '302517%' OR A.STYL_NBR LIKE '%225110%' OR
A.STYL_NBR LIKE '309511%' OR A.STYL_NBR LIKE '%308823%' OR A.STYL_NBR
LIKE '%225128%' OR A.STYL_NBR LIKE '309693%' OR A.STYL_NBR LIKE
'%307474%' OR A.STYL_NBR LIKE '%ba0917%' OR A.STYL_NBR LIKE '%304696%'
OR A.STYL_NBR LIKE '310856%' OR A.STYL_NBR LIKE '%241723%' OR
A.STYL_NBR LIKE '%195148%' OR A.STYL_NBR LIKE '%BA0738%' OR A.STYL_NBR
LIKE '%195147%' OR A.STYL_NBR LIKE '%ba0426%' OR A.STYL_NBR LIKE
'%211335%' OR A.STYL_NBR LIKE '%308673%' OR A.STYL_NBR LIKE '306974%'
OR A.STYL_NBR LIKE '%295829%' OR A.STYL_NBR LIKE '%124688%' OR
A.STYL_NBR LIKE '%117703%' OR A.STYL_NBR LIKE '%310247%' OR A.STYL_NBR
LIKE '309495%' OR A.STYL_NBR LIKE '%BA0912%' OR A.STYL_NBR LIKE
'%BA0878%' OR A.STYL_NBR LIKE '%211475%' OR A.STYL_NBR LIKE '%211473%'
OR A.STYL_NBR LIKE '%225130%' OR A.STYL_NBR LIKE '%309502%' OR
A.STYL_NBR LIKE '%297660%' OR A.STYL_NBR LIKE '%190463%' OR A.STYL_NBR
LIKE '%193022%' OR A.STYL_NBR LIKE '%296821%' OR A.STYL_NBR LIKE
'306373%' OR A.STYL_NBR LIKE '%115845%' OR A.STYL_NBR LIKE '%gs0126%'
OR A.STYL_NBR LIKE '%307944%' OR A.STYL_NBR LIKE '%193040%' OR
A.STYL_NBR LIKE '%241815%' OR A.STYL_NBR LIKE '%308642%' OR A.STYL_NBR
LIKE '%117629%' OR A.STYL_NBR LIKE '%294847%' OR A.STYL_NBR LIKE
'%190192%' OR A.STYL_NBR LIKE '%113636%' OR A.STYL_NBR LIKE '%309498%'
OR A.STYL_NBR LIKE '%309344%' OR A.STYL_NBR LIKE '%ba0916%' OR
A.STYL_NBR LIKE '%492434%' OR A.STYL_NBR LIKE '%307821%' OR A.STYL_NBR
LIKE '%310347%' OR A.STYL_NBR LIKE '%116263%' OR A.STYL_NBR LIKE
'%296899%' OR A.STYL_NBR LIKE '%191184%' OR A.STYL_NBR LIKE '%307785%'
OR A.STYL_NBR LIKE '%115882%' OR A.STYL_NBR LIKE '%308644%' OR
A.STYL_NBR LIKE '%142604%' OR A.STYL_NBR LIKE '%116772%' OR A.STYL_NBR
LIKE '%gx0024%' OR A.STYL_NBR LIKE '%308530%' OR A.STYL_NBR LIKE
'%250551%' OR A.STYL_NBR LIKE '%296804%' OR A.STYL_NBR LIKE '%225127%'
OR A.STYL_NBR LIKE '%141983%' OR A.STYL_NBR LIKE '%793668%' OR
A.STYL_NBR LIKE '%310041%' OR A.STYL_NBR LIKE '%296818%' OR A.STYL_NBR
LIKE '%BA0911%' OR A.STYL_NBR LIKE '%307566%' OR A.STYL_NBR LIKE
'%307703%' OR A.STYL_NBR LIKE '%117646%' OR A.STYL_NBR LIKE '%142605%'
OR A.STYL_NBR LIKE '%BA0910%' OR A.STYL_NBR LIKE '%118752%' OR
A.STYL_NBR LIKE '%308531%' OR A.STYL_NBR LIKE '%211282%' OR A.STYL_NBR
LIKE '%142326%' OR A.STYL_NBR LIKE '%193394%' OR A.STYL_NBR LIKE
'%304911%' OR A.STYL_NBR LIKE '%193016%' OR A.STYL_NBR LIKE '%295199%'
OR A.STYL_NBR LIKE '%308643%' OR A.STYL_NBR LIKE '142525%' OR
A.STYL_NBR LIKE '%311050%' OR A.STYL_NBR LIKE '%311520%' OR A.STYL_NBR
LIKE '%ba0932%' OR A.STYL_NBR LIKE '%112001%' OR A.STYL_NBR LIKE
'%ba0929%' OR A.STYL_NBR LIKE '%ba0848%' OR A.STYL_NBR LIKE '%309374%'
OR A.STYL_NBR LIKE '%SC0845%' OR A.STYL_NBR LIKE '%117644%' OR
A.STYL_NBR LIKE '%fe0070%' OR A.STYL_NBR LIKE '306951%' OR A.STYL_NBR
LIKE '%193397%' OR A.STYL_NBR LIKE '%137614%' OR A.STYL_NBR LIKE
'%310397%' OR A.STYL_NBR LIKE '304738%' OR A.STYL_NBR LIKE '%112738%'
OR A.STYL_NBR LIKE '%124771%' OR A.STYL_NBR LIKE '%sc0675%' OR
A.STYL_NBR LIKE '%116415%' OR A.STYL_NBR LIKE '%241911%' OR A.STYL_NBR
LIKE '%241906%' OR A.STYL_NBR LIKE '306485%' OR A.STYL_NBR LIKE
'%ba0933%' OR A.STYL_NBR LIKE '304030%' OR A.STYL_NBR LIKE '%305619%'
OR A.STYL_NBR LIKE '%gg0094%' OR A.STYL_NBR LIKE '%142321%' OR
A.STYL_NBR LIKE '306515%' OR A.STYL_NBR LIKE '308229%' OR A.STYL_NBR
LIKE '308931%' OR A.STYL_NBR LIKE '308933%' OR A.STYL_NBR LIKE
'%112677%' OR A.STYL_NBR LIKE '311121%' OR A.STYL_NBR LIKE '311022%' OR
A.STYL_NBR LIKE '311033%' OR A.STYL_NBR LIKE '%117549%' OR A.STYL_NBR
LIKE '142611%' OR A.STYL_NBR LIKE '142478%' OR A.STYL_NBR LIKE
'%117532%' OR A.STYL_NBR LIKE '%184947%' OR A.STYL_NBR LIKE '309504%'
OR A.STYL_NBR LIKE '%293909%' OR A.STYL_NBR LIKE '%293923%' OR
A.STYL_NBR LIKE '%309386%' OR A.STYL_NBR LIKE '%308561%' OR A.STYL_NBR
LIKE '%250550%' OR A.STYL_NBR LIKE '%fc0006%' OR A.STYL_NBR LIKE
'%307715%' OR A.STYL_NBR LIKE '%117772%' OR A.STYL_NBR LIKE '309369%'
OR A.STYL_NBR LIKE '%137618%' OR A.STYL_NBR LIKE '%118252%' OR
A.STYL_NBR LIKE '%307802%' OR A.STYL_NBR LIKE '%118901%' OR A.STYL_NBR
LIKE '%142315%' OR A.STYL_NBR LIKE '%118890%' OR A.STYL_NBR LIKE
'%423301%' OR A.STYL_NBR LIKE '%114219%' OR A.STYL_NBR LIKE '%295938%'
OR A.STYL_NBR LIKE '%ba0703%' OR A.STYL_NBR LIKE '%310257%' OR
A.STYL_NBR LIKE '440418%' OR A.STYL_NBR LIKE '306198%' OR A.STYL_NBR
LIKE '%137059%' OR A.STYL_NBR LIKE '112665%' OR A.STYL_NBR LIKE
'308975%' OR A.STYL_NBR LIKE '%117902%' OR A.STYL_NBR LIKE '309512%' OR
A.STYL_NBR LIKE '%311159%' OR A.STYL_NBR LIKE '%295832%' OR A.STYL_NBR
LIKE '311317%' OR A.STYL_NBR LIKE '306248%' OR A.STYL_NBR LIKE
'309427%' OR A.STYL_NBR LIKE '309432%' OR A.STYL_NBR LIKE '309440%' OR
A.STYL_NBR LIKE '310723%' OR A.STYL_NBR LIKE '%307895%' OR A.STYL_NBR
LIKE '306222%' OR A.STYL_NBR LIKE '%306265%' OR A.STYL_NBR LIKE
'%308662%' OR A.STYL_NBR LIKE '%116608%' OR A.STYL_NBR LIKE '%310200%'
OR A.STYL_NBR LIKE '%306161%' OR A.STYL_NBR LIKE '%295512%' OR
A.STYL_NBR LIKE '%295936%' OR A.STYL_NBR LIKE '%307863%' OR A.STYL_NBR
LIKE '%309488%' OR A.STYL_NBR LIKE '%224549%' OR A.STYL_NBR LIKE
'%111989%' OR A.STYL_NBR LIKE '309467%' OR A.STYL_NBR LIKE '306546%' OR
A.STYL_NBR LIKE '%117587%' OR A.STYL_NBR LIKE '%193398%' OR A.STYL_NBR
LIKE '%307576%' OR A.STYL_NBR LIKE '%211272%' OR A.STYL_NBR LIKE
'%193489%' OR A.STYL_NBR LIKE '%111850%' OR A.STYL_NBR LIKE '%142453%'
OR A.STYL_NBR LIKE '%310429%' OR A.STYL_NBR LIKE '306472%' OR
A.STYL_NBR LIKE '609044%' OR A.STYL_NBR LIKE '308849%' OR A.STYL_NBR
LIKE '%193015%' OR A.STYL_NBR LIKE '%ba0766%' OR A.STYL_NBR LIKE
'%307808%' OR A.STYL_NBR LIKE '%112664%' OR A.STYL_NBR LIKE '%115892%'
OR A.STYL_NBR LIKE '%124773%' OR A.STYL_NBR LIKE '%sc0755%' OR
A.STYL_NBR LIKE '%116386%' OR A.STYL_NBR LIKE '%211470%' OR A.STYL_NBR
LIKE '309476%' OR A.STYL_NBR LIKE '%191703%' OR A.STYL_NBR LIKE
'%296509%' OR A.STYL_NBR LIKE '%114654%' OR A.STYL_NBR LIKE '%297814%'
OR A.STYL_NBR LIKE '311124%' OR A.STYL_NBR LIKE '%116258%' OR
A.STYL_NBR LIKE '%308665%' OR A.STYL_NBR LIKE '306620%' OR A.STYL_NBR
LIKE '%115827%' OR A.STYL_NBR LIKE '%137611%' OR A.STYL_NBR LIKE
'%124693%' OR A.STYL_NBR LIKE '%440447%' OR A.STYL_NBR LIKE '%ba0747%'
OR A.STYL_NBR LIKE '%308575%' OR A.STYL_NBR LIKE '%298626%' OR
A.STYL_NBR LIKE '%295213%' OR A.STYL_NBR LIKE '%308885%' OR A.STYL_NBR
LIKE '309538%' OR A.STYL_NBR LIKE '309549%' OR A.STYL_NBR LIKE
'%gl0056%' OR A.STYL_NBR LIKE '306353%' OR A.STYL_NBR LIKE '%296561%'
OR A.STYL_NBR LIKE '%307612%' OR A.STYL_NBR LIKE '%306779%' OR
A.STYL_NBR LIKE '%193019%' OR A.STYL_NBR LIKE '%241751%' OR A.STYL_NBR
LIKE '%309457%' OR A.STYL_NBR LIKE '%117631%' OR A.STYL_NBR LIKE
'%190717%' OR A.STYL_NBR LIKE '%241866%' OR A.STYL_NBR LIKE '306518%'
OR A.STYL_NBR LIKE '%310305%' OR A.STYL_NBR LIKE '%118896%' OR
A.STYL_NBR LIKE '%293904%' OR A.STYL_NBR LIKE '%310332%' OR A.STYL_NBR
LIKE '%308344%' OR A.STYL_NBR LIKE '%188680%' OR A.STYL_NBR LIKE
'%116412%' OR A.STYL_NBR LIKE '%gl0167%' OR A.STYL_NBR LIKE '%gl0166%'
OR A.STYL_NBR LIKE '%493682%' OR A.STYL_NBR LIKE '%114231%' OR
A.STYL_NBR LIKE '%310239%' OR A.STYL_NBR LIKE '%309454%' OR A.STYL_NBR
LIKE '309469%' OR A.STYL_NBR LIKE '309470%' OR A.STYL_NBR LIKE
'%112679%' OR A.STYL_NBR LIKE '%211430%' OR A.STYL_NBR LIKE '%308897%'
OR A.STYL_NBR LIKE '%225237%' OR A.STYL_NBR LIKE '%307803%' OR
A.STYL_NBR LIKE '%304822%' OR A.STYL_NBR LIKE '%307801%' OR A.STYL_NBR
LIKE '%115880%' OR A.STYL_NBR LIKE '%fc0014%' OR A.STYL_NBR LIKE
'%116410%' OR A.STYL_NBR LIKE '%309988%' OR A.STYL_NBR LIKE '307819%'
OR A.STYL_NBR LIKE '307934%' OR A.STYL_NBR LIKE '%114234%' OR
A.STYL_NBR LIKE '%590903%' OR A.STYL_NBR LIKE '%423300%' OR A.STYL_NBR
LIKE '%295203%' OR A.STYL_NBR LIKE '%294883%' OR A.STYL_NBR LIKE
'%307511%' OR A.STYL_NBR LIKE '%114616%' OR A.STYL_NBR LIKE '%241438%'
OR A.STYL_NBR LIKE '%308641%' OR A.STYL_NBR LIKE '%308841%' OR
A.STYL_NBR LIKE '%307679%' OR A.STYL_NBR LIKE '%114818%' OR A.STYL_NBR
LIKE '%308300%' OR A.STYL_NBR LIKE '304714%' OR A.STYL_NBR LIKE
'309503%' OR A.STYL_NBR LIKE '222802%' OR A.STYL_NBR LIKE '%308661%' OR
A.STYL_NBR LIKE '%116760%' OR A.STYL_NBR LIKE '306623%' OR A.STYL_NBR
LIKE '%293686%' OR A.STYL_NBR LIKE '%297389%' OR A.STYL_NBR LIKE
'%124621%' OR A.STYL_NBR LIKE '%116616%' OR A.STYL_NBR LIKE '%294887%'
OR A.STYL_NBR LIKE '%310641%' OR A.STYL_NBR LIKE '%112215%' OR
A.STYL_NBR LIKE '%423304%' OR A.STYL_NBR LIKE '%116612%' OR A.STYL_NBR
LIKE '%310238%' OR A.STYL_NBR LIKE '%494466%' OR A.STYL_NBR LIKE
'%494463%' OR A.STYL_NBR LIKE '%440459%' OR A.STYL_NBR LIKE '%494530%'
OR A.STYL_NBR LIKE '%193047%' OR A.STYL_NBR LIKE '%111998%' OR
A.STYL_NBR LIKE '306429%' OR A.STYL_NBR LIKE '%sc0718%' OR A.STYL_NBR
LIKE '%117590%' OR A.STYL_NBR LIKE '%118775%' OR A.STYL_NBR LIKE
'%142408%' OR A.STYL_NBR LIKE '%142322%' OR A.STYL_NBR LIKE '%193350%'
OR A.STYL_NBR LIKE '309456%' OR A.STYL_NBR LIKE '%493523%' OR
A.STYL_NBR LIKE '%224744%' OR A.STYL_NBR LIKE '%SC0844%' OR A.STYL_NBR
LIKE '%293902%' OR A.STYL_NBR LIKE '%310374%' OR A.STYL_NBR LIKE
'%115871%' OR A.STYL_NBR LIKE '%211251%' OR A.STYL_NBR LIKE '%241912%'
OR A.STYL_NBR LIKE '%296328%' OR A.STYL_NBR LIKE '%117621%' OR
A.STYL_NBR LIKE '309616%' OR A.STYL_NBR LIKE '%295823%' OR A.STYL_NBR
LIKE '%624044%' OR A.STYL_NBR LIKE '304703%' OR A.STYL_NBR LIKE
'%190739%' OR A.STYL_NBR LIKE '%307060%' OR A.STYL_NBR LIKE '%308809%'
OR A.STYL_NBR LIKE '%305410%' OR A.STYL_NBR LIKE '%304891%' OR
A.STYL_NBR LIKE '%224782%' OR A.STYL_NBR LIKE '%ba0388%' OR A.STYL_NBR
LIKE '%308931%' OR A.STYL_NBR LIKE '%682595%' OR A.STYL_NBR LIKE
'%116256%' OR A.STYL_NBR LIKE '%297388%' OR A.STYL_NBR LIKE '%296321%'
OR A.STYL_NBR LIKE '%116404%' OR A.STYL_NBR LIKE '308847%' OR
A.STYL_NBR LIKE '%492538%' OR A.STYL_NBR LIKE '%224550%' OR A.STYL_NBR
LIKE '%293903%' OR A.STYL_NBR LIKE '%493663%' OR A.STYL_NBR LIKE
'%308720%' OR A.STYL_NBR LIKE '%296318%' OR A.STYL_NBR LIKE '%124629%'
OR A.STYL_NBR LIKE '306597%' OR A.STYL_NBR LIKE '%BA0390%' OR
A.STYL_NBR LIKE '%193051%' OR A.STYL_NBR LIKE '%493674%' OR A.STYL_NBR
LIKE '%293974%' OR A.STYL_NBR LIKE '%241806%' OR A.STYL_NBR LIKE
'%137211%' OR A.STYL_NBR LIKE '%114323%' OR A.STYL_NBR LIKE '%112210%'
OR A.STYL_NBR LIKE '%492448%' OR A.STYL_NBR LIKE '%142523%' OR
A.STYL_NBR LIKE '%294828%' OR A.STYL_NBR LIKE '%SC0658%' OR A.STYL_NBR
LIKE '%295194%' OR A.STYL_NBR LIKE '%211366%' OR A.STYL_NBR LIKE
'%137310%' OR A.STYL_NBR LIKE '%118899%' OR A.STYL_NBR LIKE '%307807%'
OR A.STYL_NBR LIKE '%ba0424%' OR A.STYL_NBR LIKE '%192101%' OR
A.STYL_NBR LIKE '304891%' OR A.STYL_NBR LIKE '306438%' OR A.STYL_NBR
LIKE '%124628%' OR A.STYL_NBR LIKE '%308844%' OR A.STYL_NBR LIKE
'303950%' OR A.STYL_NBR LIKE '%117705%' OR A.STYL_NBR LIKE '%183911%'
OR A.STYL_NBR LIKE '%116374%' OR A.STYL_NBR LIKE '%118241%' OR
A.STYL_NBR LIKE '183219%' OR A.STYL_NBR LIKE '307811%' OR A.STYL_NBR
LIKE '142597%' OR A.STYL_NBR LIKE '305572%' OR A.STYL_NBR LIKE
'%117604%' OR A.STYL_NBR LIKE '%307982%' OR A.STYL_NBR LIKE '%116604%'
OR A.STYL_NBR LIKE '%308013%' OR A.STYL_NBR LIKE '%193017%' OR
A.STYL_NBR LIKE '%307761%' OR A.STYL_NBR LIKE '186050%' OR A.STYL_NBR
LIKE '%bg0049%' OR A.STYL_NBR LIKE '308851%' OR A.STYL_NBR LIKE
'%118237%' OR A.STYL_NBR LIKE '%308717%' OR A.STYL_NBR LIKE '%295847%'
OR A.STYL_NBR LIKE '%310113%' OR A.STYL_NBR LIKE '%117578%' OR
A.STYL_NBR LIKE '%307240%' OR A.STYL_NBR LIKE '%297042%' OR A.STYL_NBR
LIKE '%305334%' OR A.STYL_NBR LIKE '308634%' OR A.STYL_NBR LIKE
'%306927%' OR A.STYL_NBR LIKE '%142413%' OR A.STYL_NBR LIKE '%308683%'
OR A.STYL_NBR LIKE '%sc0730%' OR A.STYL_NBR LIKE '%116578%' OR
A.STYL_NBR LIKE '%125651%' OR A.STYL_NBR LIKE '%SC0732%' OR A.STYL_NBR
LIKE '%185808%' OR A.STYL_NBR LIKE '307087%' OR A.STYL_NBR LIKE
'%118376%' OR A.STYL_NBR LIKE '%124627%' OR A.STYL_NBR LIKE '306549%'
OR A.STYL_NBR LIKE '%308933%' OR A.STYL_NBR LIKE '%114821%' OR
A.STYL_NBR LIKE '%295943%' OR A.STYL_NBR LIKE '%117996%' OR A.STYL_NBR
LIKE '%115889%' OR A.STYL_NBR LIKE '306503%' OR A.STYL_NBR LIKE
'%309989%' OR A.STYL_NBR LIKE '%241740%' OR A.STYL_NBR LIKE '%fc0007%'
OR A.STYL_NBR LIKE '%691474%' OR A.STYL_NBR LIKE '%118861%' OR
A.STYL_NBR LIKE '%118834%' OR A.STYL_NBR LIKE '%193395%' OR A.STYL_NBR
LIKE '142606%' OR A.STYL_NBR LIKE '%114247%' OR A.STYL_NBR LIKE
'%308229%' OR A.STYL_NBR LIKE '%440432%' OR A.STYL_NBR LIKE '%307061%'
OR A.STYL_NBR LIKE '%sc0673%' OR A.STYL_NBR LIKE '308973%' OR
A.STYL_NBR LIKE '304986%' OR A.STYL_NBR LIKE '%114824%' OR A.STYL_NBR
LIKE '183234%' OR A.STYL_NBR LIKE '306950%' OR A.STYL_NBR LIKE
'%308668%' OR A.STYL_NBR LIKE '%190462%' OR A.STYL_NBR LIKE '%117626%'
OR A.STYL_NBR LIKE '%142093%' OR A.STYL_NBR LIKE '306281%' OR
A.STYL_NBR LIKE '%gl0057%' OR A.STYL_NBR LIKE '310290%' OR A.STYL_NBR
LIKE '%BA0391%' OR A.STYL_NBR LIKE '308251%' OR A.STYL_NBR LIKE
'%307551%' OR A.STYL_NBR LIKE '%112587%' OR A.STYL_NBR LIKE '%309458%'
OR A.STYL_NBR LIKE '%114635%' OR A.STYL_NBR LIKE '%gl0055%' OR
A.STYL_NBR LIKE '%307764%' OR A.STYL_NBR LIKE '309181%' OR A.STYL_NBR
LIKE '%308632%' OR A.STYL_NBR LIKE '%307822%' OR A.STYL_NBR LIKE
'%306200%' OR A.STYL_NBR LIKE '%116637%' OR A.STYL_NBR LIKE '%295826%'
OR A.STYL_NBR LIKE '%117606%' OR A.STYL_NBR LIKE '%112662%' OR
A.STYL_NBR LIKE '%241739%' OR A.STYL_NBR LIKE '%296038%' OR A.STYL_NBR
LIKE '%117597%' OR A.STYL_NBR LIKE '%211254%' OR A.STYL_NBR LIKE
'%124630%' OR A.STYL_NBR LIKE '306304%' OR A.STYL_NBR LIKE '%308014%'
OR A.STYL_NBR LIKE '%117749%' OR A.STYL_NBR LIKE '%343641%' OR
A.STYL_NBR LIKE '%241768%' OR A.STYL_NBR LIKE '306174%' OR A.STYL_NBR
LIKE '305587%' OR A.STYL_NBR LIKE '%295887%' OR A.STYL_NBR LIKE
'307027%' OR A.STYL_NBR LIKE '310071%' OR A.STYL_NBR LIKE '%117593%' OR
A.STYL_NBR LIKE '%224794%' OR A.STYL_NBR LIKE '%305586%' OR A.STYL_NBR
LIKE '307089%' OR A.STYL_NBR LIKE '%310282%' OR A.STYL_NBR LIKE
'%310411%' OR A.STYL_NBR LIKE '309474%' OR A.STYL_NBR LIKE '112591%' OR
A.STYL_NBR LIKE '141993%' OR A.STYL_NBR LIKE '%136744%' OR A.STYL_NBR
LIKE '310177%' OR A.STYL_NBR LIKE '%492493%' OR A.STYL_NBR LIKE
'%115887%' OR A.STYL_NBR LIKE '306961%' OR A.STYL_NBR LIKE '%310007%'
OR A.STYL_NBR LIKE '%294226%' OR A.STYL_NBR LIKE '%308884%' OR
A.STYL_NBR LIKE '%307651%' OR A.STYL_NBR LIKE '%309574%' OR A.STYL_NBR
LIKE '%492527%' OR A.STYL_NBR LIKE '%294043%' OR A.STYL_NBR LIKE
'%117603%' OR A.STYL_NBR LIKE '183232%' OR A.STYL_NBR LIKE '%307621%'
OR A.STYL_NBR LIKE '%117917%' OR A.STYL_NBR LIKE '%294846%' OR
A.STYL_NBR LIKE '%307780%' OR A.STYL_NBR LIKE '302715%' OR A.STYL_NBR
LIKE '%fc0008%' OR A.STYL_NBR LIKE '%142324%' OR A.STYL_NBR LIKE
'%296070%' OR A.STYL_NBR LIKE '%307202%' OR A.STYL_NBR LIKE '%117628%'
OR A.STYL_NBR LIKE '%111483%' OR A.STYL_NBR LIKE '%116414%' OR
A.STYL_NBR LIKE '%116261%' OR A.STYL_NBR LIKE '%307615%' OR A.STYL_NBR
LIKE '306376%' OR A.STYL_NBR LIKE '%296474%' OR A.STYL_NBR LIKE
'%190136%' OR A.STYL_NBR LIKE '303954%' OR A.STYL_NBR LIKE '%124779%'
OR A.STYL_NBR LIKE '306487%' OR A.STYL_NBR LIKE '%112179%' OR
A.STYL_NBR LIKE '310371%' OR A.STYL_NBR LIKE '306683%' OR A.STYL_NBR
LIKE '306963%' OR A.STYL_NBR LIKE '%118895%' OR A.STYL_NBR LIKE
'%295909%' OR A.STYL_NBR LIKE '%308253%' OR A.STYL_NBR LIKE '%113498%'
OR A.STYL_NBR LIKE '%310286%' OR A.STYL_NBR LIKE '310152%' OR
A.STYL_NBR LIKE '%308725%' OR A.STYL_NBR LIKE '%308634%' OR A.STYL_NBR
LIKE '%295197%' OR A.STYL_NBR LIKE '306975%' OR A.STYL_NBR LIKE
'%210757%' OR A.STYL_NBR LIKE '%307756%' OR A.STYL_NBR LIKE '%307754%'
OR A.STYL_NBR LIKE '%111858%' OR A.STYL_NBR LIKE '%310256%' OR
A.STYL_NBR LIKE '%308970%' OR A.STYL_NBR LIKE '%306926%' OR A.STYL_NBR
LIKE '309499%' OR A.STYL_NBR LIKE '310136%' OR A.STYL_NBR LIKE
'310197%' OR A.STYL_NBR LIKE '%117704%' OR A.STYL_NBR LIKE '%310613%'
OR A.STYL_NBR LIKE '%296324%' OR A.STYL_NBR LIKE '%117492%' OR
A.STYL_NBR LIKE '306223%' OR A.STYL_NBR LIKE '%224807%' OR A.STYL_NBR
LIKE '%fe0055%' OR A.STYL_NBR LIKE '%309495%' OR A.STYL_NBR LIKE
'%295802%' OR A.STYL_NBR LIKE '%295797%' OR A.STYL_NBR LIKE '%295798%'
OR A.STYL_NBR LIKE '%295942%' OR A.STYL_NBR LIKE '302493%' OR
A.STYL_NBR LIKE '%116620%' OR A.STYL_NBR LIKE '%114233%' OR A.STYL_NBR
LIKE '%ba0737%' OR A.STYL_NBR LIKE '%ba0738%' OR A.STYL_NBR LIKE
'%295876%' OR A.STYL_NBR LIKE '%137308%' OR A.STYL_NBR LIKE '%307696%'
OR A.STYL_NBR LIKE '%113096%' OR A.STYL_NBR LIKE '%307741%' OR
A.STYL_NBR LIKE '304096%' OR A.STYL_NBR LIKE '%310385%' OR A.STYL_NBR
LIKE '%115670%' OR A.STYL_NBR LIKE '%gg0088%' OR A.STYL_NBR LIKE
'%295228%' OR A.STYL_NBR LIKE '183176%' OR A.STYL_NBR LIKE '%ba0387%'
OR A.STYL_NBR LIKE '%295230%' OR A.STYL_NBR LIKE '%310278%' OR
A.STYL_NBR LIKE '%114243%' OR A.STYL_NBR LIKE '%308963%' OR A.STYL_NBR
LIKE '%117625%' OR A.STYL_NBR LIKE '%310280%' OR A.STYL_NBR LIKE
'%211363%' OR A.STYL_NBR LIKE '310014%' OR A.STYL_NBR LIKE '%ba0635%'
OR A.STYL_NBR LIKE '%117595%' OR A.STYL_NBR LIKE '%224736%' OR
A.STYL_NBR LIKE '%112639%' OR A.STYL_NBR LIKE '%309382%' OR A.STYL_NBR
LIKE '308822%' OR A.STYL_NBR LIKE '%118374%' OR A.STYL_NBR LIKE
'%117706%' OR A.STYL_NBR LIKE '%310213%' OR A.STYL_NBR LIKE '%307550%'
OR A.STYL_NBR LIKE '%306465%' OR A.STYL_NBR LIKE '%142323%' OR
A.STYL_NBR LIKE '%295232%' OR A.STYL_NBR LIKE '%308966%' OR A.STYL_NBR
LIKE '%124619%' OR A.STYL_NBR LIKE '224547%' OR A.STYL_NBR LIKE
'%296142%' OR A.STYL_NBR LIKE '%ba0736%' OR A.STYL_NBR LIKE '310032%'
OR A.STYL_NBR LIKE '%295220%' OR A.STYL_NBR LIKE '%fe0059%' OR
A.STYL_NBR LIKE '%308204%' OR A.STYL_NBR LIKE '%310081%' OR A.STYL_NBR
LIKE '%310080%' OR A.STYL_NBR LIKE '%310026%' OR A.STYL_NBR LIKE
'%306251%' OR A.STYL_NBR LIKE '%bg0013%' OR A.STYL_NBR LIKE '%306263%'
OR A.STYL_NBR LIKE '192054%' OR A.STYL_NBR LIKE '%307589%' OR
A.STYL_NBR LIKE '%307766%' OR A.STYL_NBR LIKE '%188681%' OR A.STYL_NBR
LIKE '%307631%' OR A.STYL_NBR LIKE '305496%' OR A.STYL_NBR LIKE
'306579%' OR A.STYL_NBR LIKE '%307161%' OR A.STYL_NBR LIKE '303918%' OR
A.STYL_NBR LIKE '306448%' OR A.STYL_NBR LIKE '%307984%' OR A.STYL_NBR
LIKE '%294867%' OR A.STYL_NBR LIKE '%137612%' OR A.STYL_NBR LIKE
'%431334%' OR A.STYL_NBR LIKE '%305256%' OR A.STYL_NBR LIKE '%307727%'
OR A.STYL_NBR LIKE '%310388%' OR A.STYL_NBR LIKE '%310284%' OR
A.STYL_NBR LIKE '%116411%' OR A.STYL_NBR LIKE '%gg0098%' OR A.STYL_NBR
LIKE '%191744%' OR A.STYL_NBR LIKE '%116771%' OR A.STYL_NBR LIKE
'%193492%' OR A.STYL_NBR LIKE '%307779%' OR A.STYL_NBR LIKE '%293921%'
OR A.STYL_NBR LIKE '%423341%' OR A.STYL_NBR LIKE '310370%' OR
A.STYL_NBR LIKE '%116640%' OR A.STYL_NBR LIKE '%136431%' OR A.STYL_NBR
LIKE '305488%' OR A.STYL_NBR LIKE '%114823%' OR A.STYL_NBR LIKE
'%296231%' OR A.STYL_NBR LIKE '309664%' OR A.STYL_NBR LIKE '306506%' OR
A.STYL_NBR LIKE '%118385%' OR A.STYL_NBR LIKE '%307856%' OR A.STYL_NBR
LIKE '%116603%' OR A.STYL_NBR LIKE '%295218%' OR A.STYL_NBR LIKE 'BG%'
OR A.STYL_NBR LIKE '309557%' OR A.STYL_NBR LIKE '%307647%' OR
A.STYL_NBR LIKE '%309428%' OR A.STYL_NBR LIKE '%423302%' OR A.STYL_NBR
LIKE '%117611%' OR A.STYL_NBR LIKE '%296313%' OR A.STYL_NBR LIKE
'%302519%' OR A.STYL_NBR LIKE '%116260%' OR A.STYL_NBR LIKE '%310536%'
OR A.STYL_NBR LIKE '%310492%' OR A.STYL_NBR LIKE '%308672%' OR
A.STYL_NBR LIKE '%241755%' OR A.STYL_NBR LIKE '142200%' OR A.STYL_NBR
LIKE '%241816%' OR A.STYL_NBR LIKE '%307928%' OR A.STYL_NBR LIKE
'%142464%' OR A.STYL_NBR LIKE '%307946%' OR A.STYL_NBR LIKE '%193055%'
OR A.STYL_NBR LIKE '%308973%' OR A.STYL_NBR LIKE '%308729%' OR
A.STYL_NBR LIKE '%115893%' OR A.STYL_NBR LIKE '112586%' OR A.STYL_NBR
LIKE '302220%' OR A.STYL_NBR LIKE '%306374%' OR A.STYL_NBR LIKE
'%193477%' OR A.STYL_NBR LIKE '%fe0026%' OR A.STYL_NBR LIKE '%310399%'
OR A.STYL_NBR LIKE '%309327%' OR A.STYL_NBR LIKE '%192858%' OR
A.STYL_NBR LIKE '305533%' OR A.STYL_NBR LIKE '%224806%' OR A.STYL_NBR
LIKE '%307805%' OR A.STYL_NBR LIKE '%114638%' OR A.STYL_NBR LIKE
'%309937%' OR A.STYL_NBR LIKE '%115655%' OR A.STYL_NBR LIKE '%211368%'
OR A.STYL_NBR LIKE '310135%' OR A.STYL_NBR LIKE '%591406%' OR
A.STYL_NBR LIKE '%114819%' OR A.STYL_NBR LIKE '%307815%' OR A.STYL_NBR
LIKE '%188711%' OR A.STYL_NBR LIKE '%115926%' OR A.STYL_NBR LIKE
'%sc0654%' OR A.STYL_NBR LIKE '%590912%' OR A.STYL_NBR LIKE '%ba0620%'
OR A.STYL_NBR LIKE '%116409%' OR A.STYL_NBR LIKE '%305463%' OR
A.STYL_NBR LIKE '%114822%' OR A.STYL_NBR LIKE '307137%' OR A.STYL_NBR
LIKE '310006%' OR A.STYL_NBR LIKE '311369%' OR A.STYL_NBR LIKE
'311610%' OR A.STYL_NBR LIKE '308734%' OR A.STYL_NBR LIKE '%308977%' OR
A.STYL_NBR LIKE '%310503%' OR A.STYL_NBR LIKE '%308830%' OR A.STYL_NBR
LIKE '%307810%' OR A.STYL_NBR LIKE '192066%' OR A.STYL_NBR LIKE
'%306582%' OR A.STYL_NBR LIKE '309556%' OR A.STYL_NBR LIKE '302457%' OR
A.STYL_NBR LIKE '%295225%' OR A.STYL_NBR LIKE '%188701%' OR A.STYL_NBR
LIKE '%310279%' OR A.STYL_NBR LIKE '305333%' OR A.STYL_NBR LIKE
'%296335%' OR A.STYL_NBR LIKE '%241767%' OR A.STYL_NBR LIKE '%bg0053%'
OR A.STYL_NBR LIKE '%307591%' OR A.STYL_NBR LIKE '%308522%' OR
A.STYL_NBR LIKE '%310372%' OR A.STYL_NBR LIKE '142459%' OR A.STYL_NBR
LIKE '%307902%' OR A.STYL_NBR LIKE '%112627%' OR A.STYL_NBR LIKE
'%116629%' OR A.STYL_NBR LIKE '%193478%' OR A.STYL_NBR LIKE '309373%'
OR A.STYL_NBR LIKE '%192688%' OR A.STYL_NBR LIKE '%sc0732%' OR
A.STYL_NBR LIKE '%118371%' OR A.STYL_NBR LIKE '%bg0042%' OR A.STYL_NBR
LIKE '%ba0754%' OR A.STYL_NBR LIKE '304698%' OR A.STYL_NBR LIKE
'%193396%' OR A.STYL_NBR LIKE '%306979%' OR A.STYL_NBR LIKE '%306467%'
OR A.STYL_NBR LIKE '%117596%' OR A.STYL_NBR LIKE '310154%' OR
A.STYL_NBR LIKE '%116621%' OR A.STYL_NBR LIKE '%142455%' OR A.STYL_NBR
LIKE '%ba0422%' OR A.STYL_NBR LIKE '%116606%' OR A.STYL_NBR LIKE
'307028%' OR A.STYL_NBR LIKE '%BA0627%' OR A.STYL_NBR LIKE '%294839%'
OR A.STYL_NBR LIKE '%gx0019%' OR A.STYL_NBR LIKE '%gx0023%' OR
A.STYL_NBR LIKE '%295878%' OR A.STYL_NBR LIKE '%295184%' OR A.STYL_NBR
LIKE '305319%' OR A.STYL_NBR LIKE '307947%' OR A.STYL_NBR LIKE
'%241802%' OR A.STYL_NBR LIKE '%241771%' OR A.STYL_NBR LIKE '%310441%'
OR A.STYL_NBR LIKE '493516%' OR A.STYL_NBR LIKE '%ba0759%' OR
A.STYL_NBR LIKE '%bg0062%' OR A.STYL_NBR LIKE '%118658%' OR A.STYL_NBR
LIKE '%124689%' OR A.STYL_NBR LIKE '308818%' OR A.STYL_NBR LIKE
'%118248%' OR A.STYL_NBR LIKE '%ba0849%' OR A.STYL_NBR LIKE '306440%'
OR A.STYL_NBR LIKE '%492451%' OR A.STYL_NBR LIKE '%297391%' OR
A.STYL_NBR LIKE '%295910%' OR A.STYL_NBR LIKE '%ba0847%' OR A.STYL_NBR
LIKE '%ba0764%' OR A.STYL_NBR LIKE '%241799%' OR A.STYL_NBR LIKE
'306955%' OR A.STYL_NBR LIKE '%116744%' OR A.STYL_NBR LIKE '302466%' OR
A.STYL_NBR LIKE '%116770%' OR A.STYL_NBR LIKE '%295900%' OR A.STYL_NBR
LIKE '%193495%' OR A.STYL_NBR LIKE '%308537%' OR A.STYL_NBR LIKE
'%118373%' OR A.STYL_NBR LIKE '%307804%' OR A.STYL_NBR LIKE '%114321%'
OR A.STYL_NBR LIKE '%116641%' OR A.STYL_NBR LIKE '%296815%' OR
A.STYL_NBR LIKE '308964%' OR A.STYL_NBR LIKE '%492496%' OR A.STYL_NBR
LIKE '%191600%' OR A.STYL_NBR LIKE '%116605%' OR A.STYL_NBR LIKE
'%310187%' OR A.STYL_NBR LIKE '%190204%' OR A.STYL_NBR LIKE '%191183%'
OR A.STYL_NBR LIKE '%ba0390%' OR A.STYL_NBR LIKE '%183896%' OR
A.STYL_NBR LIKE '%137060%' OR A.STYL_NBR LIKE '%137056%' OR A.STYL_NBR
LIKE '%211355%' OR A.STYL_NBR LIKE '306159%' OR A.STYL_NBR LIKE
'305315%' OR A.STYL_NBR LIKE '%295937%' OR A.STYL_NBR LIKE '%305287%'
OR A.STYL_NBR LIKE '%117612%' OR A.STYL_NBR LIKE '%ba0852%' OR
A.STYL_NBR LIKE '311057%' OR A.STYL_NBR LIKE '311505%' OR A.STYL_NBR
LIKE '309441%' OR A.STYL_NBR LIKE '%307625%' OR A.STYL_NBR LIKE
'%125483%' OR A.STYL_NBR LIKE '%223830%' OR A.STYL_NBR LIKE '%115904%'
OR A.STYL_NBR LIKE '%184957%' OR A.STYL_NBR LIKE '%fc0004%' OR
A.STYL_NBR LIKE '%fc0003%' OR A.STYL_NBR LIKE '%296617%' OR A.STYL_NBR
LIKE '307510%' OR A.STYL_NBR LIKE '%593971%' OR A.STYL_NBR LIKE
'%SC0731%' OR A.STYL_NBR LIKE '%295214%' OR A.STYL_NBR LIKE '305484%'
OR A.STYL_NBR LIKE '%117657%' OR A.STYL_NBR LIKE '%116786%' OR
A.STYL_NBR LIKE '%309038%' OR A.STYL_NBR LIKE '%310153%' OR A.STYL_NBR
LIKE '306352%' OR A.STYL_NBR LIKE '%294857%' OR A.STYL_NBR LIKE
'%193131%' OR A.STYL_NBR LIKE '%191211%' OR A.STYL_NBR LIKE '%116759%'
OR A.STYL_NBR LIKE '%593977%' OR A.STYL_NBR LIKE '%593978%' OR
A.STYL_NBR LIKE '%296331%' OR A.STYL_NBR LIKE '%116613%' OR A.STYL_NBR
LIKE '%307201%' OR A.STYL_NBR LIKE '%190746%' OR A.STYL_NBR LIKE
'%308034%' OR A.STYL_NBR LIKE '305618%' OR A.STYL_NBR LIKE '%BA0387%'
OR A.STYL_NBR LIKE '101913%' OR A.STYL_NBR LIKE '%124776%' OR
A.STYL_NBR LIKE '306290%' OR A.STYL_NBR LIKE '%116796%' OR A.STYL_NBR
LIKE '306578%' OR A.STYL_NBR LIKE '%114827%' OR A.STYL_NBR LIKE
'306962%' OR A.STYL_NBR LIKE '%ba0758%' OR A.STYL_NBR LIKE '%294906%'
OR A.STYL_NBR LIKE '%116617%' OR A.STYL_NBR LIKE '306308%' OR
A.STYL_NBR LIKE '309500%' OR A.STYL_NBR LIKE '%124772%' OR A.STYL_NBR
LIKE '%309023%' OR A.STYL_NBR LIKE '311211%' OR A.STYL_NBR LIKE
'311161%' OR A.STYL_NBR LIKE '311347%' OR A.STYL_NBR LIKE '%308896%' OR
A.STYL_NBR LIKE '%116259%' OR A.STYL_NBR LIKE '%224900%' OR A.STYL_NBR
LIKE '%310188%' OR A.STYL_NBR LIKE '%SC0675%' OR A.STYL_NBR LIKE
'%591312%' OR A.STYL_NBR LIKE '%293930%' OR A.STYL_NBR LIKE '%114830%'
OR A.STYL_NBR LIKE '%593081%' OR A.STYL_NBR LIKE '%223202%' OR
A.STYL_NBR LIKE '305316%' OR A.STYL_NBR LIKE '%308658%' OR A.STYL_NBR
LIKE '%sp0114%' OR A.STYL_NBR LIKE '%241910%' OR A.STYL_NBR LIKE
'%308992%' OR A.STYL_NBR LIKE '%241593%' OR A.STYL_NBR LIKE '%195155%')
UNION (SELECT A.SRC_SYS_CD SRC_SYSTEM, A.INSTN_CD, A.STYL_NBR STYLE,
A.COLR_NBR COLOR, E.CATLG_CD CATALOG_ID, A.CAT_ID CATEGORY_ID,
A.GPC_CD GPC_CODE, A.GNDR_ID GENDER_ID, A.TECH_INFO TECH_INFO,
A.THMB_IMG_PATHNM THMB_NAIL_IMG, A.LRG_IMG_PATHNM ENLRG_IMG,
A.QUAL_CD QUAL_CD, A.PROD_DESC PROD_DESC, D.LNCH_DT LNCH_DT,
E.BEG_DT CAT_BEG_DT, E.END_DT CAT_END_DT, E.CATLG_NM CATALOG_NM,
F.PRC_LST_ID, F.LIST_PRC_FL LISTPRICE_FLAG, F.PRC_BEG_DT
PRC_BEG_DT, F.PRC_END_DT, F.PRC_AMT PRICE_AMT, H.GNDR_NM
GENDER_NM, I.TRSL_TXT GPC_NM, J.CAT_NM CATEGORY_NM, K.SRC_SESN_CD
SEASON_CD, K.SESN_NM SEASON_NM , U.SRC_UOM_CD UOM_CODE FROM
WOE_STYLE_COLOR_INSTN A, WOE_STYLE_COLOR C, WOE_STYLE D, WOE_CATALOG
E, WOE_PRODUCT_PRICE F, WOE_GPC G, WOE_GENDER H,
WOE_WEB_CONTENT_TRANSLATIONS I, WOE_UOM U,WOE_CATEGORY J, WOE_SEASON K
WHERE A.SRC_SYS_CD = 'ARG' AND C.SRC_SYS_CD = 'ARG' AND A.STYL_NBR =
C.STYL_NBR AND A.COLR_NBR = C.COLR_NBR AND A.QUAL_CD = C.QUAL_CD AND
D.SRC_SYS_CD = 'ARG' AND A.STYL_NBR = D.STYL_NBR AND A.INSTN_CD =
'1' AND E.INSTN_CD = '1' AND C.ACT_FL = 1 AND D.ACT_FL = 1 AND
F.SRC_SYS_CD = 'ARG' AND A.STYL_NBR = F.STYL_NBR AND A.COLR_NBR =
F.COLR_NBR AND A.QUAL_CD = F.QUAL_CD AND U.UOM_ID = D.UOM_ID AND
F.PRC_BEG_DT <= sysdate AND NVL(F.PRC_END_DT, TO_DATE('01-01-2099',
'MM-DD-YYYY')) >= sysdate AND H.GNDR_ID = A.GNDR_ID AND J.CAT_ID =
A.CAT_ID AND G.GPC_CD = A.GPC_CD AND K.SESN_ID = A.SESN_ID AND
I.WEB_CTNT_CD = G.WEB_CTNT_CD AND I.TRSL_LNG_ID = 3 AND
F.LIST_PRC_FL = 1 AND A.SRC_SYS_CD = 'ARG' AND A.INSTN_CD = 1 AND
E.CATLG_CD IN ( 80 ) AND ( (A.GPC_CD = 03 AND F.PRC_LST_ID = 26
AND F.PRC_AMT >= 0.0 AND F.PRC_AMT <=9999.0) OR (A.GPC_CD = 04 AND
F.PRC_LST_ID = 25 AND F.PRC_AMT >= 0.0 AND F.PRC_AMT <=9999.0) OR
(A.GPC_CD = 02 AND F.PRC_LST_ID = 24 AND F.PRC_AMT >= 0.0 AND
F.PRC_AMT <=9999.0)) AND A.GNDR_ID IN ( 8,10,9 ) AND A.CAT_ID IN
(852,773,390,377,940,564,440,929,846,946,435,458,373,847,943,380,407,382,941,384,565,388,374,557,403,375,765,372,768,559,562,942,443,441,387,767,386,760,437,359,775,381,362,406,436,843,763,947,930,370,450,385,700,814,439,740,701,376,412,698,424,761,364,922,845,558,766,389,563,454,383,764,848,396,699,419,442,379,849,378,908)
AND (( A.STYL_NBR = 'null' AND A.COLR_NBR = 'null' ) OR ( A.STYL_NBR =
'null' AND A.COLR_NBR = 'null' ) OR ( A.STYL_NBR = 'null' AND
A.COLR_NBR = 'null' ) OR ( A.STYL_NBR = 'null' AND A.COLR_NBR = 'null'
) OR ( A.STYL_NBR = 'null' AND A.COLR_NBR = 'null' )) AND C.LFCY_CD IN
(10,20) AND NOT (A.STYL_NBR LIKE '%294851%' OR A.STYL_NBR LIKE
'%307616%' OR A.STYL_NBR LIKE '306967%' OR A.STYL_NBR LIKE '%115912%'
OR A.STYL_NBR LIKE '%296345%' OR A.STYL_NBR LIKE '%117995%' OR
A.STYL_NBR LIKE '%308951%' OR A.STYL_NBR LIKE '%113646%' OR A.STYL_NBR
LIKE '%310229%' OR A.STYL_NBR LIKE '%117898%' OR A.STYL_NBR LIKE
'%117899%' OR A.STYL_NBR LIKE '%308718%' OR A.STYL_NBR LIKE '%241809%'
OR A.STYL_NBR LIKE '%ba0919%' OR A.STYL_NBR LIKE '%115645%' OR
A.STYL_NBR LIKE '%ba0391%' OR A.STYL_NBR LIKE '%gl0168%' OR A.STYL_NBR
LIKE '%595144%' OR A.STYL_NBR LIKE '%594524%' OR A.STYL_NBR LIKE
'%440460%' OR A.STYL_NBR LIKE '%114852%' OR A.STYL_NBR LIKE '%114857%'
OR A.STYL_NBR LIKE '%310225%' OR A.STYL_NBR LIKE '%310008%' OR
A.STYL_NBR LIKE '%BA0736%' OR A.STYL_NBR LIKE '%BA0856%' OR A.STYL_NBR
LIKE '%BA0737%' OR A.STYL_NBR LIKE '%116795%' OR A.STYL_NBR LIKE
'%125482%' OR A.STYL_NBR LIKE '%296958%' OR A.STYL_NBR LIKE '%116916%'
OR A.STYL_NBR LIKE '%193483%' OR A.STYL_NBR LIKE '%241862%' OR
A.STYL_NBR LIKE '%ba0704%' OR A.STYL_NBR LIKE '%sc0658%' OR A.STYL_NBR
LIKE '305414%' OR A.STYL_NBR LIKE '%117932%' OR A.STYL_NBR LIKE
'%440444%' OR A.STYL_NBR LIKE '311101%' OR A.STYL_NBR LIKE '%SP0114%'
OR A.STYL_NBR LIKE '%591405%' OR A.STYL_NBR LIKE '303919%' OR
A.STYL_NBR LIKE '%691472%' OR A.STYL_NBR LIKE '%225288%' OR A.STYL_NBR
LIKE '%225126%' OR A.STYL_NBR LIKE '%195153%' OR A.STYL_NBR LIKE
'%604139%' OR A.STYL_NBR LIKE '%118817%' OR A.STYL_NBR LIKE '210551%'
OR A.STYL_NBR LIKE '302517%' OR A.STYL_NBR LIKE '%225110%' OR
A.STYL_NBR LIKE '309511%' OR A.STYL_NBR LIKE '%308823%' OR A.STYL_NBR
LIKE '%225128%' OR A.STYL_NBR LIKE '309693%' OR A.STYL_NBR LIKE
'%307474%' OR A.STYL_NBR LIKE '%ba0917%' OR A.STYL_NBR LIKE '%304696%'
OR A.STYL_NBR LIKE '310856%' OR A.STYL_NBR LIKE '%241723%' OR
A.STYL_NBR LIKE '%195148%' OR A.STYL_NBR LIKE '%BA0738%' OR A.STYL_NBR
LIKE '%195147%' OR A.STYL_NBR LIKE '%ba0426%' OR A.STYL_NBR LIKE
'%211335%' OR A.STYL_NBR LIKE '%308673%' OR A.STYL_NBR LIKE '306974%'
OR A.STYL_NBR LIKE '%295829%' OR A.STYL_NBR LIKE '%124688%' OR
A.STYL_NBR LIKE '%117703%' OR A.STYL_NBR LIKE '%310247%' OR A.STYL_NBR
LIKE '309495%' OR A.STYL_NBR LIKE '%BA0912%' OR A.STYL_NBR LIKE
'%BA0878%' OR A.STYL_NBR LIKE '%211475%' OR A.STYL_NBR LIKE '%211473%'
OR A.STYL_NBR LIKE '%225130%' OR A.STYL_NBR LIKE '%309502%' OR
A.STYL_NBR LIKE '%297660%' OR A.STYL_NBR LIKE '%190463%' OR A.STYL_NBR
LIKE '%193022%' OR A.STYL_NBR LIKE '%296821%' OR A.STYL_NBR LIKE
'306373%' OR A.STYL_NBR LIKE '%115845%' OR A.STYL_NBR LIKE '%gs0126%'
OR A.STYL_NBR LIKE '%307944%' OR A.STYL_NBR LIKE '%193040%' OR
A.STYL_NBR LIKE '%241815%' OR A.STYL_NBR LIKE '%308642%' OR A.STYL_NBR
LIKE '%117629%' OR A.STYL_NBR LIKE '%294847%' OR A.STYL_NBR LIKE
'%190192%' OR A.STYL_NBR LIKE '%113636%' OR A.STYL_NBR LIKE '%309498%'
OR A.STYL_NBR LIKE '%309344%' OR A.STYL_NBR LIKE '%ba0916%' OR
A.STYL_NBR LIKE '%492434%' OR A.STYL_NBR LIKE '%307821%' OR A.STYL_NBR
LIKE '%310347%' OR A.STYL_NBR LIKE '%116263%' OR A.STYL_NBR LIKE
'%296899%' OR A.STYL_NBR LIKE '%191184%' OR A.STYL_NBR LIKE '%307785%'
OR A.STYL_NBR LIKE '%115882%' OR A.STYL_NBR LIKE '%308644%' OR
A.STYL_NBR LIKE '%142604%' OR A.STYL_NBR LIKE '%116772%' OR A.STYL_NBR
LIKE '%gx0024%' OR A.STYL_NBR LIKE '%308530%' OR A.STYL_NBR LIKE
'%250551%' OR A.STYL_NBR LIKE '%296804%' OR A.STYL_NBR LIKE '%225127%'
OR A.STYL_NBR LIKE '%141983%' OR A.STYL_NBR LIKE '%793668%' OR
A.STYL_NBR LIKE '%310041%' OR A.STYL_NBR LIKE '%296818%' OR A.STYL_NBR
LIKE '%BA0911%' OR A.STYL_NBR LIKE '%307566%' OR A.STYL_NBR LIKE
'%307703%' OR A.STYL_NBR LIKE '%117646%' OR A.STYL_NBR LIKE '%142605%'
OR A.STYL_NBR LIKE '%BA0910%' OR A.STYL_NBR LIKE '%118752%' OR
A.STYL_NBR LIKE '%308531%' OR A.STYL_NBR LIKE '%211282%' OR A.STYL_NBR
LIKE '%142326%' OR A.STYL_NBR LIKE '%193394%' OR A.STYL_NBR LIKE
'%304911%' OR A.STYL_NBR LIKE '%193016%' OR A.STYL_NBR LIKE '%295199%'
OR A.STYL_NBR LIKE '%308643%' OR A.STYL_NBR LIKE '142525%' OR
A.STYL_NBR LIKE '%311050%' OR A.STYL_NBR LIKE '%311520%' OR A.STYL_NBR
LIKE '%ba0932%' OR A.STYL_NBR LIKE '%112001%' OR A.STYL_NBR LIKE
'%ba0929%' OR A.STYL_NBR LIKE '%ba0848%' OR A.STYL_NBR LIKE '%309374%'
OR A.STYL_NBR LIKE '%SC0845%' OR A.STYL_NBR LIKE '%117644%' OR
A.STYL_NBR LIKE '%fe0070%' OR A.STYL_NBR LIKE '306951%' OR A.STYL_NBR
LIKE '%193397%' OR A.STYL_NBR LIKE '%137614%' OR A.STYL_NBR LIKE
'%310397%' OR A.STYL_NBR LIKE '304738%' OR A.STYL_NBR LIKE '%112738%'
OR A.STYL_NBR LIKE '%124771%' OR A.STYL_NBR LIKE '%sc0675%' OR
A.STYL_NBR LIKE '%116415%' OR A.STYL_NBR LIKE '%241911%' OR A.STYL_NBR
LIKE '%241906%' OR A.STYL_NBR LIKE '306485%' OR A.STYL_NBR LIKE
'%ba0933%' OR A.STYL_NBR LIKE '304030%' OR A.STYL_NBR LIKE '%305619%'
OR A.STYL_NBR LIKE '%gg0094%' OR A.STYL_NBR LIKE '%142321%' OR
A.STYL_NBR LIKE '306515%' OR A.STYL_NBR LIKE '308229%' OR A.STYL_NBR
LIKE '308931%' OR A.STYL_NBR LIKE '308933%' OR A.STYL_NBR LIKE
'%112677%' OR A.STYL_NBR LIKE '311121%' OR A.STYL_NBR LIKE '311022%' OR
A.STYL_NBR LIKE '311033%' OR A.STYL_NBR LIKE '%117549%' OR A.STYL_NBR
LIKE '142611%' OR A.STYL_NBR LIKE '142478%' OR A.STYL_NBR LIKE
'%117532%' OR A.STYL_NBR LIKE '%184947%' OR A.STYL_NBR LIKE '309504%'
OR A.STYL_NBR LIKE '%293909%' OR A.STYL_NBR LIKE '%293923%' OR
A.STYL_NBR LIKE '%309386%' OR A.STYL_NBR LIKE '%308561%' OR A.STYL_NBR
LIKE '%250550%' OR A.STYL_NBR LIKE '%fc0006%' OR A.STYL_NBR LIKE
'%307715%' OR A.STYL_NBR LIKE '%117772%' OR A.STYL_NBR LIKE '309369%'
OR A.STYL_NBR LIKE '%137618%' OR A.STYL_NBR LIKE '%118252%' OR
A.STYL_NBR LIKE '%307802%' OR A.STYL_NBR LIKE '%118901%' OR A.STYL_NBR
LIKE '%142315%' OR A.STYL_NBR LIKE '%118890%' OR A.STYL_NBR LIKE
'%423301%' OR A.STYL_NBR LIKE '%114219%' OR A.STYL_NBR LIKE '%295938%'
OR A.STYL_NBR LIKE '%ba0703%' OR A.STYL_NBR LIKE '%310257%' OR
A.STYL_NBR LIKE '440418%' OR A.STYL_NBR LIKE '306198%' OR A.STYL_NBR
LIKE '%137059%' OR A.STYL_NBR LIKE '112665%' OR A.STYL_NBR LIKE
'308975%' OR A.STYL_NBR LIKE '%117902%' OR A.STYL_NBR LIKE '309512%' OR
A.STYL_NBR LIKE '%311159%' OR A.STYL_NBR LIKE '%295832%' OR A.STYL_NBR
LIKE '311317%' OR A.STYL_NBR LIKE '306248%' OR A.STYL_NBR LIKE
'309427%' OR A.STYL_NBR LIKE '309432%' OR A.STYL_NBR LIKE '309440%' OR
A.STYL_NBR LIKE '310723%' OR A.STYL_NBR LIKE '%307895%' OR A.STYL_NBR
LIKE '306222%' OR A.STYL_NBR LIKE '%306265%' OR A.STYL_NBR LIKE
'%308662%' OR A.STYL_NBR LIKE '%116608%' OR A.STYL_NBR LIKE '%310200%'
OR A.STYL_NBR LIKE '%306161%' OR A.STYL_NBR LIKE '%295512%' OR
A.STYL_NBR LIKE '%295936%' OR A.STYL_NBR LIKE '%307863%' OR A.STYL_NBR
LIKE '%309488%' OR A.STYL_NBR LIKE '%224549%' OR A.STYL_NBR LIKE
'%111989%' OR A.STYL_NBR LIKE '309467%' OR A.STYL_NBR LIKE '306546%' OR
A.STYL_NBR LIKE '%117587%' OR A.STYL_NBR LIKE '%193398%' OR A.STYL_NBR
LIKE '%307576%' OR A.STYL_NBR LIKE '%211272%' OR A.STYL_NBR LIKE
'%193489%' OR A.STYL_NBR LIKE '%111850%' OR A.STYL_NBR LIKE '%142453%'
OR A.STYL_NBR LIKE '%310429%' OR A.STYL_NBR LIKE '306472%' OR
A.STYL_NBR LIKE '609044%' OR A.STYL_NBR LIKE '308849%' OR A.STYL_NBR
LIKE '%193015%' OR A.STYL_NBR LIKE '%ba0766%' OR A.STYL_NBR LIKE
'%307808%' OR A.STYL_NBR LIKE '%112664%' OR A.STYL_NBR LIKE '%115892%'
OR A.STYL_NBR LIKE '%124773%' OR A.STYL_NBR LIKE '%sc0755%' OR
A.STYL_NBR LIKE '%116386%' OR A.STYL_NBR LIKE '%211470%' OR A.STYL_NBR
LIKE '309476%' OR A.STYL_NBR LIKE '%191703%' OR A.STYL_NBR LIKE
'%296509%' OR A.STYL_NBR LIKE '%114654%' OR A.STYL_NBR LIKE '%297814%'
OR A.STYL_NBR LIKE '311124%' OR A.STYL_NBR LIKE '%116258%' OR
A.STYL_NBR LIKE '%308665%' OR A.STYL_NBR LIKE '306620%' OR A.STYL_NBR
LIKE '%115827%' OR A.STYL_NBR LIKE '%137611%' OR A.STYL_NBR LIKE
'%124693%' OR A.STYL_NBR LIKE '%440447%' OR A.STYL_NBR LIKE '%ba0747%'
OR A.STYL_NBR LIKE '%308575%' OR A.STYL_NBR LIKE '%298626%' OR
A.STYL_NBR LIKE '%295213%' OR A.STYL_NBR LIKE '%308885%' OR A.STYL_NBR
LIKE '309538%' OR A.STYL_NBR LIKE '309549%' OR A.STYL_NBR LIKE
'%gl0056%' OR A.STYL_NBR LIKE '306353%' OR A.STYL_NBR LIKE '%296561%'
OR A.STYL_NBR LIKE '%307612%' OR A.STYL_NBR LIKE '%306779%' OR
A.STYL_NBR LIKE '%193019%' OR A.STYL_NBR LIKE '%241751%' OR A.STYL_NBR
LIKE '%309457%' OR A.STYL_NBR LIKE '%117631%' OR A.STYL_NBR LIKE
'%190717%' OR A.STYL_NBR LIKE '%241866%' OR A.STYL_NBR LIKE '306518%'
OR A.STYL_NBR LIKE '%310305%' OR A.STYL_NBR LIKE '%118896%' OR
A.STYL_NBR LIKE '%293904%' OR A.STYL_NBR LIKE '%310332%' OR A.STYL_NBR
LIKE '%308344%' OR A.STYL_NBR LIKE '%188680%' OR A.STYL_NBR LIKE
'%116412%' OR A.STYL_NBR LIKE '%gl0167%' OR A.STYL_NBR LIKE '%gl0166%'
OR A.STYL_NBR LIKE '%493682%' OR A.STYL_NBR LIKE '%114231%' OR
A.STYL_NBR LIKE '%310239%' OR A.STYL_NBR LIKE '%309454%' OR A.STYL_NBR
LIKE '309469%' OR A.STYL_NBR LIKE '309470%' OR A.STYL_NBR LIKE
'%112679%' OR A.STYL_NBR LIKE '%211430%' OR A.STYL_NBR LIKE '%308897%'
OR A.STYL_NBR LIKE '%225237%' OR A.STYL_NBR LIKE '%307803%' OR
A.STYL_NBR LIKE '%304822%' OR A.STYL_NBR LIKE '%307801%' OR A.STYL_NBR
LIKE '%115880%' OR A.STYL_NBR LIKE '%fc0014%' OR A.STYL_NBR LIKE
'%116410%' OR A.STYL_NBR LIKE '%309988%' OR A.STYL_NBR LIKE '307819%'
OR A.STYL_NBR LIKE '307934%' OR A.STYL_NBR LIKE '%114234%' OR
A.STYL_NBR LIKE '%590903%' OR A.STYL_NBR LIKE '%423300%' OR A.STYL_NBR
LIKE '%295203%' OR A.STYL_NBR LIKE '%294883%' OR A.STYL_NBR LIKE
'%307511%' OR A.STYL_NBR LIKE '%114616%' OR A.STYL_NBR LIKE '%241438%'
OR A.STYL_NBR LIKE '%308641%' OR A.STYL_NBR LIKE '%308841%' OR
A.STYL_NBR LIKE '%307679%' OR A.STYL_NBR LIKE '%114818%' OR A.STYL_NBR
LIKE '%308300%' OR A.STYL_NBR LIKE '304714%' OR A.STYL_NBR LIKE
'309503%' OR A.STYL_NBR LIKE '222802%' OR A.STYL_NBR LIKE '%308661%' OR
A.STYL_NBR LIKE '%116760%' OR A.STYL_NBR LIKE '306623%' OR A.STYL_NBR
LIKE '%293686%' OR A.STYL_NBR LIKE '%297389%' OR A.STYL_NBR LIKE
'%124621%' OR A.STYL_NBR LIKE '%116616%' OR A.STYL_NBR LIKE '%294887%'
OR A.STYL_NBR LIKE '%310641%' OR A.STYL_NBR LIKE '%112215%' OR
A.STYL_NBR LIKE '%423304%' OR A.STYL_NBR LIKE '%116612%' OR A.STYL_NBR
LIKE '%310238%' OR A.STYL_NBR LIKE '%494466%' OR A.STYL_NBR LIKE
'%494463%' OR A.STYL_NBR LIKE '%440459%' OR A.STYL_NBR LIKE '%494530%'
OR A.STYL_NBR LIKE '%193047%' OR A.STYL_NBR LIKE '%111998%' OR
A.STYL_NBR LIKE '306429%' OR A.STYL_NBR LIKE '%sc0718%' OR A.STYL_NBR
LIKE '%117590%' OR A.STYL_NBR LIKE '%118775%' OR A.STYL_NBR LIKE
'%142408%' OR A.STYL_NBR LIKE '%142322%' OR A.STYL_NBR LIKE '%193350%'
OR A.STYL_NBR LIKE '309456%' OR A.STYL_NBR LIKE '%493523%' OR
A.STYL_NBR LIKE '%224744%' OR A.STYL_NBR LIKE '%SC0844%' OR A.STYL_NBR
LIKE '%293902%' OR A.STYL_NBR LIKE '%310374%' OR A.STYL_NBR LIKE
'%115871%' OR A.STYL_NBR LIKE '%211251%' OR A.STYL_NBR LIKE '%241912%'
OR A.STYL_NBR LIKE '%296328%' OR A.STYL_NBR LIKE '%117621%' OR
A.STYL_NBR LIKE '309616%' OR A.STYL_NBR LIKE '%295823%' OR A.STYL_NBR
LIKE '%624044%' OR A.STYL_NBR LIKE '304703%' OR A.STYL_NBR LIKE
'%190739%' OR A.STYL_NBR LIKE '%307060%' OR A.STYL_NBR LIKE '%308809%'
OR A.STYL_NBR LIKE '%305410%' OR A.STYL_NBR LIKE '%304891%' OR
A.STYL_NBR LIKE '%224782%' OR A.STYL_NBR LIKE '%ba0388%' OR A.STYL_NBR
LIKE '%308931%' OR A.STYL_NBR LIKE '%682595%' OR A.STYL_NBR LIKE
'%116256%' OR A.STYL_NBR LIKE '%297388%' OR A.STYL_NBR LIKE '%296321%'
OR A.STYL_NBR LIKE '%116404%' OR A.STYL_NBR LIKE '308847%' OR
A.STYL_NBR LIKE '%492538%' OR A.STYL_NBR LIKE '%224550%' OR A.STYL_NBR
LIKE '%293903%' OR A.STYL_NBR LIKE '%493663%' OR A.STYL_NBR LIKE
'%308720%' OR A.STYL_NBR LIKE '%296318%' OR A.STYL_NBR LIKE '%124629%'
OR A.STYL_NBR LIKE '306597%' OR A.STYL_NBR LIKE '%BA0390%' OR
A.STYL_NBR LIKE '%193051%' OR A.STYL_NBR LIKE '%493674%' OR A.STYL_NBR
LIKE '%293974%' OR A.STYL_NBR LIKE '%241806%' OR A.STYL_NBR LIKE
'%137211%' OR A.STYL_NBR LIKE '%114323%' OR A.STYL_NBR LIKE '%112210%'
OR A.STYL_NBR LIKE '%492448%' OR A.STYL_NBR LIKE '%142523%' OR
A.STYL_NBR LIKE '%294828%' OR A.STYL_NBR LIKE '%SC0658%' OR A.STYL_NBR
LIKE '%295194%' OR A.STYL_NBR LIKE '%211366%' OR A.STYL_NBR LIKE
'%137310%' OR A.STYL_NBR LIKE '%118899%' OR A.STYL_NBR LIKE '%307807%'
OR A.STYL_NBR LIKE '%ba0424%' OR A.STYL_NBR LIKE '%192101%' OR
A.STYL_NBR LIKE '304891%' OR A.STYL_NBR LIKE '306438%' OR A.STYL_NBR
LIKE '%124628%' OR A.STYL_NBR LIKE '%308844%' OR A.STYL_NBR LIKE
'303950%' OR A.STYL_NBR LIKE '%117705%' OR A.STYL_NBR LIKE '%183911%'
OR A.STYL_NBR LIKE '%116374%' OR A.STYL_NBR LIKE '%118241%' OR
A.STYL_NBR LIKE '183219%' OR A.STYL_NBR LIKE '307811%' OR A.STYL_NBR
LIKE '142597%' OR A.STYL_NBR LIKE '305572%' OR A.STYL_NBR LIKE
'%117604%' OR A.STYL_NBR LIKE '%307982%' OR A.STYL_NBR LIKE '%116604%'
OR A.STYL_NBR LIKE '%308013%' OR A.STYL_NBR LIKE '%193017%' OR
A.STYL_NBR LIKE '%307761%' OR A.STYL_NBR LIKE '186050%' OR A.STYL_NBR
LIKE '%bg0049%' OR A.STYL_NBR LIKE '308851%' OR A.STYL_NBR LIKE
'%118237%' OR A.STYL_NBR LIKE '%308717%' OR A.STYL_NBR LIKE '%295847%'
OR A.STYL_NBR LIKE '%310113%' OR A.STYL_NBR LIKE '%117578%' OR
A.STYL_NBR LIKE '%307240%' OR A.STYL_NBR LIKE '%297042%' OR A.STYL_NBR
LIKE '%305334%' OR A.STYL_NBR LIKE '308634%' OR A.STYL_NBR LIKE
'%306927%' OR A.STYL_NBR LIKE '%142413%' OR A.STYL_NBR LIKE '%308683%'
OR A.STYL_NBR LIKE '%sc0730%' OR A.STYL_NBR LIKE '%116578%' OR
A.STYL_NBR LIKE '%125651%' OR A.STYL_NBR LIKE '%SC0732%' OR A.STYL_NBR
LIKE '%185808%' OR A.STYL_NBR LIKE '307087%' OR A.STYL_NBR LIKE
'%118376%' OR A.STYL_NBR LIKE '%124627%' OR A.STYL_NBR LIKE '306549%'
OR A.STYL_NBR LIKE '%308933%' OR A.STYL_NBR LIKE '%114821%' OR
A.STYL_NBR LIKE '%295943%' OR A.STYL_NBR LIKE '%117996%' OR A.STYL_NBR
LIKE '%115889%' OR A.STYL_NBR LIKE '306503%' OR A.STYL_NBR LIKE
'%309989%' OR A.STYL_NBR LIKE '%241740%' OR A.STYL_NBR LIKE '%fc0007%'
OR A.STYL_NBR LIKE '%691474%' OR A.STYL_NBR LIKE '%118861%' OR
A.STYL_NBR LIKE '%118834%' OR A.STYL_NBR LIKE '%193395%' OR A.STYL_NBR
LIKE '142606%' OR A.STYL_NBR LIKE '%114247%' OR A.STYL_NBR LIKE
'%308229%' OR A.STYL_NBR LIKE '%440432%' OR A.STYL_NBR LIKE '%307061%'
OR A.STYL_NBR LIKE '%sc0673%' OR A.STYL_NBR LIKE '308973%' OR
A.STYL_NBR LIKE '304986%' OR A.STYL_NBR LIKE '%114824%' OR A.STYL_NBR
LIKE '183234%' OR A.STYL_NBR LIKE '306950%' OR A.STYL_NBR LIKE
'%308668%' OR A.STYL_NBR LIKE '%190462%' OR A.STYL_NBR LIKE '%117626%'
OR A.STYL_NBR LIKE '%142093%' OR A.STYL_NBR LIKE '306281%' OR
A.STYL_NBR LIKE '%gl0057%' OR A.STYL_NBR LIKE '310290%' OR A.STYL_NBR
LIKE '%BA0391%' OR A.STYL_NBR LIKE '308251%' OR A.STYL_NBR LIKE
'%307551%' OR A.STYL_NBR LIKE '%112587%' OR A.STYL_NBR LIKE '%309458%'
OR A.STYL_NBR LIKE '%114635%' OR A.STYL_NBR LIKE '%gl0055%' OR
A.STYL_NBR LIKE '%307764%' OR A.STYL_NBR LIKE '309181%' OR A.STYL_NBR
LIKE '%308632%' OR A.STYL_NBR LIKE '%307822%' OR A.STYL_NBR LIKE
'%306200%' OR A.STYL_NBR LIKE '%116637%' OR A.STYL_NBR LIKE '%295826%'
OR A.STYL_NBR LIKE '%117606%' OR A.STYL_NBR LIKE '%112662%' OR
A.STYL_NBR LIKE '%241739%' OR A.STYL_NBR LIKE '%296038%' OR A.STYL_NBR
LIKE '%117597%' OR A.STYL_NBR LIKE '%211254%' OR A.STYL_NBR LIKE
'%124630%' OR A.STYL_NBR LIKE '306304%' OR A.STYL_NBR LIKE '%308014%'
OR A.STYL_NBR LIKE '%117749%' OR A.STYL_NBR LIKE '%343641%' OR
A.STYL_NBR LIKE '%241768%' OR A.STYL_NBR LIKE '306174%' OR A.STYL_NBR
LIKE '305587%' OR A.STYL_NBR LIKE '%295887%' OR A.STYL_NBR LIKE
'307027%' OR A.STYL_NBR LIKE '310071%' OR A.STYL_NBR LIKE '%117593%' OR
A.STYL_NBR LIKE '%224794%' OR A.STYL_NBR LIKE '%305586%' OR A.STYL_NBR
LIKE '307089%' OR A.STYL_NBR LIKE '%310282%' OR A.STYL_NBR LIKE
'%310411%' OR A.STYL_NBR LIKE '309474%' OR A.STYL_NBR LIKE '112591%' OR
A.STYL_NBR LIKE '141993%' OR A.STYL_NBR LIKE '%136744%' OR A.STYL_NBR
LIKE '310177%' OR A.STYL_NBR LIKE '%492493%' OR A.STYL_NBR LIKE
'%115887%' OR A.STYL_NBR LIKE '306961%' OR A.STYL_NBR LIKE '%310007%'
OR A.STYL_NBR LIKE '%294226%' OR A.STYL_NBR LIKE '%308884%' OR
A.STYL_NBR LIKE '%307651%' OR A.STYL_NBR LIKE '%309574%' OR A.STYL_NBR
LIKE '%492527%' OR A.STYL_NBR LIKE '%294043%' OR A.STYL_NBR LIKE
'%117603%' OR A.STYL_NBR LIKE '183232%' OR A.STYL_NBR LIKE '%307621%'
OR A.STYL_NBR LIKE '%117917%' OR A.STYL_NBR LIKE '%294846%' OR
A.STYL_NBR LIKE '%307780%' OR A.STYL_NBR LIKE '302715%' OR A.STYL_NBR
LIKE '%fc0008%' OR A.STYL_NBR LIKE '%142324%' OR A.STYL_NBR LIKE
'%296070%' OR A.STYL_NBR LIKE '%307202%' OR A.STYL_NBR LIKE '%117628%'
OR A.STYL_NBR LIKE '%111483%' OR A.STYL_NBR LIKE '%116414%' OR
A.STYL_NBR LIKE '%116261%' OR A.STYL_NBR LIKE '%307615%' OR A.STYL_NBR
LIKE '306376%' OR A.STYL_NBR LIKE '%296474%' OR A.STYL_NBR LIKE
'%190136%' OR A.STYL_NBR LIKE '303954%' OR A.STYL_NBR LIKE '%124779%'
OR A.STYL_NBR LIKE '306487%' OR A.STYL_NBR LIKE '%112179%' OR
A.STYL_NBR LIKE '310371%' OR A.STYL_NBR LIKE '306683%' OR A.STYL_NBR
LIKE '306963%' OR A.STYL_NBR LIKE '%118895%' OR A.STYL_NBR LIKE
'%295909%' OR A.STYL_NBR LIKE '%308253%' OR A.STYL_NBR LIKE '%113498%'
OR A.STYL_NBR LIKE '%310286%' OR A.STYL_NBR LIKE '310152%' OR
A.STYL_NBR LIKE '%308725%' OR A.STYL_NBR LIKE '%308634%' OR A.STYL_NBR
LIKE '%295197%' OR A.STYL_NBR LIKE '306975%' OR A.STYL_NBR LIKE
'%210757%' OR A.STYL_NBR LIKE '%307756%' OR A.STYL_NBR LIKE '%307754%'
OR A.STYL_NBR LIKE '%111858%' OR A.STYL_NBR LIKE '%310256%' OR
A.STYL_NBR LIKE '%308970%' OR A.STYL_NBR LIKE '%306926%' OR A.STYL_NBR
LIKE '309499%' OR A.STYL_NBR LIKE '310136%' OR A.STYL_NBR LIKE
'310197%' OR A.STYL_NBR LIKE '%117704%' OR A.STYL_NBR LIKE '%310613%'
OR A.STYL_NBR LIKE '%296324%' OR A.STYL_NBR LIKE '%117492%' OR
A.STYL_NBR LIKE '306223%' OR A.STYL_NBR LIKE '%224807%' OR A.STYL_NBR
LIKE '%fe0055%' OR A.STYL_NBR LIKE '%309495%' OR A.STYL_NBR LIKE
'%295802%' OR A.STYL_NBR LIKE '%295797%' OR A.STYL_NBR LIKE '%295798%'
OR A.STYL_NBR LIKE '%295942%' OR A.STYL_NBR LIKE '302493%' OR
A.STYL_NBR LIKE '%116620%' OR A.STYL_NBR LIKE '%114233%' OR A.STYL_NBR
LIKE '%ba0737%' OR A.STYL_NBR LIKE '%ba0738%' OR A.STYL_NBR LIKE
'%295876%' OR A.STYL_NBR LIKE '%137308%' OR A.STYL_NBR LIKE '%307696%'
OR A.STYL_NBR LIKE '%113096%' OR A.STYL_NBR LIKE '%307741%' OR
A.STYL_NBR LIKE '304096%' OR A.STYL_NBR LIKE '%310385%' OR A.STYL_NBR
LIKE '%115670%' OR A.STYL_NBR LIKE '%gg0088%' OR A.STYL_NBR LIKE
'%295228%' OR A.STYL_NBR LIKE '183176%' OR A.STYL_NBR LIKE '%ba0387%'
OR A.STYL_NBR LIKE '%295230%' OR A.STYL_NBR LIKE '%310278%' OR
A.STYL_NBR LIKE '%114243%' OR A.STYL_NBR LIKE '%308963%' OR A.STYL_NBR
LIKE '%117625%' OR A.STYL_NBR LIKE '%310280%' OR A.STYL_NBR LIKE
'%211363%' OR A.STYL_NBR LIKE '310014%' OR A.STYL_NBR LIKE '%ba0635%'
OR A.STYL_NBR LIKE '%117595%' OR A.STYL_NBR LIKE '%224736%' OR
A.STYL_NBR LIKE '%112639%' OR A.STYL_NBR LIKE '%309382%' OR A.STYL_NBR
LIKE '308822%' OR A.STYL_NBR LIKE '%118374%' OR A.STYL_NBR LIKE
'%117706%' OR A.STYL_NBR LIKE '%310213%' OR A.STYL_NBR LIKE '%307550%'
OR A.STYL_NBR LIKE '%306465%' OR A.STYL_NBR LIKE '%142323%' OR
A.STYL_NBR LIKE '%295232%' OR A.STYL_NBR LIKE '%308966%' OR A.STYL_NBR
LIKE '%124619%' OR A.STYL_NBR LIKE '224547%' OR A.STYL_NBR LIKE
'%296142%' OR A.STYL_NBR LIKE '%ba0736%' OR A.STYL_NBR LIKE '310032%'
OR A.STYL_NBR LIKE '%295220%' OR A.STYL_NBR LIKE '%fe0059%' OR
A.STYL_NBR LIKE '%308204%' OR A.STYL_NBR LIKE '%310081%' OR A.STYL_NBR
LIKE '%310080%' OR A.STYL_NBR LIKE '%310026%' OR A.STYL_NBR LIKE
'%306251%' OR A.STYL_NBR LIKE '%bg0013%' OR A.STYL_NBR LIKE '%306263%'
OR A.STYL_NBR LIKE '192054%' OR A.STYL_NBR LIKE '%307589%' OR
A.STYL_NBR LIKE '%307766%' OR A.STYL_NBR LIKE '%188681%' OR A.STYL_NBR
LIKE '%307631%' OR A.STYL_NBR LIKE '305496%' OR A.STYL_NBR LIKE
'306579%' OR A.STYL_NBR LIKE '%307161%' OR A.STYL_NBR LIKE '303918%' OR
A.STYL_NBR LIKE '306448%' OR A.STYL_NBR LIKE '%307984%' OR A.STYL_NBR
LIKE '%294867%' OR A.STYL_NBR LIKE '%137612%' OR A.STYL_NBR LIKE
'%431334%' OR A.STYL_NBR LIKE '%305256%' OR A.STYL_NBR LIKE '%307727%'
OR A.STYL_NBR LIKE '%310388%' OR A.STYL_NBR LIKE '%310284%' OR
A.STYL_NBR LIKE '%116411%' OR A.STYL_NBR LIKE '%gg0098%' OR A.STYL_NBR
LIKE '%191744%' OR A.STYL_NBR LIKE '%116771%' OR A.STYL_NBR LIKE
'%193492%' OR A.STYL_NBR LIKE '%307779%' OR A.STYL_NBR LIKE '%293921%'
OR A.STYL_NBR LIKE '%423341%' OR A.STYL_NBR LIKE '310370%' OR
A.STYL_NBR LIKE '%116640%' OR A.STYL_NBR LIKE '%136431%' OR A.STYL_NBR
LIKE '305488%' OR A.STYL_NBR LIKE '%114823%' OR A.STYL_NBR LIKE
'%296231%' OR A.STYL_NBR LIKE '309664%' OR A.STYL_NBR LIKE '306506%' OR
A.STYL_NBR LIKE '%118385%' OR A.STYL_NBR LIKE '%307856%' OR A.STYL_NBR
LIKE '%116603%' OR A.STYL_NBR LIKE '%295218%' OR A.STYL_NBR LIKE 'BG%'
OR A.STYL_NBR LIKE '309557%' OR A.STYL_NBR LIKE '%307647%' OR
A.STYL_NBR LIKE '%309428%' OR A.STYL_NBR LIKE '%423302%' OR A.STYL_NBR
LIKE '%117611%' OR A.STYL_NBR LIKE '%296313%' OR A.STYL_NBR LIKE
'%302519%' OR A.STYL_NBR LIKE '%116260%' OR A.STYL_NBR LIKE '%310536%'
OR A.STYL_NBR LIKE '%310492%' OR A.STYL_NBR LIKE '%308672%' OR
A.STYL_NBR LIKE '%241755%' OR A.STYL_NBR LIKE '142200%' OR A.STYL_NBR
LIKE '%241816%' OR A.STYL_NBR LIKE '%307928%' OR A.STYL_NBR LIKE
'%142464%' OR A.STYL_NBR LIKE '%307946%' OR A.STYL_NBR LIKE '%193055%'
OR A.STYL_NBR LIKE '%308973%' OR A.STYL_NBR LIKE '%308729%' OR
A.STYL_NBR LIKE '%115893%' OR A.STYL_NBR LIKE '112586%' OR A.STYL_NBR
LIKE '302220%' OR A.STYL_NBR LIKE '%306374%' OR A.STYL_NBR LIKE
'%193477%' OR A.STYL_NBR LIKE '%fe0026%' OR A.STYL_NBR LIKE '%310399%'
OR A.STYL_NBR LIKE '%309327%' OR A.STYL_NBR LIKE '%192858%' OR
A.STYL_NBR LIKE '305533%' OR A.STYL_NBR LIKE '%224806%' OR A.STYL_NBR
LIKE '%307805%' OR A.STYL_NBR LIKE '%114638%' OR A.STYL_NBR LIKE
'%309937%' OR A.STYL_NBR LIKE '%115655%' OR A.STYL_NBR LIKE '%211368%'
OR A.STYL_NBR LIKE '310135%' OR A.STYL_NBR LIKE '%591406%' OR
A.STYL_NBR LIKE '%114819%' OR A.STYL_NBR LIKE '%307815%' OR A.STYL_NBR
LIKE '%188711%' OR A.STYL_NBR LIKE '%115926%' OR A.STYL_NBR LIKE
'%sc0654%' OR A.STYL_NBR LIKE '%590912%' OR A.STYL_NBR LIKE '%ba0620%'
OR A.STYL_NBR LIKE '%116409%' OR A.STYL_NBR LIKE '%305463%' OR
A.STYL_NBR LIKE '%114822%' OR A.STYL_NBR LIKE '307137%' OR A.STYL_NBR
LIKE '310006%' OR A.STYL_NBR LIKE '311369%' OR A.STYL_NBR LIKE
'311610%' OR A.STYL_NBR LIKE '308734%' OR A.STYL_NBR LIKE '%308977%' OR
A.STYL_NBR LIKE '%310503%' OR A.STYL_NBR LIKE '%308830%' OR A.STYL_NBR
LIKE '%307810%' OR A.STYL_NBR LIKE '192066%' OR A.STYL_NBR LIKE
'%306582%' OR A.STYL_NBR LIKE '309556%' OR A.STYL_NBR LIKE '302457%' OR
A.STYL_NBR LIKE '%295225%' OR A.STYL_NBR LIKE '%188701%' OR A.STYL_NBR
LIKE '%310279%' OR A.STYL_NBR LIKE '305333%' OR A.STYL_NBR LIKE
'%296335%' OR A.STYL_NBR LIKE '%241767%' OR A.STYL_NBR LIKE '%bg0053%'
OR A.STYL_NBR LIKE '%307591%' OR A.STYL_NBR LIKE '%308522%' OR
A.STYL_NBR LIKE '%310372%' OR A.STYL_NBR LIKE '142459%' OR A.STYL_NBR
LIKE '%307902%' OR A.STYL_NBR LIKE '%112627%' OR A.STYL_NBR LIKE
'%116629%' OR A.STYL_NBR LIKE '%193478%' OR A.STYL_NBR LIKE '309373%'
OR A.STYL_NBR LIKE '%192688%' OR A.STYL_NBR LIKE '%sc0732%' OR
A.STYL_NBR LIKE '%118371%' OR A.STYL_NBR LIKE '%bg0042%' OR A.STYL_NBR
LIKE '%ba0754%' OR A.STYL_NBR LIKE '304698%' OR A.STYL_NBR LIKE
'%193396%' OR A.STYL_NBR LIKE '%306979%' OR A.STYL_NBR LIKE '%306467%'
OR A.STYL_NBR LIKE '%117596%' OR A.STYL_NBR LIKE '310154%' OR
A.STYL_NBR LIKE '%116621%' OR A.STYL_NBR LIKE '%142455%' OR A.STYL_NBR
LIKE '%ba0422%' OR A.STYL_NBR LIKE '%116606%' OR A.STYL_NBR LIKE
'307028%' OR A.STYL_NBR LIKE '%BA0627%' OR A.STYL_NBR LIKE '%294839%'
OR A.STYL_NBR LIKE '%gx0019%' OR A.STYL_NBR LIKE '%gx0023%' OR
A.STYL_NBR LIKE '%295878%' OR A.STYL_NBR LIKE '%295184%' OR A.STYL_NBR
LIKE '305319%' OR A.STYL_NBR LIKE '307947%' OR A.STYL_NBR LIKE
'%241802%' OR A.STYL_NBR LIKE '%241771%' OR A.STYL_NBR LIKE '%310441%'
OR A.STYL_NBR LIKE '493516%' OR A.STYL_NBR LIKE '%ba0759%' OR
A.STYL_NBR LIKE '%bg0062%' OR A.STYL_NBR LIKE '%118658%' OR A.STYL_NBR
LIKE '%124689%' OR A.STYL_NBR LIKE '308818%' OR A.STYL_NBR LIKE
'%118248%' OR A.STYL_NBR LIKE '%ba0849%' OR A.STYL_NBR LIKE '306440%'
OR A.STYL_NBR LIKE '%492451%' OR A.STYL_NBR LIKE '%297391%' OR
A.STYL_NBR LIKE '%295910%' OR A.STYL_NBR LIKE '%ba0847%' OR A.STYL_NBR
LIKE '%ba0764%' OR A.STYL_NBR LIKE '%241799%' OR A.STYL_NBR LIKE
'306955%' OR A.STYL_NBR LIKE '%116744%' OR A.STYL_NBR LIKE '302466%' OR
A.STYL_NBR LIKE '%116770%' OR A.STYL_NBR LIKE '%295900%' OR A.STYL_NBR
LIKE '%193495%' OR A.STYL_NBR LIKE '%308537%' OR A.STYL_NBR LIKE
'%118373%' OR A.STYL_NBR LIKE '%307804%' OR A.STYL_NBR LIKE '%114321%'
OR A.STYL_NBR LIKE '%116641%' OR A.STYL_NBR LIKE '%296815%' OR
A.STYL_NBR LIKE '308964%' OR A.STYL_NBR LIKE '%492496%' OR A.STYL_NBR
LIKE '%191600%' OR A.STYL_NBR LIKE '%116605%' OR A.STYL_NBR LIKE
'%310187%' OR A.STYL_NBR LIKE '%190204%' OR A.STYL_NBR LIKE '%191183%'
OR A.STYL_NBR LIKE '%ba0390%' OR A.STYL_NBR LIKE '%183896%' OR
A.STYL_NBR LIKE '%137060%' OR A.STYL_NBR LIKE '%137056%' OR A.STYL_NBR
LIKE '%211355%' OR A.STYL_NBR LIKE '306159%' OR A.STYL_NBR LIKE
'305315%' OR A.STYL_NBR LIKE '%295937%' OR A.STYL_NBR LIKE '%305287%'
OR A.STYL_NBR LIKE '%117612%' OR A.STYL_NBR LIKE '%ba0852%' OR
A.STYL_NBR LIKE '311057%' OR A.STYL_NBR LIKE '311505%' OR A.STYL_NBR
LIKE '309441%' OR A.STYL_NBR LIKE '%307625%' OR A.STYL_NBR LIKE
'%125483%' OR A.STYL_NBR LIKE '%223830%' OR A.STYL_NBR LIKE '%115904%'
OR A.STYL_NBR LIKE '%184957%' OR A.STYL_NBR LIKE '%fc0004%' OR
A.STYL_NBR LIKE '%fc0003%' OR A.STYL_NBR LIKE '%296617%' OR A.STYL_NBR
LIKE '307510%' OR A.STYL_NBR LIKE '%593971%' OR A.STYL_NBR LIKE
'%SC0731%' OR A.STYL_NBR LIKE '%295214%' OR A.STYL_NBR LIKE '305484%'
OR A.STYL_NBR LIKE '%117657%' OR A.STYL_NBR LIKE '%116786%' OR
A.STYL_NBR LIKE '%309038%' OR A.STYL_NBR LIKE '%310153%' OR A.STYL_NBR
LIKE '306352%' OR A.STYL_NBR LIKE '%294857%' OR A.STYL_NBR LIKE
'%193131%' OR A.STYL_NBR LIKE '%191211%' OR A.STYL_NBR LIKE '%116759%'
OR A.STYL_NBR LIKE '%593977%' OR A.STYL_NBR LIKE '%593978%' OR
A.STYL_NBR LIKE '%296331%' OR A.STYL_NBR LIKE '%116613%' OR A.STYL_NBR
LIKE '%307201%' OR A.STYL_NBR LIKE '%190746%' OR A.STYL_NBR LIKE
'%308034%' OR A.STYL_NBR LIKE '305618%' OR A.STYL_NBR LIKE '%BA0387%'
OR A.STYL_NBR LIKE '101913%' OR A.STYL_NBR LIKE '%124776%' OR
A.STYL_NBR LIKE '306290%' OR A.STYL_NBR LIKE '%116796%' OR A.STYL_NBR
LIKE '306578%' OR A.STYL_NBR LIKE '%114827%' OR A.STYL_NBR LIKE
'306962%' OR A.STYL_NBR LIKE '%ba0758%' OR A.STYL_NBR LIKE '%294906%'
OR A.STYL_NBR LIKE '%116617%' OR A.STYL_NBR LIKE '306308%' OR
A.STYL_NBR LIKE '309500%' OR A.STYL_NBR LIKE '%124772%' OR A.STYL_NBR
LIKE '%309023%' OR A.STYL_NBR LIKE '311211%' OR A.STYL_NBR LIKE
'311161%' OR A.STYL_NBR LIKE '311347%' OR A.STYL_NBR LIKE '%308896%' OR
A.STYL_NBR LIKE '%116259%' OR A.STYL_NBR LIKE '%224900%' OR A.STYL_NBR
LIKE '%310188%' OR A.STYL_NBR LIKE '%SC0675%' OR A.STYL_NBR LIKE
'%591312%' OR A.STYL_NBR LIKE '%293930%' OR A.STYL_NBR LIKE '%114830%'
OR A.STYL_NBR LIKE '%593081%' OR A.STYL_NBR LIKE '%223202%' OR
A.STYL_NBR LIKE '305316%' OR A.STYL_NBR LIKE '%308658%' OR A.STYL_NBR
LIKE '%sp0114%' OR A.STYL_NBR LIKE '%241910%' OR A.STYL_NBR LIKE
'%308992%' OR A.STYL_NBR LIKE '%241593%' OR A.STYL_NBR LIKE
'%195155%'))
Received on Thu Nov 17 2005 - 04:40:53 CST
