differences between item category and item catalog

Purchasing & Inventory forum can be used to discuss all features/issues related to Oracle Purchasing & Inventory.
Post Reply
g_suri24
Posts: 22
Joined: Thu Feb 22, 2007 8:39 am
Location: India

differences between item category and item catalog

Post by g_suri24 »

Hi,

what is the exact definitions of ITEM CATEGORY and ITEM CATALOG,
The main differences between item category and item catalog.
Please kindly take some time to answer this.....

thanks in advance..

thanks & regards,
surender reddt g
ashishd
Posts: 7
Joined: Fri Apr 25, 2008 1:08 am
Location: India

Post by ashishd »

Hi Surender

<b>Item Categories</b> shows the tables and relationships that Inventory uses to maintain category information for items. Note that each item may be assigned to a single category within a category set but may be assigned to many category sets. A category set may be restricted to a list of valid categories using the table MTL_CATEGORY_SET_VALID_CATS. Additionally, functional areas (i.e. Inventory, Purchasing), etc.) may have default category sets defined. Each item used by the functional.

<b>Item Catalog</b> shows the tables and relationships that Inventory uses to implement the Item Catalog. The descriptive elements
associated with the catalog group are defined in MTL_DESCRIPTIVE
ELEMENTS. The values of those descriptive elements for each item
assigned to the catalog group are stored in
MTL_DESCR_ELEMENT_VALUES. Recommended aliases and
recommended categories to be used with the items assigned to a
catalog group are stored in MTL_ICG_ALIASES and
MTL_ICG_CATEGORIES.

For more description refer :
Oracle Inventory Technical Reference Manual Page 40-41

Thanks And Regards
AshishD
admin
Posts: 2063
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Post by admin »

Post Reply

Who is online

Users browsing this forum: No registered users and 14 guests