INV Status attributes listing

Description
Categories: BI Publisher, Logistics
Application: Inventory
Source: Status attributes listing (XML)
Short Name: INVIRDST_XML
DB package: INV_INVIRDST_XMLP_PKG
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
To
 
LOV Oracle
Item Statuses From
 
LOV Oracle