Howto Relate Contracts to an Inventory Item (Joining tables from OKC/OKS/MTL)? (Doc ID 416334.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Inventory Management - Version: 11.5.10 and later   [Release: 11.5 and later ]

Goal

How does one join contract information in OKC tables to inventory item information in MTL tables?

For example, the inventory items table is MTL_SYSTEM_ITEMS_B and a contract lines table is OKC_K_LINES_B.  How do these tables join to show items on a contract?

NOTE
The following three letter abbreviations are often found at the start of modules related to contracts and inventory. They are the three letter module shortname:

OKC is an abbreviation for the core contracts module.
OKS is an abbreviation for the service contracts module.
MTL is the abbreviation for the inventory module.

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