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]

VIEW: APPS.MTL_RESERVATIONS_VIEW

Object Details

Object Name:	MTL_RESERVATIONS_VIEW
Object Type:	VIEW
Owner:	APPS
FND Design Data:	INV.MTL_RESERVATIONS_VIEW
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier
DEMAND_SOURCE_TYPE_ID	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_ID	NUMBER			Line id of demand source. For Sales Order demand this is: SO_LINES.LINE_ID
DEMAND_SOURCE_NAME	VARCHAR2	(30)		Identifier for user-defined Source Type
SUPPLY_SOURCE_TYPE_ID	NUMBER			Source of supply for reservation, only populated if reservation is not to on hand
PRIMARY_RESERVATION_QUANTITY	NUMBER			(primary_uom_quantity - completed_quantity) from mtl_demand
REVISION	VARCHAR2	(3)		Inventory item revision code
LOT_NUMBER	VARCHAR2	(80)		Lot number
SUBINVENTORY_CODE	VARCHAR2	(10)		Subinventory code
LOCATOR_ID	NUMBER			Locator identifier
DEMAND_SOURCE_DELIVERY	VARCHAR2	(30)		For Sales Order demand, Line id of Sales order line detail row (SO_LINE_DETAILS.LINE_DETAIL_ID)

Query Text

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


SELECT ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      DEMAND_SOURCE_TYPE_ID
,      DEMAND_SOURCE_HEADER_ID
,      DEMAND_SOURCE_LINE_ID
,      DEMAND_SOURCE_NAME
,      SUPPLY_SOURCE_TYPE_ID
,      PRIMARY_RESERVATION_QUANTITY
,      REVISION
,      LOT_NUMBER
,      SUBINVENTORY_CODE
,      LOCATOR_ID
,      DEMAND_SOURCE_DELIVERY
FROM APPS.MTL_RESERVATIONS_VIEW;

Dependencies

[top of page]

APPS.MTL_RESERVATIONS_VIEW references the following:

APPS: MTL_DEMAND

APPS.MTL_RESERVATIONS_VIEW is not referenced by any database object