Demand and reservation information used in Available To Promise, Planning and other Manufacturing Functions

Following query returns Demand and reservation information used in Available To Promise, Planning and other Manufacturing functions.

There are three major row types stored in the table

· Summary Demand rows

· Open Demand Rows

· Reservation Rows.



SELECT SUBSTR (md.demand_id, 1, 8) ID,

SUBSTR (demand_source_header_id, 1, 8) demand_source_header_id,

SUBSTR (parent_demand_id, 1, 8) parent_demand_id,

SUBSTR (demand_source_line, 1, 10) demand_source_line_id,

SUBSTR (demand_source_delivery, 1, 10) demand_source_delivery,

SUBSTR (inventory_item_id, 1, 10) “Item Id”,

(SELECT UNIQUE msi.description

FROM mtl_system_items_b msi

WHERE msi.inventory_item_id =

SUBSTR (md.inventory_item_id,



)) “Item Description”,

SUBSTR (inventory_item_id, 1, 10) item_id,

SUBSTR (organization_id, 1, 5) organization_id,

SUBSTR (reservation_quantity, 1, 5) reservation_quantity,

SUBSTR (primary_uom_quantity, 1, 5) primary_uom_quantity,

SUBSTR (reservation_type, 1, 5) reservation_type,

SUBSTR (requirement_date, 1, 10) requirement_date,

SUBSTR (subinventory, 1, 10) subinventory,

SUBSTR (serial_number, 1, 10) srl_num,

SUBSTR (lot_number, 1, 10) lot_num

FROM mtl_demand md


What are make to order and make to stock items in Oracle E-Business Suite and what are there decision factor?

What are MTO and MTS in Oracle E-Business Suite and what are there decision factor?

Make to Order (MTO)

Some manufacturing units manufacture products only against customer orders in other words job is directly associated with Sale order.

This is an example of make to order scenario. In case of make to order products manufacturing lead time need to be low enough to meet the customer requirements. Organizations may stock sub assemblies / Factory made items used in multiple finished products to enable them to satisfy customer demand within a reasonable time.

Make to Stock (MTS)

Some time Products are manufactured in advance expecting future customer orders.

This is the example of make to stock scenario. Organizations making make to stock products are almost totally dependent on planning forecast. In such cases forecast accuracy is a very important factor to maintain cost effective operations.

There are manufacturing units which has both MTO and MTS type of products

MTO & MTS Decision Factors

Depending on different factors like manufacturing lead time, product cost, market demand, competitor’s capability, storage space, change over time, change over cost etc. manufacturing organizations decide to operate the plant as MTO or MTS. The item parameters are to be set accordingly so that the recommendations provided by Advance Supply Chain Planning support MTO or MTS strategy.

Interface and respective Tables Used in Oracle BOM and WIP

Following are Interface and there respective tables Used in Oracle BOM and WIP

Oracle Bill of Material

Open Bills of Material Interface






Open Bills of Material Tables

1. bom_bill_of_materials

2. bom_inventory_components

3. bom_reference_designators

4. bom_substitute_components

5. mtl_item_revisions

Oracle Routing

Open Routing Interface





Open Routing Tables

1. bom_operational_routings

2. bom_operation_sequences

3. bom_operation_resources