Product: | BIM - Marketing Intelligence(Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT AUS.USER_STATUS_ID || '-' || INST.INSTANCE_CODE CMPGN_STATUS_PK
, 'ALL' ALL_FK
, SUBSTR(AUS.NAME
, 1
, 80) CMPGN_STATUS_DP
, AUS.NAME NAME
, AUS.USER_STATUS_ID CMPGN_STATUS_ID
, AUS.SYSTEM_STATUS_CODE SYSTEM_STATUS_CODE
, AUS.SYSTEM_STATUS_TYPE SYSTEM_STATUS_TYPE
, AUS.ENABLED_FLAG ENABLED_FLAG
, AUS.DEFAULT_FLAG DEFAULT_FLAG
, AUS.SEEDED_FLAG SEEDED_FLAG
, AUS.START_DATE_ACTIVE START_DATE_ACTIVE
, AUS.END_DATE_ACTIVE END_DATE_ACTIVE
, AUS.NAME CMPGN_STATUS_NAME
, AUS.DESCRIPTION DESCRIPTION
, INST.INSTANCE_CODE INSTANCE
, AUS.CREATION_DATE CREATION_DATE
, AUS.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM AMS_USER_STATUSES_VL AUS
, EDW_LOCAL_INSTANCE INST
WHERE AUS.SYSTEM_STATUS_TYPE = 'AMS_CAMPAIGN_STATUS' WITH READ ONLY