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

Source

View Text - Preformatted


select SESSION_ID SESSION_ID, LINE_ID LINE_ID, DOC_ID DOC_ID, ITEM_ID ITEM_ID, WHSE_CODE WHSE_CODE, BATCH_RES_ID BATCH_RES_ID, BATCH_NO BATCH_NO, BATCH_ID BATCH_ID, BATCH_LINE_ID BATCH_LINE_ID, BATCH_TYPE BATCH_TYPE, BATCH_STATUS BATCH_STATUS, START_DATE START_DATE, PLAN_CMPLT_DATE PLAN_CMPLT_DATE, PLANNED_QTY PLANNED_QTY, PLANNED_QTY2 PLANNED_QTY2, RESERVED_QTY RESERVED_QTY, RESERVED_QTY2 RESERVED_QTY2, LINE_RESERVED_QTY LINE_RESERVED_QTY, LINE_RESERVED_QTY2 LINE_RESERVED_QTY2, DELIVERY_DETAIL_ID DELIVERY_DETAIL_ID from "GML"."GML_BATCH_TMP"

View Text - HTML Formatted

SELECT SESSION_ID SESSION_ID
, LINE_ID LINE_ID
, DOC_ID DOC_ID
, ITEM_ID ITEM_ID
, WHSE_CODE WHSE_CODE
, BATCH_RES_ID BATCH_RES_ID
, BATCH_NO BATCH_NO
, BATCH_ID BATCH_ID
, BATCH_LINE_ID BATCH_LINE_ID
, BATCH_TYPE BATCH_TYPE
, BATCH_STATUS BATCH_STATUS
, START_DATE START_DATE
, PLAN_CMPLT_DATE PLAN_CMPLT_DATE
, PLANNED_QTY PLANNED_QTY
, PLANNED_QTY2 PLANNED_QTY2
, RESERVED_QTY RESERVED_QTY
, RESERVED_QTY2 RESERVED_QTY2
, LINE_RESERVED_QTY LINE_RESERVED_QTY
, LINE_RESERVED_QTY2 LINE_RESERVED_QTY2
, DELIVERY_DETAIL_ID DELIVERY_DETAIL_ID
FROM "GML"."GML_BATCH_TMP"