init_admin_cash_giro_opname

INSERT INTO cb_admin_process_daily_cash_opname(
tenant_id, ou_id, cashbank_id, cashbank_date, flag_process, ref_process_id,
curr_code, total_cash_amount, total_giro_amount,
create_datetime, create_user_id, update_datetime, update_user_id, version)

SELECT B.tenant_id, A.ou_id, A.cashbank_id, '20200731', 'Y', -99,
'IDR', 0, 0,
TO_CHAR(CURRENT_TIMESTAMP, 'YYYYMMDDHH24IISS')::character varying, -1, TO_CHAR(CURRENT_TIMESTAMP, 'YYYYMMDDHH24IISS')::character varying, -1, 0
FROM m_cashbank_ou A
INNER JOIN m_cashbank B ON A.cashbank_id = B.cashbank_id;