INV Item Statuses
Description
- Categories
- Enginatics
- Repository
- GitHub
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.
SQL 23 lines
select * from ( select msavav.inventory_item_status_code status_code, misv.inventory_item_status_code_tl status, misv.description, &column1 xxen_util.yes(msavav.attribute_value) value, &column2 substr(msavav.attribute_name,18) column_name from mtl_item_status_vl misv, mtl_stat_attrib_values_all_v msavav where 1=1 and misv.inventory_item_status_code=msavav.inventory_item_status_code order by msavav.inventory_item_status_code, msavav.attribute_name_disp ) &pivot |
Parameters 1
| Parameter | Type | List of values SQL | |
|---|---|---|---|
| Display Style | LOV |
|