6 queries found for "To Do Entry"

Get all from To Do Entry

select * 
from CI_TD_ENTRY

uploaded by Nuno Rodrigues

Get specific To Do Entry

select * 
from CI_TD_ENTRY
where 
TD_ENTRY_ID = 'XXXX'

uploaded by Nuno Rodrigues

Retrieve To Do for a given Characteristic

SELECT 
    TD.*
FROM 
    CI_TD_ENTRY TD, 
    CI_TD_ENTRY_CHA TDC
WHERE 
    TD.TD_TYPE_CD = 'INSERT_TODO_TYPE_CD'
    AND TD.TD_ENTRY_ID = TDC.TD_ENTRY_ID
    AND TDC.CHAR_TYPE_CD = 'INSERT_CHAR_TYPE_CD'
    AND TDC.SRCH_CHAR_VAL = 'INSERT_CHAR_VAL'

uploaded by Nuno Rodrigues

Close out To-do's of particular type

Update Cisadm.Ci_Td_Entry 
Set Entry_Status_Flg  = 'C'
 where message_nbr ='XXXXXX' and td_type_cd ='XXXXXXX' and Entry_Status_Flg='O'

uploaded by Vinayak Gadgil

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