My Oracle Support Banner

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

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Inventory Management - Version 11.5.10 and later
Information in this document applies to any platform.


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?

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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.