你好,游客 登录
背景:
阅读新闻

Item Categories - PTIAN ORACLE EBS REPOSITORY

[日期:2013-04-15] 来源:  作者: [字体: ]

Category是把具有相似特性的物料分配到一个类别里。Category set是一组Category的合集。



The complete set up of item categories is done in below 5 steps in sequence.



Related Tables

MTL_CATEGORIES_B is the code combinations table for item categories. Items are grouped into categories within the context of a category set to provide flexible grouping schemes.
The item category is a key flexfield with a flex code of MCAT. The flexfield structure identifier is also stored in this table to support the ability to define more than one flexfield structure (multi-flex).
Item categories now support multilingual category description. MLS is implemented with a pair of tables: MTL_CATEGORIES_B and MTL_CATEGORIES_TL. MTL_CATEGORIES_TL table holds translated Description for Categories.

Primary Key:CATEGORY_ID


MTL_CATEGORY_SETS_B contains the entity definition for category sets. A category set is a categorization scheme for a group of items. Items may be assigned to different categories in different category sets to represent the different groupings of items used for different purposes. An item may be assigned to only one category within a category set, however.

STRUCTURE_ID identifies the flexfield structure associated with the category set. Only categories with the same flexfield structure may be grouped into a category set.

CONTROL_LEVEL defines whether the category set is controlled at the item or the item/organization level. When an item is assigned to an item level category set within the item master organization, the category set assignment is propagated to all other organizations to which the item is assigned.

VALIDATE_FLAG defines whether a list of valid categories is used to validate category usage within the set. Validated category sets will not allow item assignment to the category set in categories that are not in a predefined list of valid categories.
.
Category Sets now support multilingual category set name and description. MLS is implemented with a pair of tables: MTL_CATEGORY_SETS_B and MTL_CATEGORY_SETS_TL. MTL_CATEGORY_SETS_TL table holds translated Name and Description for Category Sets

Primary Key:CATEGORY_SET_ID


MTL_ITEM_CATEGORIES stores inventory item assignments to categories within a category set. For each category assignment, this table stores the item, the category set, and the category. Items always may beassigned to multiple category sets. However, depending on the Multiple Assignments Allowed attribute value in a given category set definition,an item can be assigned to either many or only one category in that category set.
.
This table may be populated through the Master Items and Organization Items windows. It can also be populated by performing item assignments when a category set is defined. It is also populated when an item is transferred from engineering to
manufacturing. The table may also be populated through the Item Category Open Interface.

Primary Key:INVENTORY_ITEM_ID + ORGANIZATION_ID + CATEGORY_SET_ID





References:

How to create a Category Set and Assign Items to Categories [ID 423551.1]

http://imdjkoch.wordpress.com/2011/07/29/how-to-create-category-and-category-set-in-oracle-inventory/







收藏 推荐 打印 | 录入:admin | 阅读:
相关新闻