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

TABLE: AMS.AMS_IMP_LIST_IMPORT_TYPES

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


This table stores the import types used for list import like Organization, person or address, Event and Lead.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
IMPORT_TYPE_ID NUMBER
Yes Unique identifier.
IMPORT_TYPE VARCHAR2 (30) Yes List import type.
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
VIEW_NAME VARCHAR2 (50)
View used in list import. It is based on import type.
B2B_FLAG VARCHAR2 (1)
B2B or B2C data type flag.
CONCURRENT_PROGRAM VARCHAR2 (50)
Name of the concurrent program used in li list import and it is based on import type.
WORKBOOK_NAME VARCHAR2 (50)
Name of the workbook.
SECURITY_GROUP_ID NUMBER

Used in hosted environment.
Query Text

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


SELECT IMPORT_TYPE_ID
,      IMPORT_TYPE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      VIEW_NAME
,      B2B_FLAG
,      CONCURRENT_PROGRAM
,      WORKBOOK_NAME
,      SECURITY_GROUP_ID
FROM AMS.AMS_IMP_LIST_IMPORT_TYPES;

Dependencies

[top of page]

AMS.AMS_IMP_LIST_IMPORT_TYPES does not reference any database object

AMS.AMS_IMP_LIST_IMPORT_TYPES is referenced by following:

SchemaAPPS
SynonymAMS_IMP_LIST_IMPORT_TYPES