VIEW: BIM.EDW_BIM_CSTA_CMPSTATS_LTC#

Source

View Text - Preformatted

select CMPGN_STATUS_PK CMPGN_STATUS_PK, CMPGN_STATUS_PK_KEY CMPGN_STATUS_PK_KEY, ALL_FK ALL_FK, ALL_FK_KEY ALL_FK_KEY, CMPGN_STATUS_DP CMPGN_STATUS_DP, NAME NAME, CMPGN_STATUS_ID CMPGN_STATUS_ID, SYSTEM_STATUS_CODE SYSTEM_STATUS_CODE, SYSTEM_STATUS_TYPE SYSTEM_STATUS_TYPE, ENABLED_FLAG ENABLED_FLAG, DEFAULT_FLAG DEFAULT_FLAG, SEEDED_FLAG SEEDED_FLAG, START_DATE_ACTIVE START_DATE_ACTIVE, END_DATE_ACTIVE END_DATE_ACTIVE, CMPGN_STATUS_NAME CMPGN_STATUS_NAME, DESCRIPTION DESCRIPTION, INSTANCE INSTANCE, USER_ATTRIBUTE1 USER_ATTRIBUTE1, USER_ATTRIBUTE2 USER_ATTRIBUTE2, USER_ATTRIBUTE3 USER_ATTRIBUTE3, USER_ATTRIBUTE4 USER_ATTRIBUTE4, USER_ATTRIBUTE5 USER_ATTRIBUTE5, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATION_DATE CREATION_DATE, SECURITY_GROUP_ID SECURITY_GROUP_ID from "BIM"."EDW_BIM_CSTA_CMPSTATS_LTC"

View Text - HTML Formatted

SELECT CMPGN_STATUS_PK CMPGN_STATUS_PK
, CMPGN_STATUS_PK_KEY CMPGN_STATUS_PK_KEY
, ALL_FK ALL_FK
, ALL_FK_KEY ALL_FK_KEY
, CMPGN_STATUS_DP CMPGN_STATUS_DP
, NAME NAME
, CMPGN_STATUS_ID CMPGN_STATUS_ID
, SYSTEM_STATUS_CODE SYSTEM_STATUS_CODE
, SYSTEM_STATUS_TYPE SYSTEM_STATUS_TYPE
, ENABLED_FLAG ENABLED_FLAG
, DEFAULT_FLAG DEFAULT_FLAG
, SEEDED_FLAG SEEDED_FLAG
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
, CMPGN_STATUS_NAME CMPGN_STATUS_NAME
, DESCRIPTION DESCRIPTION
, INSTANCE INSTANCE
, USER_ATTRIBUTE1 USER_ATTRIBUTE1
, USER_ATTRIBUTE2 USER_ATTRIBUTE2
, USER_ATTRIBUTE3 USER_ATTRIBUTE3
, USER_ATTRIBUTE4 USER_ATTRIBUTE4
, USER_ATTRIBUTE5 USER_ATTRIBUTE5
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_DATE CREATION_DATE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
FROM "BIM"."EDW_BIM_CSTA_CMPSTATS_LTC"