VIEW: APPS.AMS_IMP_LIST_HEADERS_VL

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')