INSERT INTO tt_journal_trx_item
            (session_id, tenant_id, journal_trx_id, line_no,
            ref_doc_type_id, ref_id,
            partner_id, product_id, cashbank_id, ou_rc_id,
            segmen_id, sign_journal, flg_source_coa, activity_gl_id,
            coa_id, curr_code, qty, uom_id,
            amount, journal_date, type_rate,
            numerator_rate, denominator_rate, journal_desc, remark)
            SELECT 'ADRIAN', A.tenant_id, D.journal_trx_id, 1,
                A.doc_type_id, B.inventory_item_id,
                A.partner_id, B.product_id, -99, -99,
                -99, 'D', 'PRODUCT', -99,
                f_get_product_coa_group_product(A.tenant_id, B.product_id), f_get_value_system_config_by_param_code(11, 'ValutaBuku'), B.qty_realization, B.base_uom_id,
                0 , A.doc_date, 'COM',
                1, 1, 'PRODUCT_STOCK', B.remark
            FROM in_inventory A, in_inventory_item B, gl_journal_trx D
            WHERE --A.inventory_id = vAdjQtyId AND
                A.inventory_id = B.inventory_id AND
                B.qty_realization > 0 --AND
                --B.inventory_item_id = C.inventory_item_id AND
                --(C.flg_buy_konsinyasi = 'N' OR (C.flg_buy_konsinyasi = 'N' AND C.product_status = 'RETURN'))
                AND A.inventory_id = D.doc_id AND A.doc_type_id = D.doc_type_id
                AND B.product_id = 6426;

            INSERT INTO tt_journal_trx_item
            (session_id, tenant_id, journal_trx_id, line_no,
            ref_doc_type_id, ref_id,
            partner_id, product_id, cashbank_id, ou_rc_id,
            segmen_id, sign_journal, flg_source_coa, activity_gl_id,
            coa_id, curr_code, qty, uom_id,
            amount, journal_date, type_rate,
            numerator_rate, denominator_rate, journal_desc, remark)
            SELECT 'ADRIAN', A.tenant_id, D.journal_trx_id, 1,
                A.doc_type_id, B.inventory_item_id,
                A.partner_id, B.product_id, -99, -99,
                -99, 'C', 'PRODUCT', -99,
                f_get_product_coa_group_product(A.tenant_id, B.product_id),
                f_get_value_system_config_by_param_code(11, 'ValutaBuku'), ABS(B.qty_realization), B.base_uom_id,
                0 , A.doc_date, 'COM',
                1, 1, 'PRODUCT_STOCK', B.remark
            FROM in_inventory A, in_inventory_item B, gl_journal_trx D
            WHERE --A.inventory_id = vAdjQtyId AND
                A.inventory_id = B.inventory_id AND
                B.qty_realization < 0 --AND
                --B.inventory_item_id = C.inventory_item_id AND
                --(C.flg_buy_konsinyasi = 'N' OR (C.flg_buy_konsinyasi = 'Y' AND C.product_status = 'RETURN'))
                AND A.inventory_id = D.doc_id AND A.doc_type_id = D.doc_type_id
                AND B.product_id = 6426;


            INSERT INTO gl_journal_trx_item
            (tenant_id, journal_trx_id, line_no,
            ref_doc_type_id, ref_id,
            partner_id, product_id, cashbank_id, ou_rc_id,
            segmen_id, sign_journal, flg_source_coa, activity_gl_id,
            coa_id, curr_code, qty, uom_id,
            amount, journal_date, type_rate,
            numerator_rate, denominator_rate, journal_desc, remark,
            "version", create_datetime, create_user_id, update_datetime, update_user_id)
            SELECT A.tenant_id, A.journal_trx_id, 1218,
                A.ref_doc_type_id, A.ref_id,
                A.partner_id, A.product_id, A.cashbank_id, A.ou_rc_id,
                A.segmen_id, A.sign_journal, A.flg_source_coa, A.activity_gl_id,
                A.coa_id, A.curr_code, A.qty, A.uom_id,
                A.amount, A.journal_date, A.type_rate,
                A.numerator_rate, A.denominator_rate, A.journal_desc, A.remark,
                0, '20170213', -1, '20170213', -1
            FROM tt_journal_trx_item A
            WHERE A.session_id = 'ADRIAN' AND
                A.journal_desc = 'PRODUCT_STOCK';

            DELETE FROM tt_journal_trx_item WHERE session_id = 'ADRIAN';