[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: |
APPS.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 |