eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: AMS.AMS_IMP_LIST_HEADERS_ALL

Object Details

Object Name:	AMS_IMP_LIST_HEADERS_ALL
Object Type:	TABLE
Owner:	AMS
FND Design Data:	AMS.AMS_IMP_LIST_HEADERS_ALL
Subobject Name:
Status:	VALID

AMS_IMP_LIST_HEADERS_ALL stores the definition of every list that is imported. The information captured include vendor, loaded rows, loaded date, details about the data file, etc.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMS_IMP_LIST_HEADERS_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	IMPORT_LIST_HEADER_ID
AMS_IMP_LIST_HEADERS_ALL_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	NAME VERSION VIEW_APPLICATION_ID
AMS_IMP_LIST_HEADERS_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORG_ID
AMS_IMP_LIST_HEADERS_ALL_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STATUS_CODE RENTED_LIST_FLAG
AMS_IMP_LIST_HEADERS_ALL_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OWNER_USER_ID
AMS_IMP_LIST_HEADERS_ALL_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LIST_SOURCE_TYPE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
IMPORT_LIST_HEADER_ID	NUMBER		Yes	Unique Identifier.
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column
OBJECT_VERSION_NUMBER	NUMBER	(9)		This column is used for locking purposes.
VIEW_APPLICATION_ID	NUMBER		Yes	The ID of the application from which the record is viewable.
NAME	VARCHAR2	(120)		Name of the import.
VERSION	VARCHAR2	(10)	Yes	Version of the import.
IMPORT_TYPE	VARCHAR2	(30)	Yes	Used to indicate the type of imported data.
OWNER_USER_ID	NUMBER	(15)	Yes	The user ID of the owner of the import.
LIST_SOURCE_TYPE_ID	NUMBER			Reference to the import list column mapping.
STATUS_CODE	VARCHAR2	(30)	Yes	The de-normalized status of the import.
STATUS_DATE	DATE		Yes	The date the last status change occurred.
USER_STATUS_ID	NUMBER		Yes	The internal ID of the status of the import.
SOURCE_SYSTEM	VARCHAR2	(4000)		The source from which the import data originated.
VENDOR_ID	NUMBER			The source vendor for the import data.
PIN_ID	NUMBER	(15)		Not implemented.
ORG_ID	NUMBER	(32)		Operating Unit Identifier
SCHEDULED_TIME	DATE			Date and time to schedule data imports.
LOADED_NO_OF_ROWS	NUMBER	(15)		The number of rows imported into the interface table.
LOADED_DATE	DATE			The date on which the import load completes successfully.
ROWS_TO_SKIP	NUMBER	(15)		Number of rows in the data file to skip during the import.
PROCESSED_ROWS	NUMBER	(15)		Number of rows which were processed by the post-import processing procedure.
HEADINGS_FLAG	VARCHAR2	(1)		Flag which indicates whether the data file contains a field heading.
EXPIRY_DATE	DATE			The date on which the imported date expires from the system.
PURGE_DATE	DATE			The date on which the imported data was purged from the application.
DESCRIPTION	VARCHAR2	(4000)		The description of the import.
KEYWORDS	VARCHAR2	(4000)		Keywords on which the import information can be searched.
TRANSACTIONAL_COST	NUMBER	(15)		Value used to hold the internal monetary amount based on an internal currency code.
TRANSACTIONAL_CURRENCY_CODE	VARCHAR2	(15)		Code used to indicate the internally used currency code.
FUNCTIONAL_COST	NUMBER	(15)		Published cost having the values determined by the user-defined currency code.
FUNCTIONAL_CURRENCY_CODE	VARCHAR2	(15)		User-defined currency code.
TERMINATED_BY	VARCHAR2	(30)		Character used as the field delimiter.
ENCLOSED_BY	VARCHAR2	(30)		Character optionally used in conjunction with the delimiter to separate the fields, particularly for those data items which contain the delimiter character.
DATA_FILENAME	VARCHAR2	(1000)		Column to save the name and path of the file which was last used to import the external data and size should be 500.
PROCESS_IMMED_FLAG	VARCHAR2	(1)		Not used.
DEDUPE_FLAG	VARCHAR2	(1)		Column to indicate whether dedupe needs to be done on the imported data.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfiled structure defining column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment.
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
CUSTOM_SETUP_ID	NUMBER			Custom setup Identifier.
COUNTRY	NUMBER			Country
USAGE	NUMBER			Not used
NUMBER_OF_RECORDS	VARCHAR2	(240)		Number of records
DATA_FILE_NAME	VARCHAR2	(1000)		Name of the client side data file.
B2B_FLAG	VARCHAR2	(1)		B2B or B2C data type flag.
RENTED_LIST_FLAG	VARCHAR2	(1)		Rented, purchased list flag
SERVER_FLAG	VARCHAR2	(1)		Client side or server side import flag
LOG_FILE_NAME	VARCHAR2	(60)		Log file name
NUMBER_OF_FAILED_RECORDS	NUMBER			Number of failed records in list import process.
NUMBER_OF_DUPLICATE_RECORDS	NUMBER			Number of duplicate records in list import process.
ENABLE_WORD_REPLACEMENT_FLAG	VARCHAR2	(1)		Word replacement flag used while checking deplicate records.
BATCH_ID	NUMBER			Batch id of the import process.
EXECUTE_MODE	VARCHAR2	(1)		Flag to store the execution mode of import.
VALIDATE_FILE	VARCHAR2	(1)		Flag for data validation.
RECORD_UPDATE_FLAG	VARCHAR2	(1)		Flag used to update the record.
SERVER_NAME	VARCHAR2	(256)		Server name for data file upload.
USER_NAME	VARCHAR2	(256)		Username for FTP import.
PASSWORD	VARCHAR2	(256)		Password for FTP import.
UPLOAD_FLAG	VARCHAR2	(1)		Upload flag for import.
PARENT_IMP_HEADER_ID	NUMBER			Parent ID for recurring import.
RECURRING_IMP_NAME	VARCHAR2	(120)		Recurring import name.
CANCEL_FLAG	VARCHAR2	(1)		Cancel flag for recurring import.
CANCEL_DATE	DATE			Cancel date for recurring import.
REPEAT_TIME	VARCHAR2	(60)		Repeat time for recurring import.
REPEAT_INTERVAL	NUMBER			Repeat interval for recurring import.
REPEAT_UNIT	VARCHAR2	(30)		Repeat unit for recurring import.
REPEAT_END_TIME	VARCHAR2	(60)		Recurring import stop date.
REPEAT_START_TIME	VARCHAR2	(60)		Repeat import start date.
REPEAT_MODE	VARCHAR2	(60)		Repeat mode of recurring import.
ERROR_THRESHOLD	NUMBER			Error threshold for import process.
CHARSET	VARCHAR2	(30)		This column stores the character set.
NUMBER_OF_INSTANCES	NUMBER			To store the number of instances.
BATCH_SIZE	NUMBER			Size of the batch to be processed.
GENERATE_LIST	VARCHAR2	(1)		Store if the list needs to be generated.
GENERATED_LIST_NAME	VARCHAR2	(240)		Stores the generated list name.
PARENT_REQUEST_ID	NUMBER			Stores the parent request id.

Query Text

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


SELECT IMPORT_LIST_HEADER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      VIEW_APPLICATION_ID
,      NAME
,      VERSION
,      IMPORT_TYPE
,      OWNER_USER_ID
,      LIST_SOURCE_TYPE_ID
,      STATUS_CODE
,      STATUS_DATE
,      USER_STATUS_ID
,      SOURCE_SYSTEM
,      VENDOR_ID
,      PIN_ID
,      ORG_ID
,      SCHEDULED_TIME
,      LOADED_NO_OF_ROWS
,      LOADED_DATE
,      ROWS_TO_SKIP
,      PROCESSED_ROWS
,      HEADINGS_FLAG
,      EXPIRY_DATE
,      PURGE_DATE
,      DESCRIPTION
,      KEYWORDS
,      TRANSACTIONAL_COST
,      TRANSACTIONAL_CURRENCY_CODE
,      FUNCTIONAL_COST
,      FUNCTIONAL_CURRENCY_CODE
,      TERMINATED_BY
,      ENCLOSED_BY
,      DATA_FILENAME
,      PROCESS_IMMED_FLAG
,      DEDUPE_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SECURITY_GROUP_ID
,      CUSTOM_SETUP_ID
,      COUNTRY
,      USAGE
,      NUMBER_OF_RECORDS
,      DATA_FILE_NAME
,      B2B_FLAG
,      RENTED_LIST_FLAG
,      SERVER_FLAG
,      LOG_FILE_NAME
,      NUMBER_OF_FAILED_RECORDS
,      NUMBER_OF_DUPLICATE_RECORDS
,      ENABLE_WORD_REPLACEMENT_FLAG
,      BATCH_ID
,      EXECUTE_MODE
,      VALIDATE_FILE
,      RECORD_UPDATE_FLAG
,      SERVER_NAME
,      USER_NAME
,      PASSWORD
,      UPLOAD_FLAG
,      PARENT_IMP_HEADER_ID
,      RECURRING_IMP_NAME
,      CANCEL_FLAG
,      CANCEL_DATE
,      REPEAT_TIME
,      REPEAT_INTERVAL
,      REPEAT_UNIT
,      REPEAT_END_TIME
,      REPEAT_START_TIME
,      REPEAT_MODE
,      ERROR_THRESHOLD
,      CHARSET
,      NUMBER_OF_INSTANCES
,      BATCH_SIZE
,      GENERATE_LIST
,      GENERATED_LIST_NAME
,      PARENT_REQUEST_ID
FROM AMS.AMS_IMP_LIST_HEADERS_ALL;

Dependencies

[top of page]

AMS.AMS_IMP_LIST_HEADERS_ALL does not reference any database object

AMS.AMS_IMP_LIST_HEADERS_ALL is referenced by following:

AMS: AMS_IMP_LIST_HEADERS_ALL#