VIEW: AMS.AMS_IMP_LIST_HEADERS_ALL#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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