1 query found for "Rate Version"
Retrieve the relevant Rate Schedule, rate version, rate component and bill factors.
--This query retrieves the relevant rate schedule,rate version, rate component and bill factors. Save the data in excel and make pivot table to give a meaningful picture to this complex data set :-) '
select * from ci_rs rs, ci_rv rv, ci_rc rc, ci_bf bf, ci_bf_val bfv
where rs.rs_cd=rv.rs_cd
and rv.rs_cd=rc.rs_cd
and rc.bf_cd=bf.bf_cd
and bf.bf_cd=bfv.bf_cd
and rs.rs_cd='Insert Rate Schedule code'
uploaded by Muhammad Junaid