[Home] [Help]
| Product: | BIM - Marketing Intelligence |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT AEH.EVENT_HEADER_ID || '-' || INST.INSTANCE_CODE || '-EVENT' EVENT_PK
, 'ALL' ALL_FK
, AEH.EVENT_HEADER_NAME EVENT_DP
, AEH.EVENT_HEADER_NAME NAME
, AEH.EVENT_HEADER_ID EVENT_HEADER_ID
, AEH.PARENT_EVENT_HEADER_ID PARENT_EVENT_HEADER_ID
, AEH.EVENT_LEVEL EVENT_LEVEL
, AEH.EVENT_TYPE_CODE EVENT_TYPE_CODE
, AEH.USER_STATUS_ID USER_STATUS_ID
, AEH.SYSTEM_STATUS_CODE SYSTEM_STATUS_CODE
, AEH.LAST_STATUS_DATE LAST_STATUS_DATE
, AEH.REG_REQUIRED_FLAG REG_REQUIRED_FLAG
, AEH.REG_INVITED_ONLY_FLAG REG_INVITED_ONLY_FLAG
, AEH.REG_CHARGE_FLAG REG_CHARGE_FLAG
, AEH.EVENT_STANDALONE_FLAG EVENT_STANDALONE_FLAG
, AEH.REG_MINIMUM_CAPACITY REG_MINIMUM_CAPACITY
, AEH.REG_MAXIMUM_CAPACITY REG_MAXIMUM_CAPACITY
, AEH.SOURCE_CODE SOURCE_CODE
, AEH.DURATION DURATION
, AEH.DURATION_UOM_CODE DURATION_UOM_CODE
, AEH.DAY_OF_EVENT DAY_OF_EVENT
, AEH.COORDINATOR_ID COORDINATOR_ID
, AEH.OWNER_USER_ID OWNER_USER_ID
, AEH.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, AEH.ORG_ID ORG_ID
, AEH.CERT_CREDIT_TYPE_CODE CERT_CREDIT_TYPE_CODE
, AEH.CERTIFICATION_CREDITS CERTIFICATION_CREDITS
, AEH.STREAM_TYPE_CODE STREAM_TYPE_CODE
, AEH.PARTNER_FLAG PARTNER_FLAG
, AEH.OVERFLOW_FLAG OVERFLOW_FLAG
, AEH.MAIN_LANGUAGE_CODE MAIN_LANGUAGE_CODE
, AEH.CANCELLATION_REASON_CODE CANCELLATION_REASON_CODE
, AEH.PRIORITY_TYPE_CODE PRIORITY_TYPE_CODE
, AEH.AGENDA_START_TIME AGENDA_START_TIME
, AEH.AGENDA_END_TIME AGENDA_END_TIME
, AEH.ACTIVE_FROM_DATE ACTIVE_FROM_DATE
, AEH.ACTIVE_TO_DATE ACTIVE_TO_DATE
, AEH.INBOUND_SCRIPT_NAME INBOUND_SCRIPT_NAME
, AEH.EMAIL EMAIL
, AEH.PHONE PHONE
, AEH.URL URL
, AEH.EVENT_MKTG_MESSAGE EVENT_MKTG_MESSAGE
, AEH.EVENT_HEADER_NAME EVENT_HEADER_NAME
, AEH.DESCRIPTION DESCRIPTION
, INST.INSTANCE_CODE INSTANCE
, AEH.CREATION_DATE CREATION_DATE
, AEH.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM AMS_EVENT_HEADERS_VL AEH
, EDW_LOCAL_INSTANCE INST
WHERE AEH.EVENT_LEVEL = 'MAIN'