Untitled
Anonymous
plain_text
04/09/2026 5:48 PM
34.7 KB
20
Indexable
SELECT
i.cost,
i.receivedate,
p.iscurrent,
p.reasonnotcurrent,
CONCAT('s', i.serialnumber) serial,
i.product,
p.categoryname,
i.size,
i.bin,
i.location,
CASE
WHEN
i.product IN ('CODR-WH98' , 'CODR-WH96',
'CODR-WH95',
'CODR-WH9',
'CODR-WH8',
'CODR-WH75',
'CODR-WH74',
'CODR-WH72',
'CODR-WH68',
'CODR-WH65',
'CODR-WH57',
'CODR-WH56',
'CODR-WH53',
'CODR-WH52',
'CODR-WH48',
'CODR-WH44',
'CODR-WH42',
'CODR-WH3',
'CODR-WH28',
'CODR-WH22',
'CODR-WH204',
'CODR-WH203',
'CODR-WH201',
'CODR-WH197',
'CODR-WH193',
'CODR-WH192',
'CODR-WH191',
'CODR-WH190',
'CODR-WH189',
'CODR-WH187',
'CODR-WH186',
'CODR-WH185',
'CODR-WH181',
'CODR-WH18',
'CODR-WH175',
'CODR-WH167',
'CODR-WH166',
'CODR-WH165',
'CODR-WH163',
'CODR-WH162',
'CODR-WH161',
'CODR-WH160',
'CODR-WH157',
'CODR-WH156',
'CODR-WH152',
'CODR-WH148',
'CODR-WH145',
'CODR-WH143',
'CODR-WH140',
'CODR-WH14',
'CODR-WH138',
'CODR-WH137',
'CODR-WH133',
'CODR-WH130',
'CODR-WH120',
'CODR-WH117',
'CODR-WH115',
'CODR-WH114',
'CODR-WH112',
'CODR-WH110',
'CODR-WH11',
'CODR-WH108',
'CODR-WH107',
'CODR-WH105',
'CODR-WH102',
'CODR-WH10',
'BDRE-WH45',
'BDRE-WH44',
'BDRE-WH43',
'CFAN-WH79',
'CFAN-WH78',
'CFAN-WH70',
'CFAN-WH67',
'CFAN-WH66',
'CFAN-WH64',
'CFAN-WH34',
'CFAN-WH17',
'CFAN-WH13',
'DLLR-WH9',
'DLLR-WH8',
'DLLR-WH7',
'DLLR-WH6',
'DLLR-WH5',
'DLLR-WH4',
'DLLR-WH3',
'DLLR-WH2',
'DLLR-WH13',
'DLLR-WH12',
'DLLR-WH10',
'DLLR-WH1',
'FUNR-WH46',
'FUNR-WH44',
'FSTU-WH111',
'FSTU-WH104',
'FSTU-WH103',
'FSTU-WA82',
'FSTU-WA11',
'PADR-WH42',
'VOLU-WH9',
'VOLU-WH8',
'VOLU-WA208')
THEN
'Phase 1'
WHEN
i.product IN ('SLAU-WY2966' , 'SLAU-WY2964',
'SLAU-WY2594',
'SLAU-WY2962',
'SLAU-WY2965',
'SLAU-WY2595',
'SLAU-WZ837',
'SLAU-WZ761',
'SLAU-WY2968',
'SLAU-WY2967',
'SLAU-WY2963',
'SLAU-WY2847',
'SLAU-WY2841',
'SLAU-WY2729',
'SLAU-WY2047',
'SLAU-WY1804',
'SLAU-WY1288',
'SLAU-MS134',
'RICK-WS312',
'OSCF-WD78',
'BURF-WO117',
'BURF-WD28',
'BOTT-WY1286',
'BOTT-MO46',
'BURF-WZ72',
'BALF-WY1466',
'TERX-WY1',
'BURF-WS124',
'BURF-WD52',
'BURF-WQ44',
'TERX-WZ421',
'TERX-WZ417',
'TERX-WZ416',
'TERX-WZ412',
'TERX-WZ413',
'BURF-WS156',
'BURF-WQ16',
'BURF-WZ76',
'TERX-WZ415',
'VSAC-WH12',
'SPRR-WO2',
'BURF-WZ43',
'RTFF-WD41',
'BURF-WZ75',
'CANA-WO183',
'AZER-WD57',
'CGOO-WO5',
'KTAH-WF19',
'JBRA-WD10',
'ISAB-WD227',
'BURF-WZ84',
'FEXN-WA8',
'FNEF-WL300',
'RTFF-WD34',
'SORA-WZ9',
'RTFF-WO3',
'AZER-WQ2',
'AZER-WD51')
THEN
'Phase 2'
WHEN
i.product IN ('DSAR-WU24' , 'DOLF-WS135',
'AWAN-WZ265',
'AWAN-WZ255',
'ZIMM-WD515',
'UAMR-WD55',
'CANA-WO184',
'ZIMM-WD517',
'CULG-WD294',
'TBIF-WO24',
'SORA-WZ12',
'PBTO-WD305',
'WNYF-WP81',
'AZER-WD58',
'ZIMM-WS173',
'SORA-WZ2',
'CRUI-WS5',
'MMAF-WC3',
'SORA-WZ5',
'ZIMM-WS171',
'ZIMM-WD518',
'AKNF-WD61',
'AWAR-WO29',
'SORA-WZ7',
'SORA-WZ4',
'LPÈF-MK2',
'CLNC-WD52',
'MMAF-WO14',
'GGOR-WZ404',
'AZER-WD49',
'PGIR-WS64',
'ZIMM-WD519',
'MILL-WO154',
'MILL-WD1105',
'RHUF-MK45',
'VBEF-WD79',
'LESH-WK18',
'GGOO-WZ435',
'GLOV-WO158',
'AZER-WD44',
'GGOR-WZ230',
'RTFF-WR1',
'MILL-WD1118',
'MILL-WD1104',
'ZIMM-WF69',
'MILL-WD1115',
'RTFF-WP20',
'PARR-WD185',
'LPEF-MJ1',
'NILF-WS210',
'RTFF-WP3',
'PRAR-WG11',
'BAFE-WS17',
'BROR-WD132',
'GLOV-WO176',
'MILL-WD1111',
'AZER-WD59',
'MMAF-WS50',
'PRAR-WG5',
'MIUF-WG45',
'RHUF-MK44',
'LSPB-WD84',
'TRAL-WZ138',
'MMAF-WP16',
'VBEF-WD73',
'JDAF-WC4',
'ZIMM-WS172',
'ZIMM-WP39',
'AZER-WD46',
'RTAF-WS311',
'RTAF-WD45',
'FAIB-WD684',
'MILL-WD1116',
'KTAH-WA32',
'GUCC-WG59',
'GLOV-WD46',
'BURF-WA11',
'MFAR-WD74',
'LSPB-WD83',
'LSPB-WD85',
'LSPB-WD79',
'RTFF-WS13',
'NOMF-WD98',
'HLNR-WR2',
'RGBR-MZ51',
'LPÈF-MS5',
'AMAN-WD2033',
'LAGF-WS131',
'GREA-WK253',
'AYAR-WP27',
'LNCF-WD158',
'MARJ-WY661',
'VAUR-WK4',
'MMAF-WS53',
'MILL-WS543',
'STUA-WZ277',
'NKIE-WD482',
'LIKR-WD720',
'AGOF-WJ85',
'LNYA-WI10',
'LSEF-WO6',
'AMAN-WD2067',
'FORL-WD1202',
'CULG-WS112',
'MCRE-WD18',
'BROC-WS32',
'EQUI-WS1293',
'MISA-WD823',
'EBDF-WD2',
'DELR-WO1',
'ALIX-WS41',
'AYAR-WK25',
'ENZF-WD469',
'LSPB-WS82',
'MILL-WQ196',
'LAGF-WP6',
'ETOI-WK144',
'BROR-WQ4',
'AIJR-WD63',
'RONR-WC8',
'GUCC-MA5',
'JCAM-WZ1298',
'EQUF-WS649',
'DENR-WJ32',
'AFSC-WZ53',
'SABF-WP53',
'REBR-WP3',
'FORL-WD1136',
'ALLR-WY148',
'MILL-WS547',
'MILL-WQ200',
'BROC-WP19',
'TTHR-WU29',
'SLKE-WJ79',
'LNYA-WI13',
'LIKR-WD715',
'EQUF-WS644',
'EQUF-WS642',
'CAMN-WQ3',
'ALOR-WO5',
'AIJR-WD67',
'AZER-WS8',
'LPÈF-MS2',
'GREA-WS288',
'FORL-WD1230',
'DELR-WQ16',
'TTHR-WU6',
'NATI-WK36',
'ALIX-WD97',
'FORL-WD1173',
'RHUF-MA81',
'MILL-WP64',
'BTRY-WD23',
'BJNA-WD55',
'LSUD-WK31',
'FORL-WD1116',
'SPEL-WD204',
'SHON-WD8',
'RHUF-MS179',
'MOTF-WJ630',
'LSEF-WP41',
'AMAN-WD1401',
'NOMF-WO15',
'FORL-WD1251',
'ENZA-WP109',
'BSUF-UH25',
'MOTH-WJ756',
'MOTF-WJ581',
'FNKE-WP25',
'CITI-WJ1766',
'PAIG-WJ1521',
'FORL-WD1250',
'AMAN-WD2075',
'OIEF-WH2',
'OIEF-WH1',
'FRNX-WH3',
'FRNX-WH2',
'FRNX-WH1',
'AMAN-WD2083',
'RAYF-MA7',
'NHOX-WS165',
'AMAN-WR235',
'FORL-WD1207',
'MOTF-WC3',
'FORL-WD1123',
'CLEO-WD464',
'CLEO-WD474',
'CITI-WJ621',
'NHOX-WS147',
'SUSA-WD1866',
'MOTF-WJ509',
'AGOF-WJ112',
'LNYA-WI11',
'AMAN-WD1988',
'SOYA-WQ44',
'AMAN-WD2147',
'AMAN-WD2149',
'AMAN-WD2145',
'NKAM-WO69',
'CLEO-WD465',
'FORL-WD1163',
'AMAN-WR191',
'REDF-WK7',
'GLOV-WQ40',
'FORL-WD1246',
'HMAY-WA2',
'ENZF-WD216',
'FORL-WD1137',
'ALLR-MZ54',
'AMAN-WR194',
'CMAN-WS123',
'PORR-MY7',
'ELLI-WD227',
'FORL-WD1252',
'ROCS-WS54',
'GCDR-WF3',
'ENZF-WS897',
'GLOV-WS364',
'FORL-WD1146',
'FORL-WD1147',
'PLNE-WS28',
'CLEO-WK18',
'AGOF-WJ67',
'AGOF-WJ41',
'AGOF-WJ30',
'CLEO-WD475',
'SEVE-WF20',
'FORL-WS586',
'NIKR-MZ547',
'ALOR-WO9',
'VBRD-WS78',
'NOMF-WD104',
'NHOX-WS131',
'GLOV-WS371',
'SOYA-WR4',
'RGBR-WS532',
'NIKR-MK73',
'JKAY-WH12',
'GLOV-WQ51',
'NIKR-MZ726',
'FREE-WO852',
'FREE-WD2849',
'FORL-WD1154',
'SCHU-WZ1080',
'PLMF-MP3',
'GRLR-WF105',
'CIOF-WF25',
'GIGI-WK2',
'MALR-WD1085',
'GLOV-WF31',
'FORL-WD1199',
'RAVR-WS26',
'GLOV-WF29',
'CLEO-WK15',
'SDRY-WD210',
'GIGI-WP5',
'NKIE-WD342',
'GIGI-WP4',
'FORL-WD1264',
'FREE-WC329',
'RAGA-WS372',
'LIKR-WD340',
'FREE-WJ320',
'NKIE-WD333',
'FAHR-MS43',
'SOLS-WZ254',
'LMOS-WK222',
'ANIN-WK58',
'SOLS-WZ251',
'HLSA-WD140',
'GLOV-WS359',
'ADIO-WZ27',
'WWWR-WS153',
'TONR-WZ498',
'RAIL-WS689',
'ENZF-WD214',
'FREE-WD2844',
'GRLR-WK40',
'CAMN-WS181',
'DIES-WI9',
'LOVF-WJ91',
'SFAN-WL3',
'LMOS-WK207',
'FORL-WS587',
'ENZF-WF4',
'GAIA-WL76',
'CLEO-WS204',
'BOYR-WK67',
'HARL-WD422',
'CLEO-WS206',
'SETR-WK1',
'RTFF-WL2',
'LSUD-WA3',
'FREE-WO510',
'ERIK-WD26',
'SCHU-WZ822',
'TTHR-WU17',
'SLST-WX363',
'SAME-WZ1053',
'MARA-WX518',
'LMOS-WP230',
'HEAR-WD401',
'BOYR-WP59',
'CLEO-WS207',
'CLEO-WS203',
'HARL-WD421',
'HARL-WD420',
'FAME-WP81',
'BOBI-WK164',
'SSTA-WS72',
'GREA-WS286',
'FREE-WD2884',
'SRIF-WK35',
'HATR-WA101',
'CMAN-WS79',
'WWWR-WC53',
'FREE-WK1106',
'ENZA-WS979',
'YNLF-WP28',
'HARL-WD419',
'FORL-WS340',
'BEIS-WY281',
'GIGI-WF6',
'HEAR-WD421',
'ASTR-WC7',
'ALLR-MS75',
'WWWR-WD118',
'FORL-WS584',
'WWWR-WJ33',
'WWWR-WJ32',
'SPAN-WQ1',
'NOMF-WX86',
'LSPA-WC12',
'FREE-WZ407',
'SHAS-WL721',
'EBER-WI984',
'WWWR-WD120',
'WWWR-WJ70',
'SPRR-WK9',
'GRLR-WF130',
'FORL-WS602',
'FORL-WS593',
'FORL-WQ224',
'DGUI-WQ37',
'CMAN-WI235',
'CMAN-WI216',
'ACMR-WP60',
'BGEN-WZ37',
'BEIS-WY282',
'AGUA-WX576',
'FREE-WK644',
'GIGI-WI6',
'FREE-WC349',
'FREE-WK691',
'SKIR-WI167',
'FREE-WK1214',
'FREE-WD2891',
'FORL-WS536',
'SKIR-WI168',
'NIKR-WK8',
'FREE-WS4798',
'COTR-WS126',
'SMAD-WZ1384',
'NIKR-WZ407',
'CLEO-WS176',
'NIKR-WZ733',
'CMAN-WI214',
'SHAS-WL1013',
'HEAR-WD301',
'ALIX-WS59',
'BOYR-WL5',
'WWWR-WD127',
'WWWR-WD126',
'WWWR-WD125',
'SPLR-WP28',
'LANS-WO114',
'GIGI-WP7',
'GIGI-WK4',
'DGUI-WS16',
'CAHN-WK115',
'FORL-WS554',
'NOMF-WD539',
'MIKO-WX631',
'MELR-WD426',
'FROR-WY107',
'BLAN-WP39',
'FORL-WS610',
'FORL-WS589',
'FORL-WS591',
'MICH-WD904',
'SHAS-WL1100',
'MELR-WR16',
'MARC-WA692',
'MALR-WC42',
'LPAR-WJ4',
'GRLR-WJ260',
'FREE-WJ322',
'WWWR-WS160',
'SHOW-WF101',
'MMWR-WX9',
'MMWR-WX22',
'HEAR-WQ30',
'CAHN-WK116',
'GIGI-WS7',
'MMWR-WX23',
'LMOS-WD297',
'DIES-WI7',
'NIKR-WP96',
'MMWR-WX26',
'SMAD-WO160',
'BRIO-WP124',
'ALLR-WF4',
'WWWR-WX428',
'WWWR-WX425',
'LMOS-WS1537',
'LADA-WD50',
'GRLR-WJ278',
'GRLR-WJ12',
'DGUI-WQ75',
'8OTH-WY7',
'DGUI-WQ21',
'MMWR-WX10',
'BLAN-MJ4',
'LEIV-WJ304',
'AFFM-WP50',
'DIES-WI11',
'ONET-WF63',
'NBDR-WD692',
'LEIV-WJ99',
'HGHT-WX98',
'EOSR-WS12',
'CMAN-WS177',
'WWWR-WQ60',
'WWWR-WS163',
'WWWR-WP97',
'TRAG-WU5',
'ONIT-MZ48',
'MMWR-WX4',
'MICH-WD757',
'LSPA-WX1033',
'LAMA-WS2019',
'FSTU-WH99',
'FREE-WS4864',
'FREE-WS4843',
'FREE-WS4771',
'FREE-WK1257',
'FREE-WK1253',
'FREE-WK1252',
'FREE-WK1221',
'BRIX-WH210',
'GIGI-WX89',
'PENR-WI76',
'WWWR-WR45',
'RVLV-WK3',
'HEAR-WS385',
'DIGR-MS39',
'WWWR-WQ66',
'WWWR-WP105',
'HEAR-WS402',
'HEAR-WK241',
'HEAR-WD424',
'AGUA-WX364',
'NATA-WL522',
'SOSR-WS126',
'PRIP-WD283',
'MMWR-WX18',
'HARL-WQ64',
'GRLR-WF112',
'EOSR-WS11',
'WWWR-WP103',
'WWWR-WO49',
'MMWR-WX16',
'WWWR-WD117',
'PLMF-MS9',
'MMWR-WX32',
'NKAM-WS277',
'WWWR-WS172',
'MMWR-WX27',
'WWWR-WX401',
'SHAS-WL1096',
'FORL-WX230',
'WWWR-WX402',
'SHAS-WL1139',
'PRIP-WD1012',
'HEAR-WS373',
'GIGI-WI8',
'GIGI-WF7',
'DEPT-WK50',
'DEPT-WK56',
'WWWR-WQ55',
'DDRE-WS761',
'TIAR-WQ20',
'INDA-WQ65',
'HEAR-WS377',
'FLER-WI141',
'CTIL-WU59',
'LONE-WI143',
'HEAR-WK218',
'DIGR-MS67',
'DIES-WI22',
'THEO-WS927',
'SHAS-WL780',
'DGUI-WS14',
'TRUE-WA7',
'PENR-WP124',
'ETEF-WS70',
'SHAS-WL872',
'JSWI-WX26',
'FREE-WS3766',
'FREE-WF174',
'CMAN-WI319',
'SHAS-WL787',
'FREE-WS4782',
'LOVF-WD2452',
'LOVF-WB48',
'SHAS-WL658',
'LONE-WI145',
'GGLO-WH39',
'MAIL-WS3',
'SHAS-WL784',
'ONIR-WX365',
'BRIX-WH208',
'FREE-WD1853',
'WWWR-WQ65',
'SHAS-WA109',
'FREE-WS4789',
'AMBE-WA25',
'FREE-WF338',
'FREE-WS4790',
'FREE-WS4761',
'APRS-WA17',
'PLUS-WA63',
'PEXR-WX6',
'PENR-WA4',
'ALEA-WA22',
'WWWR-WI59',
'PENR-WI74',
'NIKR-WS233',
'SIXF-MS6',
'SHAS-WL506',
'SHAS-WA124',
'HEAR-WS384',
'CPOR-WL11',
'BRIX-MX8',
'SEAF-WX372',
'TRTE-WU308',
'SPRD-WD169',
'LAMA-WS2123',
'HFRH-WS13',
'BOYR-WS49',
'BOYR-WS46',
'BOYR-WS45',
'WWWR-WS156',
'GRLR-WF121',
'CCLA-WL200',
'WWWR-WF60',
'FREE-WS4879',
'WWWR-WI56',
'SHAS-WL344',
'PENR-WA3',
'DLER-WP201',
'DIES-WI15',
'NIKR-WS231',
'YTHF-WU26',
'SKIR-WI161',
'BEIS-WA118',
'WWWR-WX418',
'WWWR-WX412',
'THEL-WU4',
'SHAS-WL336',
'SETR-WI6',
'GRLR-WS72',
'CPOR-WL12',
'AIKA-WU174',
'TRTE-WU310',
'SPDW-WD482',
'SHAS-WL586',
'THEL-WA9',
'THEL-WA20',
'GRLR-WS50',
'FSTU-WH88',
'DIES-WI13',
'WWWR-WI13',
'WWWR-WI12',
'SHYC-WX7',
'SHAS-WA55',
'OAYF-MH2',
'FRPS-WI4',
'1STR-WS252',
'SKGM-WU10',
'NIKR-WS192',
'NIKR-MY18',
'STAI-MS4',
'MINK-WX316',
'LOVF-WL151',
'AAYR-WS10',
'PCEW-WA1',
'WWWR-WS178',
'DIES-WI25',
'PENR-WA5',
'BTWR-WD248',
'LOVF-WK780',
'8OTH-WL758',
'ILMQ-WU17',
'ILMQ-WU16',
'SPDW-WD1722',
'SPRD-WS176',
'EJAY-WA13',
'THEL-WA16',
'RHOM-WH4',
'GISU-WU23',
'GISU-WU22',
'THEL-WU1',
'KAAI-WU34',
'ILON-WU143',
'BCOS-WU603')
THEN
'Phase 3'
WHEN
i.product IN ('FWRF-UU4' , 'RBEA-WU52',
'MZSK-WU5',
'YTHF-WU35',
'SOOR-WU129',
'ORIB-WU175',
'SRIL-WU51',
'YTHF-WU13',
'CTIL-WU165',
'YTHF-WU36',
'YTHF-WU18',
'KJER-WU185',
'KJER-WU184',
'100R-WU10',
'YTHF-WU33',
'YTHF-WU30',
'YTHF-WU29',
'YTHF-WU27',
'YTHF-WU22',
'YTHF-WU23',
'YTHF-WU25',
'YTHF-WU21',
'YTHF-WU20',
'FRIA-WU1',
'YTHF-WU24',
'YTHF-WU28',
'YTHF-WU34',
'YTHF-WU31',
'YTHF-WU32',
'CBIR-WU3',
'FOOR-WU5',
'FRIA-WU6',
'TRTE-WU312',
'TRTE-WU311',
'CCOS-WU31',
'YTHF-WU9',
'WTHR-WU9',
'YTHF-WU15',
'YTHF-WU1',
'YTHF-WU14',
'YTHF-WU16',
'YTHF-WU12',
'MZSK-WU40',
'HAMR-WU8',
'YTHF-WU17',
'TFAC-WU113',
'OUAR-WU12',
'SRIL-WU38',
'HIMR-MA13',
'100R-WU315',
'CORX-WU27',
'TRTE-WU129',
'YTHF-WU4',
'YTHF-WU2',
'YTHF-WU3',
'YTHF-WU5',
'YTHF-WU6',
'WBEA-WU45',
'KLOR-WU10',
'CORX-WU44',
'BYBI-WU29',
'199R-WU13',
'DIBR-WU17',
'PTHO-WU122',
'SUMR-WU69',
'SEED-WU67',
'RBEA-WU46',
'PTHO-WU183',
'ORIB-WU279',
'KOSA-WU322',
'EREP-WU70',
'BTYS-WU251')
THEN
'Phase 4'
ELSE 'Missing'
END AS 'Phase'
FROM
(SELECT
code,
code2,
iscurrent,
reasonnotcurrent,
receiveddate,
categoryname
FROM
product
WHERE
iscurrent = 0 AND code LIKE '____-%'
GROUP BY code) p
JOIN
inventoryitem i ON i.product = p.code
WHERE
location LIKE '7-%' AND qtyonhand = 1
AND i.receivedate < '2025-01-01 00:00:00'
ORDER BY i.location ASC;Editor is loading...
Leave a Comment