SQL to get Coverage and Service name from contract

HI :  really need some help.  My ERP is 11.5.10.2   I try to write a SQL to get the Contract number ( okc_k_headers_b ) Coverage name, Coverage description , ( okc_coverage_v ) Service name, Service Description Warranty ( ??? table ), tem instance number ( csi_item_instances ) and Item  ( mtl_system_items ).

So far, I was NOT able to locate the tables and join to get the service name and service description.  Any help?

Here is one of the example data I am looking for

Service Manager > View Installed Base > enter serial number and item > click Search

It return Item Instance

click on Contract link