4 queries found for "Billable Charge"

Get all from Billable Charge

select * 
from CI_BILL_CHG

uploaded by Nuno Rodrigues

Get specific Billable Charge

select * 
from CI_BILL_CHG
where 
BILLABLE_CHG_ID = 'XXXX'

uploaded by Nuno Rodrigues

Retrieve Off Cycle Bill Generator SAs

SELECT DISTINCT B.SA_ID
FROM C1_OFFCYC_BGEN_BCHG A, CI_BILL_CHG B
WHERE A.OFFCYC_BGEN_ID = 'INSERT_OFFCYC_GEN_ID'
And A.BILLABLE_CHG_ID = B.BILLABLE_CHG_ID
UNION
SELECT A.SA_ID from C1_OFFCYC_BGEN_SA A
WHERE A.OFFCYC_BGEN_ID =  'INSERT_OFFCYC_GEN_ID'

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