How to Link the TRANSACTION_SOURCE_ID to TRANSACTION_SOURCE_TYPE_ID of MMT and MMTT tables?
Last updated on JUNE 22, 2017
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)?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms