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

Source

View Text - Preformatted


select SESSION_ID SESSION_ID, LINE_ID LINE_ID, DOC_ID DOC_ID, ITEM_ID ITEM_ID, LOT_NO LOT_NO, SUBLOT_NO SUBLOT_NO, LOT_ID LOT_ID, LOT_CREATED LOT_CREATED, EXPIRE_DATE EXPIRE_DATE, QC_GRADE QC_GRADE, WHSE_CODE WHSE_CODE, LOCATION LOCATION, LOCT_ONHAND LOCT_ONHAND, LOCT_ONHAND2 LOCT_ONHAND2, COMMIT_QTY COMMIT_QTY, COMMIT_QTY2 COMMIT_QTY2, TRANS_ID TRANS_ID, ID_COUNT ID_COUNT, ALLOC_QTY ALLOC_QTY, ALLOC_QTY2 ALLOC_QTY2, LINE_DETAIL_ID LINE_DETAIL_ID, REASON_CODE REASON_CODE, VENDOR_LOT_NO VENDOR_LOT_NO from "GMI"."GMI_TRAN_TMP"

View Text - HTML Formatted

SELECT SESSION_ID SESSION_ID
, LINE_ID LINE_ID
, DOC_ID DOC_ID
, ITEM_ID ITEM_ID
, LOT_NO LOT_NO
, SUBLOT_NO SUBLOT_NO
, LOT_ID LOT_ID
, LOT_CREATED LOT_CREATED
, EXPIRE_DATE EXPIRE_DATE
, QC_GRADE QC_GRADE
, WHSE_CODE WHSE_CODE
, LOCATION LOCATION
, LOCT_ONHAND LOCT_ONHAND
, LOCT_ONHAND2 LOCT_ONHAND2
, COMMIT_QTY COMMIT_QTY
, COMMIT_QTY2 COMMIT_QTY2
, TRANS_ID TRANS_ID
, ID_COUNT ID_COUNT
, ALLOC_QTY ALLOC_QTY
, ALLOC_QTY2 ALLOC_QTY2
, LINE_DETAIL_ID LINE_DETAIL_ID
, REASON_CODE REASON_CODE
, VENDOR_LOT_NO VENDOR_LOT_NO
FROM "GMI"."GMI_TRAN_TMP"