My Oracle Support Banner

How to Link the TRANSACTION_SOURCE_ID to TRANSACTION_SOURCE_TYPE_ID of MMT and MMTT tables? (Doc ID 987471.1)

Last updated on DECEMBER 05, 2024

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

 

Goal

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)?




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
References


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