DBA Data[Home] [Help] [Dependency Information]

TABLE: WMS.WMS_TRANSACTION_LOTS_TRACE

Object Details
Object Name: WMS_TRANSACTION_LOTS_TRACE
Object Type: TABLE
Owner: WMS
FND Design Data: TableWMS.WMS_TRANSACTION_LOTS_TRACE
Subobject Name:
Status: VALID


WMS_TRANSACTION_LOTS TEMP is a history table used for storing lot number details and will be used for run time trace. - This for WMS internal Use only.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WMS_TRANSACTION_LOTS_TRACE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_TEMP_ID
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_TEMP_ID NUMBER
Yes Transaction Temp Id
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Standard column
PROGRAM_APPLICATION_ID NUMBER

Standard Who column
PROGRAM_ID NUMBER

Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who column
TRANSACTION_QUANTITY NUMBER
Yes Transaction Quantity, in the userr's preferred unit of measure
PRIMARY_QUANTITY NUMBER
Yes Transaction quantity, in the item's primary unit of measure
LOT_NUMBER VARCHAR2 (80) Yes Transaction lot number
LOT_EXPIRATION_DATE DATE

Lot Exeiration Date
ERROR_CODE VARCHAR2 (240)
Error Code
SERIAL_TRANSACTION_TEMP_ID NUMBER

connects the corresponding rows in WMS_SERIAL_NUMBERS_TEMP to this table through the TRANSACTION_TEMP_ID
GROUP_HEADER_ID NUMBER

Group Identifier
PUT_AWAY_RULE_ID NUMBER

Put Away Rule ID
PICK_RULE_ID NUMBER

Pick Rule ID
DESCRIPTION VARCHAR2 (256)
Used by WMS only
VENDOR_NAME VARCHAR2 (240)
Identification for Vendor- Used By WMS Only
SUPPLIER_LOT_NUMBER VARCHAR2 (150)
Supplier's Lot NUmber
ORIGINATION_DATE DATE

Orgination Date
DATE_CODE VARCHAR2 (150)
Date Code - WMS internal use only.
GRADE_CODE VARCHAR2 (150)
Grade code - WMS internal use only.
CHANGE_DATE DATE

Change Date - WMS internal use only.
MATURITY_DATE DATE

Maturity Date - WMS internal use only.
STATUS_ID NUMBER

Status Identifier - WMS internal use only.
RETEST_DATE DATE

Retest Date - WMS internal use only.
AGE NUMBER

Age - WMS internal use only.
ITEM_SIZE NUMBER

Item Size - WMS internal use only.
COLOR VARCHAR2 (150)
Color - WMS internal use only.
VOLUME NUMBER

Volume - WMS internal use only.
VOLUME_UOM VARCHAR2 (3)
Volume UOM - WMS internal use only.
PLACE_OF_ORIGIN VARCHAR2 (150)
Place of Origin - WMS internal use only.
BEST_BY_DATE DATE

Best By Date - WMS internal use only.
LENGTH NUMBER

Length - WMS internal use only.
LENGTH_UOM VARCHAR2 (3)
Length Uom - WMS internal use only.
RECYCLED_CONTENT NUMBER

Recycle Content - WMS internal use only.
THICKNESS NUMBER

Thickness - WMS internal use only.
THICKNESS_UOM VARCHAR2 (3)
Thickness UOM - WMS internal use only.
WIDTH NUMBER

Width - WMS internal use only.
WIDTH_UOM VARCHAR2 (3)
Width UOM - WMS internal use only.
CURL_WRINKLE_FOLD VARCHAR2 (150)
Curl Wrinkle Fold - WMS internal use only.
LOT_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Lot Attribute Category - WMS internal use only.
C_ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield Segment- Used By WMS Only
C_ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield Segment- Used By WMS Only
C_ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield Segment- Used By WMS Only
C_ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield Segment- Used By WMS Only
C_ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield Segment- Used By WMS Only
C_ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield Segment- Used By WMS Only
C_ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield Segment- Used By WMS Only
C_ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield Segment- Used By WMS Only
C_ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield Segment- Used By WMS Only
C_ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield Segment- Used By WMS Only
C_ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield Segment- Used By WMS Only
C_ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield Segment- Used By WMS Only
C_ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield Segment- Used By WMS Only
C_ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield Segment- Used By WMS Only
C_ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield Segment- Used By WMS Only
C_ATTRIBUTE16 VARCHAR2 (150)
Descriptive Flexfield Segment- Used By WMS Only
C_ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flexfield Segment- Used By WMS Only
C_ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flexfield Segment- Used By WMS Only
C_ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flexfield Segment- Used By WMS Only
C_ATTRIBUTE20 VARCHAR2 (150)
Descriptive Flexfield Segment- Used By WMS Only
D_ATTRIBUTE1 DATE

Descriptive Flexfield Segment- Used By WMS Only
D_ATTRIBUTE2 DATE

Descriptive Flexfield Segment- Used By WMS Only
D_ATTRIBUTE3 DATE

Descriptive Flexfield Segment- Used By WMS Only
D_ATTRIBUTE4 DATE

Descriptive Flexfield Segment- Used By WMS Only
D_ATTRIBUTE5 DATE

Descriptive Flexfield Segment- Used By WMS Only
D_ATTRIBUTE6 DATE

Descriptive Flexfield Segment- Used By WMS Only
D_ATTRIBUTE7 DATE

Descriptive Flexfield Segment- Used By WMS Only
D_ATTRIBUTE8 DATE

Descriptive Flexfield Segment- Used By WMS Only
D_ATTRIBUTE9 DATE

Descriptive Flexfield Segment- Used By WMS Only
D_ATTRIBUTE10 DATE

Descriptive Flexfield Segment- Used By WMS Only
N_ATTRIBUTE1 NUMBER

Descriptive Flexfield Segment- Used By WMS Only
N_ATTRIBUTE2 NUMBER

Descriptive Flexfield Segment- Used By WMS Only
N_ATTRIBUTE3 NUMBER

Descriptive Flexfield Segment- Used By WMS Only
N_ATTRIBUTE4 NUMBER

Descriptive Flexfield Segment- Used By WMS Only
N_ATTRIBUTE5 NUMBER

Descriptive Flexfield Segment- Used By WMS Only
N_ATTRIBUTE6 NUMBER

Descriptive Flexfield Segment- Used By WMS Only
N_ATTRIBUTE7 NUMBER

Descriptive Flexfield Segment- Used By WMS Only
N_ATTRIBUTE8 NUMBER

Descriptive Flexfield Segment- Used By WMS Only
N_ATTRIBUTE9 NUMBER

Descriptive Flexfield Segment- Used By WMS Only
N_ATTRIBUTE10 NUMBER

Descriptive Flexfield Segment- Used By WMS Only
VENDOR_ID NUMBER

Vendor ID - For WMS internal use only
TERRITORY_CODE VARCHAR2 (30)
Territoty Code - for WMS internal Use only
SUBLOT_NUM VARCHAR2 (80)
Sublot Num - for WMS internal Use only
SECONDARY_QUANTITY NUMBER

Seconday Quantity - For WMS internal Use only
SECONDARY_UNIT_OF_MEASURE VARCHAR2 (25)
Secondary Unit of measure - For WMS internal Use only
QC_GRADE VARCHAR2 (25)
QC Grade - For WMS internal Use only
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TRANSACTION_TEMP_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      TRANSACTION_QUANTITY
,      PRIMARY_QUANTITY
,      LOT_NUMBER
,      LOT_EXPIRATION_DATE
,      ERROR_CODE
,      SERIAL_TRANSACTION_TEMP_ID
,      GROUP_HEADER_ID
,      PUT_AWAY_RULE_ID
,      PICK_RULE_ID
,      DESCRIPTION
,      VENDOR_NAME
,      SUPPLIER_LOT_NUMBER
,      ORIGINATION_DATE
,      DATE_CODE
,      GRADE_CODE
,      CHANGE_DATE
,      MATURITY_DATE
,      STATUS_ID
,      RETEST_DATE
,      AGE
,      ITEM_SIZE
,      COLOR
,      VOLUME
,      VOLUME_UOM
,      PLACE_OF_ORIGIN
,      BEST_BY_DATE
,      LENGTH
,      LENGTH_UOM
,      RECYCLED_CONTENT
,      THICKNESS
,      THICKNESS_UOM
,      WIDTH
,      WIDTH_UOM
,      CURL_WRINKLE_FOLD
,      LOT_ATTRIBUTE_CATEGORY
,      C_ATTRIBUTE1
,      C_ATTRIBUTE2
,      C_ATTRIBUTE3
,      C_ATTRIBUTE4
,      C_ATTRIBUTE5
,      C_ATTRIBUTE6
,      C_ATTRIBUTE7
,      C_ATTRIBUTE8
,      C_ATTRIBUTE9
,      C_ATTRIBUTE10
,      C_ATTRIBUTE11
,      C_ATTRIBUTE12
,      C_ATTRIBUTE13
,      C_ATTRIBUTE14
,      C_ATTRIBUTE15
,      C_ATTRIBUTE16
,      C_ATTRIBUTE17
,      C_ATTRIBUTE18
,      C_ATTRIBUTE19
,      C_ATTRIBUTE20
,      D_ATTRIBUTE1
,      D_ATTRIBUTE2
,      D_ATTRIBUTE3
,      D_ATTRIBUTE4
,      D_ATTRIBUTE5
,      D_ATTRIBUTE6
,      D_ATTRIBUTE7
,      D_ATTRIBUTE8
,      D_ATTRIBUTE9
,      D_ATTRIBUTE10
,      N_ATTRIBUTE1
,      N_ATTRIBUTE2
,      N_ATTRIBUTE3
,      N_ATTRIBUTE4
,      N_ATTRIBUTE5
,      N_ATTRIBUTE6
,      N_ATTRIBUTE7
,      N_ATTRIBUTE8
,      N_ATTRIBUTE9
,      N_ATTRIBUTE10
,      VENDOR_ID
,      TERRITORY_CODE
,      SUBLOT_NUM
,      SECONDARY_QUANTITY
,      SECONDARY_UNIT_OF_MEASURE
,      QC_GRADE
FROM WMS.WMS_TRANSACTION_LOTS_TRACE;

Dependencies

[top of page]

WMS.WMS_TRANSACTION_LOTS_TRACE does not reference any database object

WMS.WMS_TRANSACTION_LOTS_TRACE is referenced by following:

SchemaWMS
ViewWMS_TRANSACTION_LOTS_TRACE#