CQ Cyberquery Oracle part category information from mtl_system_items_b
define
file msib_mic = access mtl_item_categories,
set mtl_system_items_b:organization_id,
mtl_item_categories:inventory_item_id = mtl_system_items_b:inventory_item_id,
--mtl_item_categories:category_set_id = 1100000072,
many to one,
null fill on failure;
file msib_mic_mcb = access mtl_categories_b,
set mtl_categories_b:category_id = msib_mic:category_id,
many to one,
null fill on failure;
file msib_mic_mcst = access mtl_category_sets_tl, set mtl_category_sets_tl:category_set_id=msib_mic:category_set_id,
mtl_category_sets_tl:language='US'
where mtl_system_items_b:segment1 = '6102-CNG2'
and mtl_system_items_b:organization_id = 383
list/domain='mtl_system_items_b'
mtl_system_items_b:segment1
msib_mic_mcst:description
msib_mic_mcb:segment1/class
msib_mic_mcb:segment2/family
msib_mic_mcb:segment3/group
msib_mic_mcb:segment4/subgroup
define
file msib_mic = access mtl_item_categories,
set mtl_item_categories:organization_id = 383, --mtl_system_items_b:organization_id,
mtl_item_categories:inventory_item_id = mtl_system_items_b:inventory_item_id,
--mtl_item_categories:category_set_id = 1100000072,
many to one,
null fill on failure;
file msib_mic_mcb = access mtl_categories_b,
set mtl_categories_b:category_id = msib_mic:category_id,
many to one,
null fill on failure;
file xx = access mtl_category_sets_tl, set mtl_category_sets_tl:category_set_id=msib_mic:category_set_id,
mtl_category_sets_tl:language='US'
where mtl_system_items_b:segment1 = '6102-CNG2'
and mtl_system_items_b:organization_id = 383
list/domain='mtl_system_items_b'
mtl_system_items_b:segment1
xx:description
msib_mic_mcb:segment1
msib_mic_mcb:segment2
msib_mic_mcb:segment3
msib_mic_mcb:segment4