How to Link the TRANSACTION_SOURCE_ID to TRANSACTION_SOURCE_TYPE_ID of MMT and MMTT tables?
(Doc ID 987471.1)
Last updated on JULY 03, 2018
Applies to:Oracle Inventory Management - Version 11.5.10 and later
Information in this document applies to any platform.
This document includes all versions of 11i and R12 and later
Checked for relevance on 2-FEB-2017
1. In tables MTL_MATERIAL_TRANSACTIONS (MMT) and MTL_MATERIAL_TRANSACTIONS_TEMP (MMTT), how can TRANSACTION_SOURCE_ID be linked to TRANSACTION_SOURCE_TYPE_ID?
2. How to understand the value of TRANSACTION_SOURCE_ID, in order to join it to primary source table (ex Sales Order, Purchase Order)?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!