UPDATE CHANGE DOC DATE DO

UPDATE sl_do SET doc_date = '20170524' WHERE doc_no = 'DO/00507/201705' AND do_id = 12646

    UPDATE sl_so_balance_invoice Z SET ref_doc_date = A.doc_date
    FROM sl_do A
    WHERE A.do_id = 12646
        AND Z.ref_id = A.do_id
        AND Z.ref_doc_type_id = A.doc_type_id

    UPDATE in_log_product_balance_stock Z SET doc_date = A.doc_date
    FROM sl_do A
    WHERE A.do_id = 12646
        AND Z.ref_id = A.do_id
        AND Z.doc_type_id = A.doc_type_id

    UPDATE in_balance_do_item Z SET doc_date = A.doc_date
    FROM sl_do A
    WHERE A.do_id = 12646
        AND Z.do_id = A.do_id

    UPDATE sl_so_balance_warranty_invoice Z SET ref_doc_date = A.doc_date
    FROM sl_do A
    WHERE A.do_id = 12646
        AND Z.ref_id = A.do_id
        AND Z.ref_doc_type_id = A.doc_type_id

    UPDATE gl_journal_trx Z SET doc_date = A.doc_date
    FROM sl_do A
    WHERE A.do_id = 12646
        AND Z.doc_id = A.do_id
        AND Z.doc_type_id = A.doc_type_id

    UPDATE gl_journal_trx_item Z SET journal_date = '20170524'
    FROM sl_do_item A, gl_journal_trx B, sl_do C
    WHERE Z.ref_id = A.do_item_id
        AND C.do_id = 12646
        AND A.do_id = C.do_id
        AND Z.ref_doc_type_id = C.doc_type_id
        AND Z.journal_trx_id = B.journal_trx_id
        AND B.doc_id = A.do_id
        AND B.doc_type_id = Z.ref_doc_type_id

    UPDATE gl_journal_trx_mapping Z SET journal_date = '20170524'
    FROM gl_journal_trx B, sl_do C
    WHERE Z.ref_doc_type_id = C.doc_type_id
        AND Z.journal_trx_id = B.journal_trx_id
        AND C.do_id = 12646
        AND B.doc_id = C.do_id
        AND B.doc_type_id = C.doc_type_id