INV Item Statuses
Description
Categories: Enginatics, Toolkit - Operations, Toolkit - Setup & Support
Repository: Github Columns: Status Code, Status, Description, Bom Allowed, Build In Wip, Customer Order Enabled, Internal Order Enabled, Invoice Enabled, Process Execution Enabled, Purchasable ...
Repository: Github Columns: Status Code, Status, Description, Bom Allowed, Build In Wip, Customer Order Enabled, Internal Order Enabled, Invoice Enabled, Process Execution Enabled, Purchasable ...
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.
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 | |
Display Style |
|
||
Display Style |
|