| layout | default |
|---|---|
| title | INV Item Statuses | Oracle EBS SQL Report |
| description | Master data report of inventory items with the various status attributes, such as: is BOM allowed, Build in WIP, customer orders enabled, internal orders… |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, INV, Item, Statuses, mtl_item_status_vl, mtl_stat_attrib_values_all_v |
| permalink | /INV%20Item%20Statuses/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
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.
Display Style
mtl_item_status_vl, mtl_stat_attrib_values_all_v
GL Account Distribution Analysis, INV Movement Statistics, GL Account Analysis (Distributions), INV Item Attribute Master/Child Conflicts, CAC Interface Error Summary
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 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)/ |
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.
- 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.
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.
- 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).
- Display Style: How to format the output.
- 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