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

TABLE: WIP.WIP_LPN_COMPLETIONS_SERIALS

Object Details
Object Name: WIP_LPN_COMPLETIONS_SERIALS
Object Type: TABLE
Owner: WIP
FND Design Data: TableWIP.WIP_LPN_COMPLETIONS_SERIALS
Subobject Name:
Status: VALID


This table contains serial information for materials being processed in WIP Lpn completions (Mobile Apps)


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WIP_LPN_COMPLETIONS_SERIALS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnHEADER_ID
Columns
Name Datatype Length Mandatory Comments
HEADER_ID NUMBER
Yes Used to join to parent record in WIP_LPN_COMPLETIONS.
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

Enhanced who column
PROGRAM_APPLICATION_ID NUMBER

Enhanced who column
PROGRAM_ID NUMBER

Enhanced who column
PROGRAM_UPDATE_DATE DATE

Enhanced who column
FM_SERIAL_NUMBER VARCHAR2 (30) Yes From serial number
TO_SERIAL_NUMBER VARCHAR2 (30) Yes To serial number
SERIAL_PREFIX VARCHAR2 (30)
Serial prefix
PARENT_SERIAL_NUMBER VARCHAR2 (30)
Parent serial number
ERROR_CODE VARCHAR2 (240)
Serial number transaction error code
LOT_NUMBER VARCHAR2 (80)
Populated if item is lot/serial controlled.
TRANSACTION_QUANTITY NUMBER

Transaction quantity
SERIAL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Serial attribute category
STATUS_ID NUMBER

Status identifier
STATUS_CODE VARCHAR2 (80)
Status code
ORIGINATION_DATE DATE

Origination date
C_ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield column
C_ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield column
C_ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield column
C_ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield column
C_ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield column
C_ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield column
C_ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield column
C_ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield column
C_ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield column
C_ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield column
C_ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield column
C_ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield column
C_ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield column
C_ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield column
C_ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield column
C_ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield column
C_ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield column
C_ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield column
C_ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield column
C_ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield column
D_ATTRIBUTE1 DATE

Descriptive flexfield column
D_ATTRIBUTE2 DATE

Descriptive flexfield column
D_ATTRIBUTE3 DATE

Descriptive flexfield column
D_ATTRIBUTE4 DATE

Descriptive flexfield column
D_ATTRIBUTE5 DATE

Descriptive flexfield column
D_ATTRIBUTE6 DATE

Descriptive flexfield column
D_ATTRIBUTE7 DATE

Descriptive flexfield column
D_ATTRIBUTE8 DATE

Descriptive flexfield column
D_ATTRIBUTE9 DATE

Descriptive flexfield column
D_ATTRIBUTE10 DATE

Descriptive flexfield column
N_ATTRIBUTE1 NUMBER

Descriptive flexfield column
N_ATTRIBUTE2 NUMBER

Descriptive flexfield column
N_ATTRIBUTE3 NUMBER

Descriptive flexfield column
N_ATTRIBUTE4 NUMBER

Descriptive flexfield column
N_ATTRIBUTE5 NUMBER

Descriptive flexfield column
N_ATTRIBUTE6 NUMBER

Descriptive flexfield column
N_ATTRIBUTE7 NUMBER

Descriptive flexfield column
N_ATTRIBUTE8 NUMBER

Descriptive flexfield column
N_ATTRIBUTE9 NUMBER

Descriptive flexfield column
N_ATTRIBUTE10 NUMBER

Descriptive flexfield column
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

Cycled 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 HEADER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      FM_SERIAL_NUMBER
,      TO_SERIAL_NUMBER
,      SERIAL_PREFIX
,      PARENT_SERIAL_NUMBER
,      ERROR_CODE
,      LOT_NUMBER
,      TRANSACTION_QUANTITY
,      SERIAL_ATTRIBUTE_CATEGORY
,      STATUS_ID
,      STATUS_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
,      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 WIP.WIP_LPN_COMPLETIONS_SERIALS;

Dependencies

[top of page]

WIP.WIP_LPN_COMPLETIONS_SERIALS does not reference any database object

WIP.WIP_LPN_COMPLETIONS_SERIALS is referenced by following:

SchemaWIP
ViewWIP_LPN_COMPLETIONS_SERIALS#