INV Item Statuses – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Master data report of inventory items with the various status attributes, such as: is BOM allowed, Build in WIP, customer orders enabled, internal orders enabled and Invoice enabled, etc.
Report Parameters
Display Style
Oracle EBS Tables Used
mtl_item_status_vl, mtl_stat_attrib_values_all_v
Report Categories
Related Reports
GL Account Distribution Analysis, INV Movement Statistics, GL Account Analysis (Distributions), INV Item Attribute Master/Child Conflicts, CAC Interface Error Summary
Running This SQL Without Blitz Report
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.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | INV Item Statuses 07-Apr-2018 130703.xlsx |
| Blitz Report™ XML Import | INV_Item_Statuses.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/inv-item-statuses(14)/ |
INV Item Statuses - Case Study & Technical Analysis
Executive Summary
The INV Item Statuses report is a configuration audit document for the “Item Status” codes (e.g., Active, Inactive, Obsolete, Prototype). In Oracle, the Status controls a set of functional flags (Is it Stockable? Is it Purchasable? Is it Orderable?). This report lists these definitions, ensuring that an “Obsolete” item, for example, is correctly blocked from being purchased or sold.
Business Use Cases
- Lifecycle Management: Verifies that the “End of Life” status correctly disables all transaction flags to prevent accidental use.
- New Product Introduction (NPI): Ensures that “Prototype” items are transactable in Engineering but not visible to Sales.
- Master Data Governance: Audits the consistency of status rules across the enterprise.
Technical Analysis
Core Tables
MTL_ITEM_STATUS_VL: The header definition of the status code.MTL_STAT_ATTRIB_VALUES_ALL_V: The values of the individual attributes (flags) for that status.
Key Joins & Logic
- Attribute Control: The report shows the state of key attributes like
STOCK_ENABLED_FLAG,PURCHASING_ENABLED_FLAG,CUSTOMER_ORDER_ENABLED_FLAG. - Pending Changes: Some versions of this report may show pending status changes (future dated).
Key Parameters
- Display Style: How to format the output.
Useful Links
- 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