VIEW: BIM.EDW_BIM_CAMP_SCHEDULES_LTC#

Source

View Text - Preformatted

select CAMPAIGN_SCHEDULE_PK CAMPAIGN_SCHEDULE_PK, CAMPAIGN_SCHEDULE_PK_KEY CAMPAIGN_SCHEDULE_PK_KEY, CAMPAIGN_FK CAMPAIGN_FK, CAMPAIGN_FK_KEY CAMPAIGN_FK_KEY, CAMPAIGN_SCHEDULE_DP CAMPAIGN_SCHEDULE_DP, NAME NAME, LEVEL_NAME LEVEL_NAME, CAMPAIGN_SCHEDULE_ID CAMPAIGN_SCHEDULE_ID, SOURCE_CODE SOURCE_CODE, FREQUENCY FREQUENCY, FREQUENCY_UOM_CODE FREQUENCY_UOM_CODE, DELIVERABLE_ID DELIVERABLE_ID, ACTIVITY_OFFER_ID ACTIVITY_OFFER_ID, FORECASTED_START_DATE_TIME FORECASTED_START_DATE_TIME, FORECASTED_END_DATE_TIME FORECASTED_END_DATE_TIME, ACTUAL_START_DATE_TIME ACTUAL_START_DATE_TIME, ACTUAL_END_DATE_TIME ACTUAL_END_DATE_TIME, 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_CAMP_SCHEDULES_LTC"

View Text - HTML Formatted

SELECT CAMPAIGN_SCHEDULE_PK CAMPAIGN_SCHEDULE_PK
, CAMPAIGN_SCHEDULE_PK_KEY CAMPAIGN_SCHEDULE_PK_KEY
, CAMPAIGN_FK CAMPAIGN_FK
, CAMPAIGN_FK_KEY CAMPAIGN_FK_KEY
, CAMPAIGN_SCHEDULE_DP CAMPAIGN_SCHEDULE_DP
, NAME NAME
, LEVEL_NAME LEVEL_NAME
, CAMPAIGN_SCHEDULE_ID CAMPAIGN_SCHEDULE_ID
, SOURCE_CODE SOURCE_CODE
, FREQUENCY FREQUENCY
, FREQUENCY_UOM_CODE FREQUENCY_UOM_CODE
, DELIVERABLE_ID DELIVERABLE_ID
, ACTIVITY_OFFER_ID ACTIVITY_OFFER_ID
, FORECASTED_START_DATE_TIME FORECASTED_START_DATE_TIME
, FORECASTED_END_DATE_TIME FORECASTED_END_DATE_TIME
, ACTUAL_START_DATE_TIME ACTUAL_START_DATE_TIME
, ACTUAL_END_DATE_TIME ACTUAL_END_DATE_TIME
, 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_CAMP_SCHEDULES_LTC"