VIEW: WIP.WIP_LPN_COMPLETIONS_SERIALS#

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_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, FM_SERIAL_NUMBER FM_SERIAL_NUMBER, TO_SERIAL_NUMBER TO_SERIAL_NUMBER, SERIAL_PREFIX SERIAL_PREFIX, PARENT_SERIAL_NUMBER PARENT_SERIAL_NUMBER, ERROR_CODE ERROR_CODE, LOT_NUMBER LOT_NUMBER, TRANSACTION_QUANTITY TRANSACTION_QUANTITY, SERIAL_ATTRIBUTE_CATEGORY SERIAL_ATTRIBUTE_CATEGORY, STATUS_ID STATUS_ID, STATUS_CODE STATUS_CODE, ORIGINATION_DATE ORIGINATION_DATE, 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, TERRITORY_CODE TERRITORY_CODE, TIME_SINCE_NEW TIME_SINCE_NEW, CYCLES_SINCE_NEW CYCLES_SINCE_NEW, TIME_SINCE_OVERHAUL TIME_SINCE_OVERHAUL, CYCLES_SINCE_OVERHAUL CYCLES_SINCE_OVERHAUL, TIME_SINCE_REPAIR TIME_SINCE_REPAIR, CYCLES_SINCE_REPAIR CYCLES_SINCE_REPAIR, TIME_SINCE_VISIT TIME_SINCE_VISIT, CYCLES_SINCE_VISIT CYCLES_SINCE_VISIT, TIME_SINCE_MARK TIME_SINCE_MARK, CYCLES_SINCE_MARK CYCLES_SINCE_MARK, NUMBER_OF_REPAIRS NUMBER_OF_REPAIRS from "WIP"."WIP_LPN_COMPLETIONS_SERIALS"

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_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, FM_SERIAL_NUMBER FM_SERIAL_NUMBER
, TO_SERIAL_NUMBER TO_SERIAL_NUMBER
, SERIAL_PREFIX SERIAL_PREFIX
, PARENT_SERIAL_NUMBER PARENT_SERIAL_NUMBER
, ERROR_CODE ERROR_CODE
, LOT_NUMBER LOT_NUMBER
, TRANSACTION_QUANTITY TRANSACTION_QUANTITY
, SERIAL_ATTRIBUTE_CATEGORY SERIAL_ATTRIBUTE_CATEGORY
, STATUS_ID STATUS_ID
, STATUS_CODE STATUS_CODE
, ORIGINATION_DATE ORIGINATION_DATE
, 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
, TERRITORY_CODE TERRITORY_CODE
, TIME_SINCE_NEW TIME_SINCE_NEW
, CYCLES_SINCE_NEW CYCLES_SINCE_NEW
, TIME_SINCE_OVERHAUL TIME_SINCE_OVERHAUL
, CYCLES_SINCE_OVERHAUL CYCLES_SINCE_OVERHAUL
, TIME_SINCE_REPAIR TIME_SINCE_REPAIR
, CYCLES_SINCE_REPAIR CYCLES_SINCE_REPAIR
, TIME_SINCE_VISIT TIME_SINCE_VISIT
, CYCLES_SINCE_VISIT CYCLES_SINCE_VISIT
, TIME_SINCE_MARK TIME_SINCE_MARK
, CYCLES_SINCE_MARK CYCLES_SINCE_MARK
, NUMBER_OF_REPAIRS NUMBER_OF_REPAIRS
FROM "WIP"."WIP_LPN_COMPLETIONS_SERIALS"