VIEW: GMI.IC_TRAN_ARC#

Source

View Text - Preformatted

select TRANS_ID TRANS_ID, ITEM_ID ITEM_ID, LINE_ID LINE_ID, CO_CODE CO_CODE, ORGN_CODE ORGN_CODE, WHSE_CODE WHSE_CODE, LOT_ID LOT_ID, LOCATION LOCATION, DOC_ID DOC_ID, DOC_TYPE DOC_TYPE, DOC_LINE DOC_LINE, LINE_TYPE LINE_TYPE, REASON_CODE REASON_CODE, CREATION_DATE CREATION_DATE, TRANS_DATE TRANS_DATE, TRANS_QTY TRANS_QTY, TRANS_QTY2 TRANS_QTY2, QC_GRADE QC_GRADE, LOT_STATUS LOT_STATUS, TRANS_STAT TRANS_STAT, TRANS_UM TRANS_UM, TRANS_UM2 TRANS_UM2, ARCHIVE_DATE ARCHIVE_DATE, OP_CODE OP_CODE, GL_POSTED_IND GL_POSTED_IND, EVENT_ID EVENT_ID, TEXT_CODE TEXT_CODE, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, PURGE_ID PURGE_ID, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LINE_DETAIL_ID LINE_DETAIL_ID, INVOICED_FLAG INVOICED_FLAG, STAGED_IND STAGED_IND, INTORDER_POSTED_IND INTORDER_POSTED_IND, LOT_COSTED_IND LOT_COSTED_IND from "GMI"."IC_TRAN_ARC"

View Text - HTML Formatted

SELECT TRANS_ID TRANS_ID
, ITEM_ID ITEM_ID
, LINE_ID LINE_ID
, CO_CODE CO_CODE
, ORGN_CODE ORGN_CODE
, WHSE_CODE WHSE_CODE
, LOT_ID LOT_ID
, LOCATION LOCATION
, DOC_ID DOC_ID
, DOC_TYPE DOC_TYPE
, DOC_LINE DOC_LINE
, LINE_TYPE LINE_TYPE
, REASON_CODE REASON_CODE
, CREATION_DATE CREATION_DATE
, TRANS_DATE TRANS_DATE
, TRANS_QTY TRANS_QTY
, TRANS_QTY2 TRANS_QTY2
, QC_GRADE QC_GRADE
, LOT_STATUS LOT_STATUS
, TRANS_STAT TRANS_STAT
, TRANS_UM TRANS_UM
, TRANS_UM2 TRANS_UM2
, ARCHIVE_DATE ARCHIVE_DATE
, OP_CODE OP_CODE
, GL_POSTED_IND GL_POSTED_IND
, EVENT_ID EVENT_ID
, TEXT_CODE TEXT_CODE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, PURGE_ID PURGE_ID
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LINE_DETAIL_ID LINE_DETAIL_ID
, INVOICED_FLAG INVOICED_FLAG
, STAGED_IND STAGED_IND
, INTORDER_POSTED_IND INTORDER_POSTED_IND
, LOT_COSTED_IND LOT_COSTED_IND
FROM "GMI"."IC_TRAN_ARC"