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.WSM_JOB_SERIAL_NUMBERS_V

Object Details

Object Name:	WSM_JOB_SERIAL_NUMBERS_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Comments
SERIAL_NUMBER	VARCHAR2	(30)	Serial Number
WIP_SERIAL_STATUS	NUMBER		Serial number status
WIP_SERIAL_STATUS_CODE	VARCHAR2	(80)	Serial number status code
CURRENT_STATUS	NUMBER		Serial number current status
MSN_ROWID	ROWID	(10)	Rowid from MTL_SERIAL_NUMBERS
WIP_ENTITY_ID	NUMBER		Job Identifier
ORGANIZATION_ID	NUMBER		Organization Id
PRIMARY_ITEM_ID	NUMBER		Inventory intem identifier
DEPARTMENT_CODE	VARCHAR2	(10)	Department code
OPERATION_SEQ_NUM	NUMBER		Operation sequence number
INTRAOPERATION_STEP_TYPE	NUMBER		Intraoperation step
INTRAOPERATION_STEP_CODE	VARCHAR2	(80)	Intraoperation step code
STANDARD_OPERATION_CODE	VARCHAR2	(4)	Standard operation code
GROUP_MARK_ID	NUMBER		Group mark identifier
LINE_MARK_ID	NUMBER		Line mark ID
SERIAL_ATTRIBUTE_CATEGORY	VARCHAR2	(30)	Serial Attributes column
TERRITORY_CODE	VARCHAR2	(30)	Serial Attributes column
ORIGINATION_DATE	DATE		Serial Attributes column
C_ATTRIBUTE1	VARCHAR2	(150)	Serial Attributes column
C_ATTRIBUTE2	VARCHAR2	(150)	Serial Attributes column
C_ATTRIBUTE3	VARCHAR2	(150)	Serial Attributes column
C_ATTRIBUTE4	VARCHAR2	(150)	Serial Attributes column
C_ATTRIBUTE5	VARCHAR2	(150)	Serial Attributes column
C_ATTRIBUTE6	VARCHAR2	(150)	Serial Attributes column
C_ATTRIBUTE7	VARCHAR2	(150)	Serial Attributes column
C_ATTRIBUTE8	VARCHAR2	(150)	Serial Attributes column
C_ATTRIBUTE9	VARCHAR2	(150)	Serial Attributes column
C_ATTRIBUTE10	VARCHAR2	(150)	Serial Attributes column
C_ATTRIBUTE11	VARCHAR2	(150)	Serial Attributes column
C_ATTRIBUTE12	VARCHAR2	(150)	Serial Attributes column
C_ATTRIBUTE13	VARCHAR2	(150)	Serial Attributes column
C_ATTRIBUTE14	VARCHAR2	(150)	Serial Attributes column
C_ATTRIBUTE15	VARCHAR2	(150)	Serial Attributes column
C_ATTRIBUTE16	VARCHAR2	(150)	Serial Attributes column
C_ATTRIBUTE17	VARCHAR2	(150)	Serial Attributes column
C_ATTRIBUTE18	VARCHAR2	(150)	Serial Attributes column
C_ATTRIBUTE19	VARCHAR2	(150)	Serial Attributes column
C_ATTRIBUTE20	VARCHAR2	(150)	Serial Attributes column
D_ATTRIBUTE1	DATE		Serial Attributes column
D_ATTRIBUTE2	DATE		Serial Attributes column
D_ATTRIBUTE3	DATE		Serial Attributes column
D_ATTRIBUTE4	DATE		Serial Attributes column
D_ATTRIBUTE5	DATE		Serial Attributes column
D_ATTRIBUTE6	DATE		Serial Attributes column
D_ATTRIBUTE7	DATE		Serial Attributes column
D_ATTRIBUTE8	DATE		Serial Attributes column
D_ATTRIBUTE9	DATE		Serial Attributes column
D_ATTRIBUTE10	DATE		Serial Attributes column
N_ATTRIBUTE1	NUMBER		Serial Attributes column
N_ATTRIBUTE2	NUMBER		Serial Attributes column
N_ATTRIBUTE3	NUMBER		Serial Attributes column
N_ATTRIBUTE4	NUMBER		Serial Attributes column
N_ATTRIBUTE5	NUMBER		Serial Attributes column
N_ATTRIBUTE6	NUMBER		Serial Attributes column
N_ATTRIBUTE7	NUMBER		Serial Attributes column
N_ATTRIBUTE8	NUMBER		Serial Attributes column
N_ATTRIBUTE9	NUMBER		Serial Attributes column
N_ATTRIBUTE10	NUMBER		Serial Attributes column
STATUS_ID	NUMBER		Serial Attributes column
TIME_SINCE_NEW	NUMBER		Serial Attributes column
CYCLES_SINCE_NEW	NUMBER		Serial Attributes column
TIME_SINCE_OVERHAUL	NUMBER		Serial Attributes column
CYCLES_SINCE_OVERHAUL	NUMBER		Serial Attributes column
TIME_SINCE_REPAIR	NUMBER		Serial Attributes column
CYCLES_SINCE_REPAIR	NUMBER		Serial Attributes column
TIME_SINCE_VISIT	NUMBER		Serial Attributes column
CYCLES_SINCE_VISIT	NUMBER		Serial Attributes column
TIME_SINCE_MARK	NUMBER		Serial Attributes column
CYCLES_SINCE_MARK	NUMBER		Serial Attributes column
NUMBER_OF_REPAIRS	NUMBER		Serial Attributes column
ATTRIBUTE_CATEGORY	VARCHAR2	(30)	Descriptive flex column
ATTRIBUTE1	VARCHAR2	(150)	Descriptive flex column
ATTRIBUTE2	VARCHAR2	(150)	Descriptive flex column
ATTRIBUTE3	VARCHAR2	(150)	Descriptive flex column
ATTRIBUTE4	VARCHAR2	(150)	Descriptive flex column
ATTRIBUTE5	VARCHAR2	(150)	Descriptive flex column
ATTRIBUTE6	VARCHAR2	(150)	Descriptive flex column
ATTRIBUTE7	VARCHAR2	(150)	Descriptive flex column
ATTRIBUTE8	VARCHAR2	(150)	Descriptive flex column
ATTRIBUTE9	VARCHAR2	(150)	Descriptive flex column
ATTRIBUTE10	VARCHAR2	(150)	Descriptive flex column
ATTRIBUTE11	VARCHAR2	(150)	Descriptive flex column
ATTRIBUTE12	VARCHAR2	(150)	Descriptive flex column
ATTRIBUTE13	VARCHAR2	(150)	Descriptive flex column
ATTRIBUTE14	VARCHAR2	(150)	Descriptive flex column
ATTRIBUTE15	VARCHAR2	(150)	Descriptive flex column

Query Text

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


SELECT SERIAL_NUMBER
,      WIP_SERIAL_STATUS
,      WIP_SERIAL_STATUS_CODE
,      CURRENT_STATUS
,      MSN_ROWID
,      WIP_ENTITY_ID
,      ORGANIZATION_ID
,      PRIMARY_ITEM_ID
,      DEPARTMENT_CODE
,      OPERATION_SEQ_NUM
,      INTRAOPERATION_STEP_TYPE
,      INTRAOPERATION_STEP_CODE
,      STANDARD_OPERATION_CODE
,      GROUP_MARK_ID
,      LINE_MARK_ID
,      SERIAL_ATTRIBUTE_CATEGORY
,      TERRITORY_CODE
,      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
,      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
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM APPS.WSM_JOB_SERIAL_NUMBERS_V;

Dependencies

[top of page]

APPS.WSM_JOB_SERIAL_NUMBERS_V references the following:

APPS: BOM_DEPARTMENTS; BOM_STANDARD_OPERATIONS; MFG_LOOKUPS; MTL_OBJECT_GENEALOGY; MTL_SERIAL_NUMBERS; WIP_ENTITIES; WIP_OPERATIONS

APPS.WSM_JOB_SERIAL_NUMBERS_V is not referenced by any database object