1 query found for "To Do Type Language"
Retrieve To Do Counts
SELECT /*+ PARALLEL(4) */
TD.TD_TYPE_CD,
TD.TD_ENTRY_ID,
MSL.MESSAGE_TEXT,
TD.ENTRY_STATUS_FLG,
TD.BATCH_CD,
LANG.DESCR,
TD.MESSAGE_NBR,
TD.MESSAGE_CAT_NBR
FROM
CISADM.CI_TD_ENTRY TD,
CISADM.CI_TD_TYPE_L LANG,
CISADM.CI_MSG_L MSL
WHERE TD.TD_TYPE_CD = LANG.TD_TYPE_CD
AND MSL.MESSAGE_CAT_NBR = TD.MESSAGE_CAT_NBR
AND MSL.MESSAGE_NBR = TD.MESSAGE_NBR
AND TD.ROLE_ID = 'ITADMIN'
AND TD.ENTRY_STATUS_FLG <> 'C'
ORDER BY
MSL.MESSAGE_TEXT;
uploaded by Alex Joseph Dionisio