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

TABLE: INV.MTL_LOT_CONV_AUDIT

Object Details
Object Name: MTL_LOT_CONV_AUDIT
Object Type: TABLE
Owner: INV
FND Design Data: TableINV.MTL_LOT_CONV_AUDIT
Subobject Name:
Status: VALID


This table stores Audit Trail for conversion changes


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MTL_LOT_CONV_AUDIT_PK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnCONV_AUDIT_ID
MTL_LOT_CONV_AUDIT_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnCONVERSION_ID
Columns
Name Datatype Length Mandatory Comments
CONV_AUDIT_ID NUMBER
Yes audit surrogate key
CONVERSION_ID NUMBER
Yes conversion surrogate key
CONVERSION_DATE DATE
Yes Conversion Date
UPDATE_TYPE_INDICATOR NUMBER
Yes Update Type Indicator
BATCH_ID NUMBER

batch surrogate key
REASON_ID NUMBER

reason code surrogate key
OLD_CONVERSION_RATE NUMBER

prior conversion rate
NEW_CONVERSION_RATE NUMBER
Yes new conversion rate
EVENT_SPEC_DISP_ID NUMBER

surrogate key to quality event
CREATED_BY NUMBER
Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER
Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
Query Text

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


SELECT CONV_AUDIT_ID
,      CONVERSION_ID
,      CONVERSION_DATE
,      UPDATE_TYPE_INDICATOR
,      BATCH_ID
,      REASON_ID
,      OLD_CONVERSION_RATE
,      NEW_CONVERSION_RATE
,      EVENT_SPEC_DISP_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM INV.MTL_LOT_CONV_AUDIT;

Dependencies

[top of page]

INV.MTL_LOT_CONV_AUDIT does not reference any database object

INV.MTL_LOT_CONV_AUDIT is referenced by following:

SchemaAPPS
SynonymMTL_LOT_CONV_AUDIT