Howto Relate Contracts to an Inventory Item (Joining tables from OKC/OKS/MTL)?
Last updated on MARCH 08, 2017
Applies to:Oracle Inventory Management - Version: 11.5.10
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms