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

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

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

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