INV Item Statuses
Description
Categories: Enginatics
Repository: Github
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.
Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS
Contact us to schedule a demo or if you need help with the installation
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 |
|
LOV |