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

TABLE: APPS.MTL_MTLT_BACKUP

Object Details
Object Name: MTL_MTLT_BACKUP
Object Type: TABLE
Owner: APPS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_TEMP_ID NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

TRANSACTION_QUANTITY NUMBER
Yes
PRIMARY_QUANTITY NUMBER
Yes
LOT_NUMBER VARCHAR2 (30) Yes
LOT_EXPIRATION_DATE DATE

ERROR_CODE VARCHAR2 (240)
SERIAL_TRANSACTION_TEMP_ID NUMBER

GROUP_HEADER_ID NUMBER

PUT_AWAY_RULE_ID NUMBER

PICK_RULE_ID NUMBER

DESCRIPTION VARCHAR2 (256)
VENDOR_NAME VARCHAR2 (240)
SUPPLIER_LOT_NUMBER VARCHAR2 (150)
COUNTRY_OF_ORIGIN VARCHAR2 (150)
ORIGINATION_DATE DATE

DATE_CODE VARCHAR2 (150)
GRADE_CODE VARCHAR2 (150)
CHANGE_DATE DATE

MATURITY_DATE DATE

STATUS_ID NUMBER

RETEST_DATE DATE

AGE NUMBER

ITEM_SIZE NUMBER

COLOR VARCHAR2 (150)
VOLUME NUMBER

VOLUME_UOM VARCHAR2 (3)
PLACE_OF_ORIGIN VARCHAR2 (150)
KILL_DATE DATE

BEST_BY_DATE DATE

LENGTH NUMBER

LENGTH_UOM VARCHAR2 (3)
RECYCLED_CONTENT NUMBER

THICKNESS NUMBER

THICKNESS_UOM VARCHAR2 (3)
WIDTH NUMBER

WIDTH_UOM VARCHAR2 (3)
CURL_WRINKLE_FOLD VARCHAR2 (150)
LOT_ATTRIBUTE_CATEGORY VARCHAR2 (30)
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)
C_ATTRIBUTE21 VARCHAR2 (150)
C_ATTRIBUTE22 VARCHAR2 (150)
C_ATTRIBUTE23 VARCHAR2 (150)
C_ATTRIBUTE24 VARCHAR2 (150)
C_ATTRIBUTE25 VARCHAR2 (150)
C_ATTRIBUTE26 VARCHAR2 (150)
C_ATTRIBUTE27 VARCHAR2 (150)
C_ATTRIBUTE28 VARCHAR2 (150)
C_ATTRIBUTE29 VARCHAR2 (150)
C_ATTRIBUTE30 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

D_ATTRIBUTE11 DATE

D_ATTRIBUTE12 DATE

D_ATTRIBUTE13 DATE

D_ATTRIBUTE14 DATE

D_ATTRIBUTE15 DATE

D_ATTRIBUTE16 DATE

D_ATTRIBUTE17 DATE

D_ATTRIBUTE18 DATE

D_ATTRIBUTE19 DATE

D_ATTRIBUTE20 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

N_ATTRIBUTE11 NUMBER

N_ATTRIBUTE12 NUMBER

N_ATTRIBUTE13 NUMBER

N_ATTRIBUTE14 NUMBER

N_ATTRIBUTE15 NUMBER

N_ATTRIBUTE16 NUMBER

N_ATTRIBUTE17 NUMBER

N_ATTRIBUTE18 NUMBER

N_ATTRIBUTE19 NUMBER

N_ATTRIBUTE20 NUMBER

N_ATTRIBUTE21 NUMBER

N_ATTRIBUTE22 NUMBER

N_ATTRIBUTE23 NUMBER

N_ATTRIBUTE24 NUMBER

N_ATTRIBUTE25 NUMBER

N_ATTRIBUTE26 NUMBER

N_ATTRIBUTE27 NUMBER

N_ATTRIBUTE28 NUMBER

N_ATTRIBUTE29 NUMBER

N_ATTRIBUTE30 NUMBER

VENDOR_ID NUMBER

TERRITORY_CODE VARCHAR2 (30)
SUBLOT_NUM VARCHAR2 (30)
SECONDARY_QUANTITY NUMBER

SECONDARY_UNIT_OF_MEASURE VARCHAR2 (25)
QC_GRADE VARCHAR2 (25)
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
,      TRANSACTION_QUANTITY
,      PRIMARY_QUANTITY
,      LOT_NUMBER
,      LOT_EXPIRATION_DATE
,      ERROR_CODE
,      SERIAL_TRANSACTION_TEMP_ID
,      GROUP_HEADER_ID
,      PUT_AWAY_RULE_ID
,      PICK_RULE_ID
,      DESCRIPTION
,      VENDOR_NAME
,      SUPPLIER_LOT_NUMBER
,      COUNTRY_OF_ORIGIN
,      ORIGINATION_DATE
,      DATE_CODE
,      GRADE_CODE
,      CHANGE_DATE
,      MATURITY_DATE
,      STATUS_ID
,      RETEST_DATE
,      AGE
,      ITEM_SIZE
,      COLOR
,      VOLUME
,      VOLUME_UOM
,      PLACE_OF_ORIGIN
,      KILL_DATE
,      BEST_BY_DATE
,      LENGTH
,      LENGTH_UOM
,      RECYCLED_CONTENT
,      THICKNESS
,      THICKNESS_UOM
,      WIDTH
,      WIDTH_UOM
,      CURL_WRINKLE_FOLD
,      LOT_ATTRIBUTE_CATEGORY
,      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
,      C_ATTRIBUTE21
,      C_ATTRIBUTE22
,      C_ATTRIBUTE23
,      C_ATTRIBUTE24
,      C_ATTRIBUTE25
,      C_ATTRIBUTE26
,      C_ATTRIBUTE27
,      C_ATTRIBUTE28
,      C_ATTRIBUTE29
,      C_ATTRIBUTE30
,      D_ATTRIBUTE1
,      D_ATTRIBUTE2
,      D_ATTRIBUTE3
,      D_ATTRIBUTE4
,      D_ATTRIBUTE5
,      D_ATTRIBUTE6
,      D_ATTRIBUTE7
,      D_ATTRIBUTE8
,      D_ATTRIBUTE9
,      D_ATTRIBUTE10
,      D_ATTRIBUTE11
,      D_ATTRIBUTE12
,      D_ATTRIBUTE13
,      D_ATTRIBUTE14
,      D_ATTRIBUTE15
,      D_ATTRIBUTE16
,      D_ATTRIBUTE17
,      D_ATTRIBUTE18
,      D_ATTRIBUTE19
,      D_ATTRIBUTE20
,      N_ATTRIBUTE1
,      N_ATTRIBUTE2
,      N_ATTRIBUTE3
,      N_ATTRIBUTE4
,      N_ATTRIBUTE5
,      N_ATTRIBUTE6
,      N_ATTRIBUTE7
,      N_ATTRIBUTE8
,      N_ATTRIBUTE9
,      N_ATTRIBUTE10
,      N_ATTRIBUTE11
,      N_ATTRIBUTE12
,      N_ATTRIBUTE13
,      N_ATTRIBUTE14
,      N_ATTRIBUTE15
,      N_ATTRIBUTE16
,      N_ATTRIBUTE17
,      N_ATTRIBUTE18
,      N_ATTRIBUTE19
,      N_ATTRIBUTE20
,      N_ATTRIBUTE21
,      N_ATTRIBUTE22
,      N_ATTRIBUTE23
,      N_ATTRIBUTE24
,      N_ATTRIBUTE25
,      N_ATTRIBUTE26
,      N_ATTRIBUTE27
,      N_ATTRIBUTE28
,      N_ATTRIBUTE29
,      N_ATTRIBUTE30
,      VENDOR_ID
,      TERRITORY_CODE
,      SUBLOT_NUM
,      SECONDARY_QUANTITY
,      SECONDARY_UNIT_OF_MEASURE
,      QC_GRADE
FROM APPS.MTL_MTLT_BACKUP;

Dependencies

[top of page]

APPS.MTL_MTLT_BACKUP does not reference any database object

APPS.MTL_MTLT_BACKUP is not referenced by any database object