[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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. |
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;
AMS.AMS_IMP_LIST_HEADERS_ALL does not reference any database object
AMS.AMS_IMP_LIST_HEADERS_ALL is referenced by following:
|
|
|