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
| Parameter | Type | List of values SQL |
|---|---|---|
| Item Statuses From | LOV Oracle | |
| To | LOV Oracle |