2 queries found for "To Do Entry Characteristics"

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

Retrieve Billable Charge Id

select  billable_chg_id
from ci_bill_chg bc
where billable_chg_id not in (select billable_chg_id from ci_bseg_calc bc1 where trim(bc.billable_chg_id)=trim(bc1.billable_chg_id))
and billable_chg_id not in (select char_val_fk1 from ci_td_entry_cha where trim(char_val_fk1) = billable_chg_id)
AND DESCR_ON_BILL<>'xxxxx'
AND BC.BILLABLE_CHG_STAT = '10'

uploaded by Lipika Roy