Update Return Note Doc Date (+Ext Doc Date)

--Update doc date in_log_product_balance_stock
    UPDATE in_log_product_balance_stock Z
    SET doc_date = '20170220'
    FROM in_inventory A
    WHERE A.doc_no = 'RN/000001/KPS/201703'
        AND A.doc_date = '20170307'
        AND A.doc_type_id = 502
        AND Z.ref_id = A.inventory_id;

    --Update doc date sl_so_balance_invoice
    UPDATE sl_so_balance_invoice Z
    SET ref_doc_date = '20170220'
    FROM in_inventory A
    WHERE A.doc_no = 'RN/000001/KPS/201703'
        AND A.doc_date = '20170307'
        AND A.doc_type_id = 502
        AND Z.ref_id = A.inventory_id;

    --Update ref doc date sl_so_balance_invoice_tax
    UPDATE sl_so_balance_invoice_tax Z
    SET ref_doc_date = '20170220'
    FROM in_inventory A
    WHERE A.doc_no = 'RN/000001/KPS/201703'
        AND A.doc_date = '20170307'
        AND A.doc_type_id = 502
        AND Z.ref_id = A.inventory_id;

    --Update gl_admin_journal_trx untuk doc date lama
    SELECT gl_cancel_admin_journal_trx(A.tenant_id, (f_get_ou_bu_structure(A.ou_from_id)).ou_bu_id, A.ou_from_id, (f_get_document_journal(A.doc_type_id)).journal_type, f_get_year_month_date(A.doc_date), 'MONTHLY', '20170308121212', -1)
    FROM in_inventory A
    WHERE A.doc_no = 'RN/000001/KPS/201703'
        AND A.doc_date = '20170307'
        AND A.doc_type_id = 502

    --Insert/Update gl_admin_journal_trx untuk doc date baru
    SELECT gl_manage_admin_journal_trx(A.tenant_id, (f_get_ou_bu_structure(A.ou_from_id)).ou_bu_id, A.ou_from_id, (f_get_document_journal(A.doc_type_id)).journal_type, (f_get_document_journal(A.doc_type_id)).ledger_code, f_get_year_month_date('20170220'), 'MONTHLY', '20170308121212', -1)
    FROM in_inventory A
    WHERE A.doc_no = 'RN/000001/KPS/201703'
        AND A.doc_date = '20170307'
        AND A.doc_type_id = 502

    -- UPDATE gl_journal_trx
    UPDATE gl_journal_trx Z
    SET doc_date = '20170220',
        ext_doc_date = '20170220'
    FROM in_inventory A
    WHERE A.doc_no = 'RN/000001/KPS/201703'
        AND A.doc_date = '20170307'
        AND A.doc_type_id = 502
        AND Z.tenant_id = A.tenant_id
        AND Z.journal_type = (f_get_document_journal(A.doc_type_id)).journal_type
        AND Z.doc_type_id = A.doc_type_id
        AND Z.doc_id = A.inventory_id
        AND Z.doc_no = A.doc_no
        AND Z.doc_date = A.doc_date
        AND Z.ou_bu_id = (f_get_ou_bu_structure(A.ou_from_id)).ou_bu_id
        AND Z.ou_branch_id = (f_get_ou_bu_structure(A.ou_from_id)).ou_branch_id
        AND Z.ou_sub_bu_id = (f_get_ou_bu_structure(A.ou_from_id)).ou_sub_bu_id;

    -- UPDATE gl_journal_trx_item
    UPDATE gl_journal_trx_item Z
    SET journal_date = '20170220'
    FROM in_inventory A, gl_journal_trx B
    WHERE A.doc_no = 'RN/000001/KPS/201703'
        AND A.doc_date = '20170307'
        AND A.doc_type_id = 502
        AND B.tenant_id = A.tenant_id
        AND B.journal_type = (f_get_document_journal(A.doc_type_id)).journal_type
        AND B.doc_type_id = A.doc_type_id
        AND B.doc_id = A.inventory_id
        AND B.doc_no = A.doc_no
        AND B.doc_date = A.doc_date
        AND B.ou_bu_id = (f_get_ou_bu_structure(A.ou_from_id)).ou_bu_id
        AND B.ou_branch_id = (f_get_ou_bu_structure(A.ou_from_id)).ou_branch_id
        AND B.ou_sub_bu_id = (f_get_ou_bu_structure(A.ou_from_id)).ou_sub_bu_id
        AND Z.journal_trx_id = B.journal_trx_id;

    -- UPDATE gl_journal_trx_mapping
    UPDATE gl_journal_trx_mapping Z
    SET journal_date = '20170220'
    FROM in_inventory A, gl_journal_trx B
    WHERE A.doc_no = 'RN/000001/KPS/201703'
        AND A.doc_date = '20170307'
        AND A.doc_type_id = 502
        AND B.tenant_id = A.tenant_id
        AND B.journal_type = (f_get_document_journal(A.doc_type_id)).journal_type
        AND B.doc_type_id = A.doc_type_id
        AND B.doc_id = A.inventory_id
        AND B.doc_no = A.doc_no
        AND B.doc_date = A.doc_date
        AND B.ou_bu_id = (f_get_ou_bu_structure(A.ou_from_id)).ou_bu_id
        AND B.ou_branch_id = (f_get_ou_bu_structure(A.ou_from_id)).ou_branch_id
        AND B.ou_sub_bu_id = (f_get_ou_bu_structure(A.ou_from_id)).ou_sub_bu_id
        AND Z.journal_trx_id = B.journal_trx_id;

    --Update doc date in_inventory
    UPDATE in_inventory
    SET doc_date = '20170220',
        ext_doc_date = '20170220'
    WHERE doc_no = 'RN/000001/KPS/201703'
        AND doc_type_id = 502
        AND doc_date = '20170307';