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: GML.GML_BATCH_SO_ALLOC_HISTORY#

Source

View Text - Preformatted


select ALLOC_REC_ID ALLOC_REC_ID, BATCH_RES_ID BATCH_RES_ID, BATCH_ID BATCH_ID, TRANS_ID TRANS_ID, ORDER_NO ORDER_NO, BATCH_NO BATCH_NO, PLANT_CODE PLANT_CODE, BATCH_TYPE BATCH_TYPE, LINE_ID LINE_ID, LOT_ID LOT_ID, LOCATION LOCATION, WHSE_CODE WHSE_CODE, RULE_ID RULE_ID, RESERVED_QTY RESERVED_QTY, RESERVED_QTY2 RESERVED_QTY2, ALLOC_QTY ALLOC_QTY, ALLOC_QTY2 ALLOC_QTY2, TRANS_UM TRANS_UM, TRANS_UM2 TRANS_UM2, FAILURE_REASON FAILURE_REASON, BATCH_TRANS_ID BATCH_TRANS_ID, BATCH_LINE_ID BATCH_LINE_ID, DELETE_MARK DELETE_MARK, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATED_DATE LAST_UPDATED_DATE, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, LAST_UPDATED_BY LAST_UPDATED_BY from "GML"."GML_BATCH_SO_ALLOC_HISTORY"

View Text - HTML Formatted

SELECT ALLOC_REC_ID ALLOC_REC_ID
, BATCH_RES_ID BATCH_RES_ID
, BATCH_ID BATCH_ID
, TRANS_ID TRANS_ID
, ORDER_NO ORDER_NO
, BATCH_NO BATCH_NO
, PLANT_CODE PLANT_CODE
, BATCH_TYPE BATCH_TYPE
, LINE_ID LINE_ID
, LOT_ID LOT_ID
, LOCATION LOCATION
, WHSE_CODE WHSE_CODE
, RULE_ID RULE_ID
, RESERVED_QTY RESERVED_QTY
, RESERVED_QTY2 RESERVED_QTY2
, ALLOC_QTY ALLOC_QTY
, ALLOC_QTY2 ALLOC_QTY2
, TRANS_UM TRANS_UM
, TRANS_UM2 TRANS_UM2
, FAILURE_REASON FAILURE_REASON
, BATCH_TRANS_ID BATCH_TRANS_ID
, BATCH_LINE_ID BATCH_LINE_ID
, DELETE_MARK DELETE_MARK
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATED_DATE LAST_UPDATED_DATE
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, LAST_UPDATED_BY LAST_UPDATED_BY
FROM "GML"."GML_BATCH_SO_ALLOC_HISTORY"