VIEW: ONT.OE_LOTSERIAL_ACKS#

Source

View Text - Preformatted

select ORIG_SYS_DOCUMENT_REF ORIG_SYS_DOCUMENT_REF, ORIG_SYS_LINE_REF ORIG_SYS_LINE_REF, ORIG_SYS_SHIPMENT_REF ORIG_SYS_SHIPMENT_REF, ORIG_SYS_LOT_SERIAL_REF ORIG_SYS_LOT_SERIAL_REF, ACKNOWLEDGMENT_FLAG ACKNOWLEDGMENT_FLAG, FIRST_ACK_CODE FIRST_ACK_CODE, LAST_ACK_CODE LAST_ACK_CODE, FIRST_ACK_DATE FIRST_ACK_DATE, LAST_ACK_DATE LAST_ACK_DATE, BUYER_SELLER_FLAG BUYER_SELLER_FLAG, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CHANGE_DATE CHANGE_DATE, CHANGE_SEQUENCE CHANGE_SEQUENCE, ORDER_SOURCE_ID ORDER_SOURCE_ID, ORDER_SOURCE ORDER_SOURCE, LOT_NUMBER LOT_NUMBER, FROM_SERIAL_NUMBER FROM_SERIAL_NUMBER, TO_SERIAL_NUMBER TO_SERIAL_NUMBER, QUANTITY QUANTITY, CONTEXT CONTEXT, 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, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, OPERATION_CODE OPERATION_CODE, ERROR_FLAG ERROR_FLAG, INTERFACE_STATUS INTERFACE_STATUS, QUANTITY2 QUANTITY2, SUBLOT_NUMBER SUBLOT_NUMBER, INST_ID INST_ID from "ONT"."OE_LOTSERIAL_ACKS"

View Text - HTML Formatted

SELECT ORIG_SYS_DOCUMENT_REF ORIG_SYS_DOCUMENT_REF
, ORIG_SYS_LINE_REF ORIG_SYS_LINE_REF
, ORIG_SYS_SHIPMENT_REF ORIG_SYS_SHIPMENT_REF
, ORIG_SYS_LOT_SERIAL_REF ORIG_SYS_LOT_SERIAL_REF
, ACKNOWLEDGMENT_FLAG ACKNOWLEDGMENT_FLAG
, FIRST_ACK_CODE FIRST_ACK_CODE
, LAST_ACK_CODE LAST_ACK_CODE
, FIRST_ACK_DATE FIRST_ACK_DATE
, LAST_ACK_DATE LAST_ACK_DATE
, BUYER_SELLER_FLAG BUYER_SELLER_FLAG
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CHANGE_DATE CHANGE_DATE
, CHANGE_SEQUENCE CHANGE_SEQUENCE
, ORDER_SOURCE_ID ORDER_SOURCE_ID
, ORDER_SOURCE ORDER_SOURCE
, LOT_NUMBER LOT_NUMBER
, FROM_SERIAL_NUMBER FROM_SERIAL_NUMBER
, TO_SERIAL_NUMBER TO_SERIAL_NUMBER
, QUANTITY QUANTITY
, CONTEXT CONTEXT
, 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
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, OPERATION_CODE OPERATION_CODE
, ERROR_FLAG ERROR_FLAG
, INTERFACE_STATUS INTERFACE_STATUS
, QUANTITY2 QUANTITY2
, SUBLOT_NUMBER SUBLOT_NUMBER
, INST_ID INST_ID
FROM "ONT"."OE_LOTSERIAL_ACKS"