2 queries found for "Message Language"

All To Do Entry with the Messages (! LANGUAGE_CD='FRA')

SELECT 
    TD.TD_ENTRY_ID,
    TD.TD_TYPE_CD,
    TD.ROLE_ID,
    TD.BATCH_CD,
    TD.BATCH_NBR,
    TD.MESSAGE_CAT_NBR,
    TD.MESSAGE_NBR,
    MSG.MESSAGE_TEXT,
    MSG.DESCRLONG,
    TD.CRE_DTTM,
    TD.ENTRY_STATUS_FLG,
    TD.ASSIGNED_TO,
    TD.ASSIGNED_USER_ID,
    TD.ASSIGNED_DTTM,
    TD.COMPLETE_DTTM,
    TD.COMPLETE_USER_ID,
    TD.COMMENTS,
    TD.TD_PRIORITY_FLG
FROM 
    CI_TD_ENTRY TD,
    CI_MSG_L MSG
WHERE 
    1=1
    AND TD.MESSAGE_CAT_NBR = MSG.MESSAGE_CAT_NBR
    AND TD.MESSAGE_NBR = MSG.MESSAGE_NBR
    AND MSG.LANGUAGE_CD = 'FRA'
    

uploaded by Przemek Ciempiel

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