SET SESSION innodb_lock_wait_timeout=120;
START TRANSACTION;
DROP TEMPORARY TABLE IF EXISTS _plan; DROP TEMPORARY TABLE IF EXISTS _newp; DROP TEMPORARY TABLE IF EXISTS _sh;
CREATE TEMPORARY TABLE _plan(
  part_key VARCHAR(255), part_display VARCHAR(255), location_pk BIGINT UNSIGNED,
  qty INT, product_pk BIGINT UNSIGNED NULL, price DECIMAL(10,2) NULL,
  KEY(part_key), KEY(product_pk), KEY(location_pk)) ENGINE=InnoDB;
CREATE TEMPORARY TABLE _newp(product_id VARCHAR(255), spn VARCHAR(255), partslink VARCHAR(255), supplier VARCHAR(255)) ENGINE=InnoDB;
CREATE TEMPORARY TABLE _sh(location_id BIGINT UNSIGNED PRIMARY KEY) ENGINE=InnoDB;
INSERT INTO _plan (part_key,part_display,location_pk,qty) VALUES ('008340-1917L-AS','008340-1917L-AS',30,1),('08-216-1965L-B','08-216-1965L-B',8,1),('08-315-2022R-UD','08-315-2022R-UD',46,1),('08-33G-1103R','08-33G-1103R',3,1),('09-317-1147R-UD','09-317-1147R-UD',21,1),('1-03273','1-03273',99,1),('1-06484','1-06484',86,1),('1-06939','1-06939',24,1),('1-10910','1-10910',57,1),('1-10912','1-10912',131,1),('1-16431','1-16431',81,1),('1-17526','1-17526',93,1),('1-17729','1-17729',57,1),('1-17766','1-17766',77,1),('1-17934','1-17934',11,1),('1-19045','1-19045',37,1),('11-12433-00-9','11-12433-00-9',207,1),('11-5130-01','11-5130-01',161,1),('11-5189-00','11-5189-00',22,1),('11-5278-01','11-5278-01',164,1),('11-5373-01','11-5373-01',122,1),('11-5968-00-9','11-5968-00-9',90,1),('11-6315-91','11-6315-91',97,1),('11-6316-91','11-6316-91',97,1),('11-6889-00-0','11-6889-00-0',64,1),('11-6890-00-11','11-6890-00-1 1',135,1),('11-6890-00-91','11-6890-00-9 1',86,1),('11-9208-00','11-9208-00',25,1),('117-2019L-AQN','117-2019L-AQN',90,1),('12-1226-00','12-1226-00',176,1),('12-5230-00','12-5230-00',48,1),('12-5467-00','12-5467-00',207,1),('12-5491-00-9','12-5491-00-9',21,1),('12-5492-00-9','12-5492-00-9',21,1),('123-1601R-AQ','123-1601R-AQ',3,1),('13783','13783',104,1),('13915','13915',16,1),('13924','13924',104,1),('1494-1','1494-1',138,1),('150230-A','150230-A',101,1),('150257','150257',56,1),('150315-A','150315-A',24,1),('150315-A','150315-A',25,1),('150406-A','150406-A',15,1),('152024-A','152024-A',95,1),('152025-A','152025-A',35,1),('152025-A','152025-A',81,1),('152062-A','152062-A',56,1),('152070-A','152070-A',24,1),('15456','15456',94,1),('159901-A','159901-A',21,1),('17-5331-00-1','17-5331-00-1',35,1),('17-5394-00-9','17-5394-00-9',95,1),('17-5449-00','17-5449-00',86,1),('17-5834-00','17-5834-00',25,1),('17-6028-00-9','17-6028-00-9',63,1),('18-3415-01','18-3415-01',50,1),('18-3415-01','18-3415-01',156,1),('18-3416-01','18-3416-01',50,1),('18-3416-01','18-3416-01',156,1),('18-5065-01','18-5065-01',106,1),('18-5074-01','18-5074-01',99,1),('18-5894-01-9','18-5894-01-9',101,1),('18-5897-01','18-5897-01',37,1),('18-5898-01-9','18-5898-01-9',3,1),('18042','18042',108,1),('18106','18106',94,1),('19-5318-00-9','19-5318-00-9',131,1),('19-5626-00','19-5626-00',7,1),('19-5921-00-9','19-5921-00-9',87,1),('19-5921-00-9','19-5921-00-9',98,1),('19-5921-00-9','19-5921-00-9',164,1),('19-5995-01-9','19-5995-01-9',49,1),('19-6019-00-9','19-6019-00-9',90,1),('19-6038-00','19-6038-00',94,1),('19-6092-00-9','19-6092-00-9',48,1),('19-6143-00-9','19-6143-00-9',89,1),('19-6181-00','19-6181-00',95,1),('19-6248-00','19-6248-00',51,1),('19-6282-00','19-6282-00',99,1),('19-6391-00','19-6391-00',53,1),('19141','19141',91,1),('2-08302','2-08302',91,1),('2-14487','2-14487',7,1),('2-21002','2-21002',63,1),('20-17072-90','20-17072-90',87,1),('20-17910-90-9','20-17910-90-9',151,1),('20-3076-00-9','20-3076-00-9',77,1),('20-6049-00-9','20-6049-00-9',151,1),('20-6173-01-9','20-6173-01-9',139,1),('20-6235-70-9','20-6235-70-9',32,1),('20-6727-90-9','20-6727-90-9',136,1),('20-6757-91-9','20-6757-91-9',48,1),('20-9042-01-1','20-9042-01-1',87,1),('20-9080-00-9','20-9080-00-9',119,1),('20-9087-90-9','20-9087-90-9',87,1),('20-9395-00-9','20-9395-00-9',112,1),('20-9639-00-91','20-9639-00-9 1',150,1),('20-9642-00-11','20-9642-00-1 1',52,1),('20-9711','20-9711',66,1),('20-9749-70','20-9749-70',69,1),('20-9808-00-1','20-9808-00-1',80,1),('20-9962-00','20-9962-00',39,1),('20-9993-80-91','20-9993-80-9 1',4,1),('20180730','20180730',4,1),('212-19J1L-AS','212-19J1L-AS',8,1),('212-2052R-ACN','212-2052R-ACN',135,1),('212-2052R-AQ','212-2052R-AQ',20,1),('212-2088L','212-2088L',12,1),('212-2089R-AQ','212-2089R-AQ',8,1),('214-2050N-AQ','214-2050N-AQ',8,1),('215-2047L-AS','215-2047L-AS',102,1),('215-2047R-AC','215-2047R-AC',25,1),('216-1965L-AQ','216-1965L-AQ',3,1),('216-1972L-UC','216-1972L-UC',8,1),('220452','220452',30,1),('221-2012R-AQ','221-2012R-AQ',49,1),('221-2015R-AQ','221-2015R-AQ',176,1),('223-1315R-AC','223-1315R-AC',4,1),('223-1315R-AC','223-1315R-AC',8,2),('2304A','2304A',49,1),('2312C','2312C',51,1),('2320131','2320131',96,1),('2401A','2401A',164,1),('2510','2510',7,1),('2560331','2560331',98,1),('3000032','3000032',86,1),('30015','30015',11,1),('30088','30088',79,1),('30110','30110',177,1),('30200','30200',79,1),('30259','30259',104,1),('30269','30269',104,1),('30273','30273',11,1),('30279','30279',25,1),('30310','30310',25,1),('312-1145L-AC','312-1145L-AC',61,1),('312-1154L-AC','312-1154L-AC',132,1),('312-1170L-ASH2','312-1170L-ASH2',97,1),('312-1180L-ASD3','312-1180L-ASD3',12,1),('312-1182L-AC2','312-1182L-AC2',151,1),('312-1198L-UCN7','312-1198L-UCN7',12,1),('312-11A5L-US1','312-11A5L-US1',47,1),('312-11AEL-AC1N','312-11AEL-AC1N',68,1),('312-11AEL-AC2','312-11AEL-AC2',116,1),('312-11AEL-AC2','312-11AEL-AC2',20,1),('312-11AEL-AS1N','312-11AEL-AS1N',97,1),('312-11AEL-ASN2','312-11AEL-ASN2',77,1),('312-11AEL-ASN2N','312-11AEL-ASN2N',30,1),('312-11AER-AS1N','312-11AER-AS1N',60,1),('312-11AGL-AC7','312-11AGL-AC7',130,1),('312-11AKL-AC2','312-11AKL-AC2',74,1),('312-11AKL-AS2','312-11AKL-AS2',104,1),('312-11AQRMACM2','312-11AQRMACM2',169,1),('312-11AWL-ASN2','312-11AWL-ASN2',90,1),('312-11AXL-AC2','312-11AXL-AC2',30,1),('312-11AXL-ACN9','312-11AXL-ACN9',7,1),('312-11AXR-AC2','312-11AXR-AC2',29,1),('312-11B1L-UC3','312-11B1L-UC3',150,1),('312-11B1RMUSHM3','312-11B1RMUSHM3',139,1),('312-11BDL-UC9','312-11BDL-UC9',115,1),('312-11BER-AC2','312-11BER-AC2',143,1),('312-11BER-UC2','312-11BER-UC2',74,1),('312-11BER-UC2','312-11BER-UC2',156,1),('312-11BHL-UC2','312-11BHL-UC2',104,1),('312-11BKL-UC7','312-11BKL-UC7',77,1),('312-11BYL-AC2','312-11BYL-AC2',7,1),('312-11C2L-AS1','312-11C2L-AS1',100,1),('312-11C2R-AS1','312-11C2R-AS1',100,1),('312-11C3L-USN3','312-11C3L-USN3',47,1),('312-11C8LMUSHM7','312-11C8LMUSHM7',4,1),('312-11CGL-AC2','312-11CGL-AC2',142,1),('312-11CGL-ASN2','312-11CGL-ASN2',49,1),('312-11CGL-ASN2','312-11CGL-ASN2',74,1),('312-11CHR-AS2','312-11CHR-AS2',20,1),('312-11CTL-AS2','312-11CTL-AS2',109,1),('312-11D1R-UC1','312-11D1R-UC1',36,1),('312-11D8LMACMN','312-11D8LMACMN',88,1),('312-1312R-US','312-1312R-US',12,1),('312-1322R-AC-PR','312-1322R-AC-PR',90,1),('312-1328R-AC','312-1328R-AC',61,1),('312-1333R-AS','312-1333R-AS',3,1),('312-1336L-US','312-1336L-US',90,1),('312-1336R-US','312-1336R-US',3,1),('312-1338L-AS2','312-1338L-AS2',58,1),('312-1338R-AS2','312-1338R-AS2',58,1),('312-1430L-AC','312-1430L-AC',65,1),('312-1430R-AC','312-1430R-AC',65,1),('312-1547R-AS1','312-1547R-AS1',8,1),('312-1612L-AS6','312-1612L-AS6',57,1),('312-1634R-AS','312-1634R-AS',96,1),('312-1636R-AS','312-1636R-AS',112,1),('312-1638R-AS','312-1638R-AS',8,1),('312-1650L-US','312-1650L-US',91,1),('312-1655R-AS','312-1655R-AS',102,1),('312-1668L-AC','312-1668L-AC',62,1),('312-1939R-AC','312-1939R-AC',77,1),('312-1969R-AC','312-1969R-AC',172,1),('312-1976L-UC','312-1976L-UC',135,1),('312-1987L-UC','312-1987L-UC',8,1),('312-19A8L-US','312-19A8L-US',34,1),('312-19ACL-AC2C','312-19ACL-AC2C',24,1),('312-19ACL-AS2C','312-19ACL-AS2C',112,1),('312-19ACR-AC-CR','312-19ACR-AC-CR',143,1),('312-19ACR-ACVCR','312-19ACR-ACVCR',60,1),('312-19ACR-AS2C','312-19ACR-AS2C',3,1),('312-19ACR-AS2CR','312-19ACR-AS2CR',69,1),('312-19ASL-AC2','312-19ASL-AC2',24,1),('312-19ASL-AS2','312-19ASL-AS2',122,1),('312-19B6L-AC','312-19B6L-AC',168,1),('312-19B6L-UC','312-19B6L-UC',3,1),('312-19B6R-UC','312-19B6R-UC',3,1),('312-19BDR-US2','312-19BDR-US2',30,1),('312-19BER-AS','312-19BER-AS',48,1),('312-19BMR-AS','312-19BMR-AS',36,1),('312-19BMR-AS','312-19BMR-AS',138,1),('312-2011L-AS','312-2011L-AS',43,1),('312-2011R-AS','312-2011R-AS',43,1),('312-2016N-AC','312-2016N-AC',164,1),('312-2016N-AS','312-2016N-AS',56,1),('312-2018L-UC','312-2018L-UC',3,1),('312-2018L-UC','312-2018L-UC',4,1),('312-2019R-AS','312-2019R-AS',77,1),('312-2031R-AC','312-2031R-AC',90,1),('312-2035L-AQ','312-2035L-AQ',30,1),('312-2037L-AS','312-2037L-AS',101,1),('312-2543R-UD','312-2543R-UD',164,1),('312-2906R-US','312-2906R-US',3,1),('312-2907L-AS','312-2907L-AS',3,1),('312-50027-221','312-50027-221',57,1),('312-50028-121','312-50028-121',4,1),('312-5404L3EB1','312-5404L3EB1',24,1),('312-5437L3EBH2','312-5437L3EBH2',71,1),('312-5440L3EB','312-5440L3EB',112,1),('312-5446L3EBH','312-5446L3EBH',143,1),('312-5449R3EFH','312-5449R3EFH',147,1),('312-5449R3EFH','312-5449R3EFH',102,1),('312-5454R3EBH1','312-5454R3EBH1',25,1),('312-5456L3EB','312-5456L3EB',146,1),('312-5456L3EB','312-5456L3EB',172,1),('312-5456L3EBH2','312-5456L3EBH2',97,1),('312-55009-000','312-55009-000',104,1),('312-55023-301','312-55023-301',104,1),('312-58018-000','312-58018-000',12,1),('3121-0497-4203','3121-0497-4203',112,1),('314-1302R-AS2C','314-1302R-AS2C',89,1),('314-1305R-AC','314-1305R-AC',164,1),('314-1928L-AC','314-1928L-AC',134,1),('314-2012N-AC','314-2012N-AC',131,1),('314-2505L-UD','314-2505L-UD',25,1),('314-2910R-UC','314-2910R-UC',65,1),('315-1153R-AC7','315-1153R-AC7',58,1),('315-1195L-AC','315-1195L-AC',55,1),('315-11ABL-AC7','315-11ABL-AC7',139,1),('315-11AKL-AC2','315-11AKL-AC2',68,1),('315-11AML-ASN1','315-11AML-ASN1',147,1),('315-11BDL-AC2','315-11BDL-AC2',104,1),('315-11BML-AC2','315-11BML-AC2',163,1),('315-11BQL-AC2','315-11BQL-AC2',132,1),('315-1504R-AS','315-1504R-AS',12,1),('315-1927L-DC-RS','315-1927L-DC-RS',3,1),('315-1929R-AS','315-1929R-AS',51,1),('315-1977R-AS','315-1977R-AS',87,1),('315-1979L-AC','315-1979L-AC',130,1),('315-1979L-AF','315-1979L-AF',12,1),('315-1988R-AS','315-1988R-AS',112,1),('315-19AHL-AC','315-19AHL-AC',58,1),('315-19AJL-AS','315-19AJL-AS',25,1),('315-2034R-AC','315-2034R-AC',36,1),('315-2034R-AS','315-2034R-AS',101,1),('315-2034R-AS','315-2034R-AS',176,1),('315-2035L-AC','315-2035L-AC',168,1),('315-2036L-AS','315-2036L-AS',77,1),('315-2036R-AC','315-2036R-AC',35,1),('315-2036R-AC','315-2036R-AC',172,1),('315-2036R-AS','315-2036R-AS',71,1),('315-2036R-AS','315-2036R-AS',95,1),('315-2514L-UD','315-2514L-UD',57,1),('315-2514L-UD','315-2514L-UD',102,1),('315-2906L-US','315-2906L-US',65,1),('315-2906R-UC','315-2906R-UC',164,1),('315-50004-211','315-50004-211',97,1),('315-50016-211','315-50016-211',11,1),('315-5401R3MD','315-5401R3MD',4,1),('315-5407R3CB','315-5407R3CB',4,1),('315-5410L3EB','315-5410L3EB',8,1),('315-5413L3EBH1','315-5413L3EBH1',94,1),('315-5413R3EBH1','315-5413R3EBH1',94,1),('315-5413R3EBH2','315-5413R3EBH2',175,1),('315-5439L3EB','315-5439L3EB',147,1),('315-5439R3EBH2','315-5439R3EBH2',36,1),('3151-0347-4201','3151-0347-4201',135,1),('316-1127L-US1','316-1127L-US1',48,1),('316-1140L-UC2','316-1140L-UC2',25,1),('316-1140L-UC3','316-1140L-UC3',51,1),('316-1140R-UC2','316-1140R-UC2',25,1),('316-1145L-US','316-1145L-US',4,1),('316-1158R-ASN2','316-1158R-ASN2',20,1),('316-1160LMUSM2','316-1160LMUSM2',4,1),('316-1161LMUCAM2','316-1161LMUCAM2',113,1),('316-1311L3AS','316-1311L3AS',4,1),('316-1422L-UC','316-1422L-UC',12,1),('316-1422L-UC','316-1422L-UC',65,1),('316-1509L-US','316-1509L-US',98,1),('316-1925R-AC','316-1925R-AC',51,1),('316-1949L-AS','316-1949L-AS',95,1),('316-1956R-AC','316-1956R-AC',134,1),('316-2005R-AS','316-2005R-AS',4,1),('316-2904L-UC','316-2904L-UC',61,1),('317-1127R-UC','317-1127R-UC',20,1),('317-1133L-UC','317-1133L-UC',109,1),('317-1138L-UCHN','317-1138L-UCHN',20,1),('317-1148L-UC2','317-1148L-UC2',25,1),('317-1150L-UC1','317-1150L-UC1',159,1),('317-1161R-ACN2','317-1161R-ACN2',3,1),('317-1168L-AS3','317-1168L-AS3',63,1),('317-1174L-ACN2','317-1174L-ACN2',152,1),('317-1174L-ACN2','317-1174L-ACN2',94,1),('317-1174R-AC2','317-1174R-AC2',30,1),('317-1174R-ACN2','317-1174R-ACN2',152,1),('317-1174R-ASD2','317-1174R-ASD2',20,1),('317-1174R-ASN2','317-1174R-ASN2',4,1),('317-1176L-AC2','317-1176L-AC2',52,1),('317-1179R-ACB','317-1179R-ACB',76,1),('317-1183L-AC2','317-1183L-AC2',16,1),('317-1184R-AS2','317-1184R-AS2',28,1),('317-1190R-AC','317-1190R-AC',157,1),('317-1194L-ASN2','317-1194L-ASN2',4,1),('317-1316R-AS','317-1316R-AS',51,1),('317-1321R-AS','317-1321R-AS',64,1),('317-1342-R3AC','317-1342-R3AC',168,1),('317-1347L-AS','317-1347L-AS',108,1),('317-1349L-AC2','317-1349L-AC2',49,1),('317-1515R-AS','317-1515R-AS',64,1),('317-1515R-AS','317-1515R-AS',81,1),('317-1955R-UC','317-1955R-UC',3,1),('317-1979R-US-CR','317-1979R-US-CR',51,1),('317-19AEL-AS','317-19AEL-AS',65,1),('317-19AKL-AS','317-19AKL-AS',48,1),('317-19ANL-AS2','317-19ANL-AS2',8,1),('317-19ANR-AS2','317-19ANR-AS2',100,1),('317-19ANR-AS2','317-19ANR-AS2',102,1),('317-19AQL-AC','317-19AQL-AC',56,1),('317-19AUL-AC2','317-19AUL-AC2',49,1),('317-19AUR-AS','317-19AUR-AS',151,1),('317-19AWR-AS','317-19AWR-AS',53,1),('317-19AZL-AS','317-19AZL-AS',116,1),('317-19AZL-AS','317-19AZL-AS',36,1),('317-19AZR-AS','317-19AZR-AS',36,1),('317-19B1L-AC','317-19B1L-AC',8,1),('317-19B4L-AS','317-19B4L-AS',138,1),('317-19BAL-AC','317-19BAL-AC',130,1),('317-2027L-AS','317-2027L-AS',127,1),('317-2038L-AS','317-2038L-AS',8,1),('317-2061L-AC','317-2061L-AC',90,1),('317-2509L-UD','317-2509L-UD',65,1),('317-2927L-UC','317-2927L-UC',65,1),('317-50003-262','317-50003-262',3,1),('317-50005-164','317-50005-164',4,1),('317-50005-211','317-50005-211',143,1),('317-50005-212','317-50005-212',3,1),('317-50006-183','317-50006-183',111,1),('317-5410R3EB','317-5410R3EB',89,1),('317-5420L3EB2','317-5420L3EB2',172,1),('317-5420R3EB2','317-5420R3EB2',172,1),('317-5422L3EF','317-5422L3EF',81,1),('317-5422R3EB','317-5422R3EB',62,1),('317-5434L3EB1','317-5434L3EB1',60,1),('317-5434L3EBH','317-5434L3EBH',3,1),('317-5435L3EB','317-5435L3EB',134,1),('317-5435R3EB','317-5435R3EB',100,1),('3171-0301-4200','3171-0301-4200',101,1),('3171-0328-4201','3171-0328-4201',3,1),('32-317-1182R2UD','32-317-1182R2UD',134,1),('32-317-1195L4UD','32-317-1195L4UD',49,1),('32-317-1195R4UD','32-317-1195R4UD',49,1),('32-317-1198R4UD','32-317-1198R4UD',58,1),('32-A34-1103L1UD','32-A34-1103L1UD',61,1),('32-A34-1103R1UD','32-A34-1103R1UD',64,1),('320-1110L-ACN','320-1110L-ACN',8,1),('320-1116L-AC2','320-1116L-AC2',152,1),('320-1118L-AC1','320-1118L-AC1',4,1),('320-1127L-AS2','320-1127L-AS2',98,1),('320-1131LMASM2','320-1131LMASM2',100,1),('320-1305L-ASN','320-1305L-ASN',90,1),('320-2016L-AS','320-2016L-AS',151,1),('320-2022R-AS','320-2022R-AS',135,1),('320-2022R-AS','320-2022R-AS',168,1),('320-2023L-AC','320-2023L-AC',77,1),('320-2023L-AC','320-2023L-AC',172,2),('320-2023R-AC','320-2023R-AC',172,1),('320-2023R-AS','320-2023R-AS',64,1),('320-2023R-AS','320-2023R-AS',99,1),('321-1160LXAS2','321-1160LXAS2',20,1),('321-1160RXAS2','321-1160RXAS2',20,1),('321-1160RXAS2','321-1160RXAS2',96,1),('321-1190L-AS2','321-1190L-AS2',55,1),('321-1331L-AS','321-1331L-AS',7,1),('321-1340L-AS','321-1340L-AS',75,1),('321-1340R-AS','321-1340R-AS',75,1);
INSERT INTO _plan (part_key,part_display,location_pk,qty) VALUES ('321-1607L-AC','321-1607L-AC',146,1),('321-1610R-AS','321-1610R-AS',116,1),('321-1930R-AS','321-1930R-AS',3,1),('321-2017R-AQ','321-2017R-AQ',176,1),('321-2046L-AC','321-2046L-AC',37,1),('321-2049R-AQ','321-2049R-AQ',12,1),('321-2510L-UD','321-2510L-UD',93,1),('321-2510L-UD','321-2510L-UD',163,1),('321-2907R-UC','321-2907R-UC',116,1),('321-50015-111','321-50015-111',11,1),('321-50015-112','321-50015-112',11,1),('321-50016-202','321-50016-202',3,1),('321-5417L3EB','321-5417L3EB',111,1),('321-5417R3EB','321-5417R3EB',43,1),('321-55011-100','321-55011-100',12,1),('323-1115L-AS','323-1115L-AS',12,1),('323-1148L-ACN2','323-1148L-ACN2',22,1),('323-1151L-AC2','323-1151L-AC2',31,1),('323-1151LMASHN2','323-1151LMASHN2',144,1),('323-1175R-AS2','323-1175R-AS2',46,1),('323-1180LXAS2','323-1180LXAS2',49,1),('323-1180LXAS2','323-1180LXAS2',94,1),('323-1180RXAS2','323-1180RXAS2',109,1),('323-1180RXAS2','323-1180RXAS2',74,1),('323-1180RXASN2','323-1180RXASN2',169,1),('323-1311R-AC','323-1311R-AC',4,1),('323-1603L-AS','323-1603L-AS',8,1),('323-1603L-AS','323-1603L-AS',31,1),('323-1605R-AC','323-1605R-AC',37,1),('323-1689R-AC','323-1689R-AC',12,1),('323-1915R-AS','323-1915R-AS',80,1),('323-1942L-AC','323-1942L-AC',86,1),('323-1978R-AS','323-1978R-AS',151,1),('323-2008L-AQ','323-2008L-AQ',123,1),('323-2048L-AS','323-2048L-AS',12,1),('323-2925R-UC','323-2925R-UC',112,1),('323-2938L-US','323-2938L-US',25,1),('323-50007-212','323-50007-212',4,1),('323-5414R3EBH1','323-5414R3EBH1',95,1),('323-5416R3EBH1','323-5416R3EBH1',8,1),('323-5416R3EBH1','323-5416R3EBH1',151,1),('323-55006-120','323-55006-120',4,1),('324-1101L-USN7','324-1101L-USN7',12,1),('324-1104LMUCA1D','324-1104LMUCA1D',3,1),('324-1105L-AC7','324-1105L-AC7',4,1),('324-1105L-UC3','324-1105L-UC3',28,1),('324-1105L-UC3','324-1105L-UC3',51,1),('324-1105R-UC3','324-1105R-UC3',20,1),('324-1110L-UC7','324-1110L-UC7',3,1),('324-1112R-UC2','324-1112R-UC2',33,1),('324-1112R-UCN2','324-1112R-UCN2',131,1),('324-1116L-UCN2','324-1116L-UCN2',123,1),('324-1116R-USN2','324-1116R-USN2',58,1),('324-1138L-US2','324-1138L-US2',4,2),('324-1141R-UC2','324-1141R-UC2',122,1),('324-1145R-AS2','324-1145R-AS2',104,1),('324-118RMUSHM2','324-118RMUSHM2',3,1),('324-1313L-AC','324-1313L-AC',71,1),('324-1603L-AS','324-1603L-AS',60,1),('324-1605L-AS','324-1605L-AS',64,1),('324-1605R-AS','324-1605R-AS',64,1),('324-1608R-AC','324-1608R-AC',8,1),('324-1916L-AS','324-1916L-AS',22,1),('324-1916R-UC','324-1916R-UC',4,1),('324-1921L-UC','324-1921L-UC',64,1),('324-1922R-AS','324-1922R-AS',4,1),('324-2012L-AC','324-2012L-AC',97,2),('324-2012R-AC','324-2012R-AC',97,2),('324-2012R-AQ','324-2012R-AQ',59,1),('324-2012R-AQ','324-2012R-AQ',88,1),('324-2013R-AC','324-2013R-AC',15,1),('324-2910L-US','324-2910L-US',176,1),('324-2910R-US','324-2910R-US',176,1),('325-1901R-AC','325-1901R-AC',12,1),('325-1901R-AC','325-1901R-AC',134,1),('325-2903L-US','325-2903L-US',51,1),('327-1116L-AS2','327-1116L-AS2',130,1),('327-1302L-AS','327-1302L-AS',20,1),('327-1904L-AC-PR','327-1904L-AC-PR',151,1),('327-1905L-AS4','327-1905L-AS4',86,1),('327-1905L-AS4','327-1905L-AS4',175,1),('327-2004R-UC','327-2004R-UC',12,1),('327-55014-101','327-55014-101',72,1),('327-55023-100','327-55023-100',94,1),('328-1101L-UC2','328-1101L-UC2',155,1),('328-1601L-AC','328-1601L-AC',25,1),('330-1906R-UST','330-1906R-UST',115,1),('330-1952L-AS','330-1952L-AS',8,1),('330-2016R-USN','330-2016R-USN',80,1),('330-2037L-AC','330-2037L-AC',50,1),('330-2037R-AC','330-2037R-AC',69,1),('330-2037R-AS','330-2037R-AS',8,1),('330-2059L-AS','330-2059L-AS',108,1),('330-2501R-UD','330-2501R-UD',8,2),('330-2507R-UD','330-2507R-UD',96,2),('330-2905L-US','330-2905L-US',172,1),('330-50041-101','330-50041-101',8,1),('330-53013-011','330-53013-011',3,1),('330-5404R3EC1','330-5404R3EC1',47,1),('330-5405L3EC','330-5405L3EC',146,1),('330-55028-400','330-55028-400',85,1),('331-1165R-AC','331-1165R-AC',143,1),('331-1534L-US','331-1534L-US',135,1),('331-1628L-US','331-1628L-US',4,1),('331-1629L-UC','331-1629L-UC',3,1),('331-1638R3US-CY','331-1638R3US-CY',7,1),('331-1947R-US','331-1947R-US',8,1),('331-1979R-AS','331-1979R-AS',95,1),('331-2010N-AS','331-2010N-AS',3,1),('331-2012R-AQ','331-2012R-AQ',4,1),('331-2907L-AC','331-2907L-AC',105,1),('332-1110R-ASN','332-1110R-ASN',3,1),('332-1110R-ASN','332-1110R-ASN',8,1),('332-1179L-AS','332-1179L-AS',3,1),('332-11A9L-ASH2','332-11A9L-ASH2',88,1),('332-1570L-US','332-1570L-US',47,1),('332-1621R-US','332-1621R-US',8,1),('332-1675R-US','332-1675R-US',77,1),('332-1683N-US','332-1683N-US',176,1),('332-1916R-US','332-1916R-US',22,1),('332-1925L-S','332-1925L-S',47,1),('332-1949R-AS','332-1949R-AS',123,1),('332-1949R-AS','332-1949R-AS',98,1),('332-50003-014','332-50003-014',31,1),('332-50007-173','332-50007-173',3,1),('333-1188L-AS','333-1188L-AS',75,1),('333-1190R-ACN2','333-1190R-ACN2',4,1),('333-1195L-AC2','333-1195L-AC2',143,1),('333-1197RMASHM7','333-1197RMASHM7',68,1),('333-1197RMASHN2','333-1197RMASHN2',56,1),('333-1306R-AC6','333-1306R-AC6',131,1),('333-1306R-ACN6','333-1306R-ACN6',3,1),('333-1511R-US','333-1511R-US',3,1),('333-1635L-AS','333-1635L-AS',11,1),('333-1902L-US2','333-1902L-US2',37,1),('333-1909L-US','333-1909L-US',8,1),('333-1938L-AC','333-1938L-AC',3,1),('333-1959R-AS','333-1959R-AS',8,1),('333-2036N-AC','333-2036N-AC',51,1),('334-1108L-ACN','334-1108L-ACN',72,1),('334-1111R-AC1','334-1111R-AC1',127,1),('334-1126R-ASN','334-1126R-ASN',4,1),('334-1127R-AS','334-1127R-AS',207,1),('334-1127R-AS','334-1127R-AS',159,1),('334-1132L-AC2','334-1132L-AC2',143,1),('334-1137L-ACN2','334-1137L-ACN2',138,1),('334-1139L-ACD2','334-1139L-ACD2',60,1),('334-1140L-ACN2','334-1140L-ACN2',130,1),('334-1141L-ACH2','334-1141L-ACH2',53,1),('334-1141L-ACHN2','334-1141L-ACHN2',64,1),('334-1143L-AC2','334-1143L-AC2',48,1),('334-1201L-UD','334-1201L-UD',89,1),('334-1201R-UD','334-1201R-UD',89,1),('334-1408L-AS','334-1408L-AS',51,1),('334-1702R-UD','334-1702R-UD',131,1),('334-1906L-US','334-1906L-US',75,1),('334-1906L-US','334-1906L-US',97,1),('334-1932L-AC','334-1932L-AC',53,1),('334-2020L-AS','334-2020L-AS',89,1),('334-2021L-AS','334-2021L-AS',57,1),('334-2505L-UD','334-2505L-UD',65,1),('334-50014-270','334-50014-270',8,1),('334-5419L3MF','334-5419L3MF',50,1),('334-5422R3MF','334-5422R3MF',164,1),('334-55011-120','334-55011-120',8,1),('335-1114R-AC','335-1114R-AC',138,1),('335-1148L-ACN','335-1148L-ACN',144,1),('335-1158R-AC','335-1158R-AC',94,1),('335-1164L-AS2','335-1164L-AS2',77,1),('335-1175L-AC2','335-1175L-AC2',48,1),('335-1175R-AC2','335-1175R-AC2',52,1),('335-1304L-AC','335-1304L-AC',89,1),('335-1304R-AC','335-1304R-AC',57,1),('335-1607L-AC','335-1607L-AC',90,1),('335-1946L-US','335-1946L-US',3,1),('335-1967L-AS','335-1967L-AS',86,1),('335-2014N-ASN','335-2014N-ASN',75,1),('335-2027N-AS','335-2027N-AS',49,1),('335-2034R-AS','335-2034R-AS',77,1),('335-2044L-AC','335-2044L-AC',61,1),('335-2045L-AC','335-2045L-AC',102,1),('335-2045L-AS','335-2045L-AS',8,1),('335-2045L-AS','335-2045L-AS',101,1),('335-2045L-AS','335-2045L-AS',176,2),('335-2045R-AS','335-2045R-AS',25,1),('335-2048R-AQ','335-2048R-AQ',8,1),('335-2515R-UD','335-2515R-UD',207,1),('335-2519R-UD1','335-2519R-UD1',76,1),('335-50018-001','335-50018-001',81,1),('335-5406R3EB','335-5406R3EB',30,1),('335-5409L3EFH','335-5409L3EFH',7,1),('335-5442L3MF','335-5442L3MF',30,1),('335-5442L3MF','335-5442L3MF',93,1),('335-5442R3MF','335-5442R3MF',7,1),('335-5446L4MF','335-5446L4MF',138,1),('335-5446R4MF','335-5446R4MF',119,1),('335-55032-101','335-55032-101',143,1),('335-56011-100','335-56011-100',12,1),('335-58025-000','335-58025-000',3,1),('336-1106R-AS','336-1106R-AS',3,1),('336-1118L-ACHN','336-1118L-ACHN',20,1),('336-1118R-ASHN','336-1118R-ASHN',12,1),('336-2002N-AS','336-2002N-AS',176,1),('336-50007-120','336-50007-120',3,1),('336-50007-120','336-50007-120',8,1),('340-1103R-AS','340-1103R-AS',118,1),('340-1107R-AS','340-1107R-AS',3,1),('340-1133R-AC','340-1133R-AC',7,1),('340-1174R-US2','340-1174R-US2',24,1),('340-1413L-UC','340-1413L-UC',51,1),('340-1920L-AC','340-1920L-AC',172,1),('340-1930R-AC','340-1930R-AC',7,1),('340-1940L-AS','340-1940L-AS',139,1),('340-2513L-UD','340-2513L-UD',130,1),('341-1118R-AC','341-1118R-AC',176,1),('341-1124R-USH3','341-1124R-USH3',55,1),('341-1146L-AC2','341-1146L-AC2',111,1),('341-1148R-AC2','341-1148R-AC2',70,1),('341-1154L-AS2','341-1154L-AS2',109,1),('341-1910L-US','341-1910L-US',3,1),('341-2015L-AC','341-2015L-AC',146,1),('341-2507L-UD','341-2507L-UD',51,1),('341-2507R-UD','341-2507R-UD',51,1),('341-5401R9CBVM','341-5401R9CBVM',8,2),('344-1115L-USH2','344-1115L-USH2',90,1),('344-1120R-AS2Y','344-1120R-AS2Y',33,1),('344-1139RMUSHM2','344-1139RMUSHM2',21,1),('344-1146R-AS2','344-1146R-AS2',29,1),('344-1149RMUSHM2','344-1149RMUSHM2',12,1),('344-1153LMUCHM2','344-1153LMUCHM2',51,1),('344-1171LMUSM2','344-1171LMUSM2',160,1),('344-1171RMUSM2','344-1171RMUSM2',96,1),('344-1171RMUSM2','344-1171RMUSM2',160,1),('344-1417L-UC','344-1417L-UC',90,1),('344-1427L-UC','344-1427L-UC',65,1),('344-1427R-UC','344-1427R-UC',65,1),('344-1427R-US','344-1427R-US',64,1),('344-1429L-US','344-1429L-US',65,1),('344-1429R-US','344-1429R-US',65,1),('344-1430L-UC','344-1430L-UC',51,1),('344-1504R-UQ','344-1504R-UQ',25,1),('344-1506L-AS2','344-1506L-AS2',89,1),('344-2009L-AC','344-2009L-AC',11,1),('344-55001-200','344-55001-200',97,1),('344-55012-100','344-55012-100',105,1),('346-1110RMUSHN2','346-1110RMUSHN2',3,1),('346-1113L-AS2','346-1113L-AS2',57,1),('346-1124RMUCHM2','346-1124RMUCHM2',16,1),('346-4004R-ASN','346-4004R-ASN',102,1),('347-1101R-AC','347-1101R-AC',86,1),('348-1107RMACM6','348-1107RMACM6',77,1),('348-1407R-AC','348-1407R-AC',29,1),('348-55001-133','348-55001-133',16,1),('3521','3521',85,1),('364174','364174',30,1),('373-1510R-AS2','373-1510R-AS2',47,1),('373-55003-000','373-55003-000',29,1),('3767','3767',36,1),('382-1104R-ACC','382-1104R-ACC',120,1),('382-1106L-AS-C','382-1106L-AS-C',135,1),('382-1106R-AS-C','382-1106R-AS-C',138,1),('382-1106R-AS-Y','382-1106R-AS-Y',3,1),('382-4001L-AC','382-4001L-AC',89,1),('3935','3935',71,1),('3936','3936',71,1),('3971','3971',18,2),('40104','40104',80,1),('4232','4232',25,1),('4389948AA','4389948AA',51,1),('440-1310R-AQ','440-1310R-AQ',77,1),('440-1611L-AQ','440-1611L-AQ',91,1),('440-1611R-AQ','440-1611R-AQ',89,1),('440-19A1L-AC','440-19A1L-AC',111,1),('440-19A1L-AC','440-19A1L-AC',123,1),('440-19A3L-AC','440-19A3L-AC',3,1),('440-2509R-UD','440-2509R-UD',22,1),('441-1317L-US','441-1317L-US',12,1),('441-133L-US','441-133L-US',151,1),('441-19G3L-AF','441-19G3L-AF',12,1),('441-2107N-AQ','441-2107N-AQ',131,1),('441-2107N-AQ','441-2107N-AQ',132,1),('441-2908R-US2','441-2908R-US2',131,1),('444-1319R-UQ','444-1319R-UQ',49,1),('444-1321R-UQ','444-1321R-UQ',3,1),('444-1321R-UQ','444-1321R-UQ',8,1),('444-1336L-UC','444-1336L-UC',164,1),('444-1944R-AS','444-1944R-AS',3,1),('444-2014R-AQ','444-2014R-AQ',168,1),('444-2029R-AQ','444-2029R-AQ',8,1),('444-2030R-AQ','444-2030R-AQ',72,1),('444-2045L-ACN','444-2045L-ACN',61,1),('444-2513R-UD','444-2513R-UD',34,1),('446-1604R-AQ','446-1604R-AQ',3,1),('446-1604R-UQ','446-1604R-UQ',3,1),('446-1604R-UQ','446-1604R-UQ',143,1),('446-2003L-AQ','446-2003L-AQ',160,1),('446-2003R-AQ','446-2003R-AQ',61,1),('446-2011L-AC','446-2011L-AC',97,1),('446-2510R-UD','446-2510R-UD',8,2),('446-2511-UD','446-2511-UD',24,1),('446-2511L-UD','446-2511L-UD',70,1),('446-2511L-UD','446-2511L-UD',102,1),('4951','4951',25,1),('50','50',16,1),('5230541','5230541',10,1),('523541','523541',155,1),('5260011','5260011',99,1),('5380232','5380232',80,1),('54-316-1139N','54-316-1139N',12,1),('551-2008L-AC','551-2008L-AC',131,1),('551-2022R-AQ','551-2022R-AQ',131,1),('555312-11BNL-ACD2','555312-11BNL-ACD2',30,1),('5796','5796',85,3),('5797','5797',85,1),('600230','600230',20,1),('621790','621790',51,1),('622740','622740',117,1),('624130','624130',16,1),('625310','625310',93,1),('625430','625430',29,1),('630660','630660',141,1),('630730','630730',57,1),('630730','630730',89,1),('6308901','630890 1',32,1),('630990','630990',97,2),('660080','660080',80,1),('660086','660086',92,2),('660214','660214',94,1),('660344','660344',95,1),('660423','660423',24,1),('660525','660525',92,1),('660596','660596',32,1),('660653','660653',123,1),('660657','660657',58,1),('660705','660705',165,1),('6733','6733',52,1),('6740','6740',85,1),('6743-1','6743-1',64,1),('6744-1','6744-1',64,1),('700086','700086',61,1),('700086','700086',62,1),('700089','700089',70,1),('700101','700101',80,1),('700258','700258',7,1),('700303','700303',86,1),('7710652','7710652',97,1),('7710872','7710872',151,1),('773-2005L-AQ','773-2005L-AQ',172,1),('7787-2','7787-2',157,1),('882-1405R-AC','882-1405R-AC',36,1),('882-2003N-AQ','882-2003N-AQ',57,1),('882-2005L-AQ','882-2005L-AQ',3,1),('882-2007R-AQ','882-2007R-AQ',47,1),('90000411','9000041 1',132,1),('96063','96063',97,1),('97066','97066',108,1),('97128','97128',34,1),('97159','97159',2,1),('97194','97194',164,1),('97207','97207',164,1),('97326','97326',20,1),('97331','97331',138,1),('97343','97343',138,1),('97353','97353',168,1),('97384','97384',7,1),('9818','9818',57,1),('9819','9819',57,1),('A016102','A016102',50,1),('A1R121078','A1R121078',146,1),('A30-1301R-AS','A30-1301R-AS',91,1),('A32-1901-XAS','A32-1901-XAS',123,1),('A32-1901LXAS','A32-1901LXAS',144,1),('A32-1901LXAS','A32-1901LXAS',76,3),('A32-1901LXAS','A32-1901LXAS',176,1),('A32-1901RXAS','A32-1901RXAS',76,1),('A32-1923R-AC','A32-1923R-AC',12,1),('A33-1110L-UC2','A33-1110L-UC2',69,1),('A33-1110L-UC2','A33-1110L-UC2',169,1),('A33-1110L-UCN2','A33-1110L-UCN2',52,1),('A33-1110R-UC2','A33-1110R-UC2',169,1),('A33-1186L-ACN1','A33-1186L-ACN1',112,1),('A34-1123R-AS','A34-1123R-AS',131,1),('A34-1923R-AC','A34-1923R-AC',35,1),('A34-1923R-AC','A34-1923R-AC',57,1),('A34-1923R-AC','A34-1923R-AC',59,1),('A34-1928L-AC1','A34-1928L-AC1',63,1),('A34-1928L-AS2','A34-1928L-AS2',35,1),('A34-1928L-AS2','A34-1928L-AS2',104,1),('A34-1928R-AS2','A34-1928R-AS2',7,1),('A35-5401L3EFH2','A35-5401L3EFH2',15,1),('A35-5401R3EFH1','A35-5401R3EFH1',116,1),('AC1217105C','AC1217105C',46,1),('AC1288121','AC1288121',29,1),('AC1320129','AC1320129',2,1),('AC1350111','AC1350111',105,1),('AC1551106','AC1551106',151,1),('AC2520121','AC2520121',106,1),('ARBB013102','ARBB013102',159,1),('ARBC011101','ARBC011101',119,1),('ARBC011101','ARBC011101',64,1);
INSERT INTO _plan (part_key,part_display,location_pk,qty) VALUES ('ARBC011101','ARBC011101',46,1),('ARBC011102','ARBC011102',112,1),('ARBC011102','ARBC011102',30,1),('ARBC011102','ARBC011102',167,1),('ARBC011103','ARBC011103',169,1),('ARBC070104','ARBC070104',68,1),('ARBC311305','ARBC311305',139,1),('ARBC491360','ARBC491360',111,1),('ARBC761101','ARBC761101',146,1),('ARBC761102','ARBC761102',84,2),('ARBC761103','ARBC761103',104,1),('ARBC761103','ARBC761103',84,1),('ARBD462122','ARBD462122',51,1),('ARBH013101','ARBH013101',147,1),('ARBH462122','ARBH462122',89,1),('ARBJ580703','ARBJ580703',36,1),('ARBJ580703','ARBJ580703',37,1),('ARBM107508','ARBM107508',147,1),('ARBM314102','ARBM314102',97,1),('ARBS310101','ARBS310101',176,1),('ARBS310102','ARBS310102',176,1),('AT013-U000L','AT013-U000L',173,1),('AT013-U000R','AT013-U000R',173,1),('AU1010ER','AU1010ER',164,1),('AU1038164','AU1038164',57,1),('AU1039118','AU1039118',24,1),('AU1039150','AU1039150',54,1),('AU1088120','AU1088120',119,1),('AU1112GL','AU1112GL',89,1),('AU1290101','AU1290101',22,1),('AU18EL','AU18EL',47,1),('AU2802109','AU2802109',128,1),('AU38GR','AU38GR',131,1),('B222112','B222112',145,1),('B222141','B222141',23,1),('B222144','B222144',65,1),('B222144','B222144',159,1),('B461703','B461703',63,1),('BK34ER-S','BK34ER-S',159,1),('BM023-B000L','BM023-B000L',56,2),('BM06GL','BM06GL',37,1),('BM083-B001RNF','BM083-B001RNF',47,1),('BM083-B001RNF','BM083-B001RNF',48,1),('BM1043111','BM1043111',135,1),('BM1117100','BM1117100',137,1),('BM1129107','BM1129107',85,1),('BM1144125','BM1144125',99,1),('BM1144136','BM1144136',7,1),('BM1185106','BM1185106',109,1),('BM1195115','BM1195115',95,1),('BM1200128','BM1200128',34,1),('BM1200235','BM1200235',22,1),('BM1351120','BM1351120',52,1),('BM182-B000L','BM182-B000L',164,1),('BM19GL','BM19GL',176,1),('BM2503111','BM2503111',150,1),('BM2511100','BM2511100',160,1),('BM2518109','BM2518109',87,1),('BM2520104','BM2520104',147,1),('BM2553133','BM2553133',85,1),('BM30GR','BM30GR',25,1),('BM30GR','BM30GR',63,1),('BM30GR','BM30GR',101,1),('BM36GR','BM36GR',8,1),('BM36GR','BM36GR',20,1),('BM59ER','BM59ER',64,1),('BZ0444000','BZ0444000',123,1),('BZ115-B101L','BZ115-B101L',116,1),('BZ115-B101L','BZ115-B101L',72,1),('BZ115-B101R','BZ115-B101R',116,1),('BZ115-B101R','BZ115-B101R',100,1),('BZ115-B101R','BZ115-B101R',171,1),('BZ120-U200R','BZ120-U200R',107,1),('BZ120-U200R','BZ120-U200R',68,2),('BZ120-U200R','BZ120-U200R',71,1),('BZ45108LR','BZ45108LR',57,1),('C011101Q','C011101Q',46,1),('C013115','C013115',90,1),('C013116','C013116',90,1),('C013118','C013118',160,1),('C013125','C013125',112,1),('C013125','C013125',95,1),('C013126Q','C013126Q',64,1),('C013130','C013130',25,1),('C013135','C013135',147,1),('C013146','C013146',99,1),('C070155Q','C070155Q',31,1),('C100145','C100145',7,1),('C107908','C107908',88,2),('C160312','C160312',58,1),('C160312','C160312',46,2),('C160312','C160312',159,1),('C160329','C160329',39,1),('C222103','C222103',96,1),('C222174','C222174',104,1),('C462121','C462121',169,1),('C462158','C462158',113,1),('C462945','C462945',54,1),('C462945','C462945',58,1),('C462945','C462945',63,1),('C462945','C462945',98,1),('C462945','C462945',84,1),('C462946','C462946',7,1),('C462946','C462946',15,2),('C462946','C462946',19,1),('C462946','C462946',122,1),('C462946','C462946',146,1),('C462946','C462946',147,1),('C462946','C462946',160,1),('C471301','C471301',33,1),('C491309','C491309',135,1),('C762704','C762704',3,1),('CH1037112','CH1037112',138,1),('CH1042109','CH1042109',136,1),('CH1063125','CH1063125',176,1),('CH1068134','CH1068134',31,1),('CH1068140','CH1068140',142,1),('CH1191113','CH1191113',104,1),('CH1200374C','CH1200374C',119,1),('CH1200388C','CH1200388C',104,1),('CH1206113','CH1206113',1,1),('CH1206113','CH1206113',77,1),('CH1210126','CH1210126',56,1),('CH1210129','CH1210129',91,1),('CH1210132','CH1210132',99,1),('CH1236133','CH1236133',106,1),('CH1248179','CH1248179',23,1),('CH1310117','CH1310117',67,1),('CH1311164','CH1311164',122,1),('CH1320388','CH1320388',36,1),('CH1320399','CH1320399',84,1),('CH1321373','CH1321373',50,1),('CH1321403','CH1321403',157,1),('CH1431281','CH1431281',130,1),('CH1520119','CH1520119',8,1),('CH1520142','CH1520142',51,1),('CH1790112','CH1790112',7,1),('CH2502174','CH2502174',134,1),('CH2502217C','CH2502217C',59,1),('CH2502226C','CH2502226C',3,1),('CH2503308C','CH2503308C',90,1),('CH2503334','CH2503334',12,1),('CH2503926','CH2503926',93,1),('CH2509108','CH2509108',100,1),('CH251937','CH251937',129,1),('CH2521128','CH2521128',72,1),('CH2531103','CH2531103',71,1),('CH2551123','CH2551123',52,1),('CH2592163V','CH2592163V',96,1),('CH2801209C','CH2801209C',12,1),('CH281131C','CH281131C',143,1),('CH2819124C','CH2819124C',8,1),('CH29ER','CH29ER',47,1),('CH29ER','CH29ER',54,1),('CH3710377','CH3710377',114,1),('CH40EL','CH40EL',93,1),('CH67EL','CH67EL',207,1),('CHCHG-MR2-11-P1R','CHCHG-MR2-11-P1R',120,1),('CHPUP-MR2-94-X2R','CHPUP-MR2-94-X2R',139,1),('CHWRA-MR2-87-P1L','CHWRA-MR2-87-P1L',95,1),('CS053-B001R','CS053-B001R',77,1),('CS057-B001L','CS057-B001L',127,1),('CS057-B001L','CS057-B001L',167,1),('CS059-U000L','CS059-U000L',64,1),('CS099-U000L','CS099-U000L',64,1),('CS099-U000R','CS099-U000R',64,1),('CS104-U000R','CS104-U000R',71,1),('CS142-U000R','CS142-U000R',48,1),('CS235-B001R','CS235-B001R',138,1),('CS237-B001L','CS237-B001L',15,1),('CS278-B001R','CS278-B001R',146,1),('CS307-U0002-SD3V','CS307-U0002-SD3V',48,1),('CS317-U000L','CS317-U000L',52,1),('CS319-U000L','CS319-U000L',131,1),('CS319-U000R','CS319-U000R',56,2),('CS339-B001LCA','CS339-B001LCA',158,1),('CS344-B000R','CS344-B000R',95,1),('CS355-B0000','CS355-B0000',98,1),('CS357-U0100','CS357-U0100',37,2),('CS359-A001L-D3S','CS359-A001L-D3S',88,1),('CS369-B000L','CS369-B000L',107,1),('CV04148BAQ','CV04148BAQ',105,1),('CV126EL','CV126EL',20,1),('CV19EL','CV19EL',113,1),('CV31EL-S','CV31EL-S',116,1),('CV31ER-S','CV31ER-S',25,1),('CV41EL','CV41EL',165,2),('CV41ER','CV41ER',165,1),('CV41ER','CV41ER',175,1),('CV45073AL','CV45073AL',64,1),('CV84EL','CV84EL',165,3),('CV84EL','CV84EL',175,3),('CV9310000-1ROC','CV9310000-1ROC',171,1),('CV9R121RQ','CV9R121RQ',28,1),('D013106','D013106',176,1),('D013138','D013138',81,1),('D013155','D013155',25,1),('D013156','D013156',81,1),('D013157','D013157',53,1),('D013158','D013158',81,1),('D072703','D072703',161,1),('D100102Q','D100102Q',40,1),('D220137','D220137',84,1),('DG02GR','DG02GR',74,1),('DG03EL-S','DG03EL-S',6,1),('DG14120','DG14120',19,1),('DG14121','DG14121',50,1),('DG143CR-S','DG143CR-S',69,1),('DG144CR-S','DG144CR-S',2,1),('DG164EL-S','DG164EL-S',123,1),('DG174GR','DG174GR',7,1),('DG44054AR','DG44054AR',116,1),('DG77ER','DG77ER',91,1),('DS327-B000L','DS327-B000L',72,1),('DS506-B000L','DS506-B000L',22,1),('DS630-B001L','DS630-B001L',24,1),('DS630-B001R','DS630-B001R',24,1),('DS671-B001L','DS671-B001L',108,1),('DS671-B001L','DS671-B001L',47,1),('DS671-B011L','DS671-B011L',72,1),('DS726-B000R','DS726-B000R',130,1),('DS755-B001L','DS755-B001L',66,1),('DS775-B000L','DS775-B000L',156,1),('DS780-B101L','DS780-B101L',12,1),('DS780-B101R','DS780-B101R',29,1),('F013175','F013175',40,1),('F100133','F100133',156,1),('F107565','F107565',12,1),('F107565','F107565',64,1),('F130301','F130301',168,2),('F220180','F220180',135,1),('F764902','F764902',51,1),('FD098-228A-R','FD098-228A-R',115,1),('FD09ER','FD09ER',32,1),('FD147ER','FD147ER',96,1),('FD177ER','FD177ER',70,1),('FD194ER','FD194ER',90,1),('FD204ER-S','FD204ER-S',139,1),('FD274ER','FD274ER',22,1),('FD27EL','FD27EL',147,1),('FD27ER','FD27ER',147,1),('FD323R','FD323R',36,1),('FD370ER-S','FD370ER-S',98,1),('FD383GR','FD383GR',140,1),('FD387ER','FD387ER',131,1),('FD390L','FD390L',57,1),('FD397ER-S','FD397ER-S',131,1),('FD398GL','FD398GL',72,1),('FD399GL','FD399GL',119,1),('FD399GR','FD399GR',119,1),('FD39CR','FD39CR',32,1),('FD400GL','FD400GL',20,1),('FD400GL','FD400GL',98,1),('FD459GL','FD459GL',57,1),('FD534GR','FD534GR',101,1),('FD547GL','FD547GL',49,1),('FD89PER','FD89PER',123,1),('FI2003100','FI2003100',115,1),('FO1039187','FO1039187',34,1),('FO1066210','FO1066210',151,1),('FO1067180','FO1067180',160,1),('FO1202106','FO1202106',96,1),('FO1248185','FO1248185',116,1),('FO1249133','FO1249133',136,1),('FO1250127','FO1250127',119,1),('FO1284133','FO1284133',142,1),('FO13141','FO13141',147,1),('FO1320152','FO1320152',40,1),('FO1320158','FO1320158',134,1),('FO1320211','FO1320211',12,1),('FO1320321','FO1320321',169,1),('FO1320675','FO1320675',96,1),('FO1321125','FO1321125',86,1),('FO1321188','FO1321188',127,1),('FO1321230','FO1321230',139,1),('FO1520117','FO1520117',12,1),('FO1521133','FO1521133',127,1),('FO152116','FO152116',119,1),('FO2331139','FO2331139',176,1),('FO2503110','FO2503110',109,1),('FO2521180','FO2521180',36,1),('FO2592197','FO2592197',158,1),('FO2592220','FO2592220',36,1),('FO2593198','FO2593198',8,1),('FO2593215','FO2593215',151,1),('FO2600101','FO2600101',169,1),('FO2803103C','FO2803103C',12,1),('FO2803103C','FO2803103C',126,1),('FO2803199','FO2803199',93,1),('FO2804111','FO2804111',126,1),('FO3030237','FO3030237',37,1),('FO3126135','FO3126135',3,1),('FOPUP-MR2-97-P2L','FOPUP-MR2-97-P2L',134,1),('FR085-BN01L','FR085-BN01L',107,1),('FR243-U000R','FR243-U000R',69,5),('FR278-U100L','FR278-U100L',107,1),('FR335-B001R','FR335-B001R',172,1),('FR345-B001L','FR345-B001L',123,1),('FR372-B001R','FR372-B001R',68,1),('FR383-B000L','FR383-B000L',108,1),('FR391-U000R','FR391-U000R',108,1),('FR391-U000R','FR391-U000R',163,1),('FR417-U100L','FR417-U100L',57,1),('FR44-B000R','FR44-B000R',69,1),('FR444-B000L','FR444-B000L',118,2),('FR444-B000L','FR444-B000L',70,1),('FR444-B000L','FR444-B000L',71,1),('FR444-B000L','FR444-B000L',163,1),('FR444-B000L','FR444-B000L',164,1),('FR444-B000R','FR444-B000R',69,1),('FR444-B000R','FR444-B000R',70,2),('FR444-B000R','FR444-B000R',176,2),('FR452-B000R','FR452-B000R',168,1),('FR468-B000R','FR468-B000R',50,1),('FR538-U000L','FR538-U000L',80,1),('FR539-H000L','FR539-H000L',147,1),('FR539-U000L','FR539-U000L',72,1),('FR539-U000R','FR539-U000R',56,1),('FR559-B000L','FR559-B000L',172,1),('FR560-BOA12-5D6V','FR560-BOA12-5D6V',18,1),('FR577-A0A12-SD4V','FR577-A0A12-SD4V',7,1),('FR641-B001R','FR641-B001R',109,1),('GA01730039','GA01730039',176,1),('GB47170006','GB47170006',172,1),('GD07580001','GD07580001',157,1),('GFD548GL','GFD548GL',51,1),('GH01590098','GH01590098',7,1),('GH10770029','GH10770029',112,1),('GH76350001','GH76350001',22,1),('GM01310003Q','GM01310003Q',61,1),('GM01310004Q','GM01310004Q',61,1),('GM014-U000R','GM014-U000R',90,1),('GM01730085','GM01730085',100,1),('GM04GL','GM04GL',51,1),('GM04GL','GM04GL',57,2),('GM096-U000L','GM096-U000L',51,1),('GM1004146','GM1004146',97,1),('GM1006698','GM1006698',16,1),('GM1038176','GM1038176',89,1),('GM1038272','GM1038272',65,1),('GM1039217','GM1039217',118,1),('GM1058192','GM1058192',123,2),('GM1066122','GM1066122',164,1),('GM1066198','GM1066198',11,1),('GM1066224','GM1066224',70,1),('GM106EL','GM106EL',176,1),('GM107-U000R','GM107-U000R',92,1),('GM110-U000R','GM110-U000R',155,1),('GM111-B001L','GM111-B001L',3,1),('GM111-B001R','GM111-B001R',3,1),('GM114EL','GM114EL',168,1),('GM1170249C','GM1170249C',31,1),('GM1184104','GM1184104',116,1),('GM1200712','GM1200712',79,1),('GM1248121','GM1248121',145,1),('GM1248183','GM1248183',122,1),('GM1249179','GM1249179',60,1),('GM1290257','GM1290257',104,1),('GM130460','GM130460',148,1),('GM1320339','GM1320339',169,2),('GM1320342','GM1320342',12,1),('GM1320425','GM1320425',90,1),('GM1321122','GM1321122',168,5),('GM1321339','GM1321339',167,2),('GM1321339','GM1321339',173,1),('GM1321395','GM1321395',104,1),('GM1321400','GM1321400',161,1),('GM1321460','GM1321460',157,1),('GM1321497','GM1321497',168,3),('GM1350125','GM1350125',151,1),('GM1350155','GM1350155',50,1),('GM1350165','GM1350165',88,1),('GM1353165','GM1353165',136,1),('GM141CL','GM141CL',169,1),('GM1513112','GM1513112',29,1),('GM154EL','GM154EL',3,1),('GM156EL-S','GM156EL-S',12,1),('GM174GR','GM174GR',57,1),('GM179GR','GM179GR',65,1),('GM190CL','GM190CL',143,1),('GM1915133','GM1915133',52,1),('GM204GR','GM204GR',37,1),('GM204GR','GM204GR',127,1),('GM213ER','GM213ER',123,1),('GM219ER','GM219ER',143,1),('GM221EL','GM221EL',164,1),('GM221ER','GM221ER',20,1),('GM2225248','GM2225248',113,1),('GM222L','GM222L',25,1),('GM223-U000L','GM223-U000L',116,1),('GM237EL-S','GM237EL-S',122,1),('GM24ER','GM24ER',172,1),('GM2502294C','GM2502294C',3,1),('GM2502394','GM2502394',48,1),('GM2502394','GM2502394',69,1),('GM2502459','GM2502459',25,1),('GM2503213C','GM2503213C',12,1),('GM2503232C','GM2503232C',3,1),('GM2503232C','GM2503232C',150,1),('GM2503345C','GM2503345C',133,1);
INSERT INTO _plan (part_key,part_display,location_pk,qty) VALUES ('GM2503390','GM2503390',108,1),('GM2503453','GM2503453',144,1),('GM2503453','GM2503453',171,2),('GM2505014','GM2505014',158,1),('GM251104','GM251104',71,1),('GM2522124','GM2522124',8,1),('GM2531105','GM2531105',35,1),('GM2531122C','GM2531122C',12,1),('GM2592127C','GM2592127C',134,1),('GM2593170C','GM2593170C',143,1),('GM277GL','GM277GL',63,1),('GM2800202','GM2800202',106,1),('GM2800268','GM2800268',30,1),('GM2800270','GM2800270',3,1),('GM2803104','GM2803104',75,1),('GM2804124C','GM2804124C',12,1),('GM3010406','GM3010406',12,1),('GM301532','GM301532',130,1),('GM306-U000R','GM306-U000R',52,1),('GM314-U000R','GM314-U000R',3,1),('GM387-B001R','GM387-B001R',3,1),('GM510-B000L','GM510-B000L',68,1),('GM516-B000R','GM516-B000R',16,1),('GM60EL','GM60EL',97,1),('GM631-B0Q0A-SD5V','GM631-B0Q0A-SD5V',171,1),('GM631-B0QDA-SD5V','GM631-B0QDA-SD5V',165,1),('GM631-B1Q0A-SD5V','GM631-B1Q0A-SD5V',108,1),('GM631-B1Q0A-SD5V','GM631-B1Q0A-SD5V',18,1),('GM631-B1Q0A-SD5V','GM631-B1Q0A-SD5V',177,1),('GM631-BOQOA-SD5V','GM631-BOQOA-SD5V',150,1),('GM631-BOQOA-SD5V','GM631-BOQOA-SD5V',159,1),('GMAVA-DIHF-07-BKCR','GMAVA-DIHF-07-BKCR',89,1),('GMEQO-MR2-10-P2R','GMEQO-MR2-10-P2R',99,1),('GMSIL-MR2-03-D1R','GMSIL-MR2-03-D1R',25,1),('GMTBL-WRP-02-BRR','GMTBL-WRP-02-BRR',18,1),('GMTER-MR2-15-P1L','GMTER-MR2-15-P1L',48,1),('GPD2311692','GPD2311692',112,1),('GT10770033','GT10770033',3,1),('GT10770033','GT10770033',53,1),('GT10770033','GT10770033',61,1),('GT10770034','GT10770034',123,1),('H013139','H013139',90,1),('H013139Q','H013139Q',176,1),('H013140','H013140',90,1),('H013140Q','H013140Q',176,1),('H013501','H013501',20,1),('H160908','H160908',151,1),('H190907','H190907',160,1),('H222104','H222104',47,1),('H222152','H222152',91,1),('H222162','H222162',138,1),('H222166','H222166',164,1),('H222181','H222181',4,1),('H222182','H222182',112,1),('H462163','H462163',35,1),('H462164','H462164',35,1),('H462907','H462907',151,1),('H462915','H462915',144,1),('H491711','H491711',56,1),('HD107-B000R','HD107-B000R',131,1),('HD194-U000R','HD194-U000R',71,1),('HD231-U000R','HD231-U000R',69,1),('HD307-A001L','HD307-A001L',107,1),('HD35R','HD35R',7,1),('HD35R','HD35R',25,1),('HD427-B001L','HD427-B001L',24,1),('HD478-U000L','HD478-U000L',135,1),('HD609-B000L','HD609-B000L',91,1),('HD621-B101RCA','HD621-B101RCA',72,1),('HD634-U000R','HD634-U000R',51,1),('HD660-B000R','HD660-B000R',54,1),('HD730-B000R','HD730-B000R',30,1),('HD744-B101R','HD744-B101R',157,1),('HD760-B100L','HD760-B100L',168,1),('HD79GR','HD79GR',116,1),('HD82GL','HD82GL',57,1),('HD82GL','HD82GL',164,1),('HD82GR','HD82GR',31,1),('HD82GR','HD82GR',55,1),('HD82GR','HD82GR',164,1),('HD84ER','HD84ER',77,1),('HO1032103','HO1032103',20,1),('HO1033103','HO1033103',20,1),('HO1048158','HO1048158',121,1),('HO1066118','HO1066118',138,1),('HO1066118C','HO1066118C',35,1),('HO1067118','HO1067118',138,1),('HO1146104','HO1146104',176,1),('HO1213118','HO1213118',123,1),('HO1213118','HO1213118',94,1),('HO1213119','HO1213119',76,1),('HO1228168','HO1228168',84,1),('HO1236146','HO1236146',68,1),('HO1236147','HO1236147',95,1),('HO131269','HO131269',61,1),('HO13135','HO13135',22,1),('HO1320123','HO1320123',97,1),('HO1320123','HO1320123',169,1),('HO1321361','HO1321361',57,1),('HO1324132','HO1324132',116,1),('HO1352135','HO1352135',138,1),('HO138ER','HO138ER',111,1),('HO1521114','HO1521114',8,1),('HO1790102','HO1790102',104,1),('HO21L','HO21L',157,1),('HO22GR','HO22GR',90,1),('HO2500162','HO2500162',84,1),('HO2503167','HO2503167',20,1),('HO2508121','HO2508121',18,2),('HO2531116','HO2531116',68,1),('HO2550103','HO2550103',70,1),('HO2592124','HO2592124',51,1),('HO2592138C','HO2592138C',93,1),('HO2603103','HO2603103',160,1),('HO2800154C','HO2800154C',12,1),('HO57EL','HO57EL',136,1),('HO71EL-S1','HO71EL-S1',59,1),('HOCVC-MR1-96-P2R','HOCVC-MR1-96-P2R',97,1),('HOCVC-MR2-12-P1L','HOCVC-MR2-12-P1L',116,1),('HOODY-CAM-08-R','HOODY-CAM-08-R',98,1),('HY025-B001L','HY025-B001L',156,1),('HY1038141','HY1038141',58,1),('HY1039130','HY1039130',11,1),('HY1039141','HY1039141',58,1),('HY1044108','HY1044108',134,1),('HY1047119','HY1047119',31,1),('HY109EL-S','HY109EL-S',128,1),('HY110EL-S','HY110EL-S',86,1),('HY1166134','HY1166134',96,2),('HY1210112','HY1210112',63,1),('HY1216103','HY1216103',121,1),('HY1228207','HY1228207',67,1),('HY1236162','HY1236162',77,1),('HY1249172C','HY1249172C',38,1),('HY125-B010L','HY125-B010L',2,1),('HY125EL','HY125EL',16,1),('HY128EL-S','HY128EL-S',50,1),('HY1320154','HY1320154',168,5),('HY1320204','HY1320204',165,1),('HY1321174','HY1321174',16,1),('HY1321189','HY1321189',59,1),('HY1321354','HY1321354',136,1),('HY1350134','HY1350134',110,1),('HY1356105','HY1356105',86,1),('HY1521106','HY1521106',110,1),('HY23L','HY23L',64,2),('HY23L','HY23L',152,1),('HY23L','HY23L',86,1),('HY23L','HY23L',176,1),('HY2502103','HY2502103',112,1),('HY2502133C','HY2502133C',8,1),('HY2503226','HY2503226',4,1),('HY2592136','HY2592136',46,1),('HY2801128','HY2801128',80,1),('HY2883103','HY2883103',134,1),('HY32ER','HY32ER',143,1),('HY44EL','HY44EL',2,1),('HY74EL-S','HY74EL-S',54,1),('I462905','I462905',164,1),('IN1248116','IN1248116',122,1),('IN21EL','IN21EL',102,1),('IN29EL','IN29EL',165,1),('IN3010114','IN3010114',88,1),('J222117','J222117',23,1),('J42110','J42110',115,1),('J462111','J462111',57,1),('J462112','J462112',57,1),('J553903','J553903',65,1),('JA1047104','JA1047104',152,1),('JA47170002','JA47170002',51,1),('JAC23EL-S','JAC23EL-S',94,1),('JAU04EL-S','JAU04EL-S',139,1),('JAU06ER-S','JAU06ER-S',60,1),('JAU09EL-S','JAU09EL-S',139,1),('JBM61EL-S','JBM61EL-S',30,1),('JBM61EL-S','JBM61EL-S',138,1),('JC47170010','JC47170010',63,1),('JC47170013','JC47170013',95,1),('JCV123EL-S','JCV123EL-S',64,1),('JCV126L','JCV126L',146,1),('JCV126R','JCV126R',160,1),('JCV127R','JCV127R',30,1),('JCV135EL','JCV135EL',100,1),('JCV144ER','JCV144ER',135,1),('JCV30ER','JCV30ER',135,1),('JCV31EL-S','JCV31EL-S',25,1),('JCV31ER-S','JCV31ER-S',60,1),('JCV37ER-S','JCV37ER-S',4,1),('JCV41EL','JCV41EL',122,1),('JCV41ER','JCV41ER',102,1),('JCV41ER-S','JCV41ER-S',169,1),('JCV44EL','JCV44EL',98,1),('JCV85R','JCV85R',160,1),('JD07070001','JD07070001',132,1),('JDG03EL-S','JDG03EL-S',24,1),('JDG143CL-SM','JDG143CL-SM',139,1),('JDG152ER-S','JDG152ER-S',159,1),('JDG158EL-S','JDG158EL-S',7,1),('JDG158EL-S','JDG158EL-S',30,1),('JDG158EL-S','JDG158EL-S',47,1),('JDG161EL-S','JDG161EL-S',160,1),('JDG162CL-S','JDG162CL-S',33,1),('JDG162CL-S','JDG162CL-S',74,1),('JDG44L','JDG44L',79,1),('JDG44R','JDG44R',91,1),('JDG84EL','JDG84EL',88,1),('JDG84ER','JDG84ER',160,1),('JDG97L','JDG97L',15,1),('JDG97R','JDG97R',57,1),('JDG97R','JDG97R',77,1),('JF311320','JF311320',98,1),('JF47170010','JF47170010',101,1),('JF47170011','JF47170011',90,1),('JF47170018','JF47170018',34,1),('JF47170018','JF47170018',168,1),('JF47170020','JF47170020',99,1),('JFD101R','JFD101R',111,1),('JFD11L','JFD11L',159,1),('JFD147ER','JFD147ER',54,1),('JFD269EL','JFD269EL',147,1),('JFD275EL-S','JFD275EL-S',157,1),('JFD275ER-S','JFD275ER-S',100,1),('JFD360ER-S','JFD360ER-S',138,1),('JFD384ER-S','JFD384ER-S',70,1),('JFD390R','JFD390R',31,1),('JFD418EL-S','JFD418EL-S',86,1),('JFD79EL','JFD79EL',54,1),('JFD79EL','JFD79EL',169,1),('JFD79ER','JFD79ER',54,1),('JG191802','JG191802',51,1),('JGM108EL','JGM108EL',172,1),('JGM146EL-S','JGM146EL-S',57,1),('JGM147CR-S','JGM147CR-S',146,1),('JGM156ER-S','JGM156ER-S',32,1),('JGM178CL-S','JGM178CL-S',77,1),('JGM210ER','JGM210ER',143,1),('JGM210ER-S','JGM210ER-S',55,1),('JGM221ER','JGM221ER',29,1),('JGM223EL','JGM223EL',51,1),('JGM229EL','JGM229EL',20,1),('JGM229EL','JGM229EL',119,1),('JH01590001','JH01590001',7,1),('JH01590001','JH01590001',63,1),('JH01590001','JH01590001',160,1),('JH01590001','JH01590001',168,1),('JH462901','JH462901',138,1),('JH462902','JH462902',138,1),('JH76350015','JH76350015',3,1),('JHD51ER-S','JHD51ER-S',135,1),('JHD60EL','JHD60EL',94,1),('JHD65EL','JHD65EL',60,1),('JHD65ER','JHD65ER',7,1),('JHD65ER','JHD65ER',112,1),('JHD65ER','JHD65ER',62,2),('JHD80ER-S','JHD80ER-S',25,1),('JHD82ER','JHD82ER',89,1),('JHO02EL-FH','JHO02EL-FH',135,1),('JHO05EL','JHO05EL',172,1),('JHO105EL','JHO105EL',64,1),('JHO105EL','JHO105EL',102,1),('JHO113EL-S','JHO113EL-S',32,1),('JHO114EL-S','JHO114EL-S',138,1),('JHO142GL','JHO142GL',51,1),('JHO144EL','JHO144EL',64,1),('JHO48EL','JHO48EL',88,1),('JHO74EL-S','JHO74EL-S',112,1),('JHO74EL-S','JHO74EL-S',25,1),('JHO92EL','JHO92EL',3,1),('JHO97EL-S','JHO97EL-S',30,1),('JHO97EL-S','JHO97EL-S',60,1),('JHY126ER-S','JHY126ER-S',35,1),('JHY128ER-S','JHY128ER-S',54,1),('JHY140ER-S','JHY140ER-S',62,1),('JHY61ER','JHY61ER',56,1),('JHY71EL-S','JHY71EL-S',72,1),('JHY71ER-S','JHY71ER-S',72,1),('JIN01ER-S','JIN01ER-S',60,1),('JIN11ER','JIN11ER',172,1),('JJ01590038','JJ01590038',31,1),('JJP16ER','JJP16ER',28,1),('JKA81EL','JKA81EL',130,1),('JKI102R','JKI102R',43,1),('JL462904','JL462904',112,1),('JL462904','JL462904',31,2),('JL462952','JL462952',58,1),('JLX05ER-S','JLX05ER-S',53,1),('JLX08EL-S','JLX08EL-S',55,1),('JLX26ER','JLX26ER',95,1),('JLX30EL-S','JLX30EL-S',99,1),('JMA113EL-S','JMA113EL-S',89,1),('JMA113EL-S','JMA113EL-S',96,1),('JMA86ER-S','JMA86ER-S',134,1),('JMT22ER','JMT22ER',43,1),('JMT40ER','JMT40ER',130,1),('JMZ124ER','JMZ124ER',130,1),('JMZ89R','JMZ89R',4,1),('JN192001','JN192001',151,1),('JNS105EL','JNS105EL',56,1),('JNS121EL','JNS121EL',30,1),('JNS141EL','JNS141EL',20,1),('JNS166ER','JNS166ER',75,1),('JNS183EL-S','JNS183EL-S',37,1),('JNS189EL-S','JNS189EL-S',131,1),('JNS189ER-S','JNS189ER-S',147,1),('JNS191EL-S','JNS191EL-S',31,1),('JNS212EL','JNS212EL',57,1),('JNS49EL','JNS49EL',77,1),('JP01GR','JP01GR',168,1),('JP42EL-S','JP42EL-S',168,1),('JP59EL','JP59EL',143,1),('JP60ER','JP60ER',31,1),('JP71ER-S','JP71ER-S',32,1),('JP77GR','JP77GR',176,1),('JP89EL-S','JP89EL-S',94,1),('JP92GL','JP92GL',101,1),('JRC31500006','JRC31500006',127,1),('JRC31500006','JRC31500006',51,1),('JRD46290010','JRD46290010',47,1),('JRL49170010','JRL49170010',35,1),('JS47170007','JS47170007',57,1),('JSU01CL-S','JSU01CL-S',33,1),('JSU02EL-S','JSU02EL-S',164,1),('JSU02ER','JSU02ER',7,1),('JSU55EL','JSU55EL',134,1),('JSU55ER','JSU55ER',167,1),('JSU57EL-S','JSU57EL-S',146,1),('JSU63EL-S','JSU63EL-S',91,1),('JSU67EL','JSU67EL',57,1),('JSU67EL','JSU67EL',172,1),('JSU67ER','JSU67ER',164,1),('JSU68EL-S','JSU68EL-S',134,1),('JSU68EL-S','JSU68EL-S',89,1),('JSU68ER-S','JSU68ER-S',89,1),('JSU69EL','JSU69EL',25,1),('JSU77EL','JSU77EL',57,1),('JSU77EL','JSU77EL',101,1),('JSU77ER','JSU77ER',146,1),('JSU77ER','JSU77ER',172,1),('JSU79EL','JSU79EL',127,1),('JSU79EL','JSU79EL',151,1),('JT462940','JT462940',55,1),('JT463112','JT463112',50,1),('JTY01EL-S','JTY01EL-S',3,1),('JTY136EL-S','JTY136EL-S',146,1),('JTY137EL-S','JTY137EL-S',25,1),('JTY137ER-S','JTY137ER-S',25,1),('JTY143EL-S','JTY143EL-S',139,1),('JTY155EL-S','JTY155EL-S',119,1),('JTY177ER','JTY177ER',50,1),('JTY198EL-S','JTY198EL-S',172,1),('JTY207EL-S','JTY207EL-S',167,1),('JTY210CR','JTY210CR',116,1),('JTY246EL','JTY246EL',87,1),('JTY246EL','JTY246EL',104,1),('JTY246ER','JTY246ER',91,1),('JTY246ER','JTY246ER',159,1),('JTY253EL-S','JTY253EL-S',77,1),('JTY253ER-S','JTY253ER-S',172,1),('JTY267ER-S','JTY267ER-S',22,1),('JTY280ER','JTY280ER',116,1),('JTY294ER','JTY294ER',95,1),('JTY43R','JTY43R',164,1),('JTY60CR','JTY60CR',172,1),('JTY92L','JTY92L',111,1),('JU2503140','JU2503140',87,1),('JVW70ER-S','JVW70ER-S',33,1),('JVW75EL-S','JVW75EL-S',61,1),('JVW75ER-S','JVW75ER-S',89,1),('JVW75ER-S','JVW75ER-S',94,1),('JWS462916','JWS462916',4,1),('K222106','K222106',4,1),('K30-1127R-AC','K30-1127R-AC',128,1),('K30-1136L-AS','K30-1136L-AS',70,1),('K30-1143L-ACN2','K30-1143L-ACN2',7,1),('K30-1152R-ASN2','K30-1152R-ASN2',60,1),('K30-1153L-AC2','K30-1153L-AC2',160,1),('K30-1153R-AC2','K30-1153R-AC2',157,1),('K30-1304L-AC','K30-1304L-AC',168,1),('K30-1304R-AC','K30-1304R-AC',12,1),('K30-1942R-UC','K30-1942R-UC',20,1),('K30-1954L-AC','K30-1954L-AC',60,1),('K30-2024L-AC','K30-2024L-AC',127,1),('KA02EL-S','KA02EL-S',168,1),('KA105ER-S','KA105ER-S',57,1),('KA106EL-S','KA106EL-S',111,1),('KA107EL','KA107EL',91,1),('KA15L','KA15L',138,1),('KA15R','KA15R',157,1),('KA80EL-S','KA80EL-S',97,1),('KA97EL-S','KA97EL-S',152,1),('KAVC30250','KAVC30250',43,1),('KI102L','KI102L',131,1),('KI1038150','KI1038150',31,1),('KI1038179','KI1038179',112,1),('KI1047112','KI1047112',123,1),('KI1167109','KI1167109',37,1),('KI1288142','KI1288142',29,1),('KI1320201','KI1320201',109,1),('KI1320229','KI1320229',112,1),('KI1526105','KI1526105',116,1);
INSERT INTO _plan (part_key,part_display,location_pk,qty) VALUES ('KI250165C','KI250165C',93,1),('KI2502182C','KI2502182C',12,1),('KI2530105','KI2530105',8,1),('KI2563102','KI2563102',12,1),('KI2800416','KI2800416',128,1),('KI2805121N','KI2805121N',12,1),('KVAC30029','KVAC30029',22,1),('KVAC30029','KVAC30029',139,1),('KVAC30043','KVAC30043',24,1),('KVAC30068','KVAC30068',20,1),('KVAC30114','KVAC30114',51,1),('KVAC30115','KVAC30115',18,1),('KVAC30115','KVAC30115',105,1),('KVAC30118','KVAC30118',16,1),('KVAC30121','KVAC30121',105,1),('KVAC30183','KVAC30183',77,1),('KVAC30188','KVAC30188',16,1),('KVAC30199','KVAC30199',24,1),('KVAC30218','KVAC30218',22,1),('KVAC30223','KVAC30223',91,1),('KVAC30259','KVAC30259',25,1),('KVAC3580','KVAC3580',126,1),('KVAC3882','KVAC3882',79,2),('KVAC3937','KVAC3937',25,1),('KVAC3948','KVAC3948',29,2),('KVAC3948','KVAC3948',93,1),('KVAC4516','KVAC4516',16,1),('KVAC4614','KVAC4614',16,1),('KVAC4763','KVAC4763',29,1),('L222103','L222103',145,1),('L491704','L491704',167,1),('LS0802294','LS0802294',160,1),('LX1043131','LX1043131',81,1),('LX1217103','LX1217103',91,1),('LX1218108','LX1218108',22,1),('LX1288100','LX1288100',135,1),('LX1288130','LX1288130',70,1),('LX1350115','LX1350115',92,1),('LX1351104','LX1351104',19,1),('LX1550100','LX1550100',116,1),('LX1791100','LX1791100',104,1),('LX2502135C','LX2502135C',85,1),('LX2800313C','LX2800313C',143,1),('LX2805133','LX2805133',16,1),('M1046194','M1046194',35,1),('M21551','M21551',11,1),('M222130','M222130',128,1),('M2222310','M2222310',161,1),('M250516','M250516',28,1),('MA04GR','MA04GR',51,1),('MA106GL','MA106GL',89,1),('MA113EL-S','MA113EL-S',57,1),('MA113ER-S','MA113ER-S',89,1),('MA1244104','MA1244104',25,1),('MA128GL','MA128GL',176,1),('MA1311122','MA1311122',66,1),('MA1320154','MA1320154',169,1),('MA1324107','MA1324107',4,1),('MA19ER-S','MA19ER-S',120,1),('MA2521112','MA2521112',98,1),('MA2593128','MA2593128',123,1),('MA2801115C','MA2801115C',12,1),('MA2801188','MA2801188',68,1),('MA2819115','MA2819115',134,1),('MA2883104','MA2883104',135,1),('MA29EL-S','MA29EL-S',77,1),('MA58EL-S','MA58EL-S',32,1),('MA66EL-S','MA66EL-S',113,1),('MB103100','MB103100',128,1),('MB1046196','MB1046196',35,1),('MB1210117','MB1210117',81,1),('MB1225122','MB1225122',29,1),('MB1324107','MB1324107',126,1),('MB206-B00CR','MB206-B00CR',71,1),('MB2502160','MB2502160',3,1),('MB2502220','MB2502220',36,1),('MB2563101','MB2563101',123,1),('MB2592120','MB2592120',120,2),('MB2661124','MB2661124',70,1),('MB2886101','MB2886101',155,1),('MC1039105','MC1039105',159,1),('MC1216100C','MC1216100C',65,1),('MI03EL','MI03EL',77,1),('MI1042103','MI1042103',135,1),('MI1320110','MI1320110',31,1),('MI1321103','MI1321103',97,1),('MI2502118','MI2502118',84,1),('MI2519123','MI2519123',112,1),('MI33070172','MI33070172',98,1),('MN01ER','MN01ER',81,1),('MT18R','MT18R',127,1),('MT40EL','MT40EL',77,1),('MZ125GL','MZ125GL',65,1),('MZ15EL','MZ15EL',100,1),('MZ221-B000R','MZ221-B000R',172,1),('MZ229-B000L','MZ229-B000L',68,1),('MZ91GR','MZ91GR',57,1),('MZ92GR','MZ92GR',64,1),('N012511','N012511',31,1),('N012512','N012512',123,1),('N107903','N107903',98,1),('N11234139','N11234139',151,1),('N222101','N222101',122,1),('N250503','N250503',20,1),('NF79-51-180C','NF79-51-180C',123,1),('NI10006253','NI10006253',98,1),('NI1038170','NI1038170',94,1),('NI1039183','NI1039183',25,1),('NI1042122','NI1042122',65,1),('NI1066152','NI1066152',34,1),('NI1070206','NI1070206',20,1),('NI1236190','NI1236190',61,1),('NI1246197','NI1246197',22,1),('NI1251106','NI1251106',122,1),('NI1321147','NI1321147',131,1),('NI1550142','NI1550142',164,1),('NI2500198','NI2500198',137,1),('NI2502120','NI2502120',151,1),('NI2502153C','NI2502153C',12,1),('NI2503218','NI2503218',12,1),('NI2503232','NI2503232',156,1),('NI2505123','NI2505123',38,1),('NI2509106','NI2509106',101,1),('NI2592128','NI2592128',143,1),('NI2800118','NI2800118',106,1),('NI2803256','NI2803256',121,1),('NIARM-CAM-17-R','NIARM-CAM-17-R',131,1),('NIFRO-WRP-05-FR','NIFRO-WRP-05-FR',112,1),('NIMUR-CAM-13-R','NIMUR-CAM-13-R',112,1),('NS174R-S','NS174R-S',64,1),('NS38L','NS38L',36,1),('NV0638578','NV0638578',152,1),('P-HOO1H','P-HOO1H',12,2),('P13197','P13197',132,1),('P13253','P13253',77,1),('P13320','P13320',108,1),('P13395','P13395',16,1),('P13451','P13451',105,1),('P13514','P13514',7,1),('P13536','P13536',60,1),('P13605','P13605',54,1),('P13788','P13788',11,1),('P13792','P13792',79,1),('P13831','P13831',11,1),('P13831','P13831',116,1),('P13842','P13842',35,1),('P13965','P13965',104,1),('P2791','P2791',6,1),('P39703','P39703',139,1),('P618','P618',67,1),('P921','P921',51,1),('PB57069','PB57069',31,1),('PC30093','PC30093',133,1),('PC30153','PC30153',64,1),('PC30155','PC30155',29,1),('PC3148P','PC3148P',16,1),('PC3636P','PC3636P',16,1),('PC4808A','PC4808A',7,1),('PF1728','PF1728',55,1),('PF41164','PF41164',29,1),('PF44973','PF44973',79,1),('PF52509','PF52509',29,1),('PF5319','PF5319',24,1),('PF5552','PF5552',161,1),('PO3115103','PO3115103',46,1),('PR0965A','PR0965A',134,1),('PR0965A','PR0965A',77,1),('PR1109A','PR1109A',79,1),('PR1151A','PR1151A',85,1),('PR1322A','PR1322A',32,1),('PR13304A','PR13304A',15,1),('PR13475A','PR13475A',142,1),('PR13667A','PR13667A',16,1),('PR13842A','PR13842A',29,1),('PR13883A','PR13883A',29,1),('PR1388A','PR1388A',106,1),('PR13918A','PR13918A',104,1),('PR13925A','PR13925A',16,1),('PR2094A','PR2094A',54,1),('PR2413A','PR2413A',135,1),('PR2585A','PR2585A',79,1),('PR2715A','PR2715A',79,1),('PR2980A','PR2980A',156,1),('PT26R','PT26R',160,1),('RA01310006','RA01310006',22,1),('RA01310006','RA01310006',164,1),('RA01310023','RA01310023',22,1),('RA01310024','RA01310024',25,1),('RA01470005','RA01470005',71,1),('RA01530021','RA01530021',138,1),('RA01530021','RA01530021',88,1),('RA01530028','RA01530028',36,1),('RA01530030','RA01530030',100,1),('RA01550002','RA01550002',76,1),('RA01730004','RA01730004',53,1),('RA01750011','RA01750011',98,1),('RA01910014','RA01910014',134,1),('RA07230001','RA07230001',18,1),('RA07580001','RA07580001',79,1),('RA10770011','RA10770011',15,1),('RA10770013','RA10770013',34,1),('RA10770013','RA10770013',135,1),('RA10770013','RA10770013',56,1),('RA10770016','RA10770016',146,1),('RA10770017','RA10770017',7,1),('RA10770017','RA10770017',58,1),('RA10770017','RA10770017',100,1),('RA10770018','RA10770018',36,1),('RA10770018','RA10770018',135,1),('RA10770018','RA10770018',58,1),('RA10770022','RA10770022',164,1),('RA10810002','RA10810002',28,1),('RA10980008','RA10980008',159,1),('RA22130001','RA22130001',22,1),('RA22210023','RA22210023',100,1),('RA22210024','RA22210024',100,1),('RA22210047','RA22210047',60,1),('RA22210058','RA22210058',20,1),('RA22370013','RA22370013',61,1),('RA22370014','RA22370014',112,1),('RA25010002','RA25010002',43,1),('RA54390006','RA54390006',62,1),('RB01250006','RB01250006',16,1),('RB01310004','RB01310004',65,1),('RB01310007','RB01310007',37,1),('RB01310027','RB01310027',64,1),('RB01310058','RB01310058',65,1),('RB01530072','RB01530072',156,1),('RB01530086','RB01530086',77,1),('RB01530103','RB01530103',56,1),('RB01550005','RB01550005',168,1),('RB01550021','RB01550021',176,1),('RB01550022','RB01550022',147,1),('RB01550027','RB01550027',55,1),('RB01550028','RB01550028',55,1),('RB01550060','RB01550060',52,1),('RB01590006','RB01590006',99,1),('RB01590019','RB01590019',84,1),('RB01590019','RB01590019',105,1),('RB01590019Q','RB01590019Q',160,1),('RB01590023','RB01590023',84,1),('RB01590047','RB01590047',104,1),('RB01610001','RB01610001',102,1),('RB01610002','RB01610002',102,1),('RB01610002','RB01610002',164,1),('RB01610013','RB01610013',90,1),('RB01730031','RB01730031',151,1),('RB01840004','RB01840004',22,1),('RB01910018','RB01910018',112,1),('RB02030010','RB02030010',30,1),('RB02030011','RB02030011',90,1),('RB02030011','RB02030011',164,1),('RB07010052','RB07010052',112,1),('RB07580002','RB07580002',15,1),('RB07580002','RB07580002',148,1),('RB07580002','RB07580002',104,1),('RB10820003','RB10820003',7,1),('RB10820013','RB10820013',11,1),('RB10820014','RB10820014',3,1),('RB10820019','RB10820019',22,1),('RB13030002','RB13030002',37,1),('RB16130001','RB16130001',91,1),('RB16330005','RB16330005',140,1),('RB22370003','RB22370003',176,1),('RB22370012','RB22370012',7,1),('RB22370016','RB22370016',95,1),('RB22470001','RB22470001',99,1),('RB22470002','RB22470002',99,1),('RB31110003','RB31110003',207,1),('RB31110003','RB31110003',61,1),('RB520312','RB520312',135,1),('RB54390006','RB54390006',18,1),('RB55390005','RB55390005',131,1),('RB73490011','RB73490011',115,1),('RB76210010','RB76210010',88,1),('RB76260003','RB76260003',101,1),('RB76350029','RB76350029',20,1),('RB76350030','RB76350030',49,1),('RB76350046','RB76350046',176,1),('RB76370002','RB76370002',164,1),('RB76430008','RB76430008',24,1),('RBC013104','RBC013104',62,1),('RBG130501','RBG130501',123,1),('RBT100105','RBT100105',155,1),('RBT462111','RBT462111',57,1),('RBV462904','RBV462904',89,1),('RC01250020','RC01250020',112,1),('RC01310051','RC01310051',98,1),('RC01310052','RC01310052',98,1),('RC01310058','RC01310058',94,1),('RC01310075','RC01310075',37,1),('RC01310119','RC01310119',51,1),('RC01310119','RC01310119',100,1),('RC01310140','RC01310140',62,1),('RC01590018','RC01590018',111,1),('RC01590042','RC01590042',50,2),('RC01610003','RC01610003',37,1),('RC01610004','RC01610004',164,1),('RC01610005','RC01610005',108,1),('RC01730025','RC01730025',101,1),('RC04050001','RC04050001',88,1),('RC04050002','RC04050002',15,1),('RC04050002','RC04050002',99,1),('RC07110001','RC07110001',65,1),('RC07110001','RC07110001',156,1),('RC07580001','RC07580001',47,1),('RC07580015','RC07580015',12,1),('RC10810007','RC10810007',139,1),('RC10810024','RC10810024',131,1),('RC10810027','RC10810027',64,1),('RC10810050','RC10810050',151,1),('RC10820004','RC10820004',65,1),('RC10820009','RC10820009',21,1),('RC10820009','RC10820009',65,1),('RC10820010','RC10820010',24,1),('RC13050027','RC13050027',158,1),('RC13230009','RC13230009',7,1),('RC13230009','RC13230009',37,2),('RC13230011','RC13230011',30,1),('RC16090052','RC16090052',24,1),('RC16250006','RC16250006',43,1),('RC16250006','RC16250006',135,1),('RC16250006','RC16250006',172,1),('RC19090001','RC19090001',130,1),('RC22210008','RC22210008',143,1),('RC22210022','RC22210022',145,1),('RC22210031','RC22210031',122,1),('RC22370014','RC22370014',131,1),('RC22370015','RC22370015',139,1),('RC22370027','RC22370027',65,1),('RC22370028','RC22370028',65,1),('RC28210073','RC28210073',22,2),('RC31010019','RC31010019',164,1),('RC46290008','RC46290008',99,1),('RC46290024','RC46290024',10,1),('RC47170008','RC47170008',98,1),('RC49170010','RC49170010',7,1),('RC49170025','RC49170025',119,1),('RC49170025','RC49170025',37,1),('RC50290003','RC50290003',20,1),('RC50290003','RC50290003',43,1),('RC50290004','RC50290004',43,1),('RC76260005','RC76260005',152,1),('RC76270005','RC76270005',101,1),('RC76270023','RC76270023',90,1),('RC76270024','RC76270024',151,1),('RC76270025','RC76270025',90,1),('RC76270026','RC76270026',102,1),('RC76490010','RC76490010',7,1),('RC76790002','RC76790002',65,1),('RC82510004','RC82510004',114,1),('RD01310010','RD01310010',134,1),('RD01310027','RD01310027',65,1),('RD01370002','RD01370002',143,1),('RD01370003','RD01370003',15,1),('RD01370003','RD01370003',37,1),('RD01370003','RD01370003',126,1),('RD01370005','RD01370005',16,1),('RD01370005','RD01370005',111,1),('RD01440003','RD01440003',53,1),('RD01610001','RD01610001',72,1),('RD01730012','RD01730012',43,1),('RD01730012','RD01730012',77,1),('RD04050001','RD04050001',65,1),('RD07070010','RD07070010',135,1),('RD07580004','RD07580004',7,1),('RD07580006','RD07580006',105,1),('RD10750011A','RD10750011A',35,1),('RD10810014','RD10810014',93,1),('RD11050003','RD11050003',88,1),('RD13230006','RD13230006',37,1),('RD13230007','RD13230007',29,1),('RD16230002','RD16230002',130,1),('RD16290001','RD16290001',58,1),('RD16290002','RD16290002',57,1),('RD22210008','RD22210008',145,1),('RD22210024','RD22210024',123,1),('RD51070009','RD51070009',172,1),('RD55390001','RD55390001',104,1),('RD76320001','RD76320001',207,1),('RD76490003','RD76490003',132,1),('RECP016102','RECP016102',7,1),('RECP016102','RECP016102',23,1),('RECP016102','RECP016102',130,1),('RECP016102','RECP016102',131,1),('RECP016102','RECP016102',143,1),('RECP016102','RECP016102',89,1),('RECP016102','RECP016102',98,1),('RECP016102','RECP016102',176,1),('REPA013109','REPA013109',50,1),('REPA013113','REPA013113',130,1),('REPA013123','REPA013123',69,1),('REPA015509','REPA015509',61,1),('REPA015510','REPA015510',61,1),('REPA040302','REPA040302',38,1),('REPA108007','REPA108007',95,1),('REPA108017','REPA108017',20,1),('REPA108619','REPA108619',51,1),('REPA108620','REPA108620',122,1),('REPA108620','REPA108620',53,1);
INSERT INTO _plan (part_key,part_display,location_pk,qty) VALUES ('REPA132301','REPA132301',53,1),('REPA161304','REPA161304',155,1),('REPA222122','REPA222122',139,1),('REPA222150','REPA222150',56,1),('REPA222150','REPA222150',145,1),('REPA286501','REPA286501',90,2),('REPA286502','REPA286502',123,2),('REPA462927','REPA462927',29,1),('REPA462927','REPA462927',51,1),('REPA462966','REPA462966',123,1),('REPA763502','REPA763502',58,1),('REPB013124','REPB013124',90,1),('REPB013127','REPB013127',131,1),('REPB013128','REPB013128',152,1),('REPB014701','REPB014701',22,1),('REPB014701','REPB014701',142,1),('REPB015344','REPB015344',40,1),('REPB015551','REPB015551',7,1),('REPB016119','REPB016119',25,1),('REPB016119','REPB016119',93,1),('REPB016120','REPB016120',119,1),('REPB016120','REPB016120',130,1),('REPB016120','REPB016120',138,1),('REPB016120','REPB016120',159,1),('REPB016122','REPB016122',68,1),('REPB016123','REPB016123',76,1),('REPB017317','REPB017317',176,1),('REPB041101Q','REPB041101Q',36,1),('REPB100110','REPB100110',59,1),('REPB104107','REPB104107',89,1),('REPB108015','REPB108015',99,1),('REPB108016','REPB108016',98,1),('REPB108207','REPB108207',50,1),('REPB108208','REPB108208',112,1),('REPB108209','REPB108209',95,1),('REPB108210','REPB108210',99,1),('REPB221315','REPB221315',85,1),('REPB221316','REPB221316',79,1),('REPB221316','REPB221316',85,1),('REPB221320','REPB221320',18,1),('REPB221320','REPB221320',40,1),('REPB2221303','REPB2221303',40,1),('REPB222182','REPB222182',57,1),('REPB250311Q','REPB250311Q',7,1),('REPB310121','REPB310121',105,1),('REPB462915','REPB462915',164,1),('REPB553905','REPB553905',104,2),('REPB553906','REPB553906',39,1),('REPB553906','REPB553906',85,1),('REPB553909','REPB553909',29,1),('REPB553915','REPB553915',1,1),('REPB730304','REPB730304',98,1),('REPB761103P','REPB761103P',79,1),('REPB766924','REPB766924',35,1),('REPBZ222111','REPBZ222111',29,1),('REPC010335','REPC010335',46,1),('REPC013108','REPC013108',25,1),('REPC013121','REPC013121',131,1),('REPC013122','REPC013122',131,1),('REPC013159','REPC013159',76,1),('REPC013160','REPC013160',76,1),('REPC01317','REPC01317',105,1),('REPC013176','REPC013176',57,1),('REPC013176','REPC013176',99,1),('REPC013185','REPC013185',12,1),('REPC013185','REPC013185',31,1),('REPC013185','REPC013185',65,1),('REPC013185','REPC013185',74,1),('REPC013186Q','REPC013186Q',7,1),('REPC015319Q','REPC015319Q',143,1),('REPC015928','REPC015928',60,1),('REPC015928','REPC015928',90,1),('REPC016127','REPC016127',65,1),('REPC017302','REPC017302',60,1),('REPC017318','REPC017318',91,1),('REPC018913','REPC018913',112,1),('REPC018913','REPC018913',158,1),('REPC019512','REPC019512',59,1),('REPC019515','REPC019515',20,1),('REPC020302','REPC020302',49,1),('REPC100350Q','REPC100350Q',167,1),('REPC104507','REPC104507',35,1),('REPC104508','REPC104508',35,1),('REPC107519','REPC107519',100,1),('REPC107520','REPC107520',100,1),('REPC107532','REPC107532',43,1),('REPC107532','REPC107532',62,1),('REPC108008','REPC108008',21,1),('REPC108013','REPC108013',160,1),('REPC108014','REPC108014',176,1),('REPC108019','REPC108019',37,1),('REPC108601','REPC108601',64,1),('REPC108604','REPC108604',53,1),('REPC108605','REPC108605',138,1),('REPC108622','REPC108622',31,1),('REPC108622','REPC108622',65,1),('REPC108634','REPC108634',64,1),('REPC108634','REPC108634',138,1),('REPC110501','REPC110501',92,1),('REPC110502','REPC110502',92,1),('REPC111505Q','REPC111505Q',63,1),('REPC130501','REPC130501',49,1),('REPC130521','REPC130521',37,1),('REPC130522','REPC130522',37,1),('REPC130541','REPC130541',131,1),('REPC130542','REPC130542',131,1),('REPC130548','REPC130548',168,1),('REPC130667','REPC130667',151,1),('REPC132306','REPC132306',90,1),('REPC132314','REPC132314',35,1),('REPC160301','REPC160301',135,1),('REPC190903','REPC190903',11,1),('REPC222105','REPC222105',57,1),('REPC222136','REPC222136',122,1),('REPC222154','REPC222154',135,1),('REPC251507','REPC251507',147,1),('REPC251703','REPC251703',112,1),('REPC262903','REPC262903',97,1),('REPC311612','REPC311612',57,1),('REPC314101','REPC314101',89,1),('REPC319804','REPC319804',159,1),('REPC462196','REPC462196',89,1),('REPC462393WK','REPC462393WK',30,1),('REPC462928','REPC462928',167,1),('REPC462946','REPC462946',29,1),('REPC462946','REPC462946',136,1),('REPC464302','REPC464302',57,1),('REPC468701','REPC468701',65,1),('REPC491375','REPC491375',127,1),('REPC491385','REPC491385',123,1),('REPC491386','REPC491386',123,1),('REPC491391','REPC491391',101,1),('REPC580737','REPC580737',90,1),('REPC580739C','REPC580739C',89,1),('REPC580752','REPC580752',50,1),('REPC580752','REPC580752',176,1),('REPC760502','REPC760502',30,1),('REPC760502','REPC760502',99,1),('REPC761103','REPC761103',70,1),('REPC761103','REPC761103',156,1),('REPC761103','REPC761103',95,1),('REPC761104','REPC761104',98,1),('REPC761114','REPC761114',87,1),('REPC762702','REPC762702',139,1),('REPC762729','REPC762729',50,1),('REPC762730','REPC762730',7,1),('REPC762742','REPC762742',4,1),('REPC763522','REPC763522',64,1),('REPC764903','REPC764903',29,1),('REPC764903','REPC764903',32,1),('REPC764903','REPC764903',40,1),('REPC764903','REPC764903',31,1),('REPC764903','REPC764903',62,1),('REPC764903','REPC764903',66,1),('REPC764904','REPC764904',7,1),('REPC764904','REPC764904',12,1),('REPC764904','REPC764904',29,1),('REPC764904','REPC764904',31,1),('REPC764904','REPC764904',59,1),('REPC764904','REPC764904',60,1),('REPC764904','REPC764904',155,1),('REPC764907','REPC764907',148,1),('REPC764907','REPC764907',93,1),('REPC764908','REPC764908',18,1),('REPC764908','REPC764908',132,1),('REPC764908','REPC764908',31,1),('REPC764929','REPC764929',96,1),('REPC766908','REPC766908',111,1),('REPC960912','REPC960912',176,4),('REPCH462141','REPCH462141',164,1),('REPD015908Q','REPD015908Q',31,1),('REPD018402','REPD018402',135,1),('REPD019503','REPD019503',7,1),('REPD019503','REPD019503',25,2),('REPD019503','REPD019503',122,1),('REPD019503','REPD019503',123,1),('REPD019503','REPD019503',127,1),('REPD019503','REPD019503',65,1),('REPD019503','REPD019503',70,1),('REPD019503','REPD019503',156,1),('REPD019503','REPD019503',104,1),('REPD072702','REPD072702',52,1),('REPD108612','REPD108612',81,1),('REPD108613Q','REPD108613Q',64,1),('REPD109901','REPD109901',25,1),('REPD109901','REPD109901',79,1),('REPD132303','REPD132303',91,1),('REPD160913','REPD160913',93,1),('REPD221307','REPD221307',30,1),('REPD222121','REPD222121',112,1),('REPD222122','REPD222122',112,1),('REPD222125','REPD222125',86,1),('REPD223703','REPD223703',4,1),('REPD223703','REPD223703',143,1),('REPD281524','REPD281524',15,1),('REPD310811','REPD310811',57,4),('REPD462107WK','REPD462107WK',29,1),('REPD462107WK','REPD462107WK',61,1),('REPD462107WK','REPD462107WK',176,1),('REPD462108','REPD462108',138,1),('REPD462128','REPD462128',127,1),('REPD462193','REPD462193',36,1),('REPD462193','REPD462193',76,1),('REPD462193','REPD462193',77,1),('REPD462193','REPD462193',88,1),('REPD491346','REPD491346',98,1),('REPD494701','REPD494701',123,1),('REPD503902','REPD503902',176,1),('REPD760149','REPD760149',90,1),('REPD762702','REPD762702',22,1),('REPD762702','REPD762702',63,1),('REPD762702','REPD762702',147,1),('REPD762702','REPD762702',95,1),('REPD764903','REPD764903',63,1),('REPF012703','REPF012703',98,1),('REPF013151','REPF013151',95,1),('REPF016104','REPF016104',135,1),('REPF019507','REPF019507',31,1),('REPF040915','REPF040915',37,1),('REPF071719','REPF071719',79,1),('REPF107537-HD','REPF107537-HD',132,1),('REPF108207','REPF108207',115,1),('REPF108605','REPF108605',63,1),('REPF160938','REPF160938',79,1),('REPF221322','REPF221322',104,1),('REPF251116','REPF251116',53,1),('REPF310105','REPF310105',104,1),('REPF310151','REPF310151',138,1),('REPF311320','REPF311320',32,1),('REPF316004','REPF316004',12,1),('REPF462916','REPF462916',112,1),('REPF462916','REPF462916',57,2),('REPF462931','REPF462931',113,1),('REPF462940','REPF462940',87,1),('REPF491311','REPF491311',147,1),('REPF491316','REPF491316',135,2),('REPF491365','REPF491365',127,1),('REPF491366','REPF491366',127,1),('REPF580706','REPF580706',2,1),('REPF580727','REPF580727',127,1),('REPF580727','REPF580727',171,1),('REPF760704','REPF760704',31,1),('REPF760705','REPF760705',112,1),('REPF760705','REPF760705',22,1),('REPF760705','REPF760705',52,1),('REPF760705','REPF760705',139,1),('REPF760705','REPF760705',91,1),('REPF760705','REPF760705',96,1),('REPF762714','REPF762714',111,1),('REPG013101','REPG013101',116,1),('REPG013114','REPG013114',168,1),('REPG015906','REPG015906',31,1),('REPG017303','REPG017303',112,1),('REPG019101','REPG019101',29,1),('REPG019101','REPG019101',106,1),('REPG108003','REPG108003',36,1),('REPG108202','REPG108202',101,1),('REPG108202','REPG108202',176,1),('REPG108204','REPG108204',134,1),('REPG108204','REPG108204',102,1),('REPG108206','REPG108206',63,1),('REPG313702','REPG313702',119,1),('REPG314105','REPG314105',36,1),('REPG468701','REPG468701',98,1),('REPG468702','REPG468702',98,1),('REPG763503','REPG763503',31,1),('REPH013186','REPH013186',115,1),('REPH015907','REPH015907',89,1),('REPH017307','REPH017307',168,1),('REPH017512','REPH017512',168,1),('REPH070167','REPH070167',7,1),('REPH070184','REPH070184',108,1),('REPH070702','REPH070702',132,1),('REPH0707119','REPH0707119',76,1),('REPH071511','REPH071511',31,1),('REPH100357','REPH100357',116,1),('REPH106911','REPH106911',177,1),('REPH106912','REPH106912',46,1),('REPH107513','REPH107513',19,1),('REPH107542Q','REPH107542Q',35,1),('REPH108601','REPH108601',158,1),('REPH108609','REPH108609',55,1),('REPH108614','REPH108614',64,1),('REPH110501','REPH110501',120,1),('REPH130529','REPH130529',35,1),('REPH130530','REPH130530',35,1),('REPH130546','REPH130546',102,1),('REPH130546','REPH130546',168,1),('REPH130547','REPH130547',57,1),('REPH130547','REPH130547',77,1),('REPH130551','REPH130551',25,1),('REPH130551','REPH130551',101,1),('REPH130551','REPH130551',160,1),('REPH130551','REPH130551',167,1),('REPH130552','REPH130552',25,1),('REPH130554','REPH130554',10,1),('REPH1320552','REPH1320552',101,1),('REPH132322','REPH132322',176,1),('REPH160962','REPH160962',20,1),('REPH160962','REPH160962',92,1),('REPH160970','REPH160970',36,1),('REPH220184','REPH220184',64,1),('REPH222127','REPH222127',123,1),('REPH222147','REPH222147',7,1),('REPH222148','REPH222148',4,1),('REPH222302','REPH222302',76,1),('REPH222308','REPH222308',58,2),('REPH282119','REPH282119',116,1),('REPH310132','REPH310132',138,1),('REPH310137','REPH310137',21,1),('REPH310187','REPH310187',29,1),('REPH310188','REPH310188',23,1),('REPH310193','REPH310193',122,1),('REPH311322','REPH311322',148,1),('REPH462123','REPH462123',98,1),('REPH462908','REPH462908',93,1),('REPH462908','REPH462908',161,1),('REPH491703','REPH491703',50,1),('REPH494714','REPH494714',20,1),('REPH494714','REPH494714',176,1),('REPH533903','REPH533903',29,1),('REPH580704','REPH580704',64,1),('REPHD462323','REPHD462323',97,1),('REPHD462324','REPHD462324',101,1),('REPHY462131C','REPHY462131C',135,1),('REPI109901','REPI109901',80,1),('REPI161308','REPI161308',167,1),('REPI314101','REPI314101',108,1),('REPI462190','REPI462190',22,1),('REPI462190','REPI462190',164,1),('REPI762106','REPI762106',105,1),('REPJ013107','REPJ013107',164,1),('REPJ015509','REPJ015509',51,1),('REPJ015907','REPJ015907',58,1),('REPJ017304','REPJ017304',119,1),('REPJ070128Q','REPJ070128Q',57,1),('REPJ070701','REPJ070701',74,1),('REPJ221325','REPJ221325',18,1),('REPJ221326','REPJ221326',171,1),('REPJ222116','REPJ222116',4,1),('REPJ462125','REPJ462125',152,1),('REPJ462125','REPJ462125',89,1),('REPJ462125','REPJ462125',161,1),('REPJ730148','REPJ730148',136,1),('REPJ762202','REPJ762202',63,1),('REPJ763201','REPJ763201',1,1),('REPJ764907','REPJ764907',60,1),('REPK070131Q','REPK070131Q',123,1),('REPK100178','REPK100178',18,1),('REPK108004','REPK108004',167,1),('REPK222155','REPK222155',145,1),('REPK310106','REPK310106',29,1),('REPK310112','REPK310112',10,1),('REPK310112','REPK310112',29,1),('REPK310112','REPK310112',121,1),('REPK462106','REPK462106',89,1),('REPK462135','REPK462135',22,1),('REPK462136','REPK462136',89,1),('REPK480103','REPK480103',19,1),('REPK491340','REPK491340',19,1),('REPK730120','REPK730120',112,1),('REPL013133','REPL013133',140,1),('REPL013134','REPL013134',95,1),('REPL013134','REPL013134',176,1),('REPL014911','REPL014911',139,1),('REPL014915','REPL014915',49,1),('REPL014916','REPL014916',62,1),('REPL014916','REPL014916',168,1),('REPL015504','REPL015504',51,1),('REPL018902','REPL018902',18,1),('REPL108010','REPL108010',172,1),('REPL108209','REPL108209',108,1),('REPL109901','REPL109901',131,1),('REPL109902','REPL109902',168,1),('REPL110507','REPL110507',32,1),('REPL110508','REPL110508',47,1),('REPL132317','REPL132317',65,1),('REPL222121','REPL222121',145,1),('REPL250301','REPL250301',52,1),('REPL310106','REPL310106',46,1),('REPL313501','REPL313501',90,1),('REPL314101','REPL314101',60,1),('REPL462127','REPL462127',11,1),('REPL462956','REPL462956',76,1),('REPL762703','REPL762703',65,1),('REPL766905','REPL766905',127,1),('REPM013116','REPM013116',34,1),('REPM013118','REPM013118',58,1),('REPM013301','REPM013301',120,1),('REPM015321','REPM015321',46,1),('REPM015361','REPM015361',81,1),('REPM016117','REPM016117',63,1),('REPM016118','REPM016118',63,1),('REPM016126','REPM016126',176,1),('REPM017324','REPM017324',176,1),('REPM017331','REPM017331',158,1),('REPM018425','REPM018425',51,1),('REPM040507','REPM040507',65,1),('REPM070180','REPM070180',65,1),('REPM070189','REPM070189',29,1);
INSERT INTO _plan (part_key,part_display,location_pk,qty) VALUES ('REPM070717Q','REPM070717Q',16,1),('REPM070719','REPM070719',88,1),('REPM071501','REPM071501',29,1),('REPM071503','REPM071503',65,1),('REPM100177','REPM100177',16,1),('REPM108020','REPM108020',57,1),('REPM108026','REPM108026',139,1),('REPM108216','REPM108216',31,1),('REPM108619','REPM108619',127,1),('REPM109904','REPM109904',114,1),('REPM161306','REPM161306',88,1),('REPM191509','REPM191509',128,1),('REPM192012','REPM192012',172,1),('REPM222165','REPM222165',145,1),('REPM222327','REPM222327',57,1),('REPM222363','REPM222363',68,1),('REPM222370','REPM222370',60,1),('REPM224118','REPM224118',36,1),('REPM251108','REPM251108',31,1),('REPM282106','REPM282106',164,1),('REPM310141','REPM310141',46,1),('REPM310163','REPM310163',145,1),('REPM462911','REPM462911',89,1),('REPM462958','REPM462958',2,1),('REPM462958','REPM462958',19,2),('REPM491321','REPM491321',37,1),('REPM491321','REPM491321',151,1),('REPM503005','REPM503005',47,1),('REPM542101','REPM542101',63,1),('REPM763734','REPM763734',63,1),('REPM766901','REPM766901',37,1),('REPN013101','REPN013101',176,1),('REPN013102','REPN013102',176,1),('REPN013105','REPN013105',65,1),('REPN013127','REPN013127',65,1),('REPN013128','REPN013128',65,1),('REPN013128','REPN013128',81,1),('REPN013133','REPN013133',96,1),('REPN014713','REPN014713',207,1),('REPN015906Q','REPN015906Q',47,1),('REPN017326','REPN017326',64,1),('REPN040503','REPN040503',65,1),('REPN040505','REPN040505',168,1),('REPN070705Q','REPN070705Q',47,1),('REPN100318','REPN100318',57,1),('REPN108007','REPN108007',29,1),('REPN108601','REPN108601',53,1),('REPN108634','REPN108634',61,1),('REPN108646','REPN108646',51,2),('REPN221301','REPN221301',24,1),('REPN221323','REPN221323',104,1),('REPN222107','REPN222107',88,1),('REPN222114','REPN222114',145,1),('REPN222130','REPN222130',115,1),('REPN223705','REPN223705',57,1),('REPN250504','REPN250504',147,1),('REPN251502','REPN251502',51,1),('REPN310108','REPN310108',57,1),('REPN310136','REPN310136',96,1),('REPN462920','REPN462920',99,1),('REPN580713','REPN580713',50,1),('REPN762709','REPN762709',37,1),('REPN762710','REPN762710',37,1),('REPN762711','REPN762711',131,1),('REPN762711','REPN762711',168,1),('REPN762712','REPN762712',131,1),('REPN762712','REPN762712',168,1),('REPN764904','REPN764904',7,1),('REPN764904','REPN764904',86,1),('REPN960341','REPN960341',61,1),('REPN960342','REPN960342',61,1),('REPP013106','REPP013106',7,1),('REPP013106','REPP013106',135,1),('REPP015503','REPP015503',24,1),('REPP310108','REPP310108',22,1),('REPP761101','REPP761101',49,1),('REPR580901','REPR580901',79,1),('REPS070704','REPS070704',119,1),('REPS108601','REPS108601',20,1),('REPS108602','REPS108602',167,1),('REPS1086111','REPS1086111',113,1),('REPS132304','REPS132304',119,1),('REPS190902','REPS190902',111,1),('REPS310101','REPS310101',138,2),('REPS462125','REPS462125',94,1),('REPS462933','REPS462933',89,1),('REPS491716','REPS491716',144,1),('REPS491722','REPS491722',131,1),('REPS960915','REPS960915',157,2),('REPT011111','REPT011111',207,1),('REPT011113','REPT011113',20,1),('REPT011117','REPT011117',4,1),('REPT011117','REPT011117',148,1),('REPT011118','REPT011118',11,1),('REPT011118','REPT011118',15,1),('REPT011118','REPT011118',20,1),('REPT011118','REPT011118',24,1),('REPT011118','REPT011118',117,1),('REPT011118','REPT011118',130,1),('REPT011118','REPT011118',132,1),('REPT011118','REPT011118',54,1),('REPT011118','REPT011118',207,1),('REPT011118','REPT011118',59,1),('REPT011118','REPT011118',66,1),('REPT011118','REPT011118',142,1),('REPT011118','REPT011118',69,1),('REPT011119Q','REPT011119Q',131,1),('REPT011119Q','REPT011119Q',53,1),('REPT011119Q','REPT011119Q',150,1),('REPT011119Q','REPT011119Q',173,5),('REPT013114','REPT013114',156,1),('REPT013114','REPT013114',88,1),('REPT013117','REPT013117',164,1),('REPT013118','REPT013118',168,1),('REPT013118','REPT013118',176,1),('REPT013163','REPT013163',51,1),('REPT013171','REPT013171',207,1),('REPT013171','REPT013171',164,1),('REPT013302','REPT013302',92,1),('REPT013302','REPT013302',94,1),('REPT014903','REPT014903',71,1),('REPT014904','REPT014904',71,1),('REPT014907','REPT014907',131,1),('REPT014917','REPT014917',172,1),('REPT015901','REPT015901',105,1),('REPT070702','REPT070702',105,1),('REPT100191','REPT100191',24,1),('REPT108009','REPT108009',20,1),('REPT108616','REPT108616',63,1),('REPT132307','REPT132307',88,1),('REPT132323','REPT132323',176,1),('REPT132340','REPT132340',98,1),('REPT190101','REPT190101',89,1),('REPT222173','REPT222173',130,1),('REPT222176','REPT222176',146,1),('REPT222194','REPT222194',112,1),('REPT222310','REPT222310',21,1),('REPT224302','REPT224302',15,1),('REPT250534','REPT250534',147,1),('REPT251506','REPT251506',35,1),('REPT310120','REPT310120',119,1),('REPT310142','REPT310142',122,1),('REPT314102','REPT314102',116,1),('REPT317402','REPT317402',35,1),('REPT370539','REPT370539',112,1),('REPT380303','REPT380303',75,1),('REPT462989','REPT462989',107,1),('REPT463123','REPT463123',7,1),('REPT491307','REPT491307',24,1),('REPT491753','REPT491753',89,1),('REPT491755','REPT491755',51,1),('REPT542103','REPT542103',15,1),('REPT542103','REPT542103',97,1),('REPT553911','REPT553911',49,1),('REPT580716','REPT580716',176,1),('REPT580723','REPT580723',37,1),('REPT580723','REPT580723',51,1),('REPT580726','REPT580726',35,1),('REPT580731','REPT580731',25,2),('REPT580731','REPT580731',34,1),('REPT580731','REPT580731',37,1),('REPT580731','REPT580731',131,1),('REPT580731','REPT580731',53,1),('REPT580731','REPT580731',64,1),('REPT580731','REPT580731',146,2),('REPT580731','REPT580731',156,1),('REPT580731','REPT580731',96,1),('REPT580731','REPT580731',102,1),('REPT580731','REPT580731',164,1),('REPT62751','REPT62751',49,1),('REPT700501','REPT700501',22,1),('REPT700501','REPT700501',51,1),('REPT761117','REPT761117',15,1),('REPT761117','REPT761117',117,1),('REPT761118Q','REPT761118Q',131,1),('REPT761127','REPT761127',21,3),('REPT761127','REPT761127',90,1),('REPT761127','REPT761127',84,2),('REPT761128','REPT761128',140,1),('REPT761128','REPT761128',84,4),('REPT761129','REPT761129',138,1),('REPT761129','REPT761129',84,2),('REPT761131','REPT761131',84,1),('REPT761132','REPT761132',84,2),('REPT761135','REPT761135',58,1),('REPT761135Q','REPT761135Q',99,1),('REPT761139','REPT761139',24,1),('REPT761140','REPT761140',135,1),('REPT761140','REPT761140',76,1),('REPT761140','REPT761140',105,1),('REPT761142','REPT761142',142,1),('REPT761142Q','REPT761142Q',112,1),('REPT761143','REPT761143',207,1),('REPT761143','REPT761143',61,1),('REPT761143','REPT761143',76,2),('REPT761143','REPT761143',98,1),('REPT761143','REPT761143',100,2),('REPT761144','REPT761144',15,1),('REPT761144','REPT761144',25,1),('REPT761144','REPT761144',30,1),('REPT761144','REPT761144',117,1),('REPT761144','REPT761144',139,1),('REPT761144','REPT761144',160,1),('REPT761144','REPT761144',172,1),('REPT761146','REPT761146',84,1),('REPT762210','REPT762210',164,1),('REPT762709','REPT762709',81,1),('REPT762719','REPT762719',102,1),('REPT762720','REPT762720',102,1),('REPT762751','REPT762751',112,1),('REPT762751','REPT762751',22,1),('REPT762751','REPT762751',30,1),('REPT762751','REPT762751',56,1),('REPT762751','REPT762751',57,3),('REPT762751','REPT762751',58,1),('REPT762751','REPT762751',61,1),('REPT762751','REPT762751',64,1),('REPT762751','REPT762751',143,1),('REPT762751','REPT762751',74,1),('REPT762751','REPT762751',75,2),('REPT762751','REPT762751',76,1),('REPT762751','REPT762751',77,1),('REPT762751','REPT762751',95,1),('REPT762751','REPT762751',99,1),('REPT762751','REPT762751',101,1),('REPT762751','REPT762751',104,1),('REPT762752','REPT762752',25,1),('REPT762752','REPT762752',30,1),('REPT762752','REPT762752',50,2),('REPT762752','REPT762752',64,1),('REPT762752','REPT762752',139,1),('REPT762752','REPT762752',75,5),('REPT762752','REPT762752',80,1),('REPT762752','REPT762752',99,1),('REPT763301','REPT763301',49,1),('REPT763701','REPT763701',22,2),('REPT763702','REPT763702',64,1),('REPT763702','REPT763702',100,1),('REPT764901','REPT764901',7,1),('REPT764901','REPT764901',146,1),('REPT764901','REPT764901',95,1),('REPT764901','REPT764901',176,1),('REPT764902','REPT764902',22,1),('REPT764905','REPT764905',43,1),('REPT764905','REPT764905',60,1),('REPT764907','REPT764907',85,1),('REPV015518','REPV015518',147,1),('REPV018912','REPV018912',65,1),('REPV018914','REPV018914',172,1),('REPV108610','REPV108610',35,1),('REPV130509','REPV130509',131,1),('REPV311302','REPV311302',53,1),('REPV311306','REPV311306',31,1),('REPV318401','REPV318401',56,1),('REPV462930','REPV462930',112,1),('REPV469501','REPV469501',22,1),('REPV469502','REPV469502',22,1),('REPV491707','REPV491707',15,1),('REPV731908Q','REPV731908Q',65,1),('REPV763504','REPV763504',63,1),('RF01310043','RF01310043',146,1),('RF01310073','RF01310073',21,1),('RF01310087Q','RF01310087Q',96,1),('RF01310088Q','RF01310088Q',96,1),('RF01310111','RF01310111',22,1),('RF01310111','RF01310111',25,1),('RF01310111','RF01310111',31,1),('RF01310111','RF01310111',63,1),('RF01310111','RF01310111',87,1),('RF01310111','RF01310111',160,1),('RF07270001','RF07270001',105,1),('RF07580001','RF07580001',87,1),('RF07580003','RF07580003',11,1),('RF07580013','RF07580013',20,1),('RF07580013','RF07580013',53,1),('RF07580013','RF07580013',207,1),('RF10750059A','RF10750059A',57,1),('RF10770009','RF10770009',57,1),('RF10980004','RF10980004',168,1),('RF11190011','RF11190011',160,1),('RF11190012','RF11190012',81,1),('RF13230006','RF13230006',51,1),('RF16290008','RF16290008',77,1),('RF22130028','RF22130028',20,1),('RF22130028','RF22130028',24,1),('RF22370014','RF22370014',7,1),('RF22370022','RF22370022',65,1),('RF25260004','RF25260004',176,1),('RF28050078','RF28050078',64,1),('RF31530001','RF31530001',168,1),('RF32100002','RF32100002',90,1),('RF45010013','RF45010013',22,1),('RF45330003','RF45330003',64,1),('RF46210001K','RF46210001K',36,2),('RF46210001K','RF46210001K',49,2),('RF46210001K','RF46210001K',50,1),('RF46210001K','RF46210001K',51,1),('RF46210001K','RF46210001K',57,1),('RF46210001K','RF46210001K',64,1),('RF46210001K','RF46210001K',77,1),('RF46210001K','RF46210001K',99,1),('RF46210002','RF46210002',30,1),('RF46210002','RF46210002',77,1),('RF46210002','RF46210002',101,1),('RF46290005','RF46290005',79,1),('RF46290023','RF46290023',36,1),('RF46290023','RF46290023',89,1),('RF46290023','RF46290023',98,1),('RF46290024','RF46290024',35,1),('RF47150007','RF47150007',164,1),('RF47170016','RF47170016',70,1),('RF47170020','RF47170020',50,1),('RF47170021','RF47170021',61,1),('RF47170021','RF47170021',95,1),('RF47170022','RF47170022',30,1),('RF54130005','RF54130005',77,1),('RF54390006','RF54390006',22,1),('RF76260003','RF76260003',115,1),('RF76690007','RF76690007',94,1),('RG01310005','RG01310005',11,1),('RG01310005','RG01310005',77,1),('RG01310034','RG01310034',57,1),('RG01590017','RG01590017',146,1),('RG05010007','RG05010007',29,1),('RG10810003','RG10810003',7,1),('RG10810003','RG10810003',25,1),('RG10810012','RG10810012',34,1),('RG10810022','RG10810022',134,1),('RG10810022','RG10810022',99,2),('RG10810027','RG10810027',51,1),('RG10810027','RG10810027',102,1),('RG10820001','RG10820001',59,1),('RG10820002','RG10820002',112,1),('RG10820002','RG10820002',36,1),('RG10820004','RG10820004',151,1),('RG10820008','RG10820008',65,1),('RG10820011','RG10820011',22,1),('RG10860001','RG10860001',93,1),('RG10860002','RG10860002',62,1),('RG10860002','RG10860002',169,1),('RG10860005','RG10860005',172,1),('RG13050004','RG13050004',88,1),('RG22370006','RG22370006',61,1),('RG47170002','RG47170002',30,1),('RG76350006','RG76350006',90,1),('RG76370003','RG76370003',116,1),('RG76370012','RG76370012',63,1),('RH01040001','RH01040001',69,1),('RH01310002','RH01310002',31,1),('RH01310077','RH01310077',34,1),('RH01310095','RH01310095',7,1),('RH01590089','RH01590089',64,1),('RH01590091','RH01590091',50,1),('RH01590092','RH01590092',63,2),('RH01610006','RH01610006',58,1),('RH01610012','RH01610012',25,1),('RH01610013','RH01610013',36,1),('RH01610029','RH01610029',57,1),('RH01610033','RH01610033',91,1),('RH01910005','RH01910005',163,1),('RH01910006','RH01910006',159,1),('RH02010006','RH02010006',58,1),('RH02010007','RH02010007',63,1),('RH04010002','RH04010002',33,1),('RH04010003','RH04010003',25,1),('RH04010003','RH04010003',90,1),('RH07010015','RH07010015',60,1),('RH07010020','RH07010020',105,1),('RH07010085Q','RH07010085Q',85,1),('RH07070003','RH07070003',155,1),('RH07070044','RH07070044',49,1),('RH07110002','RH07110002',207,1),('RH07270002','RH07270002',156,1),('RH10770005','RH10770005',31,1),('RH10790013','RH10790013',37,1),('RH10810011','RH10810011',21,1),('RH10810011','RH10810011',163,1),('RH10810016','RH10810016',112,1),('RH10810018','RH10810018',87,1),('RH10860008','RH10860008',34,1),('RH10860015','RH10860015',4,1),('RH10860016','RH10860016',4,1),('RH10860018','RH10860018',20,1),('RH10980005','RH10980005',90,1),('RH10980006','RH10980006',65,1),('RH11050001','RH11050001',160,1),('RH13030003','RH13030003',131,1),('RH13030007','RH13030007',35,1),('RH13050009','RH13050009',131,1),('RH13050010','RH13050010',131,1),('RH13050011','RH13050011',135,1),('RH16090008','RH16090008',4,1),('RH16090029','RH16090029',168,1),('RH16090041','RH16090041',79,1),('RH16090041','RH16090041',157,1),('RH16230001','RH16230001',50,1),('RH16230022','RH16230022',34,1),('RH16290001','RH16290001',77,1),('RH16290007','RH16290007',64,1),('RH22130007','RH22130007',18,1);
INSERT INTO _plan (part_key,part_display,location_pk,qty) VALUES ('RH22370003','RH22370003',65,1),('RH22370005','RH22370005',122,1),('RH25090003','RH25090003',51,1),('RH25170001','RH25170001',156,1),('RH25270001','RH25270001',20,1),('RH27090001','RH27090001',60,1),('RH28210037','RH28210037',50,2),('RH31220001','RH31220001',61,1),('RH31500001','RH31500001',51,1),('RH370500204','RH370500204',64,1),('RH37050024','RH37050024',11,1),('RH37050024','RH37050024',160,1),('RH37050037','RH37050037',151,1),('RH46290015','RH46290015',24,1),('RH46290015','RH46290015',51,1),('RH46290061','RH46290061',146,1),('RH46290120','RH46290120',59,1),('RH46290130','RH46290130',35,1),('RH47150003','RH47150003',35,1),('RH47150004','RH47150004',91,1),('RH47170003','RH47170003',127,1),('RH47170014','RH47170014',89,1),('RH50250002','RH50250002',89,1),('RH55470001','RH55470001',98,1),('RH76110001Q','RH76110001Q',93,1),('RH76110002','RH76110002',119,1),('RH76260005','RH76260005',7,1),('RH76260005','RH76260005',51,1),('RH76260006','RH76260006',7,1),('RH76260007','RH76260007',22,1),('RH76260007','RH76260007',51,1),('RH76260008','RH76260008',31,1),('RH76260010Q','RH76260010Q',65,1),('RH76260013','RH76260013',51,1),('RH76260013','RH76260013',65,1),('RH76260014','RH76260014',51,1),('RH76260014','RH76260014',65,1),('RH76270019','RH76270019',139,1),('RH76270032','RH76270032',164,1),('RH76270033','RH76270033',176,1),('RH76350013','RH76350013',20,1),('RH76350015','RH76350015',111,1),('RH76370019','RH76370019',77,1),('RH76370021','RH76370021',51,1),('RH76370022','RH76370022',116,1),('RH76370022','RH76370022',147,1),('RI01440002','RI01440002',131,1),('RI01470011','RI01470011',37,1),('RI10820001','RI10820001',35,1),('RI10820001','RI10820001',150,1),('RI10820001','RI10820001',88,1),('RI13050005','RI13050005',131,1),('RI22210003','RI22210003',96,1),('RI22210005','RI22210005',67,1),('RI25050003','RI25050003',64,1),('RI49170002','RI49170002',24,1),('RI76690002','RI76690002',101,1),('RJ01310009','RJ01310009',111,1),('RJ01310013','RJ01310013',15,1),('RJ01730001','RJ01730001',16,1),('RJ01730001','RJ01730001',112,1),('RJ01730001','RJ01730001',22,1),('RJ01730001','RJ01730001',35,2),('RJ01730001','RJ01730001',65,1),('RJ02030004','RJ02030004',37,1),('RJ02030013','RJ02030013',35,1),('RJ02030013','RJ02030013',101,1),('RJ04170002','RJ04170002',152,1),('RJ07070001','RJ07070001',47,1),('RJ10790004','RJ10790004',53,1),('RJ108100008','RJ108100008',94,1),('RJ10810003','RJ10810003',65,1),('RJ10990001','RJ10990001',168,1),('RJ10990002','RJ10990002',102,1),('RJ16090005','RJ16090005',93,1),('RJ22210035','RJ22210035',109,1),('RJ22370002','RJ22370002',12,1),('RJ25170002','RJ25170002',11,1),('RJ31350001','RJ31350001',113,1),('RJ46290004','RJ46290004',97,1),('RJ46290006','RJ46290006',21,1),('RJ46390003','RJ46390003',64,1),('RJ46390004','RJ46390004',64,1),('RJ54130001','RJ54130001',37,3),('RJ54210001','RJ54210001',63,1),('RJ54210002','RJ54210002',51,1),('RJ7070011','RJ7070011',31,1),('RJ76270016','RJ76270016',50,1),('RJ76350005','RJ76350005',20,1),('RJ76690002','RJ76690002',58,1),('RJ76690002','RJ76690002',163,1),('RK01310051','RK01310051',77,1),('RK01310052','RK01310052',77,1),('RK01590013','RK01590013',28,1),('RK07010052','RK07010052',20,1),('RK10820012','RK10820012',25,1),('RK13030002','RK13030002',53,1),('RK13050015','RK13050015',37,1),('RK13050016','RK13050016',37,1),('RK16230007','RK16230007',90,1),('RK22470001','RK22470001',160,1),('RK37050022','RK37050022',130,1),('RK37050022','RK37050022',60,1),('RK37050022','RK37050022',151,1),('RK51070012','RK51070012',85,1),('RK73490038','RK73490038',63,1),('RK76260025','RK76260025',131,1),('RK76260030','RK76260030',51,1),('RK76260033','RK76260033',7,1),('RK76270012','RK76270012',95,1),('RK76270019','RK76270019',87,1),('RK76270020','RK76270020',22,1),('RK76270020','RK76270020',87,1),('RK76350015','RK76350015',65,1),('RK76350016','RK76350016',65,1),('RK76370001','RK76370001',172,1),('RL01030124P','RL01030124P',4,1),('RL01250010','RL01250010',18,1),('RL01310037','RL01310037',88,1),('RL01310041','RL01310041',147,1),('RL01310052','RL01310052',176,1),('RL01530021','RL01530021',20,1),('RL01530022','RL01530022',131,1),('RL01550009','RL01550009',55,1),('RL01550010','RL01550010',64,2),('RL01550010','RL01550010',172,1),('RL01550011','RL01550011',30,1),('RL01550011','RL01550011',135,1),('RL01550011','RL01550011',71,1),('RL01550012','RL01550012',54,1),('RL01550013','RL01550013',139,1),('RL01550018','RL01550018',37,1),('RL01550020','RL01550020',50,1),('RL01550020','RL01550020',62,1),('RL01610005','RL01610005',104,1),('RL01610006','RL01610006',65,1),('RL01610008','RL01610008',135,1),('RL01610008','RL01610008',91,1),('RL01610008','RL01610008',176,1),('RL01730008','RL01730008',134,1),('RL01730008','RL01730008',147,1),('RL01730042','RL01730042',15,1),('RL07070008','RL07070008',105,1),('RL10770002','RL10770002',127,1),('RL10810007','RL10810007',20,1),('RL10810008','RL10810008',16,1),('RL10810008','RL10810008',131,1),('RL10810008','RL10810008',50,1),('RL10810015','RL10810015',34,1),('RL10820005','RL10820005',35,1),('RL10820006','RL10820006',57,1),('RL10820008','RL10820008',65,1),('RL13230004','RL13230004',43,1),('RL16230003','RL16230003',34,1),('RL16230005','RL16230005',49,1),('RL16330002','RL16330002',111,1),('RL16330002','RL16330002',79,1),('RL22210002','RL22210002',65,1),('RL22210003','RL22210003',122,1),('RL22210004','RL22210004',122,1),('RL22210034','RL22210034',111,1),('RL25050013','RL25050013',49,1),('RL25270001','RL25270001',148,1),('RL25270002','RL25270002',139,1),('RL37050005','RL37050005',75,1),('RL37050009','RL37050009',43,1),('RL46290010','RL46290010',161,1),('RM01310004','RM01310004',101,1),('RM01310007','RM01310007',65,1),('RM01310007','RM01310007',172,1),('RM01310008','RM01310008',172,1),('RM01310014','RM01310014',74,1),('RM01310018','RM01310018',161,1),('RM01310027','RM01310027',101,1),('RM01310028','RM01310028',56,1),('RM01310052','RM01310052',58,1),('RM01310052','RM01310052',62,1),('RM01310062','RM01310062',65,1),('RM01310076','RM01310076',38,1),('RM01440022','RM01440022',81,1),('RM01530046','RM01530046',72,1),('RM01530103','RM01530103',50,1),('RM01540015','RM01540015',22,1),('RM01550005','RM01550005',65,1),('RM01550013','RM01550013',108,1),('RM01590043','RM01590043',31,1),('RM01590043','RM01590043',81,1),('RM01590067','RM01590067',65,1),('RM01590074','RM01590074',57,1),('RM01590075','RM01590075',64,1),('RM01590110','RM01590110',139,1),('RM01610032','RM01610032',97,1),('RM01610068','RM01610068',61,1),('RM01610068','RM01610068',164,1),('RM01730005','RM01730005',31,1),('RM01730020','RM01730020',35,1),('RM01730034','RM01730034',115,1),('RM01730034','RM01730034',49,1),('RM01730034','RM01730034',207,1),('RM01730034','RM01730034',65,1),('RM01730034','RM01730034',74,1),('RM01730034','RM01730034',89,1),('RM01730034','RM01730034',96,1),('RM01730036','RM01730036',168,1),('RM01730039','RM01730039',131,1),('RM01730050','RM01730050',172,1),('RM01730060','RM01730060',49,1),('RM01730060','RM01730060',65,1),('RM01910002','RM01910002',121,1),('RM01910023','RM01910023',65,1),('RM02030001','RM02030001',161,1),('RM02030002','RM02030002',135,1),('RM02030002','RM02030002',89,1),('RM07010016','RM07010016',32,1),('RM07070016','RM07070016',43,1),('RM07070027','RM07070027',77,1),('RM07070028','RM07070028',77,1),('RM07070032','RM07070032',50,1),('RM07070035','RM07070035',136,1),('RM07070036','RM07070036',19,1),('RM10700001','RM10700001',51,1),('RM10750015A','RM10750015A',77,1),('RM10810025','RM10810025',25,1),('RM10810036','RM10810036',20,1),('RM10810036','RM10810036',89,1),('RM10930076','RM10930076',64,1),('RM10980007','RM10980007',126,1),('RM13030005','RM13030005',158,1),('RM13230004','RM13230004',51,1),('RM16230002','RM16230002',160,1),('RM22050001','RM22050001',168,1),('RM22130013','RM22130013',32,1),('RM22130013','RM22130013',77,1),('RM22130013','RM22130013',93,1),('RM22130014','RM22130014',105,1),('RM25010011','RM25010011',135,1),('RM47150008','RM47150008',172,1),('RM49170007','RM49170007',32,1),('RM76270020','RM76270020',51,1),('RM76270024','RM76270024',64,1),('RM76270052','RM76270052',101,1),('RM76350063','RM76350063',40,1),('RM76370003','RM76370003',108,1),('RM76370003','RM76370003',25,1),('RM76370003','RM76370003',146,1),('RM76370004','RM76370004',71,1),('RM76370006','RM76370006',109,1),('RM76690011','RM76690011',116,1),('RM76690012','RM76690012',116,1),('RM76690017','RM76690017',65,1),('RMA27379','RMA27379',92,1),('RN01310034','RN01310034',25,1),('RN01310042','RN01310042',176,1),('RN0159004','RN0159004',20,1),('RN01730001','RN01730001',65,1),('RN01730016','RN01730016',49,1),('RN07580001','RN07580001',90,1),('RN10010029Q','RN10010029Q',155,1),('RN10770011','RN10770011',31,1),('RN10770032','RN10770032',104,1),('RN10820003','RN10820003',100,1),('RN10860005','RN10860005',172,1),('RN13030001','RN13030001',52,1),('RN13030002','RN13030002',52,1),('RN13050011','RN13050011',61,1),('RN13050012','RN13050012',97,1),('RN13050013','RN13050013',146,1),('RN13050014','RN13050014',146,1),('RN13050014','RN13050014',160,1),('RN13230004','RN13230004',164,1),('RN16270001','RN16270001',33,1),('RN16270002','RN16270002',111,1),('RN16270002','RN16270002',53,1),('RN16270002','RN16270002',172,1),('RN22170004','RN22170004',101,1),('RN22210033','RN22210033',30,1),('RN22210034','RN22210034',30,1),('RN22370005','RN22370005',43,1),('RN22370005','RN22370005',90,1),('RN22370006','RN22370006',123,1),('RN22370006','RN22370006',43,1),('RN22370012','RN22370012',51,1),('RN25010001Q','RN25010001Q',29,1),('RN25050007Q','RN25050007Q',57,1),('RN37050032','RN37050032',59,1),('RN37050034','RN37050034',130,1),('RN46290008','RN46290008',146,1),('RN49170010','RN49170010',164,1),('RN50920002','RN50920002',25,1),('RN50920002','RN50920002',63,1),('RN51070006','RN51070006',28,1),('RN55390003','RN55390003',85,1),('RN55390004','RN55390004',85,3),('RN61090001','RN61090001',172,1),('RN76210003','RN76210003',84,1),('RN76260001','RN76260001',30,1),('RN76260005','RN76260005',30,1),('RN76260008','RN76260008',168,1),('RN76270027','RN76270027',57,1),('RN76270028','RN76270028',172,1),('RN76270029','RN76270029',112,1),('RO1039108','RO1039108',51,1),('RO3126103','RO3126103',43,1),('RR01310002','RR01310002',20,1),('RR22370002','RR22370002',51,1),('RS07010006Q','RS07010006Q',7,1),('RS07580003','RS07580003',165,1),('RS10810007','RS10810007',65,1),('RS28150052','RS28150052',32,2),('RS46290004','RS46290004',25,1),('RT01030081','RT01030081',51,1),('RT01030081','RT01030081',172,1),('RT01030082','RT01030082',51,1),('RT01110001','RT01110001',22,1),('RT01110001','RT01110001',25,1),('RT01110001','RT01110001',37,1),('RT01110001','RT01110001',57,1),('RT01110001','RT01110001',64,1),('RT01110001','RT01110001',96,1),('RT01110001','RT01110001',160,1),('RT01270001','RT01270001',160,1),('RT01270002','RT01270002',176,1),('RT01300002','RT01300002',151,1),('RT01300002','RT01300002',102,1),('RT0130002','RT0130002',89,1),('RT01310007','RT01310007',57,1),('RT01310007','RT01310007',172,1),('RT01310008','RT01310008',37,1),('RT01310008Q','RT01310008Q',64,1),('RT01310017','RT01310017',43,1),('RT01310018','RT01310018',25,1),('RT01310018','RT01310018',55,1),('RT01310030','RT01310030',176,1),('RT01310032','RT01310032',65,1),('RT01310049','RT01310049',135,1),('RT01310067','RT01310067',11,1),('RT01310083','RT01310083',81,1),('RT01330002','RT01330002',176,1),('RT01490008','RT01490008',164,1),('RT01550003','RT01550003',51,1),('RT01550004','RT01550004',168,1),('RT01590007','RT01590007',47,1),('RT01590007','RT01590007',85,1),('RT01590011Q','RT01590011Q',34,1),('RT01590016','RT01590016',112,1),('RT01590016','RT01590016',132,1),('RT01590044','RT01590044',91,1),('RT01590049','RT01590049',61,1),('RT01590050','RT01590050',99,1),('RT01590050','RT01590050',176,1),('RT01590068','RT01590068',59,1),('RT01590069','RT01590069',160,1),('RT01590069Q','RT01590069Q',29,1),('RT01590070','RT01590070',64,1),('RT01730025','RT01730025',112,1),('RT01730025','RT01730025',101,1),('RT01730056','RT01730056',34,1),('RT0201005','RT0201005',21,1),('RT10770005','RT10770005',18,1),('RT10770005','RT10770005',38,1),('RT10770005','RT10770005',163,1),('RT10770006','RT10770006',58,1),('RT10770007','RT10770007',139,1),('RT10810018','RT10810018',22,1),('RT10810041','RT10810041',176,1),('RT10820000','RT10820000',51,1),('RT10820005','RT10820005',51,1),('RT10820019','RT10820019',98,1),('RT10860011','RT10860011',30,1),('RT10860011','RT10860011',65,1),('RT10860014','RT10860014',139,1),('RT10990007','RT10990007',65,1),('RT13230005','RT13230005',30,1),('RT13230006','RT13230006',35,1),('RT13230006','RT13230006',52,1),('RT13230006','RT13230006',161,1),('RT13230011','RT13230011',25,1),('RT13230021','RT13230021',31,1),('RT16030008','RT16030008',117,1),('RT16090005','RT16090005',24,1),('RT16090005','RT16090005',18,1),('RT16330001','RT16330001',147,1),('RT16340001','RT16340001',49,1),('RT16340001','RT16340001',65,1),('RT22210021','RT22210021',10,1),('RT22210062-A','RT22210062-A',161,1),('RT25090012','RT25090012',64,1),('RT25270011','RT25270011',21,1),('RT25270012','RT25270012',161,1),('RT25270022','RT25270022',138,1),('RT25270022','RT25270022',151,1),('RT28080057','RT28080057',7,1),('RT2810001','RT2810001',127,1),('RT28150002','RT28150002',18,1),('RT28150008','RT28150008',18,1),('RT28150013','RT28150013',15,1),('RT28150013','RT28150013',116,1),('RT28150014','RT28150014',15,1),('RT28150014','RT28150014',116,1),('RT28150014','RT28150014',62,1);
INSERT INTO _plan (part_key,part_display,location_pk,qty) VALUES ('RT28150028','RT28150028',61,1),('RT31010037','RT31010037',119,1),('RT31010037','RT31010037',31,1),('RT32040001','RT32040001',56,1),('RT37050013','RT37050013',75,1),('RT42170014','RT42170014',51,1),('RT45490002','RT45490002',71,1),('RT46290003','RT46290003',29,1),('RT46290006','RT46290006',51,1),('RT46290082','RT46290082',150,1),('RT46390004','RT46390004',98,1),('RT46390006','RT46390006',30,1),('RT48010003','RT48010003',11,1),('RT51070024','RT51070024',113,1),('RT54210011','RT54210011',80,1),('RT5539002','RT5539002',62,1),('RT63050001','RT63050001',1,1),('RT63050001','RT63050001',24,2),('RT70020001','RT70020001',48,1),('RT76110001','RT76110001',7,1),('RT76110001','RT76110001',112,1),('RT76110001','RT76110001',71,2),('RT76110001','RT76110001',76,1),('RT76110002','RT76110002',4,1),('RT76110002','RT76110002',115,1),('RT76110002','RT76110002',71,2),('RT76110002','RT76110002',76,1),('RT76110002Q','RT76110002Q',74,1),('RT76260005','RT76260005',65,1),('RT76270011','RT76270011',22,1),('RT76270019','RT76270019',88,1),('RT76330006','RT76330006',74,1),('RT76350011','RT76350011',18,2),('RT76490001','RT76490001',85,1),('RU-445','RU-445',136,1),('RV01110022-HD','RV01110022-HD',24,1),('RV01310010','RV01310010',32,1),('RV01310016','RV01310016',22,1),('RV01310016','RV01310016',57,1),('RV01530018','RV01530018',156,1),('RV01530018','RV01530018',94,1),('RV01530041','RV01530041',51,1),('RV01550017','RV01550017',112,1),('RV01550017','RV01550017',126,1),('RV01550017','RV01550017',131,1),('RV01590002','RV01590002',35,1),('RV01590002','RV01590002',49,1),('RV01610009','RV01610009',62,1),('RV01610009','RV01610009',65,1),('RV01730003','RV01730003',143,1),('RV01730004','RV01730004',172,1),('RV01730011','RV01730011',32,1),('RV10790001','RV10790001',30,1),('RV10820008','RV10820008',101,1),('RV10860004','RV10860004',65,1),('RV10860006','RV10860006',22,1),('RV10990001','RV10990001',43,1),('RV10990001','RV10990001',99,1),('RV10990002','RV10990002',164,2),('RV10990009','RV10990009',51,1),('RV10990009','RV10990009',64,1),('RV10990010','RV10990010',64,1),('RV13050001','RV13050001',22,1),('RV22210047','RV22210047',54,1),('RV22370016','RV22370016',156,1),('RV31820001','RV31820001',176,1),('RV46290009','RV46290009',156,1),('RV47150008','RV47150008',89,1),('RV47150011','RV47150011',36,1),('RV47170011','RV47170011',172,1),('RV54390005','RV54390005',207,1),('RV54390011','RV54390011',111,1),('RV55390003','RV55390003',109,1),('RV55390003','RV55390003',1,1),('RV55390004','RV55390004',1,1),('RV76220003','RV76220003',131,1),('RV76350014','RV76350014',138,1),('RV76350027','RV76350027',65,1),('RV76370007','RV76370007',51,1),('S070119','S070119',18,1),('S107902','S107902',96,2),('S222153','S222153',160,1),('S462911','S462911',7,1),('S462912','S462912',7,1),('SC2591006','SC2591006',112,1),('SCIA-CAM-16-R','SCIA-CAM-16-R',109,1),('SHE0054-300-2','SHE0054-300-2',176,1),('SHE088-350U','SHE088-350U',58,1),('SHE2913J-95-1','SHE2913J-95-1',116,1),('SHE3305-24-1','SHE3305-24-1',123,1),('SHE332-850SETQU','SHE332-850SETQU',102,1),('SHE332E-320GR','SHE332E-320GR',25,1),('SHE633A-24L','SHE633A-24L',164,1),('SHE8174-83A-0','SHE8174-83A-0',31,1),('SHE901-49A','SHE901-49A',56,1),('SHE902-351','SHE902-351',20,1),('SHE902-84FU','SHE902-84FU',57,1),('SHE932A-84CL','SHE932A-84CL',99,1),('SHEHOCRV17-92M-1','SHEHOCRV17-92M-1',104,1),('SHEKIFORT10-24-1','SHEKIFORT10-24-1',111,1),('SHEMBC30015B-98-0','SHEMBC30015B-98-0',81,1),('SHENIALTI19A-99-0','SHENIALTI19A-99-0',1,1),('SHEPOMACA15-84G-0','SHEPOMACA15-84G-0',54,1),('SHETOHIGH20-49AQ-1','SHETOHIGH20-49AQ-1',29,1),('SN0059543287','SN0059543287',164,1),('ST27EL','ST27EL',32,1),('STPN27110033','STPN27110033',56,2),('STPSSCOP333','STPSSCOP333',56,1),('STPSSCP1632','STPSSCP1632',147,1),('STPSSCP729','STPSSCP729',176,1),('STYCV1417MC02','STYCV1417MC02',62,1),('STYCV1417MC06','STYCV1417MC06',7,1),('STYCV1417MC06','STYCV1417MC06',61,1),('STYCV1417MC06','STYCV1417MC06',100,1),('SU1039104','SU1039104',143,1),('SU1070114','SU1070114',85,1),('SU1237108','SU1237108',36,1),('SU1246103','SU1246103',172,1),('SU1320168','SU1320168',37,1),('SU15ER','SU15ER',57,1),('SU17EL','SU17EL',157,5),('SU2503172C','SU2503172C',144,1),('SU42ER','SU42ER',24,1),('SU56ER-S','SU56ER-S',60,1),('T011113','T011113',127,1),('T013138','T013138',64,1),('T013159','T013159',53,1),('T013165','T013165',176,1),('T013172','T013172',74,1),('T013174','T013174',25,1),('T160317','T160317',20,1),('T222101','T222101',145,1),('T222158','T222158',138,1),('T222176','T222176',122,1),('T222177','T222177',104,1),('T250901','T250901',11,1),('T310123','T310123',29,1),('T462178','T462178',57,1),('T491315','T491315',168,1),('T580503','T580503',105,1),('T580702','T580702',131,1),('T762115','T762115',152,1),('TO1033124','TO1033124',65,1),('TO1038209','TO1038209',168,1),('TO1038242','TO1038242',104,1),('TO1039136','TO1039136',152,1),('TO1039209','TO1039209',57,1),('TO1039278','TO1039278',65,1),('TO1042148','TO1042148',84,1),('TO1042154','TO1042154',65,1),('TO1044127','TO1044127',50,1),('TO1046110','TO1046110',91,1),('TO1046113','TO1046113',63,1),('TO1046114','TO1046114',31,1),('TO1046128','TO1046128',147,1),('TO1047113','TO1047113',25,1),('TO1047113','TO1047113',93,1),('TO1047127','TO1047127',86,1),('TO1047128','TO1047128',147,1),('TO1047128','TO1047128',159,1),('TO1047129','TO1047129',33,1),('TO1063110C','TO1063110C',57,1),('TO10661778','TO10661778',11,1),('TO1066186','TO1066186',134,1),('TO1066190','TO1066190',22,1),('TO1067112','TO1067112',147,1),('TO1103138','TO1103138',43,1),('TO1104135','TO1104135',58,1),('TO1116108C','TO1116108C',167,1),('TO1116109','TO1116109',46,1),('TO1116113','TO1116113',67,1),('TO1117109C','TO1117109C',110,1),('TO1167118','TO1167118',65,1),('TO1190102','TO1190102',84,1),('TO1190103','TO1190103',148,1),('TO119012','TO119012',109,1),('TO1200411','TO1200411',144,1),('TO1216103','TO1216103',104,1),('TO1225396OE','TO1225396OE',20,1),('TO1228207C','TO1228207C',43,1),('TO1228276','TO1228276',116,1),('TO1230207','TO1230207',31,1),('TO1237130','TO1237130',35,1),('TO1244135','TO1244135',164,1),('TO124812','TO124812',156,1),('TO1248162','TO1248162',122,1),('TO1248227','TO1248227',169,1),('TO1249227','TO1249227',139,1),('TO1288180','TO1288180',16,1),('TO1288192','TO1288192',75,1),('TO1320122','TO1320122',37,1),('TO1320367','TO1320367',172,1),('TO1321182','TO1321182',12,1),('TO1321308','TO1321308',118,1),('TO1321349','TO1321349',3,1),('TO1321387','TO1321387',123,1),('TO1324125','TO1324125',150,1),('TO1326162','TO1326162',106,1),('TO132O334','TO132O334',143,1),('TO1350164','TO1350164',116,1),('TO1353102','TO1353102',2,1),('TO1357106','TO1357106',87,1),('TO1551139','TO1551139',175,1),('TO1820160','TO1820160',134,1),('TO1916118','TO1916118',43,1),('TO2030118','TO2030118',11,1),('TO2502212','TO2502212',30,1),('TO2503165C','TO2503165C',126,1),('TO2503202C','TO2503202C',172,1),('TO2503209','TO2503209',16,1),('TO2503312C','TO2503312C',156,1),('TO2503347','TO2503347',30,1),('TO2519197C','TO2519197C',30,1),('TO2532111C','TO2532111C',12,1),('TO2532116','TO2532116',12,1),('TO2800210','TO2800210',93,1),('TO2803112C','TO2803112C',137,1),('TO2803180','TO2803180',134,1),('TO2813120','TO2813120',148,1),('TO2819116','TO2819116',64,1),('TO2883102C','TO2883102C',122,1),('TO3010202','TO3010202',47,1),('TO3110114','TO3110114',1,1),('TO3110114','TO3110114',79,1),('TOHLR-MR2-18-P1L','TOHLR-MR2-18-P1L',85,1),('TOPUP-MR2-89-C2R','TOPUP-MR2-89-C2R',37,1),('TORV4-MR2-19-P2R','TORV4-MR2-19-P2R',130,1),('TOSQI-MR2-01-P1L','TOSQI-MR2-01-P1L',164,1),('TY100ER','TY100ER',127,1),('TY1032-U000L','TY1032-U000L',3,1),('TY1032-U000L','TY1032-U000L',30,1),('TY1032-U000L','TY1032-U000L',131,5),('TY1032-U000L','TY1032-U000L',51,1),('TY1032-U000L','TY1032-U000L',94,1),('TY1032-U000L','TY1032-U000L',98,1),('TY1032-U000L','TY1032-U000L',168,1),('TY1032-U000L','TY1032-U000L',172,2),('TY1032-U000L','TY1032-U000L',176,1),('TY108ER-S','TY108ER-S',63,1),('TY1157-U000R','TY1157-U000R',172,1),('TY1225-B000R','TY1225-B000R',163,1),('TY1287-B131L','TY1287-B131L',118,1),('TY136EL-S','TY136EL-S',95,1),('TY1382-A101L','TY1382-A101L',20,1),('TY141EL','TY141EL',87,1),('TY1436-B100R','TY1436-B100R',4,1),('TY171CR','TY171CR',75,1),('TY222EL-S','TY222EL-S',61,1),('TY240GL','TY240GL',63,1),('TY260ER-S','TY260ER-S',51,1),('TY3160','TY3160',85,1),('TY422-B000L','TY422-B000L',107,1),('TY4515A','TY4515A',92,1),('TY46035AR','TY46035AR',64,1),('TY531-B000R','TY531-B000R',173,1),('TY667-U000L','TY667-U000L',69,1),('TY677-B000R','TY677-B000R',160,1),('TY683-B00DR','TY683-B00DR',72,1),('TY688-B000L','TY688-B000L',107,1),('TY688-B000L','TY688-B000L',72,5),('TY688-B000L','TY688-B000L',97,1),('TY688-B000L','TY688-B000L',104,1),('TY692-B1012','TY692-B1012',40,1),('TY716-B001L','TY716-B001L',107,1),('TY716-B001L','TY716-B001L',69,1),('TY716-B001L','TY716-B001L',70,1),('TY739-U000L','TY739-U000L',172,1),('TY739-U100L','TY739-U100L',12,1),('TY739-U100L','TY739-U100L',147,1),('TY739-U100R','TY739-U100R',35,1),('TY739-U100R','TY739-U100R',156,1),('TY745-A001L','TY745-A001L',104,1),('TY809-B000L','TY809-B000L',70,1),('TY812-B001R','TY812-B001R',86,1),('TY964-B000R','TY964-B000R',68,2),('TY973-B001R','TY973-B001R',107,1),('TY973-B001R','TY973-B001R',48,1),('TY973-B001R','TY973-B001R',69,1),('V462925','V462925',97,1),('VA0194409','VA0194409',144,1),('VO1039109','VO1039109',151,1),('VO1087100','VO1087100',63,1),('VO2592106','VO2592106',64,1),('VV05GR','VV05GR',99,1),('VW1038106','VW1038106',116,1),('VW1039149','VW1039149',62,1),('VW1039152','VW1039152',99,1),('VW1047109','VW1047109',138,1),('VW1058100','VW1058100',134,1),('VW115ER','VW115ER',138,1),('VW116EL','VW116EL',126,1),('VW116EL','VW116EL',72,1),('VW1184109','VW1184109',106,1),('VW1320156','VW1320156',135,1),('VW1321117','VW1321117',8,1),('VW1321146','VW1321146',163,1),('VW1321146','VW1321146',169,3),('VW17L','VW17L',15,1),('VW2551104','VW2551104',52,1),('VW2801110','VW2801110',99,1),('VW28EL','VW28EL',63,1),('VW3010143','VW3010143',1,1),('VW3115111','VW3115111',115,1),('VW53EL-S','VW53EL-S',156,1),('VW53EL-S','VW53EL-S',176,1),('VW55ER-S','VW55ER-S',51,1),('VW65GL','VW65GL',64,1),('VW75ER-S','VW75ER-S',81,1),('VW78ER-S','VW78ER-S',57,1),('W0133-1850220','W0133-1850220',112,1),('W610058','W610058',35,1);
INSERT INTO _newp (product_id,spn,partslink,supplier) VALUES ('008340-1917L-AS','008340-1917L-AS','MB2800142','DEPO'),('1-03273','1-03273','1-03273','TYC'),('1-06484','1-06484','1-06484','TYC'),('11-6315-91','11-6315-91','FO2819148','TYC'),('11-6316-91','11-6316-91','FO2818148','TYC'),('117-2019L-AQN','117-2019L-AQN','HO2592149','DEPO'),('13783','13783','BM3010201','TYC'),('13924','13924','CH3010394','TYC'),('1494-1','1494-1','AC1248102','TYC'),('150230-A','150230-A','150230-A','TYC'),('17-5394-00-9','17-5394-00-9','TO2802113C','TYC'),('18-5894-01-9','18-5894-01-9','FO2520171C','TYC'),('19-6181-00','19-6181-00','VO2593125','TYC'),('19-6282-00','19-6282-00','FO2592248','TYC'),('20-17072-90','20-17072-90','LX2502177','TYC'),('20-3076-00-9','20-3076-00-9','FO2503130C','TYC'),('20-6757-91-9','20-6757-91-9','TO2503168','TYC'),('20-9749-70','20-9749-70','TO2503266','TYC'),('20180730','20180730','20180730','TYC'),('215-2047L-AS','215-2047L-AS','NI2592138','DEPO'),('220452','220452','TO2502315','TYC'),('3000032','3000032','FO1320124','TYC'),('30088','30088','FO3030266','TYC'),('30200','30200','KI3030158','TYC'),('30259','30259','TO3030350','TYC'),('30269','30269','FO3030282','TYC'),('312-11AEL-AS1N','312-11AEL-AS1N','TO2502284','DEPO'),('312-11AXL-ACN9','312-11AXL-ACN9','TO2502299C','DEPO'),('312-11BHL-UC2','312-11BHL-UC2','TO2518197','DEPO'),('312-11BYL-AC2','312-11BYL-AC2','TO2502313','DEPO'),('312-11C2L-AS1','312-11C2L-AS1','TO2502199','DEPO'),('312-11CGL-ASN2','312-11CGL-ASN2','TO2502327','DEPO'),('312-11CTL-AS2','312-11CTL-AS2','TO2502345','DEPO'),('312-11D8LMACMN','312-11D8LMACMN','TO2502220C','DEPO'),('312-1322R-AC-PR','312-1322R-AC-PR','TO2803135C','DEPO'),('312-1336L-US','312-1336L-US','TO2802150','DEPO'),('312-1338L-AS2','312-1338L-AS2','TO2802170','DEPO'),('312-1338R-AS2','312-1338R-AS2','TO2803170','DEPO'),('312-2019R-AS','312-2019R-AS','LX2593103','DEPO'),('312-2037L-AS','312-2037L-AS','TO2592146','DEPO'),('312-5437L3EBH2','312-5437L3EBH2','TO1320209','DEPO'),('312-5440L3EB','312-5440L3EB','TO1320293','DEPO'),('312-5456L3EBH2','312-5456L3EBH2','TO1320395','DEPO'),('312-55023-301','312-55023-301','TO3110142','DEPO'),('3121-0497-4203','3121-0497-4203','TO1321422','DEPO'),('315-11BML-AC2','315-11BML-AC2','NI2502283','DEPO'),('315-1977R-AS','315-1977R-AS','NI2801195','DEPO'),('315-19AHL-AC','315-19AHL-AC','NI2804126C','DEPO'),('315-2036L-AS','315-2036L-AS','NI2592141','DEPO'),('315-5413R3EBH1','315-5413R3EBH1','NI1321161','DEPO'),('315-5439R3EBH2','315-5439R3EBH2','NI1321312','DEPO'),('3151-0347-4201','3151-0347-4201','NI1321327','DEPO'),('316-1158R-ASN2','316-1158R-ASN2','MA2503149','DEPO'),('316-1160LMUSM2','316-1160LMUSM2','MA2502151','DEPO'),('317-1127R-UC','317-1127R-UC','HO2519104C','DEPO'),('317-1176L-AC2','317-1176L-AC2','HO2502168C','DEPO'),('317-1349L-AC2','317-1349L-AC2','HO2802136C','DEPO'),('317-19AKL-AS','317-19AKL-AS','HO2804116','DEPO'),('317-19ANR-AS2','317-19ANR-AS2','HO2805131','DEPO'),('317-19AUL-AC2','317-19AUL-AC2','HO2804132C','DEPO'),('317-19AZR-AS','317-19AZR-AS','HO2805128','DEPO'),('317-2061L-AC','317-2061L-AC','HO2592145C','DEPO'),('317-5420L3EB2','317-5420L3EB2','HO1320259','DEPO'),('3171-0301-4200','3171-0301-4200','HO1321285','DEPO'),('32-317-1195L4UD','32-317-1195L4UD','HO2508121','DEPO'),('32-317-1195R4UD','32-317-1195R4UD','HO2509121','DEPO'),('32-317-1198R4UD','32-317-1198R4UD','HO1043151','DEPO'),('320-1131LMASM2','320-1131LMASM2','SU2502165','DEPO'),('320-2023L-AC','320-2023L-AC','SU2592130C','DEPO'),('321-1160RXAS2','321-1160RXAS2','HY2503204','DEPO'),('321-1340L-AS','321-1340L-AS','HY2882107','DEPO'),('321-1340R-AS','321-1340R-AS','HY2883107','DEPO'),('323-1180LXAS2','323-1180LXAS2','KI2502254','DEPO'),('323-1180RXAS2','323-1180RXAS2','KI2503254','DEPO'),('323-1942L-AC','323-1942L-AC','KI2804109','DEPO'),('323-2925R-UC','323-2925R-UC','KI1185121C','DEPO'),('324-1141R-UC2','324-1141R-UC2','LX2503190C','DEPO'),('324-1145R-AS2','324-1145R-AS2','LX2503196','DEPO'),('327-55023-100','327-55023-100','AC3115130','DEPO'),('330-2905L-US','330-2905L-US','FO1184100','DEPO'),('331-1979R-AS','331-1979R-AS','FO2801203','DEPO'),('333-1197RMASHM7','333-1197RMASHM7','CH2503252','DEPO'),('334-1143L-AC2','334-1143L-AC2','CH2502344C','DEPO'),('335-1114R-AC','335-1114R-AC','GM2503214C','DEPO'),('335-1175R-AC2','335-1175R-AC2','GM2503391C','DEPO'),('335-2034R-AS','335-2034R-AS','GM2593294','DEPO'),('335-2045L-AC','335-2045L-AC','GM2592315C','DEPO'),('335-5442L3MF','335-5442L3MF','GM1320455','DEPO'),('335-5446L4MF','335-5446L4MF','GM1320480','DEPO'),('335-5446R4MF','335-5446R4MF','GM1321480','DEPO'),('340-1133R-AC','340-1133R-AC','MB2503182C','DEPO'),('340-1930R-AC','340-1930R-AC','MB2801161C','DEPO'),('344-1417L-UC','344-1417L-UC','BM1084100C','DEPO'),('347-1101R-AC','347-1101R-AC','SM2503100C','DEPO'),('364174','364174','FO2592247','TYC'),('373-55003-000','373-55003-000','VO3115109','DEPO'),('382-4001L-AC','382-4001L-AC','MC2892100C','DEPO'),('3935','3935','TO1067122','TYC'),('3936','3936','TO1066122','TYC'),('446-2011L-AC','446-2011L-AC','AU2592117C','DEPO'),('555312-11BNL-ACD2','555312-11BNL-ACD2','TO2502325C','MEYER'),('622740','622740','MA3115150','TYC'),('625310','625310','TA3115101','TYC'),('625430','625430','CH3115212','TYC'),('630730','630730','SU3117101','TYC'),('660214','660214','GM1350145','TYC'),('660657','660657','MA1351110','TYC'),('773-2005L-AQ','773-2005L-AQ','VO2592101','DEPO'),('97331','97331','97331','TYC'),('97343','97343','97343','TYC'),('97353','97353','97353','TYC'),('A33-1110L-UCN2','A33-1110L-UCN2','CH2502351C','DEPO'),('ARBC070104','ARBC070104','GM1200600','USAUTO'),('ARBS310101','ARBS310101','SC1228103','USAUTO'),('ARBS310102','ARBS310102','SC1228102','USAUTO'),('AU1112GL','AU1112GL','AU1324107','USAUTO'),('B461703','B461703','BM1305102','USAUTO'),('BM1144125','BM1144125','BM1144125','ValueLine'),('BM1144136','BM1144136','BM1144136','ValueLine'),('C013115','C013115','GM1067147','USAUTO'),('C107908','C107908','CH2592131','USAUTO'),('C762704','C762704','GM1166116','USAUTO'),('CH1037112','CH1037112','CH1037112','ValueLine'),('CH1191113','CH1191113','CH1191113','ValueLine'),('CH1210129','CH1210129','CH1210129','ValueLine'),('CH1210132','CH1210132','CH1210132','ValueLine'),('CH1790112','CH1790112','CH1790112','ValueLine'),('CH2592163V','CH2592163V','CH2592163','ValueLine'),('CH3710377','CH3710377','CH3710377','ValueLine'),('CV45073AL','CV45073AL','GM1066177','USAUTO'),('D100102Q','D100102Q','D100102Q','USAUTO'),('DG77ER','DG77ER','CH1321320','USAUTO'),('DS327-B000L','DS327-B000L','NI2550104','ELT'),('F130301','F130301','FO1236121','USAUTO'),('FD459GL','FD459GL','FO1324149','USAUTO'),('FD534GR','FD534GR','FO1325205','USAUTO'),('FO1321125','FO1321125','FO1321125','ValueLine'),('FR538-U000L','FR538-U000L','FO2594101','ELT'),('GA01730039','GA01730039','AU1068138','USAUTO'),('GB47170006','GB47170006','BM1326107','USAUTO'),('GFD548GL','GFD548GL','FO1324171','USAUTO'),('GH01590098','GH01590098','HY1046142','USAUTO'),('GH10770029','GH10770029','HO1039138','USAUTO'),('GM014-U000R','GM014-U000R','GM2521101','ELT'),('GM01730085','GM01730085','MB1068182','ValueLine'),('GM1038176','GM1038176','GM1038176','ValueLine'),('GM107-U000R','GM107-U000R','GM2521110','ELT'),('GM111-B001L','GM111-B001L','GM2502130','ELT'),('GM111-B001R','GM111-B001R','GM2503130','ELT'),('GM1248183','GM1248183','GM1248183','ValueLine'),('GM1320342','GM1320342','GM1320342','ValueLine'),('GM1320425','GM1320425','GM1320425','ValueLine'),('GM1321395','GM1321395','GM1321395','ValueLine'),('GM60EL','GM60EL','GM1320173','USAUTO'),('GMEQO-MR2-10-P2R','GMEQO-MR2-10-P2R','GM1321387','MEYER'),('GMSIL-MR2-03-D1R','GMSIL-MR2-03-D1R','GM1321294','MEYER'),('H013139','H013139','HO1067107','USAUTO'),('H013140','H013140','HO1066108','USAUTO'),('HD478-U000L','HD478-U000L','HO2818129','ELT'),('HD760-B100L','HD760-B100L','AC2592115','ELT'),('HD84ER','HD84ER','HO1321364','USAUTO'),('HO1213119','HO1213119','HO1213119','USAUTO'),('HO1236147','HO1236147','HO1236147','ValueLine'),('HO22GR','HO22GR','HO1325111','USAUTO'),('HO2508121','HO2508121','HO2508121','ValueLine'),('HO2603103','HO2603103','RH11050002','USAUTO'),('HOCVC-MR1-96-P2R','HOCVC-MR1-96-P2R','HO1321123','MEYER'),('HY025-B001L','HY025-B001L','HY2502121','ELT'),('HY1166134','HY1166134','HY1166134','ValueLine'),('HY1210112','HY1210112','HY1210112','ValueLine'),('HY1236162','HY1236162','HY1236162','ValueLine'),('IN21EL','IN21EL','IN1320114','USAUTO'),('JAC23EL-S','JAC23EL-S','AC1320113','USAUTO'),('JC47170013','JC47170013','GM1327115','USAUTO'),('JCV135EL','JCV135EL','GM1320659','USAUTO'),('JCV144ER','JCV144ER','GM1321612','USAUTO'),('JCV30ER','JCV30ER','GM1321445','USAUTO'),('JCV37ER-S','JCV37ER-S','GM1321435','USAUTO'),('JCV41EL','JCV41EL','GM1320407','USAUTO'),('JDG44L','JDG44L','CH1320227','USAUTO'),('JDG44R','JDG44R','CH1321227','USAUTO'),('JF47170020','JF47170020','FO1326151','USAUTO'),('JFD360ER-S','JFD360ER-S','FO1321511','USAUTO'),('JFD384ER-S','JFD384ER-S','FO1321645','USAUTO'),('JFD418EL-S','JFD418EL-S','FO1320620','USAUTO'),('JGM108EL','JGM108EL','GM1320415','USAUTO'),('JGM229EL','JGM229EL','GM1320649','USAUTO'),('JH462901','JH462901','HO1351117','USAUTO'),('JH76350015','JH76350015','HY1144121','USAUTO'),('JHD51ER-S','JHD51ER-S','HO1321275','USAUTO'),('JHD60EL','JHD60EL','HO1320233','USAUTO'),('JHD82ER','JHD82ER','HO1321362','USAUTO'),('JHO05EL','JHO05EL','HO1320282','USAUTO'),('JHO114EL-S','JHO114EL-S','HO1320343','USAUTO'),('JHO144EL','JHO144EL','HO1320368','USAUTO'),('JJ01590038','JJ01590038','CH1037137','USAUTO'),('JLX26ER','JLX26ER','LX1321118','USAUTO'),('JLX30EL-S','JLX30EL-S','LX1320143','USAUTO'),('JMZ89R','JMZ89R','MB1321115','USAUTO'),('JNS166ER','JNS166ER','NI1321294','USAUTO'),('JNS212EL','JNS212EL','NI1320345','USAUTO'),('JNS49EL','JNS49EL','NI1320161','USAUTO'),('JP92GL','JP92GL','CH1324109','USAUTO'),('JSU63EL-S','JSU63EL-S','SU1320181','USAUTO'),('JTY01EL-S','JTY01EL-S','TO1320409','USAUTO'),('JTY246EL','JTY246EL','TO1320383','USAUTO'),('JTY253EL-S','JTY253EL-S','TO1320368','USAUTO'),('JTY294ER','JTY294ER','TO1321454','USAUTO'),('KI1038179','KI1038179','KI1038179','ValueLine'),('KI1320229','KI1320229','KI1320229','ValueLine'),('KVAC30183','KVAC30183','TO3030343','USAUTO'),('KVAC3882','KVAC3882','HY3030144','USAUTO'),('LX1043131','LX1043131','RL01470003','USAUTO'),('LX1350115','LX1350115','LX1350115','ValueLine'),('LX1791100','LX1791100','LX1791100','ValueLine'),('MA2521112','MA2521112','MA2521112','ValueLine'),('MA29EL-S','MA29EL-S','MA1320209','USAUTO'),('MB1210117','MB1210117','MB1210117','ValueLine'),('MB206-B00CR','MB206-B00CR','MI2551104','ELT'),('MI03EL','MI03EL','MC1320103','USAUTO'),('MI33070172','MI33070172','MI33070172','ValueLine'),('MN01ER','MN01ER','MC1321104','USAUTO'),('MT40EL','MT40EL','MI1320139','USAUTO'),('MZ15EL','MZ15EL','MB1320107','USAUTO'),('MZ91GR','MZ91GR','MB1325107','USAUTO'),('N222101','N222101','NI1251106','USAUTO'),('NI1038170','NI1038170','NI1038170','ValueLine'),('NI1251106','NI1251106','NI1251106','ValueLine'),('NI2509106','NI2509106','NI2509106','ValueLine'),('NIFRO-WRP-05-FR','NIFRO-WRP-05-FR','NI1351129','MEYER'),('P13253','P13253','HY3010174','USAUTO'),('P13965','P13965','HO3010259','USAUTO'),('PC30155','PC30155','TO3030338','USAUTO'),('PF44973','PF44973','MA3115169','USAUTO'),('PR13918A','PR13918A','HY3010234','USAUTO'),('RA01530021','RA01530021','AU1039147','USAUTO'),('RA01530030','RA01530030','AU1038152','USAUTO'),('RA07230001','RA07230001','AU1207102','USAUTO'),('RA07580001','RA07580001','AU1206100','USAUTO'),('RA22210023','RA22210023','AC1249138','USAUTO'),('RA22210024','RA22210024','AC1248138','USAUTO'),('RB01550060','RB01550060','BM1038226','USAUTO'),('RB01590006','RB01590006','BM1044118','USAUTO'),('RB01590047','RB01590047','BM1044125','USAUTO'),('RB01610013','RB01610013','BM1047153','USAUTO'),('RB07010052','RB07010052','BM1200292','USAUTO'),('RB16130001','RB16130001','BM3014112','USAUTO'),('RB22370016','RB22370016','BM1244111','USAUTO'),('RB22470001','RB22470001','GM1267102','USAUTO'),('RB22470002','RB22470002','GM1266102','USAUTO'),('RB54390006','RB54390006','BM3012108','USAUTO'),('RB76260003','RB76260003','BM1174101','USAUTO'),('RC01310058','RC01310058','GM1062115','USAUTO'),('RC01730025','RC01730025','GM1068205','USAUTO'),('RC22210031','RC22210031','GM1249254','USAUTO'),('RC47170008','RC47170008','GM1326129','USAUTO'),('RC76270023','RC76270023','GM1177102','USAUTO'),('RC76490010','RC76490010','GM1191132','USAUTO'),('RD11050003','RD11050003','CH1061119','USAUTO'),('RD55390001','RD55390001','CH1769108','USAUTO'),('REPB017317','REPB017317','BM1068129','USAUTO'),('REPB108015','REPB108015','GM1039172','USAUTO'),('REPB761103P','REPB761103P','GM1117101','USAUTO'),('REPC013159','REPC013159','GM1067198','USAUTO'),('REPC013160','REPC013160','GM1066198','USAUTO'),('REPC107519','REPC107519','GM1039121','USAUTO'),('REPC107520','REPC107520','GM1038121','USAUTO'),('REPC491391','REPC491391','GM1521142','USAUTO'),('REPC580737','REPC580737','GM1915136','USAUTO'),('REPC762742','REPC762742','GM1132102','USAUTO'),('REPC960912','REPC960912','REPC960912','USAUTO'),('REPD015908Q','REPD015908Q','CH1044109C','USAUTO'),('REPD132303','REPD132303','CH1234107','USAUTO'),('REPD222121','REPD222121','CH1249154','USAUTO'),('REPD222122','REPD222122','CH1248154','USAUTO'),('REPD503902','REPD503902','PS00010000022','USAUTO'),('REPF071719','REPF071719','FO1202102','USAUTO'),('REPF160938','REPF160938','FO3115212','USAUTO'),('REPF310105','REPF310105','FO1228110','USAUTO'),('REPF310151','REPF310151','FO1228141','USAUTO'),('REPG017303','REPG017303','GM1068136','USAUTO'),('REPG108202','REPG108202','GM1038190','USAUTO'),('REPH015907','REPH015907','HO1044103','USAUTO'),('REPH070167','REPH070167','HO1200214','USAUTO'),('REPH130547','REPH130547','HY1236161','USAUTO'),('REPH1320552','REPH1320552','HO1236144','USAUTO'),('REPH160970','REPH160970','HO3113133','USAUTO'),('REPH222147','REPH222147','RT01590015','USAUTO'),('REPH222148','REPH222148','HO1248138','USAUTO'),('REPH222308','REPH222308','HY1249154','USAUTO'),('REPH462123','REPH462123','HY1353120','USAUTO'),('REPHD462324','REPHD462324','HY1310134','USAUTO'),('REPK730120','REPK730120','KI2804103','USAUTO'),('REPL108010','REPL108010','LX1038107','USAUTO'),('REPN013133','REPN013133','NI1067146','USAUTO'),('REPN100318','REPN100318','NI2500103','USAUTO'),('REPT011113','REPT011113','TO1005182','USAUTO'),('REPT014903','REPT014903','TO1033102','USAUTO'),('REPT014904','REPT014904','TO1032102','USAUTO'),('REPT222194','REPT222194','TO1248194','USAUTO'),('REPT310120','REPT310120','TO1228141','USAUTO'),('REPT370539','REPT370539','TO1288196','USAUTO'),('REPT761135','REPT761135','TO1105135','USAUTO'),('REPT761146','REPT761146','TO1104137','USAUTO'),('REPT762719','REPT762719','TO1143107','USAUTO'),('REPT762720','REPT762720','TO1142107','USAUTO'),('REPT764907','REPT764907','TO119110','USAUTO'),('REPV763504','REPV763504','REPV763504','USAUTO'),('RF25260004','RF25260004','FO1225278','USAUTO'),('RF76690007','RF76690007','FO1129106','USAUTO'),('RH01040001','RH01040001','HO1043139','USAUTO'),('RH10810016','RH10810016','HO1038148','USAUTO'),('RH47150004','RH47150004','HO1328101','USAUTO'),('RH47170014','RH47170014','HO1326102','USAUTO'),('RH55470001','RH55470001','HO1708106','USAUTO'),('RH76370019','RH76370019','HY1147107','USAUTO'),('RJ10990002','RJ10990002','CH2508110','USAUTO'),('RJ7070011','RJ7070011','CH1202106','USAUTO'),('RJ76270016','RJ76270016','CH1166116','USAUTO'),('RK01310051','RK01310051','KI1043109','USAUTO'),('RK01310052','RK01310052','KI1042109','USAUTO'),('RK16230007','RK16230007','KI1039185','USAUTO'),('RL01030124P','RL01030124P','RO1047100','USAUTO'),('RL01250010','RL01250010','RO1006107','USAUTO'),('RL22210003','RL22210003','IN1249131','USAUTO'),('RL22210004','RL22210004','IN1248131','USAUTO'),('RM01310014','RM01310014','MC1042101','USAUTO'),('RM01310076','RM01310076','MB1042147','USAUTO'),('RM01440022','RM01440022','MB1029173','USAUTO'),('RM01530103','RM01530103','MB1039237','USAUTO'),('RM01590075','RM01590075','MB1047192','USAUTO'),('RM01730036','RM01730036','MB1068164','USAUTO'),('RM01730050','RM01730050','MB1068166','USAUTO'),('RM07070027','RM07070027','MB1213101','USAUTO'),('RM07070028','RM07070028','MB1212101','USAUTO'),('RM47150008','RM47150008','MB1328101','USAUTO'),('RM76270052','RM76270052','MB1162117','USAUTO'),('RMA27379','RMA27379','RMA27379','USAUTO'),('RN07580001','RN07580001','NI1206102','USAUTO'),('RN22170004','RN22170004','NI1244109','USAUTO'),('RN55390003','RN55390003','NI1791101','USAUTO'),('RN61090001','RN61090001','NI1911103','USAUTO'),('RT01730025','RT01730025','TO1068164','USAUTO'),('RT10810041','RT10810041','TO1039284','USAUTO'),('RT16030008','RT16030008','TO3110139','USAUTO'),('RT45490002','RT45490002','TO1182130','USAUTO'),('RT54210011','RT54210011','TO1245113','USAUTO'),('RT76350011','RT76350011','TO1144109','USAUTO'),('RU-445','RU-445','RU-445','USAUTO'),('RV10820008','RV10820008','VW1038151','USAUTO'),('RV47170011','RV47170011','VW1327108','USAUTO'),('RV76350014','RV76350014','VW1146109','USAUTO'),('S070119','S070119','SU1200129','USAUTO'),('SCIA-CAM-16-R','SCIA-CAM-16-R','TO1960152','MEYER'),('SHE332-850SETQU','SHE332-850SETQU','CH1165104C','MEYER'),('SHE902-84FU','SHE902-84FU','GM1065109','MEYER'),('SHE932A-84CL','SHE932A-84CL','GM1066158','MEYER'),('SHEHOCRV17-92M-1','SHEHOCRV17-92M-1','HO1290108','MEYER'),('SHEKIFORT10-24-1','SHEKIFORT10-24-1','KI1248118','MEYER'),('SHEMBC30015B-98-0','SHEMBC30015B-98-0','MB1044111','MEYER'),('SHENIALTI19A-99-0','SHENIALTI19A-99-0','NI1200293','MEYER'),('SU1246103','SU1246103','SU1246103','ValueLine'),('T013138','T013138','TO1066149','USAUTO'),('T222176','T222176','TO1250122','USAUTO'),('T222177','T222177','TO1249174','USAUTO'),('TO1047127','TO1047127','TO1047127','ValueLine'),('TO1104135','TO1104135','TO1104135','ValueLine'),('TO1216103','TO1216103','TO1216103','ValueLine'),('TO1248162','TO1248162','TO1248162','ValueLine'),('TO1288192','TO1288192','REPT370537','USAUTO'),('TO1320367','TO1320367','TO1320367','ValueLine'),('TO1321349','TO1321349','TO1321349','ValueLine'),('TO2030118','TO2030118','KVAC3024','ValueLine'),('TO2502212','TO2502212','TO2502212','DEPO'),('TO2503347','TO2503347','TO2503347','DEPO'),('TO2519197C','TO2519197C','TO2519197C','DEPO'),('TO2532116','TO2532116','TO2532116','ValueLine'),('TOHLR-MR2-18-P1L','TOHLR-MR2-18-P1L','TO1320409','MEYER'),('TY171CR','TY171CR','TO1321300','USAUTO'),('TY745-A001L','TY745-A001L','TO2502147','ELT'),('VV05GR','VV05GR','VO1325100','USAUTO'),('VW1039152','VW1039152','VW1039152','ValueLine'),('VW1047109','VW1047109','VW1047109','ValueLine'),('VW115ER','VW115ER','VW1321191','USAUTO'),('VW75ER-S','VW75ER-S','VW1321180','USAUTO'),('W0133-1850220','W0133-1850220','W0133-1850220','ELT');
INSERT INTO _sh (location_id) VALUES (2),(3),(4),(6),(7),(8),(10),(11),(12),(15),(16),(107),(108),(109),(110),(111),(112),(113),(114),(115),(116),(1),(19),(20),(21),(22),(23),(24),(25),(28),(29),(30),(117),(118),(119),(120),(121),(122),(123),(18),(32),(33),(34),(35),(36),(37),(38),(39),(40),(43),(126),(127),(128),(129),(130),(131),(132),(133),(134),(135),(31),(47),(48),(49),(50),(51),(52),(53),(54),(207),(55),(56),(57),(58),(59),(60),(61),(62),(63),(64),(65),(66),(136),(137),(138),(139),(140),(141),(142),(143),(144),(145),(46),(68),(69),(70),(71),(72),(74),(75),(76),(77),(79),(80),(81),(146),(147),(148),(150),(151),(152),(155),(156),(67),(85),(86),(87),(88),(89),(90),(91),(92),(93),(94),(95),(96),(97),(98),(99),(100),(101),(102),(104),(157),(158),(159),(160),(161),(163),(164),(165),(84),(167),(168),(169),(171),(172),(173),(175),(176),(105),(177),(106);
-- 1. create the missing products at price 0 (enriched afterwards)
INSERT INTO products (product_id, supplier_part_number, partslink, supplier, average_price, status, created_at, updated_at)
SELECT product_id, spn, partslink, supplier, 0.00, 'active', NOW(), NOW() FROM _newp;
-- 2. reactivate the shelves the sheet counts stock on
UPDATE locations SET is_active=1, updated_at=NOW() WHERE id IN (SELECT location_id FROM _sh) AND is_active=0;
-- 3. resolve plan -> product ids and prices
UPDATE _plan p JOIN products pr ON pr.product_id = p.part_display SET p.product_pk=pr.id, p.price=pr.average_price;
UPDATE _plan p JOIN products pr
   ON REPLACE(REPLACE(REPLACE(UPPER(pr.product_id),' ',''),'\t',''),'\n','') = p.part_key
 SET p.product_pk=pr.id, p.price=pr.average_price WHERE p.product_pk IS NULL;
SELECT COUNT(*) INTO @unresolved FROM _plan WHERE product_pk IS NULL OR location_pk IS NULL;
-- 4. EMPTY every shelf the sheet names
INSERT INTO stock_history
 (product_id,warehouse_id,location_id,action_type,quantity_before,quantity_change,quantity_after,
  unit_price,reference_type,reference_id,user_id,notes,created_at)
SELECT s.product_id,s.warehouse_id,s.location_id,'location_emptied',s.quantity,-s.quantity,0,
       s.average_price,'stock_take','SEPT-RESCAN-2026-08-31',NULL,
       'September rescan - shelf emptied before reload (UPLOAD 9-1-26.xlsx)',NOW()
FROM stocks s WHERE s.location_id IN (SELECT location_id FROM _sh) AND s.quantity<>0;
SELECT ROW_COUNT() INTO @emptied_rows;
UPDATE stocks SET quantity=0, updated_at=NOW() WHERE location_id IN (SELECT location_id FROM _sh) AND quantity<>0;
-- 5. LOAD the counted quantities, keyed on (part, shelf)
UPDATE stocks s JOIN _plan p ON s.product_id=p.product_pk AND s.location_id=p.location_pk
   SET s.quantity=p.qty, s.average_price=p.price, s.warehouse_id=54,
       s.last_counted_at='2026-08-31', s.updated_at=NOW();
INSERT INTO stocks
 (product_id,warehouse_id,location_id,sub_location,quantity,reserved_quantity,average_price,
  is_selling,`condition`,last_counted_at,created_at,updated_at)
SELECT p.product_pk,54,p.location_pk,NULL,p.qty,0,p.price,1,'new','2026-08-31',NOW(),NOW()
FROM _plan p LEFT JOIN stocks s ON s.product_id=p.product_pk AND s.location_id=p.location_pk
WHERE s.id IS NULL;
INSERT INTO stock_history
 (product_id,warehouse_id,location_id,action_type,quantity_before,quantity_change,quantity_after,
  unit_price,reference_type,reference_id,user_id,notes,created_at)
SELECT p.product_pk,54,p.location_pk,'stock_take',0,p.qty,p.qty,p.price,'stock_take','SEPT-RESCAN-2026-08-31',NULL,
       'September rescan - counted quantity placed (UPLOAD 9-1-26.xlsx)',NOW() FROM _plan p;
-- 6. VERIFY
SELECT COUNT(*) INTO @pos FROM stocks s JOIN _sh h ON h.location_id=s.location_id WHERE s.quantity>0;
SELECT IFNULL(SUM(s.quantity),0) INTO @units FROM stocks s JOIN _sh h ON h.location_id=s.location_id WHERE s.quantity>0;
SELECT @unresolved AS unresolved, @pos AS positions_after, @units AS units_after, 3511 AS expect_pos, 3653 AS expect_units;