FND Design Data [Home] [Help]

View: OE_LOTSERIAL_ACKS_V

Product: ONT - Order Management
Description: View based on the oe_lotserial_acks table, striped on organization.
Implementation/DBA Data: ViewAPPS.OE_LOTSERIAL_ACKS_V
View Text

SELECT ORDER_SOURCE_ID
, ORIG_SYS_DOCUMENT_REF
, ORIG_SYS_LINE_REF
, ORIG_SYS_SHIPMENT_REF
, ORIG_SYS_LOT_SERIAL_REF
, ACKNOWLEDGMENT_FLAG
, BUYER_SELLER_FLAG
, CHANGE_SEQUENCE
, LOT_NUMBER
, FROM_SERIAL_NUMBER
, TO_SERIAL_NUMBER
, QUANTITY
, QUANTITY2
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, OPERATION_CODE
FROM OE_LOTSERIAL_ACKS

Columns

Name
ORDER_SOURCE_ID
ORIG_SYS_DOCUMENT_REF
ORIG_SYS_LINE_REF
ORIG_SYS_SHIPMENT_REF
ORIG_SYS_LOTSERIAL_REF
ACKNOWLEDGMENT_FLAG
BUYER_SELLER_FLAG
CHANGE_SEQUENCE
LOT_NUMBER
FROM_SERIAL_NUMBER
TO_SERIAL_NUMBER
QUANTITY
QUANTITY2
CONTEXT
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
OPERATION_CODE