INV Item Statuses

➜ Back to Library
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
)
)
Download
 
Related Blitz Reports
ECC Contract Lifecycle Management, Requisitions, SQL11 ECC Contract Lifecycle Management, Requisitions, SQL11 (1) ECC Procurement, Purchase Orders AHL Supplier Warranty Visit ECC Sourcing, Negotiations, SQL2 ECC Sourcing, Negotiations, SQL1 WSH Open Deliveries PO Endeca Template INV Movement Statistics
Blitz Report In Action
Blitz Report™

Blitz Report™ provides multiple benefits: