[Home] [Help]
View: BIM_DIMV_EVENT_TYPES
Product: | BIM - Marketing Intelligence(Obsolete) |
Description: | Shows all event types. |
Implementation/DBA Data: |
APPS.BIM_DIMV_EVENT_TYPES
|
View Text
SELECT AML.LOOKUP_CODE EVENT_TYPE
, AML.MEANING EVENT_TYPE_NAME
, AML.DESCRIPTION EVENT_TYPE_DESCRIPTION
, AML.ENABLED_FLAG ENABLED_FLAG
, AML.START_DATE_ACTIVE START_DATE_ACTIVE
, AML.END_DATE_ACTIVE END_DATE_ACTIVE FROM AMS_LOOKUPS AML
WHERE AML.LOOKUP_TYPE = 'AMS_EVENT_TYPE' WITH READ ONLY
Columns
Name |
EVENT_TYPE |
EVENT_TYPE_NAME |
EVENT_TYPE_DESCRIPTION |
ENABLED_FLAG |
START_DATE_ACTIVE |
END_DATE_ACTIVE |