VIEW: WMS.WMS_LPN_CONTENTS_INTERFACE#

Source

View Text - Preformatted

select LICENSE_PLATE_NUMBER LICENSE_PLATE_NUMBER, INTERFACE_TRANSACTION_ID INTERFACE_TRANSACTION_ID, GROUP_ID GROUP_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, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, ITEM_NUM ITEM_NUM, ITEM_DESCRIPTION ITEM_DESCRIPTION, ITEM_REVISION ITEM_REVISION, VENDOR_ITEM_NUM VENDOR_ITEM_NUM, LOT_NUMBER LOT_NUMBER, QUANTITY QUANTITY, UOM_CODE UOM_CODE, FROM_SERIAL_NUMBER FROM_SERIAL_NUMBER, TO_SERIAL_NUMBER TO_SERIAL_NUMBER, DOCUMENT_NUM DOCUMENT_NUM, DOCUMENT_LINE_NUM DOCUMENT_LINE_NUM, SHIP_TO_ORGANIZATION_CODE SHIP_TO_ORGANIZATION_CODE, SHIPMENT_NUM SHIPMENT_NUM, SERIAL_TRANSACTION_INTF_ID SERIAL_TRANSACTION_INTF_ID, EXPIRATION_DATE EXPIRATION_DATE, 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, GRADE_CODE GRADE_CODE, ORIGINATION_DATE ORIGINATION_DATE, DATE_CODE DATE_CODE, CHANGE_DATE CHANGE_DATE, AGE AGE, RETEST_DATE RETEST_DATE, MATURITY_DATE MATURITY_DATE, LOT_ATTRIBUTE_CATEGORY LOT_ATTRIBUTE_CATEGORY, ITEM_SIZE ITEM_SIZE, COLOR COLOR, VOLUME VOLUME, VOLUME_UOM_CODE VOLUME_UOM_CODE, PLACE_OF_ORIGIN PLACE_OF_ORIGIN, KILL_DATE KILL_DATE, BEST_BY_DATE BEST_BY_DATE, LENGTH LENGTH, LENGTH_UOM_CODE LENGTH_UOM_CODE, RECYCLED_CONTENT RECYCLED_CONTENT, THICKNESS THICKNESS, THICKNESS_UOM_CODE THICKNESS_UOM_CODE, WIDTH WIDTH, WIDTH_UOM_CODE WIDTH_UOM_CODE, CURL_WRINKLE_FOLD CURL_WRINKLE_FOLD, 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, 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, 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, SUPPLIER_LOT_NUMBER SUPPLIER_LOT_NUMBER, TERRITORY_CODE TERRITORY_CODE, STATUS_ID STATUS_ID, STATUS_NAME STATUS_NAME from "WMS"."WMS_LPN_CONTENTS_INTERFACE"

View Text - HTML Formatted

SELECT LICENSE_PLATE_NUMBER LICENSE_PLATE_NUMBER
, INTERFACE_TRANSACTION_ID INTERFACE_TRANSACTION_ID
, GROUP_ID GROUP_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
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ITEM_NUM ITEM_NUM
, ITEM_DESCRIPTION ITEM_DESCRIPTION
, ITEM_REVISION ITEM_REVISION
, VENDOR_ITEM_NUM VENDOR_ITEM_NUM
, LOT_NUMBER LOT_NUMBER
, QUANTITY QUANTITY
, UOM_CODE UOM_CODE
, FROM_SERIAL_NUMBER FROM_SERIAL_NUMBER
, TO_SERIAL_NUMBER TO_SERIAL_NUMBER
, DOCUMENT_NUM DOCUMENT_NUM
, DOCUMENT_LINE_NUM DOCUMENT_LINE_NUM
, SHIP_TO_ORGANIZATION_CODE SHIP_TO_ORGANIZATION_CODE
, SHIPMENT_NUM SHIPMENT_NUM
, SERIAL_TRANSACTION_INTF_ID SERIAL_TRANSACTION_INTF_ID
, EXPIRATION_DATE EXPIRATION_DATE
, 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
, GRADE_CODE GRADE_CODE
, ORIGINATION_DATE ORIGINATION_DATE
, DATE_CODE DATE_CODE
, CHANGE_DATE CHANGE_DATE
, AGE AGE
, RETEST_DATE RETEST_DATE
, MATURITY_DATE MATURITY_DATE
, LOT_ATTRIBUTE_CATEGORY LOT_ATTRIBUTE_CATEGORY
, ITEM_SIZE ITEM_SIZE
, COLOR COLOR
, VOLUME VOLUME
, VOLUME_UOM_CODE VOLUME_UOM_CODE
, PLACE_OF_ORIGIN PLACE_OF_ORIGIN
, KILL_DATE KILL_DATE
, BEST_BY_DATE BEST_BY_DATE
, LENGTH LENGTH
, LENGTH_UOM_CODE LENGTH_UOM_CODE
, RECYCLED_CONTENT RECYCLED_CONTENT
, THICKNESS THICKNESS
, THICKNESS_UOM_CODE THICKNESS_UOM_CODE
, WIDTH WIDTH
, WIDTH_UOM_CODE WIDTH_UOM_CODE
, CURL_WRINKLE_FOLD CURL_WRINKLE_FOLD
, 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
, 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
, 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
, SUPPLIER_LOT_NUMBER SUPPLIER_LOT_NUMBER
, TERRITORY_CODE TERRITORY_CODE
, STATUS_ID STATUS_ID
, STATUS_NAME STATUS_NAME
FROM "WMS"."WMS_LPN_CONTENTS_INTERFACE"