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.

VIEW: APPS.MTL_RESERVATIONS_VIEW

Source

View Text - Preformatted


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

View Text - HTML Formatted

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