magritton
7/10/2015 - 7:50 PM

CQ Cyberquery Oracle part category information from mtl_system_items_b

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