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

TYPE: SYSTEM.WIP_SERIAL_ATTRIBUTES_OBJ_T

Object Details
Object Name: WIP_SERIAL_ATTRIBUTES_OBJ_T
Object Type: TYPE
Owner: SYSTEM
Subobject Name:
Status: VALID
Type Details
Type Code: OBJECT
Predefined: NO
Incomplete: NO
Attributes
Name Datatype Length Prcn
SERIAL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
ORIGINATION_DATE DATE

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

D_ATTRIBUTE2 DATE

D_ATTRIBUTE3 DATE

D_ATTRIBUTE4 DATE

D_ATTRIBUTE5 DATE

D_ATTRIBUTE6 DATE

D_ATTRIBUTE7 DATE

D_ATTRIBUTE8 DATE

D_ATTRIBUTE9 DATE

D_ATTRIBUTE10 DATE

N_ATTRIBUTE1 NUMBER

N_ATTRIBUTE2 NUMBER

N_ATTRIBUTE3 NUMBER

N_ATTRIBUTE4 NUMBER

N_ATTRIBUTE5 NUMBER

N_ATTRIBUTE6 NUMBER

N_ATTRIBUTE7 NUMBER

N_ATTRIBUTE8 NUMBER

N_ATTRIBUTE9 NUMBER

N_ATTRIBUTE10 NUMBER

STATUS_ID NUMBER
30
TERRITORY_CODE VARCHAR2 (30)
TIME_SINCE_NEW NUMBER

CYCLES_SINCE_NEW NUMBER

TIME_SINCE_OVERHAUL NUMBER

CYCLES_SINCE_OVERHAUL NUMBER

TIME_SINCE_REPAIR NUMBER

CYCLES_SINCE_REPAIR NUMBER

TIME_SINCE_VISIT NUMBER

CYCLES_SINCE_VISIT NUMBER

TIME_SINCE_MARK NUMBER

CYCLES_SINCE_MARK NUMBER

NUMBER_OF_REPAIRS NUMBER

Dependencies

[top of page]

SYSTEM.WIP_SERIAL_ATTRIBUTES_OBJ_T references the following:

SchemaSYS
PL/SQL PackageSTANDARD - show dependent code
SYSTEM.WIP_SERIAL_ATTRIBUTES_OBJ_T is referenced by following:

SchemaSYSTEM
TYPE BODYWIP_LOT_SERIAL_OBJ_T
TYPEWIP_LOT_SERIAL_OBJ_T
TYPEWIP_TXN_SERIAL_OBJ_T