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.IC_PERD_BAL#

Source

View Text - Preformatted


select PERIOD_ID PERIOD_ID, LOT_ID LOT_ID, WHSE_CODE WHSE_CODE, LOCATION LOCATION, ITEM_ID ITEM_ID, FISCAL_YEAR FISCAL_YEAR, PERIOD PERIOD, LOCT_ONHAND LOCT_ONHAND, LOCT_ONHAND2 LOCT_ONHAND2, LOCT_USAGE LOCT_USAGE, LOCT_USAGE2 LOCT_USAGE2, LOCT_YIELD LOCT_YIELD, LOCT_YIELD2 LOCT_YIELD2, LOCT_VALUE LOCT_VALUE, LOT_STATUS LOT_STATUS, QCHOLD_RES_CODE QCHOLD_RES_CODE, LOG_END_DATE LOG_END_DATE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, GL_POSTED_IND GL_POSTED_IND, PERD_BAL_ID PERD_BAL_ID, MIGRATED_IND MIGRATED_IND, PERIOD_BALANCE_ID PERIOD_BALANCE_ID from "GMI"."IC_PERD_BAL"

View Text - HTML Formatted

SELECT PERIOD_ID PERIOD_ID
, LOT_ID LOT_ID
, WHSE_CODE WHSE_CODE
, LOCATION LOCATION
, ITEM_ID ITEM_ID
, FISCAL_YEAR FISCAL_YEAR
, PERIOD PERIOD
, LOCT_ONHAND LOCT_ONHAND
, LOCT_ONHAND2 LOCT_ONHAND2
, LOCT_USAGE LOCT_USAGE
, LOCT_USAGE2 LOCT_USAGE2
, LOCT_YIELD LOCT_YIELD
, LOCT_YIELD2 LOCT_YIELD2
, LOCT_VALUE LOCT_VALUE
, LOT_STATUS LOT_STATUS
, QCHOLD_RES_CODE QCHOLD_RES_CODE
, LOG_END_DATE LOG_END_DATE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, GL_POSTED_IND GL_POSTED_IND
, PERD_BAL_ID PERD_BAL_ID
, MIGRATED_IND MIGRATED_IND
, PERIOD_BALANCE_ID PERIOD_BALANCE_ID
FROM "GMI"."IC_PERD_BAL"