Tuesday, March 30, 2010

Tables related to Item Catalog Group

Following are the table for Item Catalog
  • Mtl_Item_Catalog_Groups
  • Mtl_Descriptive_Elements
  • Mtl_descr_element_values

MTL_ITEM_CATALOG_GROUPS: When a new Item catalog group is created using Item Catalog Group Screen, this table is populated.
Following are the important column in this table
o        Item_Catalog_Group_Id
o        Segment1
o        Description
      MTL_DESCRITIVE_ELEMENTS: When a descriptive element are created for Item     
      catalog group, this table is populated
      Following are the important column in this table
o        Item_Catalog_Group_Id
o        Element_Name
o        Required_Element_Flg
o        Default_Element_Flag
      MTL_DESCR_ELEMENT_VALUES: When a element value is entered for each descriptive
      elements in Item catalog screen, this table is populated.
      Following are the important column in this table
o        Inventory_Item_Id
o        Element_Name
o        Element_Value
o        Default_Element_Flag

1 Responses to “Tables related to Item Catalog Group”

Anonymous said...
June 24, 2015 at 9:50 AM

Thanks for sharing your knowledge with us, just the table name is "MTL_DESCRIPTIVE_ELEMENTS"


Post a Comment

Disclaimer

The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.