Script Perbaikan Data MF-218

--Script Perbaikan Data :
--> Header SQ
UPDATE sl_quotation SET remark = 'SP DPS-Santy Garthoff' WHERE doc_no = 'MEG-SQ22.02.0816';
--> Header SQ
UPDATE sl_so SET remark = 'SP DPS-Santy Garthoff' WHERE doc_no = 'MEG-SO22.02.0443';
--> Detail SQ Item
UPDATE sl_quotation_item A SET
city = 'DENPASAR KOTA',
remark = 'Kode /harga bunga: KTA SP 301 /Rp 529.000+30.000 Tgl & Jam Kirim: 14 feb 2022, jam 12 Nama & No.hp penerima: Santy, 08113999572 ------------- Ucapan di kartu : Happy Valentine’s day Nama pengirim di kartu: ------------- Alamat kirim: The Grove Bumbak, Jl Raya Bumbak, Umalas Kerobokan'
WHERE EXISTS (SELECT 1 FROM sl_quotation B
        WHERE B.doc_no = 'MEG-SQ22.02.0816'
        AND A.quotation_id = B.quotation_id)
AND EXISTS (SELECT 1 FROM m_product C
        WHERE A.product_id = C.product_id
        AND C.product_code = 'HeavyWhiteGuipureLace');
--> Detail SO Item
UPDATE sl_so_item_quotation_details A SET
city = 'DENPASAR KOTA',
remark = 'Kode /harga bunga: KTA SP 301 /Rp 529.000+30.000 Tgl & Jam Kirim: 14 feb 2022, jam 12 Nama & No.hp penerima: Santy, 08113999572 ------------- Ucapan di kartu : Happy Valentine’s day Nama pengirim di kartu: ------------- Alamat kirim: The Grove Bumbak, Jl Raya Bumbak, Umalas Kerobokan'
WHERE EXISTS (SELECT 1 FROM sl_so_item B
        INNER JOIN sl_so C ON B.so_id = C.so_id
        WHERE C.doc_no = 'MEG-SO22.02.0443'
        AND A.so_item_id = B.so_item_id)
AND EXISTS (SELECT 1 FROM sl_so_item B
        INNER JOIN sl_so C ON B.so_id = C.so_id
        INNER JOIN m_product D ON B.product_id = D.product_id
        WHERE C.doc_no = 'MEG-SO22.02.0443'
        AND A.so_item_id = B.so_item_id
        AND D.product_code = 'HeavyWhiteGuipureLace');

-- Update Item Ongkir
--> Detail SQ Item
UPDATE sl_quotation_item A SET city = 'DENPASAR KOTA'
WHERE EXISTS (SELECT 1 FROM sl_quotation B
        WHERE B.doc_no = 'MEG-SQ22.02.0816'
        AND A.quotation_id = B.quotation_id)
AND EXISTS (SELECT 1 FROM m_product C
        WHERE A.product_id = C.product_id
        AND C.product_code = 'Ongkir');
--> Detail SO Item
UPDATE sl_so_item_quotation_details A SET city = 'DENPASAR KOTA'
WHERE EXISTS (SELECT 1 FROM sl_so_item B
        INNER JOIN sl_so C ON B.so_id = C.so_id
        INNER JOIN m_product D ON B.product_id = D.product_id
        WHERE C.doc_no = 'MEG-SO22.02.0443'
        AND A.so_item_id = B.so_item_id
        AND D.product_code = 'Ongkir');