VIEW: INV.MTL_TRANSACTION_LOT_NUMBERS#

Source

View Text - Preformatted

select TRANSACTION_ID TRANSACTION_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, TRANSACTION_DATE TRANSACTION_DATE, TRANSACTION_SOURCE_ID TRANSACTION_SOURCE_ID, TRANSACTION_SOURCE_TYPE_ID TRANSACTION_SOURCE_TYPE_ID, TRANSACTION_SOURCE_NAME TRANSACTION_SOURCE_NAME, TRANSACTION_QUANTITY TRANSACTION_QUANTITY, PRIMARY_QUANTITY PRIMARY_QUANTITY, LOT_NUMBER LOT_NUMBER, SERIAL_TRANSACTION_ID SERIAL_TRANSACTION_ID, DESCRIPTION DESCRIPTION, VENDOR_NAME VENDOR_NAME, SUPPLIER_LOT_NUMBER SUPPLIER_LOT_NUMBER, COUNTRY_OF_ORIGIN COUNTRY_OF_ORIGIN, ORIGINATION_DATE ORIGINATION_DATE, DATE_CODE DATE_CODE, GRADE_CODE GRADE_CODE, CHANGE_DATE CHANGE_DATE, MATURITY_DATE MATURITY_DATE, STATUS_ID STATUS_ID, RETEST_DATE RETEST_DATE, AGE AGE, ITEM_SIZE ITEM_SIZE, COLOR COLOR, VOLUME VOLUME, VOLUME_UOM VOLUME_UOM, PLACE_OF_ORIGIN PLACE_OF_ORIGIN, KILL_DATE KILL_DATE, BEST_BY_DATE BEST_BY_DATE, LENGTH LENGTH, LENGTH_UOM LENGTH_UOM, WIDTH WIDTH, WIDTH_UOM WIDTH_UOM, RECYCLED_CONTENT RECYCLED_CONTENT, THICKNESS THICKNESS, THICKNESS_UOM THICKNESS_UOM, CURL_WRINKLE_FOLD CURL_WRINKLE_FOLD, LOT_ATTRIBUTE_CATEGORY LOT_ATTRIBUTE_CATEGORY, C_ATTRIBUTE1 C_ATTRIBUTE1, C_ATTRIBUTE2 C_ATTRIBUTE2, C_ATTRIBUTE3 C_ATTRIBUTE3, C_ATTRIBUTE4 C_ATTRIBUTE4, C_ATTRIBUTE5 C_ATTRIBUTE5, C_ATTRIBUTE6 C_ATTRIBUTE6, C_ATTRIBUTE7 C_ATTRIBUTE7, C_ATTRIBUTE8 C_ATTRIBUTE8, C_ATTRIBUTE9 C_ATTRIBUTE9, C_ATTRIBUTE10 C_ATTRIBUTE10, C_ATTRIBUTE11 C_ATTRIBUTE11, C_ATTRIBUTE12 C_ATTRIBUTE12, C_ATTRIBUTE13 C_ATTRIBUTE13, C_ATTRIBUTE14 C_ATTRIBUTE14, C_ATTRIBUTE15 C_ATTRIBUTE15, C_ATTRIBUTE16 C_ATTRIBUTE16, C_ATTRIBUTE17 C_ATTRIBUTE17, C_ATTRIBUTE18 C_ATTRIBUTE18, C_ATTRIBUTE19 C_ATTRIBUTE19, C_ATTRIBUTE20 C_ATTRIBUTE20, C_ATTRIBUTE21 C_ATTRIBUTE21, C_ATTRIBUTE22 C_ATTRIBUTE22, C_ATTRIBUTE23 C_ATTRIBUTE23, C_ATTRIBUTE24 C_ATTRIBUTE24, C_ATTRIBUTE25 C_ATTRIBUTE25, C_ATTRIBUTE26 C_ATTRIBUTE26, C_ATTRIBUTE27 C_ATTRIBUTE27, C_ATTRIBUTE28 C_ATTRIBUTE28, C_ATTRIBUTE29 C_ATTRIBUTE29, C_ATTRIBUTE30 C_ATTRIBUTE30, D_ATTRIBUTE1 D_ATTRIBUTE1, D_ATTRIBUTE2 D_ATTRIBUTE2, D_ATTRIBUTE3 D_ATTRIBUTE3, D_ATTRIBUTE4 D_ATTRIBUTE4, D_ATTRIBUTE5 D_ATTRIBUTE5, D_ATTRIBUTE6 D_ATTRIBUTE6, D_ATTRIBUTE7 D_ATTRIBUTE7, D_ATTRIBUTE8 D_ATTRIBUTE8, D_ATTRIBUTE9 D_ATTRIBUTE9, D_ATTRIBUTE10 D_ATTRIBUTE10, D_ATTRIBUTE11 D_ATTRIBUTE11, D_ATTRIBUTE12 D_ATTRIBUTE12, D_ATTRIBUTE13 D_ATTRIBUTE13, D_ATTRIBUTE14 D_ATTRIBUTE14, D_ATTRIBUTE15 D_ATTRIBUTE15, D_ATTRIBUTE16 D_ATTRIBUTE16, D_ATTRIBUTE17 D_ATTRIBUTE17, D_ATTRIBUTE18 D_ATTRIBUTE18, D_ATTRIBUTE19 D_ATTRIBUTE19, D_ATTRIBUTE20 D_ATTRIBUTE20, N_ATTRIBUTE1 N_ATTRIBUTE1, N_ATTRIBUTE2 N_ATTRIBUTE2, N_ATTRIBUTE3 N_ATTRIBUTE3, N_ATTRIBUTE4 N_ATTRIBUTE4, N_ATTRIBUTE5 N_ATTRIBUTE5, N_ATTRIBUTE6 N_ATTRIBUTE6, N_ATTRIBUTE7 N_ATTRIBUTE7, N_ATTRIBUTE8 N_ATTRIBUTE8, N_ATTRIBUTE9 N_ATTRIBUTE9, N_ATTRIBUTE10 N_ATTRIBUTE10, N_ATTRIBUTE11 N_ATTRIBUTE11, N_ATTRIBUTE12 N_ATTRIBUTE12, N_ATTRIBUTE13 N_ATTRIBUTE13, N_ATTRIBUTE14 N_ATTRIBUTE14, N_ATTRIBUTE15 N_ATTRIBUTE15, N_ATTRIBUTE16 N_ATTRIBUTE16, N_ATTRIBUTE17 N_ATTRIBUTE17, N_ATTRIBUTE18 N_ATTRIBUTE18, N_ATTRIBUTE19 N_ATTRIBUTE19, N_ATTRIBUTE20 N_ATTRIBUTE20, N_ATTRIBUTE21 N_ATTRIBUTE21, N_ATTRIBUTE22 N_ATTRIBUTE22, N_ATTRIBUTE23 N_ATTRIBUTE23, N_ATTRIBUTE24 N_ATTRIBUTE24, N_ATTRIBUTE25 N_ATTRIBUTE25, N_ATTRIBUTE26 N_ATTRIBUTE26, N_ATTRIBUTE27 N_ATTRIBUTE27, N_ATTRIBUTE28 N_ATTRIBUTE28, N_ATTRIBUTE29 N_ATTRIBUTE29, N_ATTRIBUTE30 N_ATTRIBUTE30, VENDOR_ID VENDOR_ID, TERRITORY_CODE TERRITORY_CODE, PRODUCT_CODE PRODUCT_CODE, PRODUCT_TRANSACTION_ID PRODUCT_TRANSACTION_ID, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, 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, EXPIRATION_ACTION_CODE EXPIRATION_ACTION_CODE, EXPIRATION_ACTION_DATE EXPIRATION_ACTION_DATE, HOLD_DATE HOLD_DATE, ORIGINATION_TYPE ORIGINATION_TYPE, PARENT_LOT_NUMBER PARENT_LOT_NUMBER, REASON_ID REASON_ID, SECONDARY_TRANSACTION_QUANTITY SECONDARY_TRANSACTION_QUANTITY, PARENT_OBJECT_TYPE PARENT_OBJECT_TYPE, PARENT_OBJECT_ID PARENT_OBJECT_ID, PARENT_OBJECT_NUMBER PARENT_OBJECT_NUMBER, PARENT_ITEM_ID PARENT_ITEM_ID, PARENT_OBJECT_TYPE2 PARENT_OBJECT_TYPE2, PARENT_OBJECT_ID2 PARENT_OBJECT_ID2, PARENT_OBJECT_NUMBER2 PARENT_OBJECT_NUMBER2 from "INV"."MTL_TRANSACTION_LOT_NUMBERS"

View Text - HTML Formatted

SELECT TRANSACTION_ID TRANSACTION_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, TRANSACTION_DATE TRANSACTION_DATE
, TRANSACTION_SOURCE_ID TRANSACTION_SOURCE_ID
, TRANSACTION_SOURCE_TYPE_ID TRANSACTION_SOURCE_TYPE_ID
, TRANSACTION_SOURCE_NAME TRANSACTION_SOURCE_NAME
, TRANSACTION_QUANTITY TRANSACTION_QUANTITY
, PRIMARY_QUANTITY PRIMARY_QUANTITY
, LOT_NUMBER LOT_NUMBER
, SERIAL_TRANSACTION_ID SERIAL_TRANSACTION_ID
, DESCRIPTION DESCRIPTION
, VENDOR_NAME VENDOR_NAME
, SUPPLIER_LOT_NUMBER SUPPLIER_LOT_NUMBER
, COUNTRY_OF_ORIGIN COUNTRY_OF_ORIGIN
, ORIGINATION_DATE ORIGINATION_DATE
, DATE_CODE DATE_CODE
, GRADE_CODE GRADE_CODE
, CHANGE_DATE CHANGE_DATE
, MATURITY_DATE MATURITY_DATE
, STATUS_ID STATUS_ID
, RETEST_DATE RETEST_DATE
, AGE AGE
, ITEM_SIZE ITEM_SIZE
, COLOR COLOR
, VOLUME VOLUME
, VOLUME_UOM VOLUME_UOM
, PLACE_OF_ORIGIN PLACE_OF_ORIGIN
, KILL_DATE KILL_DATE
, BEST_BY_DATE BEST_BY_DATE
, LENGTH LENGTH
, LENGTH_UOM LENGTH_UOM
, WIDTH WIDTH
, WIDTH_UOM WIDTH_UOM
, RECYCLED_CONTENT RECYCLED_CONTENT
, THICKNESS THICKNESS
, THICKNESS_UOM THICKNESS_UOM
, CURL_WRINKLE_FOLD CURL_WRINKLE_FOLD
, LOT_ATTRIBUTE_CATEGORY LOT_ATTRIBUTE_CATEGORY
, C_ATTRIBUTE1 C_ATTRIBUTE1
, C_ATTRIBUTE2 C_ATTRIBUTE2
, C_ATTRIBUTE3 C_ATTRIBUTE3
, C_ATTRIBUTE4 C_ATTRIBUTE4
, C_ATTRIBUTE5 C_ATTRIBUTE5
, C_ATTRIBUTE6 C_ATTRIBUTE6
, C_ATTRIBUTE7 C_ATTRIBUTE7
, C_ATTRIBUTE8 C_ATTRIBUTE8
, C_ATTRIBUTE9 C_ATTRIBUTE9
, C_ATTRIBUTE10 C_ATTRIBUTE10
, C_ATTRIBUTE11 C_ATTRIBUTE11
, C_ATTRIBUTE12 C_ATTRIBUTE12
, C_ATTRIBUTE13 C_ATTRIBUTE13
, C_ATTRIBUTE14 C_ATTRIBUTE14
, C_ATTRIBUTE15 C_ATTRIBUTE15
, C_ATTRIBUTE16 C_ATTRIBUTE16
, C_ATTRIBUTE17 C_ATTRIBUTE17
, C_ATTRIBUTE18 C_ATTRIBUTE18
, C_ATTRIBUTE19 C_ATTRIBUTE19
, C_ATTRIBUTE20 C_ATTRIBUTE20
, C_ATTRIBUTE21 C_ATTRIBUTE21
, C_ATTRIBUTE22 C_ATTRIBUTE22
, C_ATTRIBUTE23 C_ATTRIBUTE23
, C_ATTRIBUTE24 C_ATTRIBUTE24
, C_ATTRIBUTE25 C_ATTRIBUTE25
, C_ATTRIBUTE26 C_ATTRIBUTE26
, C_ATTRIBUTE27 C_ATTRIBUTE27
, C_ATTRIBUTE28 C_ATTRIBUTE28
, C_ATTRIBUTE29 C_ATTRIBUTE29
, C_ATTRIBUTE30 C_ATTRIBUTE30
, D_ATTRIBUTE1 D_ATTRIBUTE1
, D_ATTRIBUTE2 D_ATTRIBUTE2
, D_ATTRIBUTE3 D_ATTRIBUTE3
, D_ATTRIBUTE4 D_ATTRIBUTE4
, D_ATTRIBUTE5 D_ATTRIBUTE5
, D_ATTRIBUTE6 D_ATTRIBUTE6
, D_ATTRIBUTE7 D_ATTRIBUTE7
, D_ATTRIBUTE8 D_ATTRIBUTE8
, D_ATTRIBUTE9 D_ATTRIBUTE9
, D_ATTRIBUTE10 D_ATTRIBUTE10
, D_ATTRIBUTE11 D_ATTRIBUTE11
, D_ATTRIBUTE12 D_ATTRIBUTE12
, D_ATTRIBUTE13 D_ATTRIBUTE13
, D_ATTRIBUTE14 D_ATTRIBUTE14
, D_ATTRIBUTE15 D_ATTRIBUTE15
, D_ATTRIBUTE16 D_ATTRIBUTE16
, D_ATTRIBUTE17 D_ATTRIBUTE17
, D_ATTRIBUTE18 D_ATTRIBUTE18
, D_ATTRIBUTE19 D_ATTRIBUTE19
, D_ATTRIBUTE20 D_ATTRIBUTE20
, N_ATTRIBUTE1 N_ATTRIBUTE1
, N_ATTRIBUTE2 N_ATTRIBUTE2
, N_ATTRIBUTE3 N_ATTRIBUTE3
, N_ATTRIBUTE4 N_ATTRIBUTE4
, N_ATTRIBUTE5 N_ATTRIBUTE5
, N_ATTRIBUTE6 N_ATTRIBUTE6
, N_ATTRIBUTE7 N_ATTRIBUTE7
, N_ATTRIBUTE8 N_ATTRIBUTE8
, N_ATTRIBUTE9 N_ATTRIBUTE9
, N_ATTRIBUTE10 N_ATTRIBUTE10
, N_ATTRIBUTE11 N_ATTRIBUTE11
, N_ATTRIBUTE12 N_ATTRIBUTE12
, N_ATTRIBUTE13 N_ATTRIBUTE13
, N_ATTRIBUTE14 N_ATTRIBUTE14
, N_ATTRIBUTE15 N_ATTRIBUTE15
, N_ATTRIBUTE16 N_ATTRIBUTE16
, N_ATTRIBUTE17 N_ATTRIBUTE17
, N_ATTRIBUTE18 N_ATTRIBUTE18
, N_ATTRIBUTE19 N_ATTRIBUTE19
, N_ATTRIBUTE20 N_ATTRIBUTE20
, N_ATTRIBUTE21 N_ATTRIBUTE21
, N_ATTRIBUTE22 N_ATTRIBUTE22
, N_ATTRIBUTE23 N_ATTRIBUTE23
, N_ATTRIBUTE24 N_ATTRIBUTE24
, N_ATTRIBUTE25 N_ATTRIBUTE25
, N_ATTRIBUTE26 N_ATTRIBUTE26
, N_ATTRIBUTE27 N_ATTRIBUTE27
, N_ATTRIBUTE28 N_ATTRIBUTE28
, N_ATTRIBUTE29 N_ATTRIBUTE29
, N_ATTRIBUTE30 N_ATTRIBUTE30
, VENDOR_ID VENDOR_ID
, TERRITORY_CODE TERRITORY_CODE
, PRODUCT_CODE PRODUCT_CODE
, PRODUCT_TRANSACTION_ID PRODUCT_TRANSACTION_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, 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
, EXPIRATION_ACTION_CODE EXPIRATION_ACTION_CODE
, EXPIRATION_ACTION_DATE EXPIRATION_ACTION_DATE
, HOLD_DATE HOLD_DATE
, ORIGINATION_TYPE ORIGINATION_TYPE
, PARENT_LOT_NUMBER PARENT_LOT_NUMBER
, REASON_ID REASON_ID
, SECONDARY_TRANSACTION_QUANTITY SECONDARY_TRANSACTION_QUANTITY
, PARENT_OBJECT_TYPE PARENT_OBJECT_TYPE
, PARENT_OBJECT_ID PARENT_OBJECT_ID
, PARENT_OBJECT_NUMBER PARENT_OBJECT_NUMBER
, PARENT_ITEM_ID PARENT_ITEM_ID
, PARENT_OBJECT_TYPE2 PARENT_OBJECT_TYPE2
, PARENT_OBJECT_ID2 PARENT_OBJECT_ID2
, PARENT_OBJECT_NUMBER2 PARENT_OBJECT_NUMBER2
FROM "INV"."MTL_TRANSACTION_LOT_NUMBERS"