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]

VIEW: APPS.MTL_SERIAL_NUMBERS_TEMP_ERV

Object Details

Object Name:	MTL_SERIAL_NUMBERS_TEMP_ERV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	INV.MTL_SERIAL_NUMBERS_TEMP_ERV
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
TRANSACTION_TEMP_ID	NUMBER		Transaction Temp Id
LOT_NUMBER	VARCHAR2	(80)	Lot number if present
VENDOR_SERIAL_NUMBER	VARCHAR2	(30)	Vendor serial number
VENDOR_LOT_NUMBER	VARCHAR2	(30)	Vendor lot number
FM_SERIAL_NUMBER	VARCHAR2	(30)	from serial number
TO_SERIAL_NUMBER	VARCHAR2	(30)	to serial number
SERIAL_PREFIX	VARCHAR2	(30)	serial prefix
PARENT_SERIAL_NUMBER	VARCHAR2	(30)	parent serial number
END_ITEM_UNIT_NUMBER	VARCHAR2	(30)	end item unit number
SERIAL_ATTRIBUTE_CATEGORY	VARCHAR2	(30)	serial attribute category
ORIGINATION_DATE	DATE		origination date
C_ATTRIBUTE1	VARCHAR2	(150)	Standard flexfield attribute
C_ATTRIBUTE2	VARCHAR2	(150)	Standard flexfield attribute
C_ATTRIBUTE3	VARCHAR2	(150)	Standard flexfield attribute
C_ATTRIBUTE4	VARCHAR2	(150)	Standard flexfield attribute
C_ATTRIBUTE5	VARCHAR2	(150)	Standard flexfield attribute
C_ATTRIBUTE6	VARCHAR2	(150)	Standard flexfield attribute
C_ATTRIBUTE7	VARCHAR2	(150)	Standard flexfield attribute
C_ATTRIBUTE8	VARCHAR2	(150)	Standard flexfield attribute
C_ATTRIBUTE9	VARCHAR2	(150)	Standard flexfield attribute
C_ATTRIBUTE10	VARCHAR2	(150)	Standard flexfield attribute
C_ATTRIBUTE11	VARCHAR2	(150)	Standard flexfield attribute
C_ATTRIBUTE12	VARCHAR2	(150)	Standard flexfield attribute
C_ATTRIBUTE13	VARCHAR2	(150)	Standard flexfield attribute
C_ATTRIBUTE14	VARCHAR2	(150)	Standard flexfield attribute
C_ATTRIBUTE15	VARCHAR2	(150)	Standard flexfield attribute
C_ATTRIBUTE16	VARCHAR2	(150)	Standard flexfield attribute
C_ATTRIBUTE17	VARCHAR2	(150)	Standard flexfield attribute
C_ATTRIBUTE18	VARCHAR2	(150)	Standard flexfield attribute
C_ATTRIBUTE19	VARCHAR2	(150)	Standard flexfield attribute
C_ATTRIBUTE20	VARCHAR2	(150)	Standard flexfield attribute
D_ATTRIBUTE1	DATE		Standard flexfield attribute
D_ATTRIBUTE2	DATE		Standard flexfield attribute
D_ATTRIBUTE3	DATE		Standard flexfield attribute
D_ATTRIBUTE4	DATE		Standard flexfield attribute
D_ATTRIBUTE5	DATE		Standard flexfield attribute
D_ATTRIBUTE6	DATE		Standard flexfield attribute
D_ATTRIBUTE7	DATE		Standard flexfield attribute
D_ATTRIBUTE8	DATE		Standard flexfield attribute
D_ATTRIBUTE9	DATE		Standard flexfield attribute
D_ATTRIBUTE10	DATE		Standard flexfield attribute
N_ATTRIBUTE1	NUMBER		Standard flexfield attribute
N_ATTRIBUTE2	NUMBER		Standard flexfield attribute
N_ATTRIBUTE3	NUMBER		Standard flexfield attribute
N_ATTRIBUTE4	NUMBER		Standard flexfield attribute
N_ATTRIBUTE5	NUMBER		Standard flexfield attribute
N_ATTRIBUTE6	NUMBER		Standard flexfield attribute
N_ATTRIBUTE7	NUMBER		Standard flexfield attribute
N_ATTRIBUTE8	NUMBER		Standard flexfield attribute
N_ATTRIBUTE9	NUMBER		Standard flexfield attribute
N_ATTRIBUTE10	NUMBER		Standard flexfield attribute
TERRITORY_CODE	VARCHAR2	(30)	territory code
TIME_SINCE_NEW	NUMBER		Time Since New
CYCLES_SINCE_NEW	NUMBER		cycles since new
TIME_SINCE_OVERHAUL	NUMBER		time since overhaul
CYCLES_SINCE_OVERHAUL	NUMBER		cycles since overhaul
TIME_SINCE_REPAIR	NUMBER		time since repair
CYCLES_SINCE_REPAIR	NUMBER		cycles since repair
TIME_SINCE_VISIT	NUMBER		time since visit
CYCLES_SINCE_VISIT	NUMBER		cycles since visit
TIME_SINCE_MARK	NUMBER		time since mark
CYCLES_SINCE_MARK	NUMBER		cycles 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
,      LOT_NUMBER
,      VENDOR_SERIAL_NUMBER
,      VENDOR_LOT_NUMBER
,      FM_SERIAL_NUMBER
,      TO_SERIAL_NUMBER
,      SERIAL_PREFIX
,      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
,      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 APPS.MTL_SERIAL_NUMBERS_TEMP_ERV;

Dependencies

[top of page]

APPS.MTL_SERIAL_NUMBERS_TEMP_ERV references the following:

APPS: MTL_MATERIAL_TRANSACTIONS_TEMP; MTL_SERIAL_NUMBERS; MTL_SERIAL_NUMBERS_TEMP; MTL_TRANSACTION_LOTS_TEMP

APPS.MTL_SERIAL_NUMBERS_TEMP_ERV is not referenced by any database object