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.

[Home] [Help]

View: MTL_RESERVATIONS_VIEW

Product:	INV - Inventory
Description:	Not used
Implementation/DBA Data:	APPS.MTL_RESERVATIONS_VIEW

View Text

SELECT ORGANIZATION_ID
, INVENTORY_ITEM_ID
, DEMAND_SOURCE_TYPE DEMAND_SOURCE_TYPE_ID
, DEMAND_SOURCE_HEADER_ID
, TO_NUMBER(DEMAND_SOURCE_LINE) DEMAND_SOURCE_LINE_ID
, DEMAND_SOURCE_NAME
, SUPPLY_SOURCE_TYPE SUPPLY_SOURCE_TYPE_ID
, PRIMARY_UOM_QUANTITY - COMPLETED_QUANTITY PRIMARY_RESERVATION_QUANTITY
, REVISION
, LOT_NUMBER
, SUBINVENTORY SUBINVENTORY_CODE
, LOCATOR_ID
, DEMAND_SOURCE_DELIVERY
FROM MTL_DEMAND
WHERE RESERVATION_TYPE = 2
AND ROW_STATUS_FLAG = 1
AND PARENT_DEMAND_ID IS NOT NULL
AND PRIMARY_UOM_QUANTITY - COMPLETED_QUANTITY != 0

Columns

Name
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