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 ...
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
msavav.attribute_name_disp attribute_name,
LOV
Display Style
msavav.control_level_disp control_level,
Display Style
pivot (
max(value) " "
for
column_name in (
'BOM_ENABLED_FLAG' bom_allowed,
'BUILD_IN_WIP_FLAG' build_in_wip,
'CUSTOMER_ORDER_ENABLED_FLAG' customer_order_enabled,
'INTERNAL_ORDER_ENABLED_FLAG' internal_order_enabled,
'INVOICE_ENABLED_FLAG' invoice_enabled,
'PROCESS_EXECUTION_ENABLED_FLAG' process_execution_enabled,
'PURCHASING_ENABLED_FLAG' purchasable,
'RECIPE_ENABLED_FLAG' recipe_enabled,
'STOCK_ENABLED_FLAG' stockable,
'MTL_TRANSACTIONS_ENABLED_FLAG' transactable
)
)