VIEW: GMI.IC_CYCL_ADT#

Source

View Text - Preformatted

select CYCLE_ID CYCLE_ID, SEQ_NO SEQ_NO, CYCL_ADT_ID CYCL_ADT_ID, ITEM_ID ITEM_ID, LOCATION LOCATION, WHSE_CODE WHSE_CODE, LOT_NO LOT_NO, SUBLOT_NO SUBLOT_NO, LINE_TYPE LINE_TYPE, CYCLE_NO CYCLE_NO, CYCLESTART_DT CYCLESTART_DT, ITEM_COUNT_DT ITEM_COUNT_DT, COUNT_NO COUNT_NO, ITEM_NO ITEM_NO, ITEM_DESC1 ITEM_DESC1, LOT_ID LOT_ID, TRANS_DATE TRANS_DATE, DOC_TYPE DOC_TYPE, TRANS_QTY1 TRANS_QTY1, TRANS_QTY2 TRANS_QTY2, FROZEN_QTY1 FROZEN_QTY1, FROZEN_QTY2 FROZEN_QTY2, UOM1 UOM1, UOM2 UOM2, COUNT_QTY1 COUNT_QTY1, COUNT_QTY2 COUNT_QTY2, ONHAND ONHAND, ONHAND2 ONHAND2, VAR_QTY1 VAR_QTY1, VAR_QTY2 VAR_QTY2, VAR_PERCENT VAR_PERCENT, POST_ONHAND POST_ONHAND, POST_ONHAND2 POST_ONHAND2, DELETE_MARK DELETE_MARK, LAST_UPDATED_BY LAST_UPDATED_BY, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATION_DATE CREATION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "GMI"."IC_CYCL_ADT"

View Text - HTML Formatted

SELECT CYCLE_ID CYCLE_ID
, SEQ_NO SEQ_NO
, CYCL_ADT_ID CYCL_ADT_ID
, ITEM_ID ITEM_ID
, LOCATION LOCATION
, WHSE_CODE WHSE_CODE
, LOT_NO LOT_NO
, SUBLOT_NO SUBLOT_NO
, LINE_TYPE LINE_TYPE
, CYCLE_NO CYCLE_NO
, CYCLESTART_DT CYCLESTART_DT
, ITEM_COUNT_DT ITEM_COUNT_DT
, COUNT_NO COUNT_NO
, ITEM_NO ITEM_NO
, ITEM_DESC1 ITEM_DESC1
, LOT_ID LOT_ID
, TRANS_DATE TRANS_DATE
, DOC_TYPE DOC_TYPE
, TRANS_QTY1 TRANS_QTY1
, TRANS_QTY2 TRANS_QTY2
, FROZEN_QTY1 FROZEN_QTY1
, FROZEN_QTY2 FROZEN_QTY2
, UOM1 UOM1
, UOM2 UOM2
, COUNT_QTY1 COUNT_QTY1
, COUNT_QTY2 COUNT_QTY2
, ONHAND ONHAND
, ONHAND2 ONHAND2
, VAR_QTY1 VAR_QTY1
, VAR_QTY2 VAR_QTY2
, VAR_PERCENT VAR_PERCENT
, POST_ONHAND POST_ONHAND
, POST_ONHAND2 POST_ONHAND2
, DELETE_MARK DELETE_MARK
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "GMI"."IC_CYCL_ADT"