Kindly change the:
1.Please change the vender code of SANDISK from C1314 to C1475 first.
SELECT rowid,a.* FROM sorder a WHERE custsname='SANDISK'; --supp_code
SELECT rowid,a.* FROM inb_det a WHERE custsname='SANDISK'; --supp_code
UPDATE sorder SET supp_code='C1475' WHERE custsname='SANDISK'; --supp_code
UPDATE inb_det SET supp_code='C1475' WHERE custsname='SANDISK'; --supp_code
SELECT rowid,a.* FROM prod a WHERE custsname='SANDISK'; --vend_locn
UPDATE prod SET vend_locn='C1475' WHERE custsname='SANDISK';
SELECT rowid,a.* FROM hub_supp a WHERE suppsname='SANDISK'; --supp_code suppfname
UPDATE hub_supp SET supp_code='C1475',suppfname='C1475' WHERE suppsname='SANDISK';
--SELECT rowid,a.* FROM cust_config_mast a WHERE custsname='SANDISK'; --supp_code
--select rowid,a.* from cust_rpt_disb WHERE rptsname='AUTO_REPORT_C1429';
--SELECT rowid,a.* FROM goods WHERE sorder IN (SELECT sorder FROM sorder WHERE custsname='SANDISK');
select * from do_det where suppsname='SANDISK'; --OR supp_code in ('C1314'); --supp_code
select * from outb_det where suppsname in ('C1314'); --suppsname
UPDATE do_det SET supp_code='C1475' where suppsname='SANDISK'; --OR supp_code in ('C1314'); --supp_code
UPDATE outb_det SET suppsname='C1475' where suppsname in ('C1314'); --suppsname
2. Please copy all the parts of PLIANT (vender code : C1475) to SANDISK (vender code : C1475)
SELECT * FROM prod WHERE custsname='PLIANT';
SELECT * FROM prod_uom WHERE custsname='PLIANT';
SELECT * FROM prod_temp_class WHERE custsname='PLIANT';
SELECT * FROM prod_store_class WHERE custsname='PLIANT';
CREATE TABLE wzq_prod AS
SELECT * FROM prod WHERE custsname='PLIANT';
CREATE TABLE wzq_prod_uom AS
SELECT * FROM prod_uom WHERE custsname='PLIANT';
CREATE TABLE wzq_prod_temp_class AS
SELECT * FROM prod_temp_class WHERE custsname='PLIANT';
CREATE TABLE wzq_prod_store_class AS
SELECT * FROM prod_store_class WHERE custsname='PLIANT';
SELECT ROWID,a.* FROM wzq_prod a;
SELECT ROWID,a.* FROM wzq_prod_uom a;
SELECT ROWID,a.* FROM wzq_prod_temp_class a;
SELECT ROWID,a.* FROM wzq_prod_store_class a;
INSERT INTO prod SELECT * FROM wzq_prod;
INSERT INTO prod_uom SELECT * FROM wzq_prod_uom;
INSERT INTO prod_temp_class SELECT * FROM wzq_prod_temp_class;
INSERT INTO prod_store_class SELECT * FROM wzq_prod_store_class;
SELECT * FROM prod WHERE custsname='SANDISK';
SELECT * FROM prod_uom WHERE custsname='SANDISK';
SELECT * FROM prod_temp_class WHERE custsname='SANDISK';
SELECT * FROM prod_store_class WHERE custsname='SANDISK';
drop table wzq_prod ;
drop table wzq_prod_uom ;
drop table wzq_prod_temp_class ;
drop table wzq_prod_store_class ;
3 . Storting Order#: 180422
Supplier : PLIANT
Customer : from PLIANT to SANDISK
(customer request)
SELECT ROWID,a.* FROM sorder a WHERE ord_remark='SEA00007969';
SELECT ROWID,b.* FROM inb_hdr b WHERE ordno='SEA00007969';
SELECT ROWID,a.* FROM inb_det a WHERE ordno='SEA00007969';
--SELECT * FROM goods WHERE ordno='SEA00007969';
--SELECT ROWID,c.* FROM sorder_prod c WHERE sorder=180797;
--SELECT ROWID,c.* FROM cdf_det c WHERE sp_order=180797;
1 180797 180422 XM XM PLIANT SEA00007969 INN COM N 2011/8/2 18:05:18 2011/8/2 18:05:18 2011/8/2 20:45:57 371320111131134049 2011/8/2 23:02:21 DELL-XMN C1475 PUWHSE zilong 2011/8/2 20:45:57 797355542350 SEA00007969 AIR 2011/7/31 2011/8/2 2011/8/2 21:05:05
1 PLIANT SEA00007969 J080547 2011-07-29 22 797355542350 SEA00007969 22 797355542350 FEDEX CIF 2011/7/29 YCH 1 CTN
1 PLIANT SEA00007969 1 KKNXF 30 10.000 SEA00007969 10 COM 180797 C1475 AIR 2011/7/29 2011/7/29 DELL-XMN INN USD 1223.0000 US 7 30 10 6
2 PLIANT SEA00007969 2 WMWPW 60 10.000 SEA00007969 10 COM 180797 C1475 AIR 2011/7/29 2011/7/29 DELL-XMN INN USD 1834.0000 US 15 60 10 13
Please assist. Please check with users whether want to change the vend_loc in prod master, then raise DCR to SG IT for change after WMS change. Thanks!