SELECT SEGMENT1,FULL_LEAD_TIME 
from apps.mtl_system_items_b
WHERE organization_id = '2989'
AND SEGMENT1 IN (
'533-1169',
'1130479',
'1125432',
'310-6310',
'310-9352',
'1266977',
'1223378',
'1167253',
'1177091',
'1236293',
'310-9779',
'2519-0307',
'320-6285',
'1125440',
'1125442',
'1128466',
'1129509',
'400-0989',
'320-4482',
'1131034',
'7202-0204',
'310-4481',
'1075805',
'410-6698',
'420-2904',
'320-9785',
'330-3052',
'330-4489',
'1114054',
'812-4529',
'1125439',
'1118610',
'300-9770',
'310-2606',
'310-3503',
'1212824',
'703-5011',
'705-2011',
'450-0334',
'450-2807',
'450-9788',
'300-6292',
'1162725',
'1151322',
'1151323',
'1147334',
'1103937',
'1180300',
'1181315',
'1146566',
'1146977',
'1177224',
'1170600',
'1170823',
'1176756',
'1212822',
'1173958',
'7202-0604',
'1216564',
'1216563',
'1236522',
'1232616',
'1146521',
'1228315',
'1228316',
'1142155',
'2805-0035',
'1253203',
'1184491',
'1253227',
'1202827',
'1111111',
'1190530',
'1184226',
'1253206',
'1224334',
'1118915',
'1204539',
'1070800',
'1072113',
'1234950',
'1130091',
'1110720',
'3103-0196',
'7203-0204',
'1112774',
'1116078',
'1095372',
'1096625',
'1101919',
'1102854',
'1108063',
'1108262',
'7203-0208',
'1602-0054',
'1605-0056',
'1202342',
'1605-0355',
'1069418',
'1101649',
'1103471',
'1163319',
'1092690',
'1092990',
'1093851',
'1095368',
'1083895',
'2805-0045',
'1214315',
'1092691',
'1080038',
'1080043',
'1080030',
'1183842',
'1190550',
'1193821',
'1151901',
'1156466',
'1081383',
'1188193',
'1083603',
'1170506',
'1170508',
'1170336',
'1170289',
'1162122',
'1086161',
'1132939',
'1174040',
'1093863',
'1094060',
'1095381',
'1069416',
'1144697',
'1147585',
'1147595',
'1146506',
'1149209',
'1150205',
'1076574',
'1079402',
'1072455',
'1072530',
'1124794',
'1134043',
'1174298',
'1140543',
'1145162',
'1149214',
'1073362',
'1073550',
'1074549',
'1054488',
'1124792',
'1124793',
'1127127',
'1129769',
'1103797',
'1080279',
'1107266',
'1073226',
'1172635',
'1149893',
'1149896',
'1151278',
'1168789',
'1106940',
'1099286',
'1102432',
'1202822',
'1253217',
'1253220',
'1254516',
'1228321',
'1228322',
'1228323',
'1270823',
'1212823',
'1214365',
'1219480',
'1190356',
'1267728',
'1253214',
'1253215',
'1268615',
'1270826',
'1272930',
'1273049',
'1268619',
'1219471',
'1157017',
'1270817',
'1250128',
'1250129',
'1251403',
'1250107',
'1250108',
'1250117',
'1110424',
'1250029',
'1250034',
'1250130',
'1250048',
'1250099',
'1250100',
'1250754',
'1250006',
'1250007',
'1250134',
'1250137',
'1250143',
'1250145',
'1250119',
'1250198',
'1250203',
'1250008',
'1250010',
'1250014',
'1250022',
'1250175',
'1250185',
'1250190',
'1250192',
'1250517',
'1250692',
'1250193',
'1250194',
'1268512',
'1251482',
'1251570',
'1257842',
'1250146',
'1250155',
'1250122',
'1250124',
'1250125',
'1250126',
'1250127',
'1256639',
'1250920',
'1262112',
'1275808',
'1276236',
'1256641',
'1256653',
'1256659',
'1251414',
'1274199',
'1250002',
'1250005',
'1250028',
'1235987',
'1276350',
'1257285',
'1264904',
'1256669',
'1264961',
'1264967',
'1188683',
'1188681',
'1078596',
'1184303',
'1250001',
'1038125',
'1170863',
'1129120',
'1146679',
'51244',
'1184036',
'1184035',
'1183227',
'1182551',
'1120885',
'1118307',
'1138546',
'1101854',
'1190227',
'53963',
'53886',
'52928',
'51394',
'1118306',
'1183226',
'1178928',
'1127572',
'1121886',
'1121858',
'1118505',
'1039078',
'1131831',
'1130674',
'1204200',
'1127841',
'1101182',
'1101179',
'1125865',
'1125862',
'1125860',
'1118305',
'1118578',
'1118576',
'1116735',
'1078233',
'1078040',
'1076081',
'1076017',
'1126128',
'55775',
'1125970',
'1125968',
'1188507',
'1107688',
'1099233',
'1117258',
'1111173',
'1127017',
'1148008',
'1189361',
'1178169',
'1123922',
'1151479',
'1120742',
'1111779',
'1270781',
'1095708',
'1094216',
'1118500',
'1111947',
'1108503',
'1103126',
'1171402',
'1204198',
'1204196',
'1265097',
'1268726',
'1271226',
'1171549',
'1177519',
'1171200',
'1192362',
'1171230',
'1171229',
'1099597',
'1104693',
'1109602',
'1126881',
'1185127',
'1119841',
'1127166',
'1118300',
'1084027',
'1204985',
'1179823',
'1126614',
'1179810',
'1207490',
'1204988',
'1170646',
'1167647',
'1166873',
'1162843',
'1159707',
'1159275',
'1159274',
'1143751',
'1146794',
'1137716',
'1143906',
'1137690',
'1141430',
'1137684',
'1137662',
'1137697',
'1137681',
'1137760',
'1137753',
'1137722',
'1137680',
'1137679',
'1137656',
'1112634',
'1137729',
'1137695',
'1276374',
'1137734',
'1156048',
'1137474',
'1171847',
'1137304',
'1137258',
'1139132',
'1139133',
'1218790',
'1098509',
'1098483',
'1098297',
'MATRIX532-PF',
'1267203',
'1267299',
'1183207',
'1265573',
'1234756',
'1218823',
'1218827',
'1253734',
'1184522',
'1166936',
'1103667',
'1094121',
'7202-0406',
'6007-0431',
'1171554',
'1169784',
'1078578',
'1072544',
'7886-0800',
'7202-0418',
'7202-0808',
'7202-0408',
'1129779',
'1103018',
'1102905',
'1102903',
'1102901',
'1109652',
'1105258',
'1195360',
'1195362',
'1253495',
'1190815',
'1146088',
'1146087',
'1123098',
'1123087',
'1123085',
'1190521',
'1166959',
'1166957',
'1130106',
'1137257',
'1137248',
'1132777',
'1269781',
'1269782',
'1269347',
'1113632',
'1113627',
'1269262',
'1131845',
'1130032',
'1171782',
'1168957',
'1269346',
'1128602',
'1128601',
'1156964',
'1125408',
'1100468',
'1137736',
'1137748',
'1137733',
'1236439',
'1189504',
'1207561',
'1173857',
'1179415',
'1137728',
'1179133',
'1171545',
'1137738',
'1153930',
'1137727',
'1236438',
'1204986',
'1116679',
'1269135',
'1167654',
'1195071',
'1110064',
'1137726',
'1114606',
'1184494',
'1184520',
'1218320',
'1218328',
'1193826',
'1193837',
'1178790',
'1186986',
'1187038',
'1210877',
'1177654',
'1177653',
'1218329',
'1187517',
'1177656',
'1234358',
'1212977',
'1234357',
'1234649',
'1272948',
'1178858',
'1210972',
'1212973',
'1212975',
'1212976',
'1177655',
'1234359',
'1259965',
'1173310',
'1205580',
'1207057',
'1210873',
'1177652',
'1409-0020',
'1168121',
'1133588',
'1212974',
'1223375',
'1174362',
'1193845',
'1169324',
'1197983',
'1220124',
'1169323',
'1197150',
'1202844',
'1190807',
'1190797',
'1193827',
'1190810',
'1132445',
'1202871',
'1190793',
'1203371',
'1193846',
'1193838',
'1219488',
'1132441',
'1220229',
'1183637',
'1203370',
'1187040',
'1202836',
'1202826',
'1220123',
'1219477',
'1178758',
'1178764',
'1193811',
'1193842',
'1181059',
'7892-0201',
'1230991',
'1000837',
'1211415',
'1202821',
'1137735',
'1109196',
'1138521',
'1105121',
'1133606',
'1223042',
'1605-0023',
'1272952',
'1129404',
'1099513',
'1079883',
'1083436',
'1113725',
'1129766',
'1270956',
'1270957',
'1272895',
'1144528',
'1196630',
'1167652',
'1157590',
'1118568',
'1257422',
'1203719',
'1185057',
'1185383',
'1169130',
'1196752',
'1196628',
'1196629',
'1169131',
'1185054',
'1212461',
'1212628',
'1203060',
'1202699',
'1203716',
'1174349',
'1213189',
'1197143',
'1073840',
'1203063',
'1203064',
'1203717',
'1203718',
'1203066',
'1188783',
'1187035',
'1217434',
'1230178',
'1203097',
'1265510',
'1083433',
'1202346',
'1148735',
'1256112',
'1185049',
'0217-307-00',
'1231014',
'1265511',
'1150304',
'1181005',
'1203196',
'1185050',
'1185051',
'1203193',
'1087064',
'1185048',
'1146159',
'1137667',
'1158258',
'1182552',
'1137731',
'1125756',
'1184492',
'1258946',
'1142185',
'1128561',
'1269132',
'1109106',
'1269792',
'1223043',
'1150025',
'1269259',
'1203062',
'1232121',
'1180829',
'1208978',
'1161543',
'1224587',
'1156889',
'1190522',
'1109658',
'1178752',
'1173296',
'1180828',
'1210876',
'1212971',
'1185046',
'1256668',
'1251412',
'54555',
'1177584',
'1204197',
'1170982',
'1149651',
'1212186',
'1085313',
'1165460',
'1253202',
'1147893',
'1250195',
'1253218',
'1168790',
'1093853',
'1126346',
'1137730',
'1197523',
'1193830',
'1190801',
'1118572',
'1133494',
'410-6696',
'1128560',
'1147713',
'1171551',
'1130105',
'1152086',
'1137749',
'1173446',
'1187194',
'1171547',
'1072385',
'1103674',
'1071861',
'1173198',
'1179416',
'1073405',
'1127823',
'55974',
'1083625',
'1071585',
'1137675',
'1179858',
'1137377',
'1137708',
'1151721',
'1164688',
'1095382',
'1107992',
'1119268',
'1179822',
'1253198',
'1179451',
'1155902',
'1128537',
'320-6311',
'1151271',
'1156123',
'1193844',
'1072465',
'1215267',
'1187037',
'1178794',
'1193825',
'1057367',
'1157586',
'1185052',
'1137689',
'1093542',
'1204987',
'1103993',
'1167886',
'1172875',
'1167834',
'1137723',
'1218788',
'1172388',
'1159544',
'1104794',
'54103',
'55999',
'1273538',
'1094994',
'1118502',
'1076095',
'1250200',
'1250012',
'1250144',
'1250085',
'1273050',
'1273916',
'1251413',
'1251401',
'1261708',
'1266980',
'1253205',
'1117004',
'1253219',
'1095380',
'1097999',
'1105598',
'1151039',
'1275121',
'310-2722',
'410-2033',
'1116780',
'1202688',
'1269348',
'1224583',
'1269263',
'1137742',
'1128604',
'1273095',
'1220231',
'1253595',
'1134363',
'1230768',
'1261057',
'1145690',
'1128157',
'1145689',
'1101852',
'1137693',
'1147891',
'1114734',
'1196735',
'1256645',
'1280972',
'1121081',
'1124774',
'1069415',
'1149350',
'1145688',
'1132774',
'1145687',
'1273097',
'1154732',
'1078036',
'1228320',
'1273096',
'1253222',
'1253224',
'1253226',
'1253221',
'1218334',
'1220228',
'1230989',
'1196903',
'1173349',
'1173302',
'1218791',
'1185044',
'1106276',
'1157299',
'1129923',
'57218',
'1137688',
'1098579',
'1112228',
'1128485',
'1128486',
'1250179',
'1250151',
'1250695',
'1250027',
'1250092',
'51255',
'1112738',
'1105688',
'7102-1412',
'1147712',
'1250120',
'1118959',
'1224330',
'1271911',
'1079002',
'1279863',
'1220766',
'1112740',
'705-2010',
'420-4275',
'3803-0386',
'1182767',
'1118677',
'1145257',
'1253223',
'1253225',
'1146542',
'1107847',
'1079401',
'1133792',
'1163036',
'1081240',
'1173012',
'1078597',
'1111234',
'1081924',
'1159917',
'1108906',
'1103698',
'1218828',
'1218789',
'1196703',
'1267596',
'1250199',
'1251402',
'1229139',
'1156501',
'1099945',
'1161545',
'1254256',
'1124795',
'1094213',
'1106967',
'320-2019',
'1185045',
'703-9792',
'1266961',
'705-0791',
'1203909',
'1079231',
'1120663',
'1109677',
'1101219',
'1120664',
'1222675',
'1187490',
'1121885',
'1197056',
'211-0083G',
'1178367',
'1186821',
'1130563',
'1137373',
'1137750',
'1120644',
'1178852',
'153-9617',
'1102900',
'0170-668-00',
'1260894',
'1222676',
'1214874',
'1146553',
'1211396',
'1220329',
'1152101',
'1129857',
'1224388',
'1236442',
'1203067',
'1215996',
'1196627',
'1098318',
'1092700',
'55114',
'1116406',
'1256666',
'1251405',
'1250025',
'1267597',
'1102899',
'1096059',
'1147894',
'400-1133',
'320-9784',
'1190795',
'1065875',
'1270538',
'1127351',
'1202689',
'1103819',
'1116405',
'310-9775',
'1160725',
'1185058',
'1204199',
'1117168',
'1099576',
'1120890',
'1173961',
'1099393',
'1170509',
'1127574',
'1213866',
'1213187',
'1156886',
'1099379',
'1132589',
'1119036',
'1253405',
'545-0798',
'1141431',
'1150234',
'1184039',
'1155341',
'310-4494',
'310-9773',
'1250084',
'1079405',
'1409-0140',
'1190805',
'1169114',
'1170805',
'1127839',
'1203802',
'1172363',
'1236441',
'1212978',
'1219478',
'1218336',
'1130693',
'1095385',
'1191282',
'1116449',
'1175177',
'1215691',
'1186825',
'1196655',
'1219475',
'400-9179',
'1151903',
'1102174',
'310-4495',
'310-9771',
'1072457',
'1267754',
'1119457',
'1119287',
'1072454',
'1117169',
'1123103',
'1253216',
'MATRIX_UV-PF',
'1196656',
'1141002',
'1103783')