How to Query in SQL for the Contract and Line That Covers a Particular Serial Number (Doc ID 747459.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Service Contracts - Version 11.5.10 to 12.1 [Release 11.5 to 12]
Information in this document applies to any platform.
Information in this document applies to any platform.
***Checked for relevance on 20-Aug-2014***

Goal

This Note gives a SQL query that will list the Contract numbers and corresponding contract lines that cover a particular serial number / install base instance. In R12, use okc_k_headers_all_b instead of okc_k_headers_b.
The query will ask for the serial number as input.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms