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.

[Home] [Help]

View: AMS_IMP_LIST_HEADERS_VL

Product:	AMS - Marketing
Description:	This view stores all the translatable details of list import header (like name,description).
Implementation/DBA Data:	APPS.AMS_IMP_LIST_HEADERS_VL

View Text

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

Columns

Name
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
CUSTOM_SETUP_ID
COUNTRY
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
USAGE
RENTED_LIST_FLAG
SERVER_FLAG
LOG_FILE_NAME
NUMBER_OF_FAILED_RECORDS
NUMBER_OF_DUPLICATE_RECORDS
B2B_FLAG
NUMBER_OF_RECORDS
ENABLE_WORD_REPLACEMENT_FLAG
DATA_FILE_NAME
BATCH_ID
EXECUTE_MODE
VALIDATE_FILE
RECORD_UPDATE_FLAG
ERROR_THRESHOLD
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
CHARSET