Product: | AMS - Marketing |
---|---|
Description: | Stores the export header information. |
Implementation/DBA Data: | Not implemented in this database |
SELECT ILH.EXPORT_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.EXPORT_TYPE
, ILH.OWNER_USER_ID
, ILH.STATUS_CODE
, ILH.STATUS_DATE
, ILH.USER_STATUS_ID
, ILH.SECURITY_GROUP_ID
, ILH.EXPORT_DATA
, ILH.EXP_TEMPLATE_ID
, ILH.REQUEST_ID
, ILH.FINAL_SQL_STRING
, ILH.PARENT_EXP_HEADER_ID
, ILH.RECURRING_EXP_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
FROM AMS_EXP_LIST_HEADERS_ALL ILH
, AMS_EXP_LIST_HEADERS_ALL_TL ILT
WHERE ILH.EXPORT_LIST_HEADER_ID = ILT.EXPORT_LIST_HEADER_ID
AND ILT.LANGUAGE = USERENV('LANG')