DBA Data[Home] [Help]

VIEW: GMI.IC_PHYS_ERR#

Source

View Text - Preformatted

select CYCLE_ID CYCLE_ID, ITEM_ID ITEM_ID, WHSE_CODE WHSE_CODE, LOT_ID LOT_ID, LOCATION LOCATION, CYCLE_NO CYCLE_NO, ITEM_NO ITEM_NO, ERR_MSG ERR_MSG, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY from "GMI"."IC_PHYS_ERR"
View Text - HTML Formatted

SELECT CYCLE_ID CYCLE_ID
, ITEM_ID ITEM_ID
, WHSE_CODE WHSE_CODE
, LOT_ID LOT_ID
, LOCATION LOCATION
, CYCLE_NO CYCLE_NO
, ITEM_NO ITEM_NO
, ERR_MSG ERR_MSG
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
FROM "GMI"."IC_PHYS_ERR"