INV Default Category Sets

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Master data report that lists Inventory functional areas and their default category sets
select
xxen_util.meaning(mdcs.functional_area_id,'MTL_FUNCTIONAL_AREAS',700) functional_area,
mcsv.category_set_name,
mdcs.functional_area_id,
mcsv.category_set_id
from
mtl_default_category_sets mdcs,
mtl_category_sets_v mcsv
where
mdcs.category_set_id=mcsv.category_set_id
order by
mdcs.functional_area_id
Download
Related Blitz Reports
CAC Inventory Pending Cost Adjustment - No Currencies CAC Item vs. Component Include in Rollup Controls WSH Commercial Invoice CAC ICP PII Inventory and Intransit Value (Period-End) CAC Inventory and Intransit Value (Period-End) INV Item Category Assignment CAC Material Overhead Setup CAC Inventory Organization Summary PO Receiving Account Distribution (1)
Blitz Report™