6/6/2026 2:31:08 AM:ShowCBSAcNo CBS A/C No 2: 001001006984
6/6/2026 2:31:08 AM:<------------------------Started ValidationRequest CBS A/C No : 001001006629 ------------------------>
6/6/2026 2:31:08 AM:Connection Read From File  : Status OK 
6/6/2026 2:31:08 AM:Connection Successfully Opened  : Status OK 
6/6/2026 2:31:08 AM:Connection Read From File  : Status OK 
6/6/2026 2:31:08 AM:SCHLENGTH 3
6/6/2026 2:31:08 AM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|006984|SB |001
6/6/2026 2:31:08 AM:A/c no length validation qry --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG FROM  clientmaster,depositmaster  where CLMS_SNO=DEPM_CLIENT  and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='SB'  AND DEPM_NO=006984 union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG FROM  clientmaster,LOANMASTER  where CLMS_SNO=LOAM_CLIENT  and LOAM_BRANCH =001 and TRIM(LOAM_ABBR)='SB'  AND LOAM_NO=006984 UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG FROM  clientmaster,ODMASTER  where CLMS_SNO=ODMT_CLIENT  and ODMT_BRANCH=001 and TRIM(ODMT_ABBR)='SB'  AND ODMT_NO=006984
6/6/2026 2:31:08 AM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001