Product: | AMS - Marketing |
---|---|
Description: | This view returns the import list header information. |
Implementation/DBA Data: | APPS.AMS_IMP_LIST_HEADERS_ALL_V |
SELECT I.IMPORT_LIST_HEADER_ID
, I.LAST_UPDATE_DATE
, I.LAST_UPDATED_BY
, I.CREATION_DATE
, I.CREATED_BY
, I.LAST_UPDATE_LOGIN
, I.OBJECT_VERSION_NUMBER
, I.VIEW_APPLICATION_ID
, I.NAME
, I.VERSION
, I.IMPORT_TYPE
, I.OWNER_USER_ID
, U.FULL_NAME OWNER
, I.LIST_SOURCE_TYPE_ID
, I.USER_STATUS_ID
, I.STATUS_CODE
, I.STATUS_DATE
, I.SOURCE_SYSTEM
, I.VENDOR_ID
, I.PIN_ID
, I.ORG_ID
, I.SCHEDULED_TIME
, I.LOADED_NO_OF_ROWS
, I.LOADED_DATE
, I.ROWS_TO_SKIP
, I.PROCESSED_ROWS
, I.HEADINGS_FLAG
, I.DEDUPE_FLAG
, I.PROCESS_IMMED_FLAG
, I.EXPIRY_DATE
, I.PURGE_DATE
, I.DESCRIPTION
, I.KEYWORDS
, I.TRANSACTIONAL_COST
, I.TRANSACTIONAL_CURRENCY_CODE
, I.FUNCTIONAL_COST
, I.FUNCTIONAL_CURRENCY_CODE
, I.DATA_FILENAME
, I.TERMINATED_BY
, I.ENCLOSED_BY
, I.ATTRIBUTE_CATEGORY
, I.ATTRIBUTE1
, I.ATTRIBUTE2
, I.ATTRIBUTE3
, I.ATTRIBUTE4
, I.ATTRIBUTE5
, I.ATTRIBUTE6
, I.ATTRIBUTE7
, I.ATTRIBUTE8
, I.ATTRIBUTE9
, I.ATTRIBUTE10
, I.ATTRIBUTE11
, I.ATTRIBUTE12
, I.ATTRIBUTE13
, I.ATTRIBUTE14
, I.ATTRIBUTE15
FROM AMS_IMP_LIST_HEADERS_ALL I
, AMS_JTF_RS_EMP_V U
WHERE I.OWNER_USER_ID = U.RESOURCE_ID