VIEW: WIP.WIP_LPN_COMPLETIONS_LOTS#

Source

View Text - Preformatted

select HEADER_ID HEADER_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_UPDATE_DATE PROGRAM_UPDATE_DATE, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, TRANSACTION_QUANTITY TRANSACTION_QUANTITY, PRIMARY_QUANTITY PRIMARY_QUANTITY, LOT_NUMBER LOT_NUMBER, LOT_EXPIRATION_DATE LOT_EXPIRATION_DATE, ERROR_CODE ERROR_CODE, LOT_ATTRIBUTE_CATEGORY LOT_ATTRIBUTE_CATEGORY, STATUS_ID STATUS_ID, STATUS_CODE STATUS_CODE, 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, N_ATTRIBUTE11 N_ATTRIBUTE11, TERRITORY_CODE TERRITORY_CODE, VENDOR_NAME VENDOR_NAME, SUPPLIER_LOT_NUMBER SUPPLIER_LOT_NUMBER, VENDOR_ID VENDOR_ID, VENDOR_LOT_NUMBER VENDOR_LOT_NUMBER, DESCRIPTION DESCRIPTION, 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, 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, RECYCLED_CONTENT RECYCLED_CONTENT, THICKNESS THICKNESS, THICKNESS_UOM THICKNESS_UOM, WIDTH WIDTH, WIDTH_UOM WIDTH_UOM, CURL_WRINKLE_FOLD CURL_WRINKLE_FOLD, ORIGINATION_TYPE ORIGINATION_TYPE, EXPIRATION_ACTION_CODE EXPIRATION_ACTION_CODE, EXPIRATION_ACTION_DATE EXPIRATION_ACTION_DATE, HOLD_DATE HOLD_DATE from "WIP"."WIP_LPN_COMPLETIONS_LOTS"

View Text - HTML Formatted

SELECT HEADER_ID HEADER_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_UPDATE_DATE PROGRAM_UPDATE_DATE
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, TRANSACTION_QUANTITY TRANSACTION_QUANTITY
, PRIMARY_QUANTITY PRIMARY_QUANTITY
, LOT_NUMBER LOT_NUMBER
, LOT_EXPIRATION_DATE LOT_EXPIRATION_DATE
, ERROR_CODE ERROR_CODE
, LOT_ATTRIBUTE_CATEGORY LOT_ATTRIBUTE_CATEGORY
, STATUS_ID STATUS_ID
, STATUS_CODE STATUS_CODE
, 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
, N_ATTRIBUTE11 N_ATTRIBUTE11
, TERRITORY_CODE TERRITORY_CODE
, VENDOR_NAME VENDOR_NAME
, SUPPLIER_LOT_NUMBER SUPPLIER_LOT_NUMBER
, VENDOR_ID VENDOR_ID
, VENDOR_LOT_NUMBER VENDOR_LOT_NUMBER
, DESCRIPTION DESCRIPTION
, 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
, 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
, RECYCLED_CONTENT RECYCLED_CONTENT
, THICKNESS THICKNESS
, THICKNESS_UOM THICKNESS_UOM
, WIDTH WIDTH
, WIDTH_UOM WIDTH_UOM
, CURL_WRINKLE_FOLD CURL_WRINKLE_FOLD
, ORIGINATION_TYPE ORIGINATION_TYPE
, EXPIRATION_ACTION_CODE EXPIRATION_ACTION_CODE
, EXPIRATION_ACTION_DATE EXPIRATION_ACTION_DATE
, HOLD_DATE HOLD_DATE
FROM "WIP"."WIP_LPN_COMPLETIONS_LOTS"