INV Item Statuses

➜ Back to Library
Description
Categories: Enginatics
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.
select
*
from
(
select
msavav.inventory_item_status_code status_code,
misv.inventory_item_status_code_tl status,
misv.description,
&column1
xxen_util.yes(msavav.attribute_value) 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 NameSQL textValidation
Display Style
msavav.attribute_name_disp attribute_name,
LOV
Download
Related Blitz Reports
GL Account Distribution Analysis INV Movement Statistics GL Account Analysis (Distributions) TB GL Account Analysis (Drilldown)v2 INV Item Attribute Master/Child Conflicts ECC Procurement, Purchase Orders CAC Interface Error Summary ECC Sourcing, Negotiations, SQL2 ECC Sourcing, Negotiations, SQL1
Blitz Report™