VIEW: APPS.AMS_IMP_LIST_HEADERS_ALL_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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