[Home] [Help]
| Product: | ONT - Order Management |
|---|---|
| Description: | View based on the oe_lotserial_acks table, striped on organization. |
| Implementation/DBA Data: |
APPS.OE_LOTSERIAL_ACKS_V
|
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