INV Status attributes listing

Description

Categories
BI Publisher
Application
Inventory
Source
Status attributes listing (XML)
Short Name
INVIRDST_XML
DB package
INV_INVIRDST_XMLP_PKG

SQL 16 lines

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

Parameters 2

ParameterTypeList of values SQL
Item Statuses FromLOV Oracle
ToLOV Oracle