Notes![what is notes.io? What is notes.io?](/theme/images/whatisnotesio.png)
![]() ![]() Notes - notes.io |
MH.CD,
A.AMT_OS_PRINCIPAL,
A.DUE_PRINCIPAL_AMT,
TA.CURR_USER_ID,BR.CD BR_CD
FROM EBDCRS.T_ASSIGNMENTS TA
INNER JOIN EBDCRS.T_WORKFLOW_HISTS WH
ON TA.MCASE_ID = WH.MCASE_ID
INNER JOIN EBDCRS.T_MT_ROUTING_TYPS MRT
ON MRT.ID = WH.MT_ROUTING_TYP_ID
AND MRT.CD IN ('CASE_REASSIGNMENT','ROUTING')
INNER JOIN EBDCRS.T_MCASES MC
ON MC.ID = TA.MCASE_ID
INNER JOIN EBDCRS.T_MT_DEPTS DEPT
ON MC.MT_DEPT_ID = DEPT.ID
INNER JOIN EBDCRS.T_CASES TC
ON TC.MCASE_ID = MC.ID
AND TA.MCASE_ID = TC.MCASE_ID
AND TC.IS_OUT_OF_BOUND = 'N'
inner join
(select TCa.CIF_NO,
taa.MCASE_ID from ebdcrs.t_assignments taa
INNER JOIN ebdcrs.t_cases tca ON taa.mcase_id = tca.mcase_id and tca.id = taa.worst_aging_case_id AND TCa.is_cured = 'N' and tca.is_out_of_bound ='N' and tca.is_out_of_group = 'N' and TCa.CPF_FLAG = 'Y'
) CIFNO on CIFNO.MCASE_ID=TC.MCASE_ID and CIFNO.CIF_NO = TC.CIF_NO
INNER JOIN EBDCRS.T_MT_HOSTS MH
ON MH.ID = TC.ACCT_MT_HOST_ID
INNER JOIN EBDCRS.T_HT_ACCTS A
ON A.ACCT_NO = TC.ACCT_NO
AND A.CPF_FLAG = 'Y'
INNER JOIN
(SELECT
BR.ID,BR.CD,BR.DSCP,
BR.SYS_APF_CD
FROM EBDCRS.T_MT_BRANCHES BR
INNER JOIN EBDCRS.T_MT_BR_HRCHY_LVLS LVL
ON LVL.ID = BR.MT_BR_HRCHY_LVL_ID
WHERE LVL.CD = '20' – CHI NH?NH
AND BR.IS_DEL = 'N'
AND BR.IS_DEACTIVATE = 'N'
) BR
ON BR.ID = A.MT_BR_ID
WHERE DEPT.CD = 'RECOVERY'
AND TC.MT_MOD_ID = (SELECT ID
FROM EBDCRS.T_MT_MODS
WHERE CD = 'RC'
AND IS_DEL = 'N')
AND (
(EXISTS
(SELECT 1
FROM EBDCRS.T_SKIP_ASGN_CASES SAC
INNER JOIN EBDCRS.T_MT_SKIP_ASGN_RSN SAR
ON SAR.ID = SAC.MT_SKIP_ASGN_RSN_ID
AND SAR.SYS_APF_CD = SAC.SYS_APF_CD
WHERE SAR.CD IN ('CASE_REASSIGNMENT', 'ROUTING')
AND SAC.MCASE_ID = TA.MCASE_ID)
AND MC.IS_SKIP_TRACE <> 'Y'
AND NVL (MC.IS_ST_ASSIGNED, 'N') <> 'Y')
OR TA.DT_ROUTE IS NOT NULL)
![]() |
Notes.io is a web-based application for taking notes. You can take your notes and share with others people. If you like taking long notes, notes.io is designed for you. To date, over 8,000,000,000 notes created and continuing...
With notes.io;
- * You can take a note from anywhere and any device with internet connection.
- * You can share the notes in social platforms (YouTube, Facebook, Twitter, instagram etc.).
- * You can quickly share your contents without website, blog and e-mail.
- * You don't need to create any Account to share a note. As you wish you can use quick, easy and best shortened notes with sms, websites, e-mail, or messaging services (WhatsApp, iMessage, Telegram, Signal).
- * Notes.io has fabulous infrastructure design for a short link and allows you to share the note as an easy and understandable link.
Fast: Notes.io is built for speed and performance. You can take a notes quickly and browse your archive.
Easy: Notes.io doesn’t require installation. Just write and share note!
Short: Notes.io’s url just 8 character. You’ll get shorten link of your note when you want to share. (Ex: notes.io/q )
Free: Notes.io works for 12 years and has been free since the day it was started.
You immediately create your first note and start sharing with the ones you wish. If you want to contact us, you can use the following communication channels;
Email: [email protected]
Twitter: http://twitter.com/notesio
Instagram: http://instagram.com/notes.io
Facebook: http://facebook.com/notesio
Regards;
Notes.io Team