Service Contract Entitlement Data

Hi,

I am looking for data extract from the oracle service contracts module with the list of entitlements correspond to active contracts of a particular group.

I tried with the following list of tables, but I am not able to get the place where the entitlement-service activity billing type being stored.

Also I observed when we modify the coverage plan in the contract and add entitlements (service activity billing type), it adds lots of lines in the okc_k_lines_b table

oks_k_headers_all_b

oks_k_lines_b

oks_coverages_v

oks_ent_coverages_v

Please help me to frame a SQL query for this data extract.