eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: INV.MTL_DEMAND

Object Details

Object Name:	MTL_DEMAND
Object Type:	TABLE
Owner:	INV
FND Design Data:	INV.MTL_DEMAND
Subobject Name:
Status:	VALID

This table stores 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, and Reservation Rows.
.
Summary Demand is direct demand for an item within an organization on
a particular date, which originated from a particular source. For
hard reservations there are several columns which further define what
the reservation is for, and where it is being placed. Currently, four
sources of demand are supported, Sales Order, Account, Account Alias,
and User Defined transaction sources. Five different types of demand,
denoted by DEMAND_TYPE column are used. These five types are Model,
Option Class, Option Item, Configuration Item and Derived. Derived
demand rows are inserted by BOM Demand exploder when demanded item has
ATPable components. Each Summary Demand row may be associated with
one or more Reservation rows. Reservation may be placed against a
particular inventory control (ie, specific subinventory, locator,
revision and lot) against any sources (ie, Account Number, Account
Alias, Sales Order or even User-Defined sources). Each Summary Demand
row may be associated with one or more detailed rows. The detailed
rows consist of reservations and open demand. A reservation row
represents a firm promise of a supply source. Currently, two types of
reservation are supported, reservations to on-hand, and reservations
to WIP jobs. Each summary demand row may be associated with one and
only one open demand row. Open Demand rows represent the un-reserved
portion of the the Summary Demand.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_DEMAND_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DEMAND_ID
MTL_DEMAND_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DEMAND_SOURCE_TYPE DEMAND_SOURCE_HEADER_ID DEMAND_SOURCE_LINE DEMAND_SOURCE_DELIVERY
MTL_DEMAND_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVENTORY_ITEM_ID ORGANIZATION_ID AVAILABLE_TO_MRP PARENT_DEMAND_ID
MTL_DEMAND_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	N_COLUMN1
MTL_DEMAND_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVENTORY_ITEM_ID ORGANIZATION_ID DEMAND_SOURCE_LINE
MTL_DEMAND_N13	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DEMAND_SOURCE_LINE
MTL_DEMAND_N14	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BILL_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID CUSTOMER_ID
MTL_DEMAND_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVENTORY_ITEM_ID ORGANIZATION_ID DEMAND_SOURCE_TYPE DEMAND_SOURCE_HEADER_ID
MTL_DEMAND_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UPDATED_FLAG
MTL_DEMAND_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RTO_MODEL_SOURCE_LINE
MTL_DEMAND_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SUPPLY_GROUP_ID
MTL_DEMAND_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EXPLOSION_GROUP_ID
MTL_DEMAND_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONFIG_GROUP_ID
MTL_DEMAND_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVENTORY_ITEM_ID ORGANIZATION_ID RESERVATION_TYPE
MTL_DEMAND_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVENTORY_ITEM_ID ORGANIZATION_ID REQUIREMENT_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
DEMAND_ID	NUMBER		Yes	Unique identifier of a demand row, from sequence MTL_DEMAND_S
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier
DEMAND_SOURCE_TYPE	NUMBER		Yes	Code to indicate the source of the demand
DEMAND_SOURCE_HEADER_ID	NUMBER		Yes	Header ID for the source of the demand. For Sales order demand: MTL_SALES_ORDERS.SALES_ORDER_ID, For Account number: GL_CODE_COMBINATIONS.CODE_COMBINATION_ID, For Account Alias: MTL_GENERIC_DISPOSITIONS.DISPOSITION_ID
DEMAND_SOURCE_LINE	VARCHAR2	(30)		Line id of demand source. For Sales Order demand this is: SO_LINES.LINE_ID
DEMAND_SOURCE_DELIVERY	VARCHAR2	(30)		For Sales Order demand, Line id of Sales order line detail row (SO_LINE_DETAILS.LINE_DETAIL_ID)
DEMAND_SOURCE_NAME	VARCHAR2	(30)		Identifier for user-defined Source Type
UOM_CODE	VARCHAR2	(3)	Yes	Unit of measure for LINE_ITEM_QUANTITY column
LINE_ITEM_QUANTITY	NUMBER		Yes	Demand or reservation quantity expressed in units defined in UOM_CODE column
PRIMARY_UOM_QUANTITY	NUMBER		Yes	Demanded or reserved quantity expressed in the item's primary unit of measure as defined in MTL_SYSTEM_ITEMS
LINE_ITEM_RESERVATION_QTY	NUMBER			Reserved quantity expressed in units defined in UOM_CODE column, Only populated for summary demand rows
RESERVATION_QUANTITY	NUMBER			Total quantity reserved expressed in primary unit of measure. Only populated for summary and derived demand rows.
COMPLETED_QUANTITY	NUMBER		Yes	Shipped quantity in primary unit of measure code.
REQUIREMENT_DATE	DATE		Yes	Planned ship date for summary demand. Parent planned ship date - ATP_LEAD_TIME for derived demand
RESERVATION_TYPE	NUMBER		Yes	Code for type of reservation
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
REQUEST_ID	NUMBER			Standard Who column
PROGRAM_APPLICATION_ID	NUMBER			Standard Who column
PROGRAM_ID	NUMBER			Standard Who column
PROGRAM_UPDATE_DATE	DATE			Standard Who column
PARENT_DEMAND_ID	NUMBER			DEMAND_ID of parent (summary demand) for reservation and open demand rows. Null for summary and derived demand rows
EXTERNAL_SOURCE_CODE	VARCHAR2	(30)		Used to document external sourced demand
EXTERNAL_SOURCE_LINE_ID	NUMBER			Used to document external sourced demand
USER_LINE_NUM	VARCHAR2	(30)		User identifier of demand source. For sales order demand this is SO_LINES.LINE_NUMBER
USER_DELIVERY	VARCHAR2	(30)		User identifier of demand source. For sales order demand it is taken from SO_LINES.LINE_NUMBER of the schedule line, used for display only
SCHEDULE_ID	NUMBER			(not currently used)
AUTODETAIL_GROUP_ID	NUMBER			ID used when calling the Autodetail process, not null if autodetail process is successful, only populated for hard reservation rows
SUPPLY_SOURCE_TYPE	NUMBER			Source of supply for reservation, only populated if reservation is not to on hand
SUPPLY_SOURCE_HEADER_ID	NUMBER			Header id of reservation supply source, for example if supply source is WIP then it is WIP_DISCRETE_JOBS.WIP_ENTITY_ID
SUPPLY_GROUP_ID	NUMBER			Used to group demand rows for automatic WIP job creation via the Load Final Assembly Orders program, reset to null after program completes
UPDATED_FLAG	NUMBER			Flag to indicate if row requires processing by MRP Forecast Consumption program, reset to 2 (No) after MRP processing
REVISION	VARCHAR2	(3)		The item revision reserved, only populated for reservation rows that reference a specific revision
LOT_NUMBER	VARCHAR2	(80)		The specific lot number reserved, only populated for reservation rows for a specific lot number
SERIAL_NUMBER	VARCHAR2	(30)		(not currently used)
SUBINVENTORY	VARCHAR2	(10)		Subinventory demanded or reserved, can be populated for summary demand
LOCATOR_ID	NUMBER			Location identifier for reserved item
COMPONENT_SEQUENCE_ID	NUMBER			Id of BOM structure for demand associated with ATO Models. If DEMAND_TYPE is 1 (Model) then is BOM_BILL_OF_MATERIALS.BILL_SEQUENCE_ID if DEMAND_TYPE != 1 (Model) then is BOM_INVENTORY_COMPONENTS.COMPONENT_SEQUENCE_ID
PARENT_COMPONENT_SEQ_ID	NUMBER			MTL_DEMAND.COMPONENT_SEQUENCE_ID of parent in BOM structure
RTO_MODEL_SOURCE_LINE	VARCHAR2	(30)		DEMAND_SOURCE_LINE of the Model demand row for all demand and reservation rows associated with an ATO Model demand row
RTO_PREVIOUS_QTY	NUMBER			The PRIMARY_UOM_QUANTITY the last time that the ATO Order Change "report" ran
CONFIG_STATUS	NUMBER			Code to indicate status of Configured item creation for ATO Model demand
AVAILABLE_TO_MRP	NUMBER			Flag to indicate if demand should be visible to MRP
AVAILABLE_TO_ATP	NUMBER			Flag to indicate if demand should be visible to ATP
ESTIMATED_RELEASE_DATE	DATE			Requirement date - Assembly Lead time. This column is only populated for Configuration Items created by Link Configuration Item to Order (bmlcpb).
DEMAND_CLASS	VARCHAR2	(30)		Demand class of the demand row
ROW_STATUS_FLAG	NUMBER	(2)		used by the demand management functions to indicate the status of a row; 1 - Active; 2 - Complete
ORDER_CHANGE_REPORT_FLAG	NUMBER			Flag to indicate rows for ATO items that have changed after a configuration item has been created. The ATO Model Order Change report will select these rows and update to 2 (No)
ATP_LEAD_TIME	NUMBER	(22)		Number of days earlier than the parent requirement data that a component must be available to allow for assembly of the parent.
EXPLOSION_EFFECTIVITY_DATE	DATE			Date used by BOM exploder when a fixed BOM structure as of a certain date is required
BOM_LEVEL	NUMBER			Used by BOM exploder to store the level for the explosion process
MRP_DATE	DATE			Used/populated by MRP to get a read-consistent picture of the demand
MRP_QUANTITY	NUMBER			Used/populated by MRP to get a read-consistent picture of the demand
CUSTOMER_ID	NUMBER			Customer identifier associated with the demand, Used by MRP to consume forecast entries
TERRITORY_ID	NUMBER			Territory identifier associated with the demand, Used by MRP to consume forecast entries
BILL_TO_SITE_USE_ID	NUMBER			Bill to identifier associated with the demand, Used by MRP to consume forecast entries
SHIP_TO_SITE_USE_ID	NUMBER			Ship to identifier associated with the demand, Used by MRP to consume forecast entries
MASTER_RESERVATION_QTY	NUMBER			(not currently used)
DESCRIPTION	VARCHAR2	(50)		(not currently used)
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
DEMAND_TYPE	NUMBER			Code for type of demand
DUPLICATED_CONFIG_ITEM_ID	NUMBER			INVENTORY_ITEM_ID of an existing configured item that was matched to the Model/Option choices associated with this ATO Model
DUPLICATED_CONFIG_DEMAND_ID	NUMBER			DEMAND_ID of an existing model row in MTL_DEMAND with an "identical" configuration, will cause linkage to the same configuration item for both models
EXPLOSION_GROUP_ID	NUMBER			Identifier passed to BOM exploder to identify row to explode
ORDERED_ITEM_ID	NUMBER			Item id of the top item that caused this demand or reservation to be placed
CONFIG_GROUP_ID	NUMBER			Configuration group id
OPERATION_SEQ_NUM	NUMBER			Used by Create Configuration to store the operation number for the options and option classes
N_COLUMN1	NUMBER			Corresponding reservation Identifier in MTL_RESERVATIONS table

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT DEMAND_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      DEMAND_SOURCE_TYPE
,      DEMAND_SOURCE_HEADER_ID
,      DEMAND_SOURCE_LINE
,      DEMAND_SOURCE_DELIVERY
,      DEMAND_SOURCE_NAME
,      UOM_CODE
,      LINE_ITEM_QUANTITY
,      PRIMARY_UOM_QUANTITY
,      LINE_ITEM_RESERVATION_QTY
,      RESERVATION_QUANTITY
,      COMPLETED_QUANTITY
,      REQUIREMENT_DATE
,      RESERVATION_TYPE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PARENT_DEMAND_ID
,      EXTERNAL_SOURCE_CODE
,      EXTERNAL_SOURCE_LINE_ID
,      USER_LINE_NUM
,      USER_DELIVERY
,      SCHEDULE_ID
,      AUTODETAIL_GROUP_ID
,      SUPPLY_SOURCE_TYPE
,      SUPPLY_SOURCE_HEADER_ID
,      SUPPLY_GROUP_ID
,      UPDATED_FLAG
,      REVISION
,      LOT_NUMBER
,      SERIAL_NUMBER
,      SUBINVENTORY
,      LOCATOR_ID
,      COMPONENT_SEQUENCE_ID
,      PARENT_COMPONENT_SEQ_ID
,      RTO_MODEL_SOURCE_LINE
,      RTO_PREVIOUS_QTY
,      CONFIG_STATUS
,      AVAILABLE_TO_MRP
,      AVAILABLE_TO_ATP
,      ESTIMATED_RELEASE_DATE
,      DEMAND_CLASS
,      ROW_STATUS_FLAG
,      ORDER_CHANGE_REPORT_FLAG
,      ATP_LEAD_TIME
,      EXPLOSION_EFFECTIVITY_DATE
,      BOM_LEVEL
,      MRP_DATE
,      MRP_QUANTITY
,      CUSTOMER_ID
,      TERRITORY_ID
,      BILL_TO_SITE_USE_ID
,      SHIP_TO_SITE_USE_ID
,      MASTER_RESERVATION_QTY
,      DESCRIPTION
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      DEMAND_TYPE
,      DUPLICATED_CONFIG_ITEM_ID
,      DUPLICATED_CONFIG_DEMAND_ID
,      EXPLOSION_GROUP_ID
,      ORDERED_ITEM_ID
,      CONFIG_GROUP_ID
,      OPERATION_SEQ_NUM
,      N_COLUMN1
FROM INV.MTL_DEMAND;

Dependencies

[top of page]

INV.MTL_DEMAND does not reference any database object

INV.MTL_DEMAND is referenced by following:

APPS: MTL_DEMAND; MTL_DEMAND_T