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 laterInformation in this document applies to any platform.
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.
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 |