My Oracle Support Banner

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

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
  Goal
  Solution

Platforms: 1-914CU;

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

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