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: GMI.GMI_MASSTRANS_CTL#

Source

View Text - Preformatted


select JOURNAL_ID JOURNAL_ID, TRANSACTION_TYPE TRANSACTION_TYPE, ORGN_CODE ORGN_CODE, DOC_DATE DOC_DATE, REASON_CODE REASON_CODE, FROM_ITEM_NO FROM_ITEM_NO, TO_ITEM_NO TO_ITEM_NO, FROM_LOT_NO FROM_LOT_NO, TO_LOT_NO TO_LOT_NO, FROM_SUBLOT_NO FROM_SUBLOT_NO, TO_SUBLOT_NO TO_SUBLOT_NO, FROM_WHSE_CODE FROM_WHSE_CODE, FROM_LOCATION FROM_LOCATION, TO_LOCATION TO_LOCATION, FROM_GRADE FROM_GRADE, TO_GRADE TO_GRADE, FROM_LOT_STATUS FROM_LOT_STATUS, TO_LOT_STATUS TO_LOT_STATUS, EXPIRED_LOTS EXPIRED_LOTS, TARGET_WHSE_CODE TARGET_WHSE_CODE, TARGET_LOCATION TARGET_LOCATION, TARGET_GRADE TARGET_GRADE, TARGET_STATUS TARGET_STATUS, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE from "GMI"."GMI_MASSTRANS_CTL"

View Text - HTML Formatted

SELECT JOURNAL_ID JOURNAL_ID
, TRANSACTION_TYPE TRANSACTION_TYPE
, ORGN_CODE ORGN_CODE
, DOC_DATE DOC_DATE
, REASON_CODE REASON_CODE
, FROM_ITEM_NO FROM_ITEM_NO
, TO_ITEM_NO TO_ITEM_NO
, FROM_LOT_NO FROM_LOT_NO
, TO_LOT_NO TO_LOT_NO
, FROM_SUBLOT_NO FROM_SUBLOT_NO
, TO_SUBLOT_NO TO_SUBLOT_NO
, FROM_WHSE_CODE FROM_WHSE_CODE
, FROM_LOCATION FROM_LOCATION
, TO_LOCATION TO_LOCATION
, FROM_GRADE FROM_GRADE
, TO_GRADE TO_GRADE
, FROM_LOT_STATUS FROM_LOT_STATUS
, TO_LOT_STATUS TO_LOT_STATUS
, EXPIRED_LOTS EXPIRED_LOTS
, TARGET_WHSE_CODE TARGET_WHSE_CODE
, TARGET_LOCATION TARGET_LOCATION
, TARGET_GRADE TARGET_GRADE
, TARGET_STATUS TARGET_STATUS
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM "GMI"."GMI_MASSTRANS_CTL"