INV Item Statuses

Description
Categories: Enginatics, Toolkit - Operations, Toolkit - Setup & Support
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.
Run INV Item Statuses and other Oracle EBS reports with Blitz Report™ on our demo environment
select
*
from
(
select
msavav.inventory_item_status_code status_code,
misv.inventory_item_status_code_tl status,
misv.description,
&column1
xxen_util.meaning(decode(msavav.attribute_value,'Y','Y'),'YES_NO',0) 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
Parameter Name SQL text Validation
Display Style
msavav.attribute_name_disp attribute_name,
LOV