eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: WMS.WMS_SERIAL_NUMBERS_TRACE

Object Details

Object Name:	WMS_SERIAL_NUMBERS_TRACE
Object Type:	TABLE
Owner:	WMS
FND Design Data:	WMS.WMS_SERIAL_NUMBERS_TRACE
Subobject Name:
Status:	VALID

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

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WMS_SERIAL_NUMBERS_TACE_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_TEMP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_TEMP_ID	NUMBER		Yes	Transaction temp identiifer - For WMS internal Use only
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 WHO Column
PROGRAM_APPLICATION_ID	NUMBER			Standard WHO Column
PROGRAM_ID	NUMBER			Standard WHO Column
PROGRAM_UPDATE_DATE	DATE			Standard WHO Column
VENDOR_SERIAL_NUMBER	VARCHAR2	(30)		Vendor Serial Number - For WMS internal Use only
VENDOR_LOT_NUMBER	VARCHAR2	(30)		Vendor Lot Number - For WMS internal Use only
FM_SERIAL_NUMBER	VARCHAR2	(30)		From Serial Number - For WMS internal Use only
TO_SERIAL_NUMBER	VARCHAR2	(30)		To Serial Number - For WMS internal Use only
SERIAL_PREFIX	VARCHAR2	(30)		Serila Prefix - For WMS internal Use only
ERROR_CODE	VARCHAR2	(30)		Error Code - For WMS internal Use only
GROUP_HEADER_ID	NUMBER			Group Header identifier - For WMS internal Use only
PARENT_SERIAL_NUMBER	VARCHAR2	(30)		Parent Serial Number - For WMS internal Use only
END_ITEM_UNIT_NUMBER	VARCHAR2	(30)		Item unit number - For WMS internal Use only
SERIAL_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Serial Attribute Category - For WMS internal Use only
ORIGINATION_DATE	DATE			Origination Date - For WMS internal Use only
C_ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield segment
C_ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield segment
C_ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment
C_ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment
C_ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment
C_ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment
C_ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment
C_ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment
C_ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment
C_ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment
C_ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield segment
C_ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield segment
C_ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield segment
C_ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield segment
C_ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield segment
C_ATTRIBUTE16	VARCHAR2	(150)		Descriptive Flexfield segment
C_ATTRIBUTE17	VARCHAR2	(150)		Descriptive Flexfield segment
C_ATTRIBUTE18	VARCHAR2	(150)		Descriptive Flexfield segment
C_ATTRIBUTE19	VARCHAR2	(150)		Descriptive Flexfield segment
C_ATTRIBUTE20	VARCHAR2	(150)		Descriptive Flexfield segment
D_ATTRIBUTE1	DATE			Descriptive Flexfield segment
D_ATTRIBUTE2	DATE			Descriptive Flexfield segment
D_ATTRIBUTE3	DATE			Descriptive Flexfield segment
D_ATTRIBUTE4	DATE			Descriptive Flexfield segment
D_ATTRIBUTE5	DATE			Descriptive Flexfield segment
D_ATTRIBUTE6	DATE			Descriptive Flexfield segment
D_ATTRIBUTE7	DATE			Descriptive Flexfield segment
D_ATTRIBUTE8	DATE			Descriptive Flexfield segment
D_ATTRIBUTE9	DATE			Descriptive Flexfield segment
D_ATTRIBUTE10	DATE			Descriptive Flexfield segment
N_ATTRIBUTE1	NUMBER			Descriptive Flexfield segment
N_ATTRIBUTE2	NUMBER			Descriptive Flexfield segment
N_ATTRIBUTE3	NUMBER			Descriptive Flexfield segment
N_ATTRIBUTE4	NUMBER			Descriptive Flexfield segment
N_ATTRIBUTE5	NUMBER			Descriptive Flexfield segment
N_ATTRIBUTE6	NUMBER			Descriptive Flexfield segment
N_ATTRIBUTE7	NUMBER			Descriptive Flexfield segment
N_ATTRIBUTE8	NUMBER			Descriptive Flexfield segment
N_ATTRIBUTE9	NUMBER			Descriptive Flexfield segment
N_ATTRIBUTE10	NUMBER			Descriptive Flexfield segment
STATUS_ID	NUMBER	(30)		Status Identifier - For WMS internal Use only
TERRITORY_CODE	VARCHAR2	(30)		Territory code - For WMS internal Use only
TIME_SINCE_NEW	NUMBER			Age - For WMS internal Use only
CYCLES_SINCE_NEW	NUMBER			Cycles - For WMS internal Use only
TIME_SINCE_OVERHAUL	NUMBER			age - since overhaul - For WMS internal Use only
CYCLES_SINCE_OVERHAUL	NUMBER			Cycles - since overhal - For WMS internal Use only
TIME_SINCE_REPAIR	NUMBER			Time since repair - For WMS internal Use only
CYCLES_SINCE_REPAIR	NUMBER			Cycle Since Repair
TIME_SINCE_VISIT	NUMBER			Time Since visit
CYCLES_SINCE_VISIT	NUMBER			Cycle since Visit
TIME_SINCE_MARK	NUMBER			Time Since Mark
CYCLES_SINCE_MARK	NUMBER			Cycle Since Mark
NUMBER_OF_REPAIRS	NUMBER			Number of Repairs

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
,      VENDOR_SERIAL_NUMBER
,      VENDOR_LOT_NUMBER
,      FM_SERIAL_NUMBER
,      TO_SERIAL_NUMBER
,      SERIAL_PREFIX
,      ERROR_CODE
,      GROUP_HEADER_ID
,      PARENT_SERIAL_NUMBER
,      END_ITEM_UNIT_NUMBER
,      SERIAL_ATTRIBUTE_CATEGORY
,      ORIGINATION_DATE
,      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
,      STATUS_ID
,      TERRITORY_CODE
,      TIME_SINCE_NEW
,      CYCLES_SINCE_NEW
,      TIME_SINCE_OVERHAUL
,      CYCLES_SINCE_OVERHAUL
,      TIME_SINCE_REPAIR
,      CYCLES_SINCE_REPAIR
,      TIME_SINCE_VISIT
,      CYCLES_SINCE_VISIT
,      TIME_SINCE_MARK
,      CYCLES_SINCE_MARK
,      NUMBER_OF_REPAIRS
FROM WMS.WMS_SERIAL_NUMBERS_TRACE;

Dependencies

[top of page]

WMS.WMS_SERIAL_NUMBERS_TRACE does not reference any database object

WMS.WMS_SERIAL_NUMBERS_TRACE is referenced by following:

APPS: WMS_SERIAL_NUMBERS_TRACE