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: GMF.CM_BTCH_SUM#

Source

View Text - Preformatted


select ITEM_ID ITEM_ID, LINE_TYPE LINE_TYPE, WHSE_CODE WHSE_CODE, FISCAL_YEAR FISCAL_YEAR, PERIOD PERIOD, FORMULALINE_ID FORMULALINE_ID, TOTAL_ITEM_QTY1 TOTAL_ITEM_QTY1, TOTAL_ITEM_QTY2 TOTAL_ITEM_QTY2, QTY1_UM QTY1_UM, QTY2_UM QTY2_UM, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, DELETE_MARK DELETE_MARK from "GMF"."CM_BTCH_SUM"

View Text - HTML Formatted

SELECT ITEM_ID ITEM_ID
, LINE_TYPE LINE_TYPE
, WHSE_CODE WHSE_CODE
, FISCAL_YEAR FISCAL_YEAR
, PERIOD PERIOD
, FORMULALINE_ID FORMULALINE_ID
, TOTAL_ITEM_QTY1 TOTAL_ITEM_QTY1
, TOTAL_ITEM_QTY2 TOTAL_ITEM_QTY2
, QTY1_UM QTY1_UM
, QTY2_UM QTY2_UM
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, DELETE_MARK DELETE_MARK
FROM "GMF"."CM_BTCH_SUM"