| layout | default |
|---|---|
| title | INV Transaction Source Types | Oracle EBS SQL Report |
| description | – Oracle E-Business Suite SQL report |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, INV, Transaction, Source, Types, mtl_txn_source_types |
| permalink | /INV%20Transaction%20Source%20Types/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
None
Source, Show DFF Attributes
INV Transaction Historical Summary, CAC WIP Jobs With Complete Status Which Are Ready for Close, CAC AP Accrual IR ISO Match Analysis, CAC Internal Order Shipment Margin
Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.
| Resource | Link |
|---|---|
| Excel Example Output | INV Transaction Source Types 20-Jul-2024 235051.xlsx |
| Blitz Report™ XML Import | INV_Transaction_Source_Types.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/inv-transaction-source-types/ |
The INV Transaction Source Types report is a system configuration report. In Oracle Inventory, every transaction has a "Source Type" that defines where the transaction originated (e.g., "Purchase Order", "Sales Order", "Account", "Job or Schedule"). This report lists these system-defined sources.
Understanding the "Source" of a transaction is key to understanding the business process.
- Reporting: When building custom reports, developers need to know that Source Type 1 = "Purchase Order" and Source Type 2 = "Sales Order".
- Validation: Users need to know which sources are available when defining new Transaction Types.
The INV Transaction Source Types report lists the values from MTL_TXN_SOURCE_TYPES. These are mostly seeded (system-defined) values that cannot be changed, but they are critical for reference.
Key Features:
- ID Mapping: Shows the numeric ID and the user-friendly name.
- Validation: Used as the validation set for the "Source" field in many other forms.
The report queries the seed data table.
MTL_TXN_SOURCE_TYPES: The table storing the source definitions.
- Retrieval: Selects all records from the table.
- Display: Lists the ID, Name, and Description.
- Developer Aid: Essential reference for anyone writing SQL queries against
MTL_MATERIAL_TRANSACTIONS. - System Understanding: Helps users understand the different "origins" of inventory demand and supply.
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© 2026 Enginatics