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: INV.MTL_LSP_ONHAND_BALANCE_TMP#

Source

View Text - Preformatted


select CATEGORY CATEGORY, WAREHOUSE_ID WAREHOUSE_ID, WAREHOUSE WAREHOUSE, ITEM_ID ITEM_ID, ITEM ITEM, ITEM_DESCRIPTION ITEM_DESCRIPTION, REVISION REVISION, SUBINVENTORY SUBINVENTORY, LOCATOR LOCATOR, LOT LOT, LPN LPN, PARENT_LPN PARENT_LPN, SERIAL SERIAL, CONTAINERIZED_FLAG CONTAINERIZED_FLAG, PRIMARY_QUANTITY PRIMARY_QUANTITY, PRIMARY_UOM PRIMARY_UOM, SECONDARY_QUANTITY SECONDARY_QUANTITY, SECONDARY_UOM SECONDARY_UOM, SNAPSHOT_DATE SNAPSHOT_DATE, ONHAND_STATUS ONHAND_STATUS, XML_DOCUMENT_ID XML_DOCUMENT_ID from "INV"."MTL_LSP_ONHAND_BALANCE_TMP"

View Text - HTML Formatted

SELECT CATEGORY CATEGORY
, WAREHOUSE_ID WAREHOUSE_ID
, WAREHOUSE WAREHOUSE
, ITEM_ID ITEM_ID
, ITEM ITEM
, ITEM_DESCRIPTION ITEM_DESCRIPTION
, REVISION REVISION
, SUBINVENTORY SUBINVENTORY
, LOCATOR LOCATOR
, LOT LOT
, LPN LPN
, PARENT_LPN PARENT_LPN
, SERIAL SERIAL
, CONTAINERIZED_FLAG CONTAINERIZED_FLAG
, PRIMARY_QUANTITY PRIMARY_QUANTITY
, PRIMARY_UOM PRIMARY_UOM
, SECONDARY_QUANTITY SECONDARY_QUANTITY
, SECONDARY_UOM SECONDARY_UOM
, SNAPSHOT_DATE SNAPSHOT_DATE
, ONHAND_STATUS ONHAND_STATUS
, XML_DOCUMENT_ID XML_DOCUMENT_ID
FROM "INV"."MTL_LSP_ONHAND_BALANCE_TMP"