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_RESERVATIONS

Object Details

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

This table stores reservation information. Each record is a reservation that ties an item/organization combination with a demand source and a supply source. Demand source information comprises demand source type (Sales Order, Account, Account Alias, Inventory), demand source header, demand source line and demand source name. Supply source information comprises supply source type (Inventory, WIP jobs), supply source header, supply source line, supply source name and inventory controls (revision, lot, subinventory, locator).

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_RESERVATIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	RESERVATION_ID
MTL_RESERVATIONS_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DEMAND_SOURCE_LINE_DETAIL
MTL_RESERVATIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DEMAND_SOURCE_LINE_ID
MTL_RESERVATIONS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LPN_ID ORGANIZATION_ID
MTL_RESERVATIONS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REVISION LOT_NUMBER SUBINVENTORY_CODE LOCATOR_ID
MTL_RESERVATIONS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID INVENTORY_ITEM_ID REQUIREMENT_DATE
MTL_RESERVATIONS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SHIP_READY_FLAG
MTL_RESERVATIONS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	N_COLUMN1
MTL_RESERVATIONS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DEMAND_SOURCE_HEADER_ID
MTL_RESERVATIONS_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SUPPLY_SOURCE_HEADER_ID SUPPLY_SOURCE_LINE_ID SUPPLY_SOURCE_TYPE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
RESERVATION_ID	NUMBER		Yes	Reservation identifier
REQUIREMENT_DATE	DATE		Yes	Reservation requirement date
ORGANIZATION_ID	NUMBER		Yes	Identifier of organization in which reservation is made
INVENTORY_ITEM_ID	NUMBER		Yes	Identifier of reserved item
DEMAND_SOURCE_TYPE_ID	NUMBER		Yes	Indicates demand source for which reservation is made
DEMAND_SOURCE_NAME	VARCHAR2	(30)		Identifier for inventory or user defined demand
DEMAND_SOURCE_HEADER_ID	NUMBER			Header identifier for source of demand. For Sales Order: OE_ORDER_HEADERS.HEADER_ID. For Account: GL_CODE_COMBINATIONS.CODE_COMBINATION_ID. For Account Alias: MTL_GENERIC_DISPOSITIONS.DISPOSITION_ID
DEMAND_SOURCE_LINE_ID	NUMBER			Line ID for demand source. For Sales Order: OE_ORDER_LINES.LINE_ID
DEMAND_SOURCE_DELIVERY	NUMBER			Delivery identifier for demand sources having one
PRIMARY_UOM_CODE	VARCHAR2	(3)		Primary unit of measure of reserved item
PRIMARY_UOM_ID	NUMBER			Not currently used
RESERVATION_UOM_CODE	VARCHAR2	(3)		Unit of measure in which reservation is made
RESERVATION_UOM_ID	NUMBER			Not used
RESERVATION_QUANTITY	NUMBER		Yes	Quanity reserved in RESERVATION_UOM_CODE
PRIMARY_RESERVATION_QUANTITY	NUMBER		Yes	Quantity reserved in PRIMARY_UOM_CODE
AUTODETAIL_GROUP_ID	NUMBER			Not currently used
EXTERNAL_SOURCE_CODE	VARCHAR2	(30)		Not currently used
EXTERNAL_SOURCE_LINE_ID	NUMBER			Not currently used
SUPPLY_SOURCE_TYPE_ID	NUMBER		Yes	Indicates supply source of reservation
SUPPLY_SOURCE_HEADER_ID	NUMBER			Header identifier of supply source
SUPPLY_SOURCE_LINE_ID	NUMBER			Indicates line identifier of supply source
SUPPLY_SOURCE_LINE_DETAIL	NUMBER			Indicates line detail identifier of supply source
SUPPLY_SOURCE_NAME	VARCHAR2	(30)		Indicates name of supply source
REVISION	VARCHAR2	(3)		Revision of revision controlled reserved item
SUBINVENTORY_CODE	VARCHAR2	(10)		Subinventory in which reserved item resides
SUBINVENTORY_ID	NUMBER			Not currently used
LOCATOR_ID	NUMBER			Locator in which reserved item resides
LOT_NUMBER	VARCHAR2	(80)		Lot number of lot controlled reserved item
LOT_NUMBER_ID	NUMBER			Not currently used
SERIAL_NUMBER	VARCHAR2	(30)		Not currently used
SERIAL_NUMBER_ID	NUMBER			Not currently used
PARTIAL_QUANTITIES_ALLOWED	NUMBER			Not currently used
AUTO_DETAILED	NUMBER			Not currently used
PICK_SLIP_NUMBER	NUMBER			Not currently used
LPN_ID	NUMBER			LPN in which reserved item resides. This is used in WMS.
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			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
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
SHIP_READY_FLAG	NUMBER			Indicates that reserved quantity is ready to be shipped
N_COLUMN1	NUMBER			For synchronization purpose
DETAILED_QUANTITY	NUMBER			If high level reservation, quantity detailed.
COST_GROUP_ID	NUMBER			Cost Group Identifier - Used by WMS only
CONTAINER_LPN_ID	NUMBER			Indicates LPN of the empty container reserved - used by WMS only
STAGED_FLAG	VARCHAR2	(1)		Indicates if the reservation is in staged area.
SECONDARY_DETAILED_QUANTITY	NUMBER			Detailed Quantity Recorded in the Secondary Unit Of Measure
SECONDARY_RESERVATION_QUANTITY	NUMBER			Reservation Quantity Recorded in the Secondary Unit Of Measure
SECONDARY_UOM_CODE	VARCHAR2	(3)		Items Secondary Unit Of Measure Code
SECONDARY_UOM_ID	NUMBER			Not Currently Used
CROSSDOCK_FLAG	VARCHAR2	(1)		Indicates whether the reservation is crossdocked or not
CROSSDOCK_CRITERIA_ID	NUMBER			Indicates the crossdock rule that flaged the reservation
DEMAND_SOURCE_LINE_DETAIL	NUMBER			Holds the demand's line detail information
SERIAL_RESERVATION_QUANTITY	NUMBER			Indicates the number of serial reserved against the reservation record
SUPPLY_RECEIPT_DATE	DATE			Indicates when the supply is expected
DEMAND_SHIP_DATE	DATE			Indicates when the demand will be met
EXCEPTION_CODE	VARCHAR2	(150)		Holds the exception code for crossdocked reservations
ORIG_SUPPLY_SOURCE_TYPE_ID	NUMBER			Holds the original supply type that created the reservation
ORIG_SUPPLY_SOURCE_HEADER_ID	NUMBER			Holds the original supply header information that created the reservation
ORIG_SUPPLY_SOURCE_LINE_ID	NUMBER			Holds the original supply line information that created the reservation
ORIG_SUPPLY_SOURCE_LINE_DETAIL	NUMBER			Holds the original supply line detail information that created the reservation
ORIG_DEMAND_SOURCE_TYPE_ID	NUMBER			Holds the original demand type that created the reservation
ORIG_DEMAND_SOURCE_HEADER_ID	NUMBER			Holds the original demand header information that created the reservation
ORIG_DEMAND_SOURCE_LINE_ID	NUMBER			Holds the original demand line information that created the reservation
ORIG_DEMAND_SOURCE_LINE_DETAIL	NUMBER			Holds the original demand line detail information that created the reservation
PROJECT_ID	NUMBER			Indicates the project that is entered on the demand record
TASK_ID	NUMBER			Indicates the task that is entered on the demand record

Query Text

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


SELECT RESERVATION_ID
,      REQUIREMENT_DATE
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      DEMAND_SOURCE_TYPE_ID
,      DEMAND_SOURCE_NAME
,      DEMAND_SOURCE_HEADER_ID
,      DEMAND_SOURCE_LINE_ID
,      DEMAND_SOURCE_DELIVERY
,      PRIMARY_UOM_CODE
,      PRIMARY_UOM_ID
,      RESERVATION_UOM_CODE
,      RESERVATION_UOM_ID
,      RESERVATION_QUANTITY
,      PRIMARY_RESERVATION_QUANTITY
,      AUTODETAIL_GROUP_ID
,      EXTERNAL_SOURCE_CODE
,      EXTERNAL_SOURCE_LINE_ID
,      SUPPLY_SOURCE_TYPE_ID
,      SUPPLY_SOURCE_HEADER_ID
,      SUPPLY_SOURCE_LINE_ID
,      SUPPLY_SOURCE_LINE_DETAIL
,      SUPPLY_SOURCE_NAME
,      REVISION
,      SUBINVENTORY_CODE
,      SUBINVENTORY_ID
,      LOCATOR_ID
,      LOT_NUMBER
,      LOT_NUMBER_ID
,      SERIAL_NUMBER
,      SERIAL_NUMBER_ID
,      PARTIAL_QUANTITIES_ALLOWED
,      AUTO_DETAILED
,      PICK_SLIP_NUMBER
,      LPN_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SHIP_READY_FLAG
,      N_COLUMN1
,      DETAILED_QUANTITY
,      COST_GROUP_ID
,      CONTAINER_LPN_ID
,      STAGED_FLAG
,      SECONDARY_DETAILED_QUANTITY
,      SECONDARY_RESERVATION_QUANTITY
,      SECONDARY_UOM_CODE
,      SECONDARY_UOM_ID
,      CROSSDOCK_FLAG
,      CROSSDOCK_CRITERIA_ID
,      DEMAND_SOURCE_LINE_DETAIL
,      SERIAL_RESERVATION_QUANTITY
,      SUPPLY_RECEIPT_DATE
,      DEMAND_SHIP_DATE
,      EXCEPTION_CODE
,      ORIG_SUPPLY_SOURCE_TYPE_ID
,      ORIG_SUPPLY_SOURCE_HEADER_ID
,      ORIG_SUPPLY_SOURCE_LINE_ID
,      ORIG_SUPPLY_SOURCE_LINE_DETAIL
,      ORIG_DEMAND_SOURCE_TYPE_ID
,      ORIG_DEMAND_SOURCE_HEADER_ID
,      ORIG_DEMAND_SOURCE_LINE_ID
,      ORIG_DEMAND_SOURCE_LINE_DETAIL
,      PROJECT_ID
,      TASK_ID
FROM INV.MTL_RESERVATIONS;

Dependencies

[top of page]

INV.MTL_RESERVATIONS does not reference any database object

INV.MTL_RESERVATIONS is referenced by following:

INV: MTL_RESERVATIONS#