INDOCOM_update_tanggal_DO

BEGIN

    13802

    UPDATE sl_do SET doc_date = '20170905' WHERE do_id = 13802

    UPDATE sl_so_balance_invoice SET ref_doc_date = '20170905' WHERE ref_doc_type_id = 311 AND ref_id = 13802 AND ref_doc_no = 'GDON/01372/201709'

    UPDATE in_log_product_balance_stock SET doc_date = '20170905' WHERE doc_type_id = 311 AND ref_id = 13802 AND doc_no = 'GDON/01372/201709'

    UPDATE in_balance_do_item SET doc_date = '20170905' WHERE do_id = 13802 AND doc_no = 'GDON/01372/201709'

    UPDATE sl_so_balance_warranty_invoice SET ref_doc_date = '20170905' WHERE ref_doc_type_id = 311 AND ref_id = 13802 AND ref_doc_no = 'GDON/01372/201709'

    SELECT * FROM gl_journal_trx WHERE doc_type_id = 311 AND doc_id = 13802 AND doc_no = 'GDON/01372/201709'

    84764

    UPDATE gl_journal_trx SET doc_date = '20170905' WHERE doc_type_id = 311 AND doc_id = 13802 AND doc_no = 'GDON/01372/201709'

    UPDATE gl_journal_trx_item SET journal_date = '20170905' WHERE journal_trx_id = 84764

    UPDATE gl_journal_trx_mapping SET journal_date = '20170905' WHERE journal_trx_id = 84764

ROLLBACK