Reports2017-11-18T12:27:27+00:00

INV Item Statuses

Description
Categories: Enginatics, Logistics, Setup
Inventory item statuses and their attributes such as:

BOM Allowed
Build in WIP
Customer Orders Enabled
Internal Orders Enabled
Invoice Enabled
Process Execution Enabled
Purchasable
Recipe Enabled
Stockable
Transactable

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
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
)
)
Display Style
msavav.control_level_disp control_level,