THAY ĐỔI TRẠNG THÁI TÀI KHOẢN KÝ QUỸ

THAY ĐỔI TRẠNG THÁI TÀI KHOẢN KÝ QUỸ

#  200719 SELECT PRD_CD, a. * FROM INTELLECT.CA010MB a WHERE AC_NO IN ( SELECT AC_NO FROM INTELLECT.gr020mb WHERE legacy_ac= '102... tháng 1 23, 2024

# 200719

SELECT PRD_CD, a. * FROM INTELLECT.CA010MB a WHERE AC_NO IN (SELECT AC_NO FROM INTELLECT.gr020mb WHERE legacy_ac='1022499025')

SELECT PRD_CD, a. * FROM INTELLECT.CA010MB a WHERE PRD_CD ='114'

SELECT * FROM INTELLECT.GR001MB gm WHERE SUB_PROD_CD IN ('114','159')

[ 515:- For this combination [Subproduct code-114,Currency code-704, Staff flag-N,Dlq stat-0,Acc cat-01,Final legst-01,gr015pam-,Cost centre-122000,Bussiness segment-000100,Final status-1,Customer status-01|,Citizen-VN,Location code-122000,Account branch-BR0