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') |