Bookmark and Share Subscribe You may face visibility problem if http://docs.google.com is blocked on your network

Monday, May 31, 2010

Item Reservation- (InSide View)

This article will help to understand table structure which supports Item reservations in Oracle E-business suite (R12).
Item Reservation Tables
  • MTL_DEMAND : This table stores demand and reservation information used in Available to Promise, Planning, and other manufacturing functions. Four row types are stored in this table:
-                 Summary Demand rows
-                 Dependent Demand rows
-                 Open Demand rows
-                 Reservation rows
-                 The primary key is INVENTORY_ITEM_ID, DEMAND_SOURCE_TYPE, DEMAND_SOURCE_HEADER_ID, DEMAND_SOURCE_LINE (o), DEMAND_SOURCE_DELIVERY (o), COMPONENT_SEQUENCE_ID (o).
  • MTL_SALES_ORDERS : This table stores the Oracle Inventory local definition of sales orders and maps sales orders between Oracle Inventory and other Oracle Manufacturing applications. The primary key is SALES_ORDER_ID.
  • OE_ORDER_HEADERS_ALL : This table stores header information for orders in Oracle Order Management. The primary key is HEADER_ID.
  • OE-ORDER_LINES_ALL : This table stores information for all order lines in Oracle Order Management. The primary key is LINE_ID.
  • GL_CODE_COMBINATIONS : This table stores valid Accounting Flexfield segment value combinations for each accounting flexfield structure within your General Ledger application. Available material can be reserved against a valid Accounting Flexfield combination. The primary key is CODE_COMBINATION_ID.
  • MTL_GENERIC_DISPOSITIONS : This table stores the user-defined account alias. An account alias provides a method to use accounting numbers and makes it easier to transact account issues and receipts. Available inventory can be reserved against an account alias. The primary key is DISPOSITION_ID, ORGANIZATION_ID.
  • MTL_MATERIAL_TRANSACTIONS : This table stores a record of every material transaction or cost update performed in Inventory. An issue transaction to an account number or account alias can relieve a reservation against the account number or alias. The primary key is TRANSACTION_ID.
  • MTL_DEMAND_INTERFACE : This table is the interface point between non-Inventory applications and the Oracle Inventory demand module. Records inserted into this table are processed by the Demand Manager concurrent program.
  • 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 primary key for an item is the INVENTORY_ITEM_ID and the ORGANIZATION_ID.

No comments:

Post a Comment

Please add your valuable feedback / comments

Declaimer:

This blog is purely personal and the thoughts expressed here represent only me. The purpose of this blog is to share information and knowledge about Oracle's product which I have come across with my exposure to the product, practice and observations. The blog has been created keeping only one intention of sharing knowledge and for learning purpose. The blog has been created solely as a educational, for storing portions of the vast Oracle knowledge world. Oracle EBS is an Oracle Corp. product and you should contact Oracle directly for any specific fact or issue.

*NOTE: Few articles on this blog are not completely prepared by me, content is edited and complied after referring various sites to make visitor's job easy