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

TABLE: AMS.AMS_IMP_DEFAULT_MAPPING

Object Details
Object Name: AMS_IMP_DEFAULT_MAPPING
Object Type: TABLE
Owner: AMS
FND Design Data: TableAMS.AMS_IMP_DEFAULT_MAPPING
Subobject Name:
Status: VALID


This table stores the default mapping.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AMS_IMP_DEFAULT_MAPPING_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnDEFAULT_MAPPING_ID
AMS_IMP_DEFAULT_MAPPING_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnEXP_TEMPLATE_ID
AMS_IMP_DEFAULT_MAPPING_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnLIST_SOURCE_TYPE_ID
Columns
Name Datatype Length Mandatory Comments
DEFAULT_MAPPING_ID NUMBER

Unique Identifier.
LAST_UPDATE_DATE DATE

Standard WHO Column
LAST_UPDATED_BY NUMBER (15)
Standard WHO Column
CREATION_DATE DATE

Standard WHO Column
CREATED_BY NUMBER (15)
Standard WHO Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO Column
OBJECT_VERSION_NUMBER NUMBER (9)
This column is used for locking purposes.
IMPORT_TYPE VARCHAR2 (30)
Import type
LIST_SOURCE_TYPE_ID NUMBER
Yes FK to AMS_LIST_SOURCE_TYPES.
FILE_TYPE VARCHAR2 (30)
File Type.
EXP_TEMPLATE_ID NUMBER

FK to AMS_EXP_TEMPLATE.
EXPORT_TYPE VARCHAR2 (30)
Export type.
Query Text

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


SELECT DEFAULT_MAPPING_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      IMPORT_TYPE
,      LIST_SOURCE_TYPE_ID
,      FILE_TYPE
,      EXP_TEMPLATE_ID
,      EXPORT_TYPE
FROM AMS.AMS_IMP_DEFAULT_MAPPING;

Dependencies

[top of page]

AMS.AMS_IMP_DEFAULT_MAPPING does not reference any database object

AMS.AMS_IMP_DEFAULT_MAPPING is referenced by following:

SchemaAPPS
SynonymAMS_IMP_DEFAULT_MAPPING