← Detay Sayfası
Nesne Düzenle
|
SP_GET_MATCHED_ITEMS
İlgili Uygulama
-- Seçiniz --
SQL Server
Nesne Türü
View
Stored Procedure
Trigger
Job
Nesne Adı
Bu nesne dönem devrinden etkileniyor mu? (Örn: İçinde _01_ gibi sabit dönem kodu var mı?)
Genel Kullanım Amacı ve Notlar
Tam SQL Kodu
CREATE PROCEDURE SP_GET_MATCHED_ITEMS AS BEGIN SET NOCOUNT ON; DECLARE @LIST NVARCHAR(MAX) = N'48609-0F021 51726-TR0-A01 48619-F4010 52722-SDA-A01 51722-SS0-004 51722-SMG-E04 51722-TET-H01 52722-S9A-014 51722-SWA-A02 52722-SS0-003 52722-TET-A01 UNI-ANTEN-114 UNI-ANTEN-145 UNI-ANTEN-127 UNI-ANTEN-105 39151-S6A-E02 UNI-ANTEN-107 UNI-ANTEN-124-122 8980530480 UNI-ANTEN-101 UNI-ANTEN-132 UNI-ANTEN-108 UNI-ANTEN-129 UNI-ANTEN-123/112D UNI-ANTEN-102 UNI-ANTEN-103 282B3-4BA0A 1428451 1428452 UNI-AYNA-77-LH UNI-AYNA-78-RH 601000018AADQJ-H-L 601000017AADQJ-H-L 87321-25500 87321-1E000 87321-0U000 74865-SEL-T11 74865-S04-003 74865-S5A-003 74865-SEN-A01 64461-12290 75490-TR0-A01 75495-TR0-A01 60117-02010 60118-02010 60117-02250 60118-02250 60117-0D100 60118-0D100 53293-02240 53294-02230 4605A195 8-98102359-2 11955-5X00E 11925-EB32A 16577-37030 17910-65J00 85321-28020 16268-33070 17831-69G00 17860-63J00 17580-65D00 21022-EB70A 23810-30100 13368882 13368880 20940465 20940464 13368873 13368872 UNI-BRKT-020 UNI-BRKT-019 22793772 22793771 22798556 22798555 39145054 39145053 MB423467 53823-02130 53824-02130 55708-02590 55708-12130 72910-TL0-003 72950-TL0-003 72450-TL0-003 72910-TR0-A01 72950-TR0-A01 72950-TR0-A01 72410-TR0-A01 72450-TR0-A01 72910-T20-A01 72950-T20-A01 75730-12360 75740-12440 75740-02410 75710-12830 75720-12830 75730-02490 NIKELAJ 75740-02490 NIKELAJ 75740-02490 SIYAH 75710-02490 SIYAH 75710-02490 NIKELAJ 75720-02490 NIKELAJ 75720-02490 SIYAH UNI-CCSF-034 UNI-CCSF-033 UNI-CCSF-032 UNI-CCSF-031 72910-SWA-A01 72950-SWA-A01 72410-SWA-A01 72450-SWA-A01 68163-0K010 68164-0K010 68162-0K010 68161-0K010 68180-0K010 68230-0K010 68160-0K010 MN117616 MN117615 MN117612 MN117611 82821-4EA0A 82821-HV00A 8251A020 85110-12860/85110-12810 MK548498 MK548497 UH71-26-630/UH71-26-640 UR58-26-630/UR58-26-640 04943-02020/04943-02060 8979474030 53840-65D00 53810-65D00/53820-65D00 04943-0K070/04943-0K050 04943-0K045/04943-0K040 04942-0K210 MR205286/MR205287 44200-AX600 44201-EB360/44200-EB70AT 4600A139/4600A140-T 48190-0K010 8972345245 48190-0K040 48190-0K050 54580-2ZG0A 54419-VK80A 11056-AD200 39600-SAA-003 52591-02410 52592-02380 86812-29000 86820-2P000 86810-2P000 622A0-BM400 622A0-BN700 UNI-21890 UNI-07218 622A0-3HN0H 85071-4EA0A 85071-BR00A 75555-05070 75556-05070 75555-05040 75556-05040 75055-12120 75056-12120 75555-02090 75556-02100 74306-TR0-A01 74316-TR0-A01 74306-TBA-A00 75555-02011 75556-02011 75555-02270 75556-02260 75552-02140 75551-02140 75555-02220 75556-02220 75551-0K011 75552-0K011 74306-SAA-003 74316-SAA-003 73852-JE20A 73853-JE20A 52611-02530 UNI-MAC-101 UNI-MAC-100 F201-16-520B 31204-52010 897039266 31204-0K071 31204-0K110 22821-PWL-000 30531-EB300 45260-12580 45203-0K010 UNI-MD-100 UNI-BDK-335 UNI-BDK-334 MB561722 25290-73P00 25290-JD09B 84840-28030 35750-SMG-G01 UNI-DCM-100 8-97417004-0 8981912520 47125-SNA-A82ZB 71-13040-00 11049-00Q0A 14033-00Q0C 14033-00Q0B 8-973333481 8973714472 1675812480 1675812580 9817296980 9817298380 BG2M-51-040 216-1139-RH 216-1139-LH 216-1120-RH 216-1120-LH GE8K-51-030D GE8K-51-040P 8V0941044 8V0941043 8K0941030G 8K0941029G 8K0941044 8K0941043 8W0941044 8W0941043 4K0941040 4K0941039 92101-22010 92102-22010 92102-22300 92101-22300 92102-25511-T 92101-25511-T 92102-1R040 92101-1R040 33103-SM4-E04 33153-SM4-E04 2H1941016N 2H1941015N 92102-02010 92101-02010 92102-05520 92101-05520 81130-05190 81170-05194 81130-05240 81170-05240 96650528 96650754 96650755 8BUR-51-030 8BUR-51-040 53271-12060 71140-SNB-003 71190-SNB-003 71140-S9A-A00 71190-S9A-A00 62044-4EA0A 62045-4EA0A 62044-HV00A 62045-HV00A 26042-4CA0A 26092-4CA0A 33119-TA0-003(W3T19371) 33119-SZT-G01 0K600-51-020-RH 0K600-51-020-LH 0K6M7-51-030 0K6M7-51-040 92102-4E000 92101-4E000 92102-4E510 92101-4E510 92102-4E700 92101-4E700 1J5941018BE 1J5941017BE UR82-51-0K0G UR82-51-0L0E UB9B-51-0K0A UB9B-51-0L0A 2K1941006A 2K1941005A 2K1941016B 2K1941015B 2K8941006B 2K8941005B MK581218 MK581217 35120-77A00 35320-77A00 3C8941754Q 3C8941753Q 9675139980 9675140080 9817297880 9817298480 92102-2F010 92101-2F010 123-1101-RH 123-1101-LH 92102-A7550 92101-A7550 92102-A7500 92101-A7500 33101-SEL-P61 33151-SEL-P61 33100-TM0-T01 33150-TM0-T01 33101-S04-G02 33151-S04-G02 33101-S04-B03 33151-S04-B03 33101-S5A-901 33151-S5A-901 33101-TR0-G11 33151-TR0-G11 33100-T24-Y12 33150-T24-Y12 212-1112-RH 212-1112-LH 81110-1E180 81150-1E440 212-11A4-RH 212-11A4-LH 212-11D1-RH 212-11D1-LH 81130-02B10 81170-02B10 81130-02E70-RH 81170-02E70-LH 81130-02T31-M 81170-02T31-M 81110-2B640 81150-2B600 33101-S9A-B01-BYZ 33151-S9A-B01-BYZ 33101-S9A-B01-SARI 33151-S9A-B01-SARI 33101-SWA-G01 33151-SWA-G01 213-1131-RH 213-1131-LH 213-1137-RH 213-1137-LH 213-1138-RH 213-1138-LH 8981253845-B 8981253855-B 213-1142-RH 213-1142-LH 213-1143-RH 213-1143-LH UNI-X-084-2-LH 92102-2D500 92101-2D500 92102-F2100 92101-F2100 92102-F2000 92101-F2000 92102-F2600 92101-F2600 92102-F2500 92101-F2500 92102-AA100 92101-AA100 92102-24300 92101-24300 1J1941018F 1J1941017F 1K6941006R 1K6941005R 5K1941006L 5K1941005L 5G1941034 5G1941033 5G1941006 5G1941005 5G1941774 5G1941773 5G1941006D 5G1941005D 5H1941036 5H1941035 35120-65D30 35320-65D30 35120-50J20 35320-50J20 35120-65JB0 35320-65JB0 92102-4H000 92101-4H000 92102-4B000 92102-43420 92101-43420 92102-43800-T 92101-43800-T 92102-4F030 92101-4F030 92102-4F500 92101-4F500 92102-4F700 92101-4F700 81130-35370 81170-35350 UNI-FAR-042-RH UNI-FAR-041-LH 81110-0K440 81150-0K440 UNI-FAR-034-RH UNI-FAR-033-LH 81110-0K690 81150-0K690 UNI-X-170A-RH UNI-X-170A-LH UNI-06305 UNI-09860 92102-0X010 92101-0X010 92102-0X120 92101-0X120 92102-1J010 92101-1J010 221-1146-RH 221-1146-LH 92102-2S520 92101-2S520 33101-SAA-H61 33151-SAA-H61 33101-SAA-H51 33151-SAA-H51 33100-TG5-H01 33150-TG5-H01 33100-TF0-H51 33150-TF0-H51 5C7941006A 5C7941005A 96108150 96408151 8301A824 8301A823 214-1180-RH 214-1180-LH UNI-FAR-420 UNI-FAR-410 UNI-FAR-020-RH UNI-FAR-019-LH 8301C730 8301C729 8301D380 8301D381 8301D378 8301D377 MR439534 MR439533 92102-10000 92101-10000 26015-1HM0A-B201 26065-1HM0A-B201 215-11B2-RH 215-11B2-LH 26010-5X00B 26060-5X00B 26010-4JA3B 26060-4JA3B 26010-4JA0B 26060-4JA0B 9806306580 9806306180 9677202380 9677202480 3B0941016AK 3B0941015AK 3C0941006M 3C0941005M 3AB941006 3AB941754 3AB941005 3AB941753 3G1941006B 3G1941005B 3C8941754C 3C8941753C 215-1173-RH 215-1173-LH 215-1189-RH 215-1189-LH 6Q1941008AT 6Q1941007AT 6R1941008F 6R1941007F 6R1941016E 6R1941015E 6C1941006 6R1941008G 6C1941005 6R1941007G 2G1941006 2G1941005 2G1941006C 2G1941005C 26010-2F925 26060-2F925 26010-JD000 26060-JD000 26010-4EA0A 26060-4EA0A 26010-HV00A 26060-HV00A 0K31G-51-030C 0K31G-51-040C 92102-1G020 92101-1G020 92102-1G630 92101-1G630 92102-1W200 92101-1W200 92102-1W050 92101-1W050 92102-H9000 92101-H9000 92102-3E020 92101-3E020 92102-1F010 92101-1F010 92102-03000 92101-03000 92102-3W420 92101-3W420 35121-60B30 35321-60B30 35120-63J10 35320-63J10 35120-79J00 35320-79J00 1514952-00-C 1514953-00-C 5N1941032AB 5N1941031AB 5N1941006B 5N1941005B 5NB941114A 5NB941113A 5NB941114C 5NB941113C 7H1941018N 7H1941017N 92102-2E020 92101-2E020 92102-2E021 92101-2E021 92102-D3110 92101-D3110 92102-D3040 92101-D3040 92102-D7600 92101-D7600 35100-60A30 35300-60A30 UNI-FAR-303-RH UNI-FAR-303-LH 212-11A2-RH 212-11A2-LH 81130-0D090 81170-0D090 85353-12081 85354-12081 85354-02904 85353-02904 UNI-18086 UNI-18087 UNI-21303 UNI-21302 UNI-13336 UNI-13345 33100-TET-H11 33150-TET-H11 25420-5X9-A01 8973310630 8-97207143-0 8980580110 MB618320 UNI-19798 04942-0K130 44200-VW000 44201-VW000 32005-4KV0A 74320-12A30-B0 74310-12A60-B0 88217-TR0-A01ZA 74348-33040-GRI 96409-3DF0B-A156 88217-S01-A01-GRI 53701-SDA-A01 US9350000 44360-0K050 B6BF-13-220C 16578-5M000 17881-0H040 17244-PLC-000 17225-5AA-A00 17228-59N-G00 17228-P2J-000 17880-0T070 17881-22040 17881-0D040 17881-15160 17881-11380 17881-15170 17881-15180 17880-11350/17881-11560 17881-0D010 17881-0D081 17881-33060 17881-0D150 17881-74450 17225-RZP-G00 13881-65J00 17881-0L051 17881-67040 17881-54820 1505A781 ZJ01-13-221A 16578-EB70B 16578-BC20C 16578-VK50A 16578-AU00A 16576-JD00A/UNI-04-1028 17880-0N031 14463-4JA0A 14460-JD51B 14460-JG70A 14463JD72A 14460-BB30A 14460-4BE2B/14460-4EB1B 14460-HX40B/14460-4EB0B 14460-HX40B/14460-4EB0B 14460-4BE2B/14460-4EB1B 13453635 39130494 9829832380 9829831980 1320224 39108221 8980779970 8-98078176-0 01473-S04-000 UNI-13585 898019761-1 898019762-1 8-980791050 MR527979 UNI-GIH-001 UNI-GIH-002 12180-21010 UNI-KRFKTR-001 UNI-KRFKTR-002 71504-TBA-A00-FC 71509-TBA-A00-FC 67871-12380 67872-12380 67861-12820 67862-12780 68610-02180 898103030/5 35400-S5A-013 UNI-19132 84231-0D030 37670-58J10 93560-3B100 8608A220 MB698713 25360-41L00 25360-KA60A 83120-1E001 83110-1E001 82110-1E001 62311-02020 69210-12170 69220-12170 69230-12110 69240-12110 82660-29002 82650-29002 74141-TR0-A00 74141-TET-H00 53341-02060/53341-02050 53341-12260 53341-02280 74141-SWW-G00 65840-BR00A 60120-TR0-000 60170-TR0-000 75120-S5A-003 75120-S5A-031 51410-02190 75832-4BE0A 8-98036594-0 90310-T0008 90311-T0084 MN110724 43232-EB70B 40227-EA000 40232-33P00/19018090B 91205-PL3-A01 90311-T0065 MB393883 38189-N3112 91213-PE1-722 23682-30020 91212-PLC-003 91212-RNA-A01 91212-P7A-004 MN128731T 1052B393 1052B382 12279-AD200 MB919210 MD731708 33142-4JA1A 82201-85500 82202-85500 UNI-02-1185/74120-TR0-A0 53510-02830 65601-JD000 83408-S5A-010ZA 84450-35090 30542-02N10 MD348238 1035B313 MB421498 MB421497 92501-25000 92501-22010 92501-1E000 81270-0D120 92502-4X000 92501-4X000 92501-2L100 26510-1HA0A 26510-ZP50A 26510-8990A/26510-JD00A 92501-4A000 23300-0L010 1770A163/1770A229 UNI-16005 UNI-02462 65601-JX31A 79710-S5D-A02 87240-12260 292400-0360/A6860-VM09A UNI-TY-050 UNI-PÇK-040 UNI-TY-046 7104.L2 75450-TR0-A00 75450-TRN-H01 7403A314 71129-T1W-A01 9676957880 9816049280 UNI-PJR-703 UNI-PJR-046 13419813 13300945-A 87310-0U100 90810-JE20B/UNI-04-1032 87310-4A010 34101-S5A-A01 34100-TEA-T11 16711-0D060 7403A344 0K70C-51-270 UNI-RFKTR-017 UNI-RFKTR-003 UNI-RFKTR-004 81570-0K080-BYZ 8334A059 UNI-RFKTR-1001 26590-JD000 52164-F4060 UNI-RFKTR-002 UNI-RFKTR-001 33505-SEA-013 33555-SEA-013 UNI-RFKTR-021 UNI-RFKTR-022 UNI-RFKTR-026 UNI-RFKTR-025 UNI-01-1166 UNI-01-1165 92406-A2000 92405-A2000 81910-F4020 81920-F4020 33505-T31-H01 33555-T31-H01 UNI-02-1144/17-5185-00 UNI-02-1143/17-5186-00 UNI-02-1146/33555-SWA-00 UNI-02-1145/33505-SWA-00 33505-SWA-J01 33555-SWA-J01 92406-AA000 92405-AA000 92406-3X200 92405-3X200 92406-F2510 92405-F2510 35950-65J01 35970-65J01 92406-B4100 92405-B4100 92406-C8700 92405-C8700 26560-5C000 26565-5C000 26580-ED50A BN8P-51-5M0C BN8P-51-5L0C BBP2-51-5L0A/BFF4-51-5L0 BBP2-51-5M0A/BFF4-51-5M0 UNI-RFKTR-011 GJ6A-51-5M0B GJ6A-51-5L0A 92406-1Y000 92405-1Y000 92405-G6000 92406-G6000 26560-JE20A RH 26561-JE20A LH 26580-JE20A 26560-JJ90A 26565-JJ90A 92406-1W700 92405-1W700 92406-H9100 92405-H9100 92480-3E050XX 92470-3E050 92406-3U300 92405-3U300 92406-D9200 92405-D9200 92401-4A100 27150-3S810 92202-1G000 92201-1G000 92202-1G600 92201-1G600 92202-1W200 92201-1W200 8.97387990.151 8.97387989.151 8.980521191 8.980521201 8980476610 8980476610 39680-TEX-Y111 39680-TEX-Y412 39680-TLA-Y011 39680-SHJ-A61 UNI-19475 8200074008 1005A327 11056-43G00 92303-3K000 B6170-59G00 B6175-59G00 B455-51-060A B455-51-070A B455-51-060A B455-51-070A B21H-51-06XB B21H-51-070B B25D-51-060D B25D-51-070D 216-1540/05-1522-RH 216-1540/05-1522-LH 05-1510-RH 05-1510-LH 92302-22010 92301-22010 92302-22300 92301-22310 34301-SM4-G01 34351-SM4-G01 26130-BM415 26135-BM415 81510-05020-RH 81520-05020-LH 81510-05030-RH 81521-05030-LH 87624-1R000 87614-1R000 UNI-SINY-02-RH UNI-SINY-01-LH UNI-SINY-011 UNI-SINY-012 87624-1M000 87614-1M000 87624-A7000 34300-SNB-013 34350-SNB-013 34300-TM0-T01 34350-TM0-T01 JD-B031-RH JD-B031-LH 81730-12150 81740-12150 81730-52100 RH 81740-52050 LH UNI-SINY-014 UNI-SINY-013 JBL001-RH JBL001-LH 87624-3X000 87614-3X000 87624-F2000 87614-F2000 JD-56-RH JD-56-LH 87624-B9000 87614-B9000 87624-C8000 87614-C8000 87614-2L600 87613-2L600 87624-2S200 87614-2S200 34300-SAA-013 34350-SAA-013 34300-TG5-H01/JBL005-RH 34350-TG5-H01/JBL005-LH 96303-5KS0A 96304-5KS0A 26160-4BA0A-BEYAZ 26160-4BA0A-SIYAH 26165-4BA0A-BEYAZ 26165-4BA0A-SIYAH 87624-1W000 87614-1W000 87623-2P000 87613-2P000 87624-3W100 87614-3W100 87624-F1000 87614-F1000 UNI-SINY-017 UNI-SINY-016 UH71-51-060 UH71-51-070 216-1550-RH 216-1550-LH 0K60C-51-060B 0K60C-51-070B MB302245 MB302244 MC139767 MC139766 MB952158 MB952157 34300-SH3-G04 34500-SH3-G04 33300-SR3-000 33350-SR3-000 81619-12530 81620-12530 81610-12580 81620-12580 81620-12390 81610-12390 81510-80053 81520-80054 81510-20660 81520-20650 81610-20530 81620-20530 B01W-51-120 92303-22020-T 92303-25000-T 92304-1E000 92303-1E000 92304-1R000/92302-1J000 92303-1R000/92301-1J000 81731-05020 81741-05010 MR911199 92304-1M000 92303-1M000 34300-TET-H01 34350-TET-H01 33851-S2H-G01 34300-SL4-003 MR957363 81730-12240 8-97237378 92304-2D110 36410-63J00 92304-4H000 92303-4H000 92304-1Y000 92303-1Y000 92304-C7000 92303-C7000 92303-3L100 26160-89900 UNI-SÇK-003 8351A003 MR991187 8351A039 GJ6A-51-120C 26160-AX001 26160-61Y10 26160-70N00 26160-AU300 26160-9F000 0K34C-51-120 0K33C-51-120 92304-3B100 36410-60A00-RH 36430-60A00-LH 81730-0D011/81730-0D010 81740-0D011/81740-0D010 05-1202-RH 05-1202-LH 92303-24320 92301-24320 MR109212 MR109211 MK581220/MK580528 MK581219/MK580527 MK427118 MK427117 MK353664 MK353663 92302-43300 92301-43300 92302-43810-RH 92301-43810-LH 81510-95J16 81520-95J16 212-1539-6-RH 212-1539-6-LH 212-1539-RH 212-1539-LH 81511-35290 81521-35280 212-15C3-AE6-RH 212-15C3-AE6-LH 212-15C3-AE1-RH 212-15C3-AE1-LH MC139775 MC139776 92305-26031 214-1508-AE1-RH 214-1508-AE1-LH MB527090 MB527089 MB527294 MB527293 MB907018 MB907017 8980108830 8980108840 8975851722 8975851732 B6170-21G01 B6175-21G01 02-1019-RH 02-1019-LH 26100-2S425-RH 26115-3S225-LH 0K72A-51-060D 0K76B-51-070D 215-1582-RH 215-1582-LH 92302-4A500-RH 92301-4A500-LH B6120-50Y00 B6125-50Y00 36115-60B20 36135-60B20 33300-SM4-G01 33350-SM4-G01 33300-SM4-A04 33350-SM4-A04 35601-78020/35602-78020 33350-SH4-013 81510-12670-RH 81520-12520-LH 81510-20650 81520-20640 81510-89133 81520-89133 214-1625-RH 214-1625-LH MR109134 MR109133 MB831288 MB831287 MR496654 MR496653 897173535-0 897173536-0 897910032-1 897910033-1 26124-0C800 26129-0C800 26910-BV80A/NS-966 26915-BV80A/NS-966 26910-JD01A 26915-JD01A 26910-BR00A 26915-BR00A NS-736-RH 1400410 1400409 13241991 9830218180-RH 9830218180-LH 6400C042ZZ/6400B642 6400C041ZZ/6400B641 B25G-51-680C B25G-51-690C 92202-22310 92201-22310 92202-22300 92201-22300 92202-25000 92201-25000 92405-25500 92202-25710 92201-25710 92202-1E000-RH 92201-1E000-LH 92202-1R000-T 92201-1R000-T UNI-12323 UNI-14082 26150-4M426 26159-4M426 TY-519/81210-05040-RH TY-519/81220-05040-LH 81210-05050 81220-05050 81210-05060 81220-05060 OK6B-52-500 0K6B6-52-500 92202-4E001 92201-4E001 92202-4E500 92201-4E500 MC139759 MC139758 UNI-GHG-008 UNI-GHG-007 92202-A2000 92201-A2000 92202-2F010 92201-2F010 92202-2F100 92201-2F100 92202-1M400 92201-1M400 92202-1M010 92201-1M010 92202-A7500 92201-A7500 HD-051-RH HD-051-LH HD-050-RH UNI-15445 HD-042-RH HD-042-LH UNI-02-3356 HD-273-RH HD-273-LH UNI-14842 UNI-14829 UNI-14080 UNI-14079 UNI-01615 UNI-01614 33900-T24-T01 33950-T24-T01 HD-045-RH HD-045-LH HD-043-RH UNI-07231 HD-038-RH HD-038-LH 81210-12100 81220-12150 81210-02051 81220-02051 81211-12150 81221-12160 212-2048R-A 212-2048L-A TY-007-SIS-RH TY-007-SIS-LH TY-482-RH TY-482-LH UNI-LSIS-019 UNI-LSIS-018 33901-S9A-003 33951-S9A-003 33901-SPA-H02 33951-SPA-H02 33901-SWA-H01 33951-SWA-H01 34550-T0A-H01 34500-T0A-H01 33505-T1W-A01 33555-T1W-A01 34401-S10-G01 34751-S10-G10 8-97237590-1 8 97237589-1 8-97374665-2 8981862170 8981862180 92202-3X010 92201-3X010 92202-3X200 92201-3X220 92208-F2010 92207-F2010 92202-F2000 92201-F2000 92302-F2500 92301-F2500 92405-1C005 92202-1C000 92201-1C000 92405-1C500 92202-1C510 92201-1C510 92202-4H000 92201-4H000 92202-43800 92201-43800 92202-4F030 92201-4F030 92202-4F500 92201-4F500 TY-019-RH TY-019-LH TY-018-RH TY-018-LH TY-341-RH TY-341-LH 92202-B4000 92201-B4000 92202-1J510 92201-1J510 92202-C8000 92201-C8000 92202-C8100 92201-C8100 92202-C8800 92201-C8800 92208-C8700 92207-C8700 92202-2L000 92201-2L000 92202-A6000 92201-A6000 92406-2Y300 92405-2Y300 UNI-06838 UNI-GHG-009 HD-302-RH/33901-SAA-H11Z HD-302-LH/33951-SAA-H11Z HD-054-RH HD-054-LH 92202-4B000/92201-4B000 MS-083-RH MS-083-LH MS-085-RH MS-085-LH 8315A060 8315A059 MN186328 MN161677 UNI-15406 MS-237-LH 8321A108 8321A107 BN8V-51-690 BN8V-51-680 UNI-17786 UNI-17785 26150-1HA0A 26155-1HA0A NS-068/MS-068-RH NS-068/MS-068-LH 26155-2F025 26150-2F025 NS-911/NS-945-RH NS-911/NS-945-LH 92202-FD000 92201-FD000 UNI-01-23003-H-RH UNI-01-23003-H-LH 92202-2B000 92409-2B000 92408-2B000 92201-2B000 92202-03000 92201-03000 92202-3W010 92201-3W010 92202-H3100 92201-H3100 92202-4A500 92201-4A500 UNI-25960 UNI-25959 92202-2E000 92201-2E000 92406-D3100 92405-D3100 92208-D3000 92207-D3000 92202-D3020 92201-D3020 UNI-GHG-023 UNI-GHG-022 UNI-SIS-303-RH UNI-SIS-303-LH 92402-A7700 92401-A7700 92404-A7700 92403-A7700 33550-T00-K014M1 33500-T00-K014M1 92401-Q0000 92402-Q0000 92403-Q0000 92404-Q0000 26555-BV80A 26550-BV80A 26550-BR00A 26555-BR00A 8V5945092D 8V5945091D 8V5945095D 8V5945094D 8K5945096AC 8K5945095AC 8K5945094AC 8K5945093AC 8W5945092B 8W5945091B 8W5945094G 8W5945093G 8W5945092AA 8W5945091AA 8W5945094AA 8W5945093AA 8W6945092P 8W6945091P 4F5945096L 4F5945095L 4F5945096J 4F5945095J 4FD945094J 4FD945093J 4G5945096A 4G5945095A 92402-22010 92401-22010 92402-25010 92401-25010 92402-25510 92401-25510 92402-1E030 92401-1E030 92402-1R000 92401-1R000 UNI-STOP-2002 UNI-STOP-2001 UNI-01-007-RH UNI-18117 215-19G7-RH 215-19G7-LH 35602-82001 35603-82001 2H1945096A-DUYSUZ 2H1945095A-DUYSUZ 8330A690 8330A689 92402-05510 92401-05510 81560-05050 81550-05050 81551-05090-RH 81561-05090-LH 81551-05140 81561-05130 81551-05190 81561-05210 81551-05250 81561-05270 96540269 96540268 96550611 96550610 95952067 95952066 96830976 96830975 05-1002-2-RH 05-1002-2-LH 216-1947-RH 216-1947-LH 216-1953-RH 216-1953-LH 05-1002-1-RH 05-1002-1-LH 36225-70C00 0K70C-51-150 0K70C-51-160 0K60A-51-160D 0K60A-51-150C UNI-STOP-891-RH UNI-STOP-890-LH 2K1945096Q 2K1945095Q 2K1945096E 2K1945095E 81550-05030 81560-05030 81591-05050-RH 81591-05050-LH 35650-77A00 35670-77A00 218-1909-RH 218-1909-LH 3C8945208AD 3C8945207AD 3C8945308T 3C8945307S 92402-1H000 92401-1H000 92402-A2000 92401-A2000 9674809180 9674809080 9818810280 9817303780 92402-1M010 92401-1M010 92404-1M010 92403-1M010 92404-A7600 92403-A7600 92402-A7600 92401-A7600 33501-SEL-H61 33551-SEL-H61 34151-SEL-H61 34156-SEL-H61 33500-TM0-H01 33550-TM0-H01 33501-S04-G02 33551-S04-G02 33501-S5A-003 33551-S5A-003 34151-S5A-A01 34156-S5A-A01 34151-S5B-A01 34156-S5B-A01 33501-S5B-003 33551-S5B-003 34151-SM3-013 33501-SNB-003 33551-SNB-003 34156-SM3-013 34151-SNB-G51 34156-SNB-G51 33501-SNB-G52 33511-SNB-G52 117-4001-RH 117-4001-LH 34150-TET-H01 34155-TET-H01 33500-T24-T01 33550-T24-T01 34150-T24-T01 34155-T24-T01 UNI-STOP-2004 UNI-STOP-2003 81551-13350 81561-13350 81551-02150 81561-02150 81551-02300 81561-02300 81551-12A10 81561-12A10 81581-12110 81591-12100 81551-02560 81561-02560 81581-02340 81591-02340 81551-02790 81561-02790 81581-02520 81591-02530 81551-02D10 81561-02D10 81581-02C50 81591-02C50 81551-13350 81561-13350 81550-2B260 81560-2B260 95127056 95127057 33501-S9A-G00 33551-S9A-G00 33501-SWA-H01 33551-SWA-H01 33500-T1G-E52 33550-T1G-E52 8982222812 8982222822 898326843351 898328798351 8974882830 8974882820 216-1911-RH 216-1911-LH 216-1969-RH 216-1969-LH 92402-2D510 92401-2D510 92402-3X010 92401-3X010 92404-3X010 92403-3X010 92402-3X210 92401-3X210 92404-3X210 92403-3X210 92402-F2000 92401-F2000 92402-F2100 92401-F2100 92404-F2000 92403-F2000 92402-F2500 92401-F2500 92404-F2500 92403-F2500 92402-AA000 92401-AA000 33551-ST3-G11-B 33501-ST3-G11-B 33551-ST3-G11-S 33501-ST3-G11-S 92402-24320 92401-24320 92402-1C000 92401-1C000 92402-1C510-T 92401-1C510-T 1J6945112Q 1J6945111Q 5K0945096N 5K0945095N 5K0945094 5K0945093 5G0945208 5G0945207 5G0945308F 5G0945307F 5G0945208G 5G0945207G 5G0945308P 5G0945094AG 5G0945307P 5G0945093AG 5G0945096AG 5G0945095AG 5H0945096C 5H0945095C 5G0945094 5G0945093 5H0945096-LED 5H0945095-LED 5H0945094-LED 5H0945093-LED 36255-65D00 36275-65D00 92402-4H000 92401-4H000 92402-43300 92401-43300 81550-95J10 81560-95J10 0K73N-51-150A 0K73N-51-160A 212-1945-RH 212-1945-LH 81550-35130-RH 81560-35130-LH 212-19F3-RH 212-19F3-LH 81550-0K010 81560-0K010 92402-0X010 92401-0X010 92402-1J000 92401-1J000 92402-1J500 92401-1J500 92402-C8000 92401-C8000 92402-C8600 92401-C8600 92404-C8600 92403-C8600 213-1926-RH 213-1926-LH 8973756062 8973746052 8981253983 8981254013 8-981254023 8-981254053 92402-2S020 92401-2S020 92406-2S020 92405-2S020 6J4945096K 6J4945095K 33501-SAA-H02 33551-SAA-H02 33500-TG5-H01 33550-TG5-H01 33500-TF0-H51 33550-TF0-H51 33500-T5A-G01 33550-T5A-G01 1K5945096G 1K5945095G 1K5945094G 1K5945093G 5C6945094A 5C6945093A 5C6945096H 5C6945095H 5C6945094H 5C6945093H 214-1923-1-RH 214-1923-1-LH 214-1923-2-RH 214-1923-2-LH MR109128 MR109127 03-1104-RH 03-1104-LH UNI-STOP-236 UNI-STOP-235 UNI-STOP-893-RH/8330A944 UNI-STOP-892-LH/8330A945 UNI-44-1201-RH UNI-44-1200-LH 8330B210 8330B211 MB527316 MB527315 8330A606 8330A607 5F0945208E 5F0945207E 5FA945208C 5FA945207C 92402-17000 92401-17000 92402-17910 92401-17910 BN8V-51-150D BN8V-51-160D BN9A-51-150C BN9A-51-160C 26554-1HM1B 26555-1HM0B 26550-3HN0A 26555-3HN0A 215-19K6-RH 215-19K6-LH 215-19ACR-RD-UE 215-19ACL-LD-UE 5E5 945 112A 5E5 945 111A 3C5945096H 3C5945095H 3C5945094C 3C5945093C 3AE945096F 3AE945095F 3AE945208B 3AE945207B 3AE945308 3AE945307 3G5945096A 3G5945208 3G5945095A 3G5945207 3G5945094B 3G5945308 3G5945093B 3G5945307 3G5945208F 3G5945207F 3G5945308F 3G5945307F 3G5945096A 3G5945095J 3G5945094F 3G5945093F 3C8945096D 3C8945095D B6550-25G60 B6555-25G60 26550-2S425-T 26555-2S425-T 6Q6945096G 6Q6945095G 6Q6945096M 6Q6945095M 6R0945096A 6R0945095A 6C0945096 6C0945095 2G0945096B 2G0945095B 2G0945096E 2G0945095E 2G0945094B 2G0945093B 0K72A-51-150 0K72A-51-160 26550-2F025 26555-2F025 215-19B4-UE-RY-RH 215-19B4-UE-RY-LH 26550-2F925 26555-2F925 26550-JD000 26555-JD000 26550-JD800 26555-JD800 26550-BR01A 26555-BR01A 26550-4EA5B 26555-4EA5A 26550-4EA0A 26555-4EA0A 26550-HV00A 26555-HV00A 26550-HV05A 26555-HV05A 92402-FD020 92401-FD020 92402-1G010 92401-1G010 92402-1W200 92401-1W200 92404-1W200 92403-1W200 92402-1W000 92401-1W000 92402-H9000 92401-H9000 92404-H9000 92403-H9000 9820555280 9819427380 92402-3E000 92401-3E000 92402-C5000 92401-C5000 92402-03000 92401-03000 92402-3W010 92401-3W010 92406-3W010 92405-3W010 UNI-GHG-014 UNI-GHG-013 92401-47000/92402-47000 92402-4A600-T 92401-4A600-T 92406-4A600-T 92405-4A600-T 35650-62J00 35670-62J00 35650-73K00 35670-73K00 35650-79J00 35670-79J00 701945096 701945095 7E5945096 7E5945095 7E0945096K 7E0945095K UNI-TSL-051 UNI-TSL-050 UNI-TSL-053 UNI-25798 897910303-0 897910304-0 897114440-0 897114450-0 5N0945096H 5N0945093H 5N0945208 5N0945207 5N0945308 5N0945307 5NA945208C 5NA945096C 5NA945207C 5NA945095C 5NA945308D 5NA945094F 5NA945307D 5NA945093F 2GA945096A 2GA945095A 2GA945094A 2GA945093A 92402-2E010 92401-2E010 92402-D7000 92401-D7000 92404-D7000 92403-D7000 92402-D3100 92401-D3100 92402-D3600 92401-D3600 UNI-STOP-303-RH UNI-STOP-303-LH 218-1911-RH 218-1911-LH 26550-6FP0A 26555-6FP0A 212-19C7-RH 212-19C7-LH 212-19H3-RH 212-19H3-LH 81550-1A720-RH 81560-1A630-LH 2K7945208E 2K7945207E 28915-DF30A 37513-SB0-961 76840-SNB-S02 8-980576090 UNI-DSF-001 76815-SDA-A11 38480-77500 76810-TGG-E01 85381-12280 76810-S10-013 85035-89115 85381-35040 76810-SAA-E01 76850-SAA-004 76810-TF0-G01 28932-1KA0A 8265A335 MN169829 28930-AX600 UNI-13752 28931-5JG0A 28930-5JG0A UNI-19757 28931-AU000 28930-2F901 38480-61M10 85330-02030 90602-JD00A 8979428760 CA100005130 37522-EB30A 10101-00Q1M 10101-00Q1M-C 8973672850 12363-0T140 12305-0T331 12372-0T571 8-973677272-0 8-97367273-0 8-98250592-0 8-98075376-0 11220-EB70C 8972349821/8972476811 11320-JS10A-T 11320-JR70D 52618-02070 52618-02190 52618-02010 1401037 85226-AX600 85227-AX600 71193-SEA-003 71198-SEA-003 71193-TVA-A01 71198-TVA-A01 1406548 1406547 52575-02091 52576-02091 52576-05030 52575-05030 52535-05020 52536-05020 71193-S5A-003 71198-S5A-003 52535-02030 52536-02020 52562-12130 52563-12040 52115-02290 52116-02290 52575-0F030 52576-0F030 8-98247-822-1 8-98248-822-1 898074258451 898074259451 UNI-X-096-RH UNI-X-096-LH 71593-TF0-003 71598-TF0-003 62222-1KA0A 62223-1KA0A 85228-1KA0A 85229-1KA0A 62222-BV80A 62223-BV80A MN146320T MN146319T 6410C544 6410C543 85220-1HA0A 85221-1HA0A 62224-1HA0A 62226-AX000 62225-1HA0A 62227-AX000 62222-BR00A 62223-BR00A 71832-63J00 71731-68L00 71732-68L00 71731-80J00 71732-80J00 62222-3UB0A 62223-3UB0A 62222-4CL0A 62223-4CL0A 85220-4CE0A 85221-4CE0A 52155-0D050 UNI-BRKT-024 UNI-BRKT-023 UNI-BRKT-022/52535-52111 UNI-BRKT-021/52536-52080 6420A020 6420A019 85065-EB710 39020290 39020289 13238553 UNI-18231 1320211-B 13387316 13387317 92800-1E000OR 92800-1R0008M 92800-2D000QS 74880-S04-G01 74880-SNA-A01 8980737262 46420-02121 46430-02121 46420-02140/46420-12700 46430-02140/46430-12580 46420-02300 46430-02300 89800-70070 89800-70081 8-97368-068-0 8-97363-346-0 898067048-1 898067049-1 46420-0K030 46430-0K030 46420-0K210 46430-0K210 36530-9F000 74130-S5A-A01ZA 8987333-1432-7M04 898071760 47510-TR0-A52 84450-05040 48750-1E411 84450-0K010 MB903639 4408A142 MB686054 MR123396 MB141845 MN113754/MR449457 48750-2F000/48750-0M010 37111-62JA0 84450-71010 55406-02060 MB620790 2020A031 8657A099/8657A065 44610-1E310 44610-3D730 77298-SNA-D01ZA UNI-19532 UNI-19503 UNI-11721 UNI-02532 UNI-07895 UNI-13236 54131-SDA-Q81 54102-TR0-A03ZB UNI-19535 33504-12310 83357-24504-GRI UNI-19533 33504-12180 33504-22140 UNI-06405 54130-SAA-981 UNI-20988 UNI-24814 32865-50Y00 32865-JD100 UNI-18851 11140-4M500 15301-74010 15650-PLM-004 15650-PWA-000 15301-33020 UNI-03449 15301-22050 15301-37010 16910-69G01 16910-77E02 15301-30070 15301-54080 UNI-17982 1255A068 11140-EB300 11140-VK50A 11140-9F600 15710-33030 UNI-YS-002 15301-47050 8972548551 8972548541 8972548531 44201-EB360/44200-EB70A 8-97941501-3 19101-RSA-G00 16480-0N010 21710-1KK0A'; ;WITH CODELIST AS ( SELECT LTRIM(RTRIM(Split.a.value('.', 'nvarchar(200)'))) AS PRODUCTCODE FROM ( SELECT CAST('<X>' + REPLACE(@LIST, CHAR(10), '</X><X>') +'</X>' AS XML) AS DATA ) AS A CROSS APPLY DATA.nodes('/X') AS Split(a) ) SELECT C.PRODUCTCODE AS LISTE_KODU, ISNULL(I.CODE, '') AS ITEM_CODE, -- << BOS GETIRIR I.PRODUCERCODE FROM CODELIST C LEFT JOIN LG_011_ITEMS I ON I.PRODUCERCODE LIKE '%' + C.PRODUCTCODE + '%' ORDER BY LISTE_KODU; END
Oluşturulma: 23.12.2025 07:15
Son Güncelleme: 23.12.2025 17:28
İptal
Nesneyi Sil
Değişiklikleri Kaydet