[Home] [Help] [Dependency Information]
Object Name: | OE_LOTSERIAL_ACKS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ONT.OE_LOTSERIAL_ACKS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
View based on the oe_lotserial_acks table, striped on organization.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORDER_SOURCE_ID | NUMBER | Order source id | ||
ORIG_SYS_DOCUMENT_REF | VARCHAR2 | (50) | Original system document reference | |
ORIG_SYS_LINE_REF | VARCHAR2 | (50) | Original system line reference | |
ORIG_SYS_SHIPMENT_REF | VARCHAR2 | (50) | Original system shipment reference | |
ORIG_SYS_LOTSERIAL_REF | VARCHAR2 | (50) | Original system lotserial reference | |
ACKNOWLEDGMENT_FLAG | VARCHAR2 | (1) | Acknowledgment flag | |
BUYER_SELLER_FLAG | VARCHAR2 | (1) | Buyer/Seller flag | |
CHANGE_SEQUENCE | VARCHAR2 | (50) | Change sequence | |
LOT_NUMBER | VARCHAR2 | (80) | Lot number | |
FROM_SERIAL_NUMBER | VARCHAR2 | (30) | From serial number | |
TO_SERIAL_NUMBER | VARCHAR2 | (30) | To serial number | |
QUANTITY | NUMBER | Quantity | ||
QUANTITY2 | NUMBER | For OPM Process Customers, secondary ordered quantity information of return | ||
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield segment | |
ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
OPERATION_CODE | VARCHAR2 | (30) | Operation code |
Cut, paste (and edit) the following text to query this object:
SELECT 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
FROM APPS.OE_LOTSERIAL_ACKS_V;
APPS.OE_LOTSERIAL_ACKS_V is not referenced by any database object
|
|
|