INV Status attributes listing

➜ Back to Library
Description
Categories: BI Publisher
Application: Inventory
Source: Status attributes listing (XML)
Short Name: INVIRDST_XML
DB package: INV_INVIRDST_XMLP_PKG
Run INV Status attributes listing and other Oracle EBS reports with Blitz Report™ on our demo environment
select mia.user_attribute_name,
       fl.meaning   fnd_meaning,
       ml.meaning  mfg_meaning,
       msav.inventory_item_status_code  item_status_code2
from    mtl_status_attribute_values msav,
        mtl_item_attributes mia,
        mfg_lookups ml,
       fnd_lookups fl
where   msav.ATTRIBUTE_NAME = mia.ATTRIBUTE_NAME
and     ml.lookup_type = 'ITEM_STATUS_CONTROL'
and     ml.lookup_code = mia.status_control_code
and     fl.lookup_type = 'YES_NO'
and     fl.lookup_code = msav.ATTRIBUTE_VALUE 
-- and msav.inventory_item_status_code=:item_status_code
order by mia.user_attribute_name
Parameter Name SQL text Validation
Item Statuses From 
 
 LOV Oracle
To 
 
 LOV Oracle
Download
 
Related Blitz Reports
CAC Intercompany SO Price List vs. Item Cost Comparison CAC Intercompany SO Price List CAC Receiving Value (Period-End) PO Endeca Template OPM2 CAC Inventory Out-of-Balance CAC ICP PII Inventory and Intransit Value (Period-End) CAC Accounting Period Status BOM Item Where Used Report GUI
Blitz Report™

Blitz Report™ provides multiple benefits: