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_TRANSFER_TEMP#

Source

View Text - Preformatted


select FROM_RESERVATION_ID FROM_RESERVATION_ID, TO_RESERVATION_ID TO_RESERVATION_ID, TRANSFER_QUANTITY TRANSFER_QUANTITY, TRANSFER_TYPE TRANSFER_TYPE, ORGANIZATION_ID ORGANIZATION_ID, TYPE_ID TYPE_ID, HEADER_ID HEADER_ID, LINE_ID LINE_ID, LINE_DETAIL LINE_DETAIL, NAME NAME, REVISION REVISION, LOT_NUMBER LOT_NUMBER, SUBINVENTORY_CODE SUBINVENTORY_CODE, SUB_LOC_TYPE SUB_LOC_TYPE, LOCATOR_ID LOCATOR_ID, LPN_ID LPN_ID, LPN LPN, SECONDARY_TRANSFER_QUANTITY SECONDARY_TRANSFER_QUANTITY from "INV"."MTL_TRANSFER_TEMP"

View Text - HTML Formatted

SELECT FROM_RESERVATION_ID FROM_RESERVATION_ID
, TO_RESERVATION_ID TO_RESERVATION_ID
, TRANSFER_QUANTITY TRANSFER_QUANTITY
, TRANSFER_TYPE TRANSFER_TYPE
, ORGANIZATION_ID ORGANIZATION_ID
, TYPE_ID TYPE_ID
, HEADER_ID HEADER_ID
, LINE_ID LINE_ID
, LINE_DETAIL LINE_DETAIL
, NAME NAME
, REVISION REVISION
, LOT_NUMBER LOT_NUMBER
, SUBINVENTORY_CODE SUBINVENTORY_CODE
, SUB_LOC_TYPE SUB_LOC_TYPE
, LOCATOR_ID LOCATOR_ID
, LPN_ID LPN_ID
, LPN LPN
, SECONDARY_TRANSFER_QUANTITY SECONDARY_TRANSFER_QUANTITY
FROM "INV"."MTL_TRANSFER_TEMP"