Coverage Type, Service Activity Billing Type and Covered %

Hi,

I have requirement to extract Coverage Name, Service Activity Billing Type and Covered Percentage.

I have managed to get Coverage name and Discount Percent, but not Billing Type.

Below query returns OBJECT1_ID1 = 71 for Billing Type Id.

select OCV.Name, oki.JTOT_OBJECT1_CODE, OKI.OBJECT1_ID1, KLN.Discount_Percent

from apps.okc_k_lines_b okl

        inner join oks_k_lines_b KLN on KLN.CLE_ID = OKL.Id  -- To get Discount Percentage

        inner join OKC_K_Items OKI on OKI.CLE_ID = okl.ID and OKI.DNZ_CHR_ID = -1

        inner join apps.okc_k_lines_b okl_COV on okl_COV.id = OKL.CLE_Id