VIEW: GMI.IC_XFER_MST#

Source

View Text - Preformatted

select TRANSFER_ID TRANSFER_ID, TRANSFER_NO TRANSFER_NO, ORGN_CODE ORGN_CODE, TRANSFER_STATUS TRANSFER_STATUS, ITEM_ID ITEM_ID, LOT_ID LOT_ID, LOT_STATUS LOT_STATUS, RELEASE_REASON_CODE RELEASE_REASON_CODE, RECEIVE_REASON_CODE RECEIVE_REASON_CODE, CANCEL_REASON_CODE CANCEL_REASON_CODE, FROM_WAREHOUSE FROM_WAREHOUSE, FROM_LOCATION FROM_LOCATION, TO_WAREHOUSE TO_WAREHOUSE, TO_LOCATION TO_LOCATION, RELEASE_QUANTITY1 RELEASE_QUANTITY1, RELEASE_QUANTITY2 RELEASE_QUANTITY2, RELEASE_UOM1 RELEASE_UOM1, RELEASE_UOM2 RELEASE_UOM2, RECEIVE_QUANTITY1 RECEIVE_QUANTITY1, RECEIVE_QUANTITY2 RECEIVE_QUANTITY2, SCHEDULED_RELEASE_DATE SCHEDULED_RELEASE_DATE, ACTUAL_RELEASE_DATE ACTUAL_RELEASE_DATE, SCHEDULED_RECEIVE_DATE SCHEDULED_RECEIVE_DATE, ACTUAL_RECEIVE_DATE ACTUAL_RECEIVE_DATE, CANCEL_DATE CANCEL_DATE, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, ATTRIBUTE21 ATTRIBUTE21, ATTRIBUTE22 ATTRIBUTE22, ATTRIBUTE23 ATTRIBUTE23, ATTRIBUTE24 ATTRIBUTE24, ATTRIBUTE25 ATTRIBUTE25, ATTRIBUTE26 ATTRIBUTE26, ATTRIBUTE27 ATTRIBUTE27, ATTRIBUTE28 ATTRIBUTE28, ATTRIBUTE29 ATTRIBUTE29, ATTRIBUTE30 ATTRIBUTE30, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, DELETE_MARK DELETE_MARK, RECEIVED_BY RECEIVED_BY, RELEASED_BY RELEASED_BY, CANCELED_BY CANCELED_BY, TEXT_CODE TEXT_CODE, COMMENTS COMMENTS, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, TRANSFER_BATCH TRANSFER_BATCH from "GMI"."IC_XFER_MST"

View Text - HTML Formatted

SELECT TRANSFER_ID TRANSFER_ID
, TRANSFER_NO TRANSFER_NO
, ORGN_CODE ORGN_CODE
, TRANSFER_STATUS TRANSFER_STATUS
, ITEM_ID ITEM_ID
, LOT_ID LOT_ID
, LOT_STATUS LOT_STATUS
, RELEASE_REASON_CODE RELEASE_REASON_CODE
, RECEIVE_REASON_CODE RECEIVE_REASON_CODE
, CANCEL_REASON_CODE CANCEL_REASON_CODE
, FROM_WAREHOUSE FROM_WAREHOUSE
, FROM_LOCATION FROM_LOCATION
, TO_WAREHOUSE TO_WAREHOUSE
, TO_LOCATION TO_LOCATION
, RELEASE_QUANTITY1 RELEASE_QUANTITY1
, RELEASE_QUANTITY2 RELEASE_QUANTITY2
, RELEASE_UOM1 RELEASE_UOM1
, RELEASE_UOM2 RELEASE_UOM2
, RECEIVE_QUANTITY1 RECEIVE_QUANTITY1
, RECEIVE_QUANTITY2 RECEIVE_QUANTITY2
, SCHEDULED_RELEASE_DATE SCHEDULED_RELEASE_DATE
, ACTUAL_RELEASE_DATE ACTUAL_RELEASE_DATE
, SCHEDULED_RECEIVE_DATE SCHEDULED_RECEIVE_DATE
, ACTUAL_RECEIVE_DATE ACTUAL_RECEIVE_DATE
, CANCEL_DATE CANCEL_DATE
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, ATTRIBUTE21 ATTRIBUTE21
, ATTRIBUTE22 ATTRIBUTE22
, ATTRIBUTE23 ATTRIBUTE23
, ATTRIBUTE24 ATTRIBUTE24
, ATTRIBUTE25 ATTRIBUTE25
, ATTRIBUTE26 ATTRIBUTE26
, ATTRIBUTE27 ATTRIBUTE27
, ATTRIBUTE28 ATTRIBUTE28
, ATTRIBUTE29 ATTRIBUTE29
, ATTRIBUTE30 ATTRIBUTE30
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, DELETE_MARK DELETE_MARK
, RECEIVED_BY RECEIVED_BY
, RELEASED_BY RELEASED_BY
, CANCELED_BY CANCELED_BY
, TEXT_CODE TEXT_CODE
, COMMENTS COMMENTS
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TRANSFER_BATCH TRANSFER_BATCH
FROM "GMI"."IC_XFER_MST"