SELECT * FROM gl_journal_trx_item A
INNER JOIN gl_journal_trx B ON A.journal_trx_id = B.journal_trx_id
WHERE SUBSTRING(B.doc_date, 1, 6)  = '201709' AND
      B.tenant_id = 10 AND
      B.ou_bu_id = 10
    AND A.coa_id IN (
        SELECT f_get_product_coa_group_product(A.tenant_id, A.product_id)
        FROM in_summary_monthly_amount A
        WHERE A.date_year_month  = '201709' AND
                  A.ou_bu_id = 10 AND
                  A.tenant_id = 10 AND
                  A.doc_type_id = 311
                  AND A.product_id = 2081
    )