DOC

Table Information

By Francisco Stevens,2014-10-06 00:45
10 views 0
Table Information

    Table Information

    Overview

     Copyright ? Oracle, 2007. All rights reserved.

    Table Information 85709005.DOC

    Effective mm/dd/yy Page 1 of 19 Rev 1

Table Information

    System References

    None.

    Distribution

    *Job Title

    Ownership

    The Job Title [list@YourCompany.com?Subject=EDU40D7Y.doc] is responsible for ensuring

    that this document is necessary and that it reflects actual practice.

     Copyright ? Oracle, 2007. All rights reserved.

    Table Information 85709005.DOC

    Effective mm/dd/yy Page 2 of 19 Rev 1

R12 Table Information

Instructor Note

    Explain to students that the ERDs contained in this module are frozen at release 12.0.

     Copyright ? Oracle, 2007. All rights reserved.

    Table Information 85709005.DOC

    Effective mm/dd/yy Page 3 of 19 Rev 1

Objective

     Copyright ? Oracle, 2007. All rights reserved. Table Information 85709005.DOC Effective mm/dd/yy Page 4 of 19 Rev 1

Organization Tables

Organization Tables

     MTL_PARAMETERS: Associated with an organization. Primary key:

    ORGANIZATION_ID.

     MTL_INTERORG_PARAMETERS: Identifies the receiving organizations linked to a

    particular organization. You must define the interorganizational relationship before you

    perform any interorganization transfers. Units of measure, distance, transfer charge, and

    accounting information are also specified in this table. Primary key:

    FROM_ORGANIZATION_ID, TO_ORGANIZATION_ID.

     GL_SETS_OF_BOOKS: Stores define set of books data in General Ledger. Each row

    includes the set of books name, description, functional currency, and other data.

    Corresponds to the Define Set of Books window. Primary key:

    GENERAL_LEDGER_UPDATE_CODE.

     GL_CODE_COMBINATIONS: Stores valid Accounting Flexfield segment value

    combinations for each accounting flexfield structure within your General Ledger. Primary

    key: CODE_COMBINATION_ID.

     HR_ALL_ORGANIZATION_UNITS: Stores generic data about organizations. An

    organization can be used for various purposes in Oracle Manufacturing applications. For

     Copyright ? Oracle, 2007. All rights reserved.

    Table Information 85709005.DOC

    Effective mm/dd/yy Page 5 of 19 Rev 1

    example, one organization can represent a business group, an ECO department, a planning

    organization, and an inventory organization. Primary key: ORGANIZATION_ID.

     Copyright ? Oracle, 2007. All rights reserved.

    Table Information 85709005.DOC

    Effective mm/dd/yy Page 6 of 19 Rev 1

Subinventories and Locator Tables

Subinventories and Locator Tables

     MTL_SYSTEM_ITEMS_B is the definition table for items. This table holds the

    definitions for inventory items, engineering items, and purchasing items. The flexfield

    code is MSTK. The primary key for an item is the INVENTORY_ITEM_ID and the

    ORGANIZATION_ID. The same item could be defined in more than one organization.

    Each row represents an item in an organization.

     MTL_SYSTEM_ITEMS_TL: This table is holding translated Description column for

    Items. The primary key is INVENTORY_ITEM_ID, ORGANIZATION_ID,

    LANGUAGE.

     GL_CODE_COMBINATIONS: This table stores valid Accounting Flexfield segment

    value combinations for each accounting flexfield structure within your General Ledger

    application. The primary key is CODE_COMBINATION_ID.

     MTL_SECONDARY_INVENTORIES: This table is the definition table for the

    subinventory. Subinventories are assigned to items, indicating a list of valid places in

    which this item may be located. The primary key is

    SECONDARY_INVENTORY_NAME, ORGANIZATION_ID.

     Copyright ? Oracle, 2007. All rights reserved.

    Table Information 85709005.DOC

    Effective mm/dd/yy Page 7 of 19 Rev 1

     MTL_ITEM_SUB_INVENTORIES: This table maintains a listing of subinventories

    assigned to an inventory or engineering item. The subinventories make up the valid list of

    subinventories when transacting a specific item if the user has specified that the item must

    use subinventories from a predefined list. The primary key is INVENTORY_ITEM_ID,

    ORGANIZATION_ID, SECONDARY_INVENTORY.

     MTL_ITEM_LOCATIONS: This table is the definition table for stock locators. The

    associated attributes describe the subinventory to which this locator belongs, and the

    locator physical capacity. The primary key is INVENTORY_LOCATION_ID.

     MTL_SECONDARY_LOCATORS: This table stores all locators within a subinventory

    for a specific item. The locators make up the valid list of locators when transacting that

    specific item to/from the subinventory when the user has specified that the item must use

    locators from a predefined list. The primary key is INVENTORY_ITEM_ID,

    ORGANIZATION_ID, SECONDARY_LOCATORS.

     MTL_PARAMETERS: This table stores the parameters for an inventory organization

    with which an item is associated. The primary key is the ORGANIZATION_ID.

    Subinventories and Locators Tables.

     Copyright ? Oracle, 2007. All rights reserved.

    Table Information 85709005.DOC

    Effective mm/dd/yy Page 8 of 19 Rev 1

Item Master Tables

Item Master

     MTL_SYSTEM_ITEMS_B: This table is the definition table for items. This table holds

    the definitions for inventory items, engineering items, and purchasing items. The flexfield

    code is MSTK. The primary key for an item is the INVENTORY_ITEM_ID and the

    ORGANIZATION_ID. The same item could be defined in more than one organization.

    Each row represents an item in an organization.

     MTL_ITEM_ATTRIBUTES: This table stores the item attributes, their user-friendly

    names if the item is maintained at the item or item/organization level, and the kind of

    validation required for each attribute. This table is seeded on install or upgrade. The

    primary key is ATTRIBUTE_NAME.

     MTL_ITEM_TEMPL_ATTRIBUTES: This table stores the attributes and attribute values

    for a template. When a template is created, a row is inserted for each available item

    attribute. When the template is applied to an item, the enabled attribute values are

    propagated to the item. The primary key is TEMPLATE_ID, ATTRIBUTE_NAME.

     MTL_ITEM_STATUS_TL: This table is the definition table for a material status code.

    The status code is a required item attribute and indicates the item status (for example,

    active, pending, or obsolete). You may define as many additional status codes as you want.

     Copyright ? Oracle, 2007. All rights reserved.

    Table Information 85709005.DOC

    Effective mm/dd/yy Page 9 of 19 Rev 1

    The values of the individual status attributes associated with an item status are stored in

    MTL_STATUS_ATTRIBUTE_VALUES. The primary key is

    INVENTORY_ITEM_STATUS_CODE.

     MTL_ITEM_TEMPLATES_B: This table is the definition table for item templates. It

    contains the user-defined name and description. When the template is applied to an item,

    the enabled item attributes are propagated to the item. The primary key is

    TEMPLATE_ID.

     MTL_STATUS_ATTRIBUTE_VALUES: This table stores the attribute values associated

    with an item status code. One record is created for each of the function-enabling attributes

    for each defined item status code. The primary key is

    INVENTORY_ITEM_STATUS_CODE, ATTRIBUTE_NAME.

     MTL_PARAMETERS: This table is an inventory organization with which an item is

    associated. The primary key is the ORGANIZATION_ID.

     Copyright ? Oracle, 2007. All rights reserved.

    Table Information 85709005.DOC

    Effective mm/dd/yy Page 10 of 19 Rev 1

Report this document

For any questions or suggestions please email
cust-service@docsford.com