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: MSC.MSC_RESERVATIONS

Object Details

Object Name:	MSC_RESERVATIONS
Object Type:	TABLE
Owner:	MSC
FND Design Data:	MSC.MSC_RESERVATIONS
Subobject Name:
Status:	VALID

MSC_RESERVATIONS stores information regarding material reservations
from the inventory system. Each row represents a portion of inventory
that is reserved for a demand. A reservation may be against an
inventory. If the reservation is against a nonnettable subinventory,
the NONNET_QUANTITY_RESERVED column holds the quantity. If the
reservation is against a nettable subinventory or no subinventory is
specified, the reservation quantity is stored in RESERVED_QUANTITY.
Note that the sum of RESERVED_QUANTITY cannot exceed the nettable
subinventories for a part. This could happen if the planner manually
sets subinventories to be non-reserved during the planning process.
The NONNET_QUANTITY_RESERVED will then store the quantity in excess of
the sum of the nettable reserved quantities.
MSC_RESERVATIONS is populated during the Snapshot and used by the
Planner. It is derived from MTL_DEMAND from source application instance.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MSC_RESERVATIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PLAN_ID RESERVATION_TYPE TRANSACTION_ID SR_INSTANCE_ID ORGANIZATION_ID
MSC_RESERVATIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PLAN_ID SR_INSTANCE_ID ORGANIZATION_ID RESERVATION_TYPE INVENTORY_ITEM_ID DISPOSITION_TYPE DISPOSITION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_ID	NUMBER		Yes	Unique identifier generated from the source application instance
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier
PLAN_ID	NUMBER		Yes	Plan identifier
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
SR_INSTANCE_ID	NUMBER		Yes	Source application instance identifier
RESERVATION_DATE	DATE			Effectivity date of reservation
REQUIREMENT_DATE	DATE			Date of need
RESERVED_QUANTITY	NUMBER		Yes	Quantity reserved
NONNET_QUANTITY_RESERVED	NUMBER		Yes	Quantity reserved allocated to nonnettable inventory
DISPOSITION_TYPE	NUMBER		Yes	Disposition type
DISPOSITION_ID	NUMBER			Disposition identifier
PARENT_DEMAND_ID	NUMBER			Parent demand identifier
SUBINVENTORY	VARCHAR2	(10)		Subinventory identifier
DEMAND_CLASS	VARCHAR2	(34)		Demand class
REVISION	VARCHAR2	(3)		Inventory item revision code
PROJECT_ID	NUMBER	(15)		Project identifier
TASK_ID	NUMBER	(15)		Task identifier
PLANNING_GROUP	VARCHAR2	(30)		Planning group
REFRESH_NUMBER	NUMBER			Refresh number populated by the collection program
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			Concurrent Who column
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Who column
PROGRAM_ID	NUMBER			Concurrent Who column
PROGRAM_UPDATE_DATE	DATE			Concurrent Who column
SUPPLY_SOURCE_HEADER_ID	NUMBER			header id of the supply. In source. Corresponds to wip entity id
SUPPLY_SOURCE_TYPE_ID	NUMBER			Type of supply : 13 for inv, 5 for wip jobs
REPAIR_LINE_ID	NUMBER			Repair Line Id
RESERVATION_TYPE	NUMBER			Reservation Type
REPAIR_PO_HEADER_ID	NUMBER			Repair PO Header identifier
SERIAL_NUMBER	NUMBER
DEMAND_SOURCE_LINE_ID	NUMBER	(22)

Query Text

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


SELECT TRANSACTION_ID
,      INVENTORY_ITEM_ID
,      PLAN_ID
,      ORGANIZATION_ID
,      SR_INSTANCE_ID
,      RESERVATION_DATE
,      REQUIREMENT_DATE
,      RESERVED_QUANTITY
,      NONNET_QUANTITY_RESERVED
,      DISPOSITION_TYPE
,      DISPOSITION_ID
,      PARENT_DEMAND_ID
,      SUBINVENTORY
,      DEMAND_CLASS
,      REVISION
,      PROJECT_ID
,      TASK_ID
,      PLANNING_GROUP
,      REFRESH_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SUPPLY_SOURCE_HEADER_ID
,      SUPPLY_SOURCE_TYPE_ID
,      REPAIR_LINE_ID
,      RESERVATION_TYPE
,      REPAIR_PO_HEADER_ID
,      SERIAL_NUMBER
,      DEMAND_SOURCE_LINE_ID
FROM MSC.MSC_RESERVATIONS;

Dependencies

[top of page]

MSC.MSC_RESERVATIONS does not reference any database object

MSC.MSC_RESERVATIONS is referenced by following:

MSC: MSC_RESERVATIONS#