3 queries found for "Bill Factor Value"

Get Bill Factor values

SELECT *
FROM CI_BF_VAL BFV
WHERE BFV.BF_CD = :INSERT_BILL_FACTOR_CD

uploaded by Nuno Rodrigues

Get value from Bill Factor based on Char Type/Value

SELECT VAL
FROM CI_BF_VAL BFV
WHERE 
TRIM(BFV.BF_CD) = :INSERT_BILL_FACTOR_CD
AND TRIM(BFV.CHAR_TYPE_CD) = :INSERT_CHAR_TYPE_CD
AND TRIM(BFV.CHAR_VAL) = :INSERT_CHAR_VAL
AND (TRIM(BFV.TOU_GRP_CD)=:INSERT_TOU_GRP_CD OR BFV.TOU_GRP_CD=' ')
AND EFFDT = (
    SELECT MAX(EFFDT)
    FROM CI_BF_VAL BFV2
    WHERE BFV2.BF_CD = BFV.BF_CD
      AND TRIM(BFV2.CHAR_TYPE_CD) = :INSERT_CHAR_TYPE_CD
      AND TRIM(BFV2.CHAR_VAL) =:INSERT_CHAR_VAL
      AND (TRIM(BFV.TOU_GRP_CD)=:INSERT_TOU_GRP_CD OR BFV.TOU_GRP_CD=' ')
)

uploaded by Nuno Rodrigues

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