eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: BIM.EDW_BIM_CMPGNS_M#

Source

View Text - Preformatted


select L10_CAMPAIGN_SCHEDULE_PK_KEY L10_CAMPAIGN_SCHEDULE_PK_KEY, L9_CAMPAIGN_PK_KEY L9_CAMPAIGN_PK_KEY, L8_CAMPAIGN_PK_KEY L8_CAMPAIGN_PK_KEY, L7_CAMPAIGN_PK_KEY L7_CAMPAIGN_PK_KEY, L6_CAMPAIGN_PK_KEY L6_CAMPAIGN_PK_KEY, L5_CAMPAIGN_PK_KEY L5_CAMPAIGN_PK_KEY, L4_CAMPAIGN_PK_KEY L4_CAMPAIGN_PK_KEY, L3_CAMPAIGN_PK_KEY L3_CAMPAIGN_PK_KEY, L2_CAMPAIGN_PK_KEY L2_CAMPAIGN_PK_KEY, L1_CAMPAIGN_PK_KEY L1_CAMPAIGN_PK_KEY, L0_ALL_PK_KEY L0_ALL_PK_KEY, L0_ALL_PK L0_ALL_PK, L0_NAME L0_NAME, L1_CAMPAIGN_PK L1_CAMPAIGN_PK, L1_CAMPAIGN_DP L1_CAMPAIGN_DP, L1_NAME L1_NAME, L1_CAMPAIGN_ID L1_CAMPAIGN_ID, L1_SOURCE_CODE L1_SOURCE_CODE, L1_ROLLUP_TYPE L1_ROLLUP_TYPE, L1_CAMPAIGN_TYPE L1_CAMPAIGN_TYPE, L1_FORECASTED_PLAN_START_DATE L1_FORECASTED_PLAN_START_DATE, L1_FORECASTED_PLAN_END_DATE L1_FORECASTED_PLAN_END_DATE, L1_FORECASTED_EXEC_START_DATE L1_FORECASTED_EXEC_START_DATE, L1_FORECASTED_EXEC_END_DATE L1_FORECASTED_EXEC_END_DATE, L1_ACTUAL_PLAN_START_DATE L1_ACTUAL_PLAN_START_DATE, L1_ACTUAL_PLAN_END_DATE L1_ACTUAL_PLAN_END_DATE, L1_ACTUAL_EXEC_START_DATE L1_ACTUAL_EXEC_START_DATE, L1_ACTUAL_EXEC_END_DATE L1_ACTUAL_EXEC_END_DATE, L1_CAMPAIGN_NAME L1_CAMPAIGN_NAME, L1_DESCRIPTION L1_DESCRIPTION, L1_INSTANCE L1_INSTANCE, L1_USER_ATTRIBUTE1 L1_USER_ATTRIBUTE1, L1_USER_ATTRIBUTE2 L1_USER_ATTRIBUTE2, L1_USER_ATTRIBUTE3 L1_USER_ATTRIBUTE3, L1_USER_ATTRIBUTE4 L1_USER_ATTRIBUTE4, L1_USER_ATTRIBUTE5 L1_USER_ATTRIBUTE5, L2_CAMPAIGN_PK L2_CAMPAIGN_PK, L2_CAMPAIGN_DP L2_CAMPAIGN_DP, L2_NAME L2_NAME, L2_CAMPAIGN_ID L2_CAMPAIGN_ID, L2_SOURCE_CODE L2_SOURCE_CODE, L2_ROLLUP_TYPE L2_ROLLUP_TYPE, L2_CAMPAIGN_TYPE L2_CAMPAIGN_TYPE, L2_FORECASTED_PLAN_START_DATE L2_FORECASTED_PLAN_START_DATE, L2_FORECASTED_PLAN_END_DATE L2_FORECASTED_PLAN_END_DATE, L2_FORECASTED_EXEC_START_DATE L2_FORECASTED_EXEC_START_DATE, L2_FORECASTED_EXEC_END_DATE L2_FORECASTED_EXEC_END_DATE, L2_ACTUAL_PLAN_START_DATE L2_ACTUAL_PLAN_START_DATE, L2_ACTUAL_PLAN_END_DATE L2_ACTUAL_PLAN_END_DATE, L2_ACTUAL_EXEC_START_DATE L2_ACTUAL_EXEC_START_DATE, L2_ACTUAL_EXEC_END_DATE L2_ACTUAL_EXEC_END_DATE, L2_CAMPAIGN_NAME L2_CAMPAIGN_NAME, L2_DESCRIPTION L2_DESCRIPTION, L2_INSTANCE L2_INSTANCE, L2_USER_ATTRIBUTE1 L2_USER_ATTRIBUTE1, L2_USER_ATTRIBUTE2 L2_USER_ATTRIBUTE2, L2_USER_ATTRIBUTE3 L2_USER_ATTRIBUTE3, L2_USER_ATTRIBUTE4 L2_USER_ATTRIBUTE4, L2_USER_ATTRIBUTE5 L2_USER_ATTRIBUTE5, L3_CAMPAIGN_PK L3_CAMPAIGN_PK, L3_CAMPAIGN_DP L3_CAMPAIGN_DP, L3_NAME L3_NAME, L3_CAMPAIGN_ID L3_CAMPAIGN_ID, L3_SOURCE_CODE L3_SOURCE_CODE, L3_ROLLUP_TYPE L3_ROLLUP_TYPE, L3_CAMPAIGN_TYPE L3_CAMPAIGN_TYPE, L3_FORECASTED_PLAN_START_DATE L3_FORECASTED_PLAN_START_DATE, L3_FORECASTED_PLAN_END_DATE L3_FORECASTED_PLAN_END_DATE, L3_FORECASTED_EXEC_START_DATE L3_FORECASTED_EXEC_START_DATE, L3_FORECASTED_EXEC_END_DATE L3_FORECASTED_EXEC_END_DATE, L3_ACTUAL_PLAN_START_DATE L3_ACTUAL_PLAN_START_DATE, L3_ACTUAL_PLAN_END_DATE L3_ACTUAL_PLAN_END_DATE, L3_ACTUAL_EXEC_START_DATE L3_ACTUAL_EXEC_START_DATE, L3_ACTUAL_EXEC_END_DATE L3_ACTUAL_EXEC_END_DATE, L3_CAMPAIGN_NAME L3_CAMPAIGN_NAME, L3_DESCRIPTION L3_DESCRIPTION, L3_INSTANCE L3_INSTANCE, L3_USER_ATTRIBUTE1 L3_USER_ATTRIBUTE1, L3_USER_ATTRIBUTE2 L3_USER_ATTRIBUTE2, L3_USER_ATTRIBUTE3 L3_USER_ATTRIBUTE3, L3_USER_ATTRIBUTE4 L3_USER_ATTRIBUTE4, L3_USER_ATTRIBUTE5 L3_USER_ATTRIBUTE5, L4_CAMPAIGN_PK L4_CAMPAIGN_PK, L4_CAMPAIGN_DP L4_CAMPAIGN_DP, L4_NAME L4_NAME, L4_CAMPAIGN_ID L4_CAMPAIGN_ID, L4_SOURCE_CODE L4_SOURCE_CODE, L4_ROLLUP_TYPE L4_ROLLUP_TYPE, L4_CAMPAIGN_TYPE L4_CAMPAIGN_TYPE, L4_FORECASTED_PLAN_START_DATE L4_FORECASTED_PLAN_START_DATE, L4_FORECASTED_PLAN_END_DATE L4_FORECASTED_PLAN_END_DATE, L4_FORECASTED_EXEC_START_DATE L4_FORECASTED_EXEC_START_DATE, L4_FORECASTED_EXEC_END_DATE L4_FORECASTED_EXEC_END_DATE, L4_ACTUAL_PLAN_START_DATE L4_ACTUAL_PLAN_START_DATE, L4_ACTUAL_PLAN_END_DATE L4_ACTUAL_PLAN_END_DATE, L4_ACTUAL_EXEC_START_DATE L4_ACTUAL_EXEC_START_DATE, L4_ACTUAL_EXEC_END_DATE L4_ACTUAL_EXEC_END_DATE, L4_CAMPAIGN_NAME L4_CAMPAIGN_NAME, L4_DESCRIPTION L4_DESCRIPTION, L4_INSTANCE L4_INSTANCE, L4_USER_ATTRIBUTE1 L4_USER_ATTRIBUTE1, L4_USER_ATTRIBUTE2 L4_USER_ATTRIBUTE2, L4_USER_ATTRIBUTE3 L4_USER_ATTRIBUTE3, L4_USER_ATTRIBUTE4 L4_USER_ATTRIBUTE4, L4_USER_ATTRIBUTE5 L4_USER_ATTRIBUTE5, L5_CAMPAIGN_PK L5_CAMPAIGN_PK, L5_CAMPAIGN_DP L5_CAMPAIGN_DP, L5_NAME L5_NAME, L5_CAMPAIGN_ID L5_CAMPAIGN_ID, L5_SOURCE_CODE L5_SOURCE_CODE, L5_ROLLUP_TYPE L5_ROLLUP_TYPE, L5_CAMPAIGN_TYPE L5_CAMPAIGN_TYPE, L5_FORECASTED_PLAN_START_DATE L5_FORECASTED_PLAN_START_DATE, L5_FORECASTED_PLAN_END_DATE L5_FORECASTED_PLAN_END_DATE, L5_FORECASTED_EXEC_START_DATE L5_FORECASTED_EXEC_START_DATE, L5_FORECASTED_EXEC_END_DATE L5_FORECASTED_EXEC_END_DATE, L5_ACTUAL_PLAN_START_DATE L5_ACTUAL_PLAN_START_DATE, L5_ACTUAL_PLAN_END_DATE L5_ACTUAL_PLAN_END_DATE, L5_ACTUAL_EXEC_START_DATE L5_ACTUAL_EXEC_START_DATE, L5_ACTUAL_EXEC_END_DATE L5_ACTUAL_EXEC_END_DATE, L5_CAMPAIGN_NAME L5_CAMPAIGN_NAME, L5_DESCRIPTION L5_DESCRIPTION, L5_INSTANCE L5_INSTANCE, L5_USER_ATTRIBUTE1 L5_USER_ATTRIBUTE1, L5_USER_ATTRIBUTE2 L5_USER_ATTRIBUTE2, L5_USER_ATTRIBUTE3 L5_USER_ATTRIBUTE3, L5_USER_ATTRIBUTE4 L5_USER_ATTRIBUTE4, L5_USER_ATTRIBUTE5 L5_USER_ATTRIBUTE5, L6_CAMPAIGN_PK L6_CAMPAIGN_PK, L6_CAMPAIGN_DP L6_CAMPAIGN_DP, L6_NAME L6_NAME, L6_CAMPAIGN_ID L6_CAMPAIGN_ID, L6_SOURCE_CODE L6_SOURCE_CODE, L6_ROLLUP_TYPE L6_ROLLUP_TYPE, L6_CAMPAIGN_TYPE L6_CAMPAIGN_TYPE, L6_FORECASTED_PLAN_START_DATE L6_FORECASTED_PLAN_START_DATE, L6_FORECASTED_PLAN_END_DATE L6_FORECASTED_PLAN_END_DATE, L6_FORECASTED_EXEC_START_DATE L6_FORECASTED_EXEC_START_DATE, L6_FORECASTED_EXEC_END_DATE L6_FORECASTED_EXEC_END_DATE, L6_ACTUAL_PLAN_START_DATE L6_ACTUAL_PLAN_START_DATE, L6_ACTUAL_PLAN_END_DATE L6_ACTUAL_PLAN_END_DATE, L6_ACTUAL_EXEC_START_DATE L6_ACTUAL_EXEC_START_DATE, L6_ACTUAL_EXEC_END_DATE L6_ACTUAL_EXEC_END_DATE, L6_CAMPAIGN_NAME L6_CAMPAIGN_NAME, L6_DESCRIPTION L6_DESCRIPTION, L6_INSTANCE L6_INSTANCE, L6_USER_ATTRIBUTE1 L6_USER_ATTRIBUTE1, L6_USER_ATTRIBUTE2 L6_USER_ATTRIBUTE2, L6_USER_ATTRIBUTE3 L6_USER_ATTRIBUTE3, L6_USER_ATTRIBUTE4 L6_USER_ATTRIBUTE4, L6_USER_ATTRIBUTE5 L6_USER_ATTRIBUTE5, L7_CAMPAIGN_PK L7_CAMPAIGN_PK, L7_CAMPAIGN_DP L7_CAMPAIGN_DP, L7_NAME L7_NAME, L7_CAMPAIGN_ID L7_CAMPAIGN_ID, L7_SOURCE_CODE L7_SOURCE_CODE, L7_ROLLUP_TYPE L7_ROLLUP_TYPE, L7_CAMPAIGN_TYPE L7_CAMPAIGN_TYPE, L7_FORECASTED_PLAN_START_DATE L7_FORECASTED_PLAN_START_DATE, L7_FORECASTED_PLAN_END_DATE L7_FORECASTED_PLAN_END_DATE, L7_FORECASTED_EXEC_START_DATE L7_FORECASTED_EXEC_START_DATE, L7_FORECASTED_EXEC_END_DATE L7_FORECASTED_EXEC_END_DATE, L7_ACTUAL_PLAN_START_DATE L7_ACTUAL_PLAN_START_DATE, L7_ACTUAL_PLAN_END_DATE L7_ACTUAL_PLAN_END_DATE, L7_ACTUAL_EXEC_START_DATE L7_ACTUAL_EXEC_START_DATE, L7_ACTUAL_EXEC_END_DATE L7_ACTUAL_EXEC_END_DATE, L7_CAMPAIGN_NAME L7_CAMPAIGN_NAME, L7_DESCRIPTION L7_DESCRIPTION, L7_INSTANCE L7_INSTANCE, L7_USER_ATTRIBUTE1 L7_USER_ATTRIBUTE1, L7_USER_ATTRIBUTE2 L7_USER_ATTRIBUTE2, L7_USER_ATTRIBUTE3 L7_USER_ATTRIBUTE3, L7_USER_ATTRIBUTE4 L7_USER_ATTRIBUTE4, L7_USER_ATTRIBUTE5 L7_USER_ATTRIBUTE5, L8_CAMPAIGN_PK L8_CAMPAIGN_PK, L8_CAMPAIGN_DP L8_CAMPAIGN_DP, L8_NAME L8_NAME, L8_CAMPAIGN_ID L8_CAMPAIGN_ID, L8_SOURCE_CODE L8_SOURCE_CODE, L8_ROLLUP_TYPE L8_ROLLUP_TYPE, L8_CAMPAIGN_TYPE L8_CAMPAIGN_TYPE, L8_FORECASTED_PLAN_START_DATE L8_FORECASTED_PLAN_START_DATE, L8_FORECASTED_PLAN_END_DATE L8_FORECASTED_PLAN_END_DATE, L8_FORECASTED_EXEC_START_DATE L8_FORECASTED_EXEC_START_DATE, L8_FORECASTED_EXEC_END_DATE L8_FORECASTED_EXEC_END_DATE, L8_ACTUAL_PLAN_START_DATE L8_ACTUAL_PLAN_START_DATE, L8_ACTUAL_PLAN_END_DATE L8_ACTUAL_PLAN_END_DATE, L8_ACTUAL_EXEC_START_DATE L8_ACTUAL_EXEC_START_DATE, L8_ACTUAL_EXEC_END_DATE L8_ACTUAL_EXEC_END_DATE, L8_CAMPAIGN_NAME L8_CAMPAIGN_NAME, L8_DESCRIPTION L8_DESCRIPTION, L8_INSTANCE L8_INSTANCE, L8_USER_ATTRIBUTE1 L8_USER_ATTRIBUTE1, L8_USER_ATTRIBUTE2 L8_USER_ATTRIBUTE2, L8_USER_ATTRIBUTE3 L8_USER_ATTRIBUTE3, L8_USER_ATTRIBUTE4 L8_USER_ATTRIBUTE4, L8_USER_ATTRIBUTE5 L8_USER_ATTRIBUTE5, L9_CAMPAIGN_PK L9_CAMPAIGN_PK, L9_CAMPAIGN_DP L9_CAMPAIGN_DP, L9_NAME L9_NAME, L9_CAMPAIGN_ID L9_CAMPAIGN_ID, L9_SOURCE_CODE L9_SOURCE_CODE, L9_ROLLUP_TYPE L9_ROLLUP_TYPE, L9_CAMPAIGN_TYPE L9_CAMPAIGN_TYPE, L9_FORECASTED_PLAN_START_DATE L9_FORECASTED_PLAN_START_DATE, L9_FORECASTED_PLAN_END_DATE L9_FORECASTED_PLAN_END_DATE, L9_FORECASTED_EXEC_START_DATE L9_FORECASTED_EXEC_START_DATE, L9_FORECASTED_EXEC_END_DATE L9_FORECASTED_EXEC_END_DATE, L9_ACTUAL_PLAN_START_DATE L9_ACTUAL_PLAN_START_DATE, L9_ACTUAL_PLAN_END_DATE L9_ACTUAL_PLAN_END_DATE, L9_ACTUAL_EXEC_START_DATE L9_ACTUAL_EXEC_START_DATE, L9_ACTUAL_EXEC_END_DATE L9_ACTUAL_EXEC_END_DATE, L9_CAMPAIGN_NAME L9_CAMPAIGN_NAME, L9_DESCRIPTION L9_DESCRIPTION, L9_INSTANCE L9_INSTANCE, L9_USER_ATTRIBUTE1 L9_USER_ATTRIBUTE1, L9_USER_ATTRIBUTE2 L9_USER_ATTRIBUTE2, L9_USER_ATTRIBUTE3 L9_USER_ATTRIBUTE3, L9_USER_ATTRIBUTE4 L9_USER_ATTRIBUTE4, L9_USER_ATTRIBUTE5 L9_USER_ATTRIBUTE5, L10_CAMPAIGN_SCHEDULE_PK L10_CAMPAIGN_SCHEDULE_PK, L10_CAMPAIGN_SCHEDULE_DP L10_CAMPAIGN_SCHEDULE_DP, L10_NAME L10_NAME, L10_LEVEL_NAME L10_LEVEL_NAME, L10_CAMPAIGN_SCHEDULE_ID L10_CAMPAIGN_SCHEDULE_ID, L10_SOURCE_CODE L10_SOURCE_CODE, L10_FREQUENCY L10_FREQUENCY, L10_FREQUENCY_UOM_CODE L10_FREQUENCY_UOM_CODE, L10_DELIVERABLE_ID L10_DELIVERABLE_ID, L10_ACTIVITY_OFFER_ID L10_ACTIVITY_OFFER_ID, L10_FORECASTED_START_DATE_TIME L10_FORECASTED_START_DATE_TIME, L10_FORECASTED_END_DATE_TIME L10_FORECASTED_END_DATE_TIME, L10_ACTUAL_START_DATE_TIME L10_ACTUAL_START_DATE_TIME, L10_ACTUAL_END_DATE_TIME L10_ACTUAL_END_DATE_TIME, L10_INSTANCE L10_INSTANCE, L10_USER_ATTRIBUTE1 L10_USER_ATTRIBUTE1, L10_USER_ATTRIBUTE2 L10_USER_ATTRIBUTE2, L10_USER_ATTRIBUTE3 L10_USER_ATTRIBUTE3, L10_USER_ATTRIBUTE4 L10_USER_ATTRIBUTE4, L10_USER_ATTRIBUTE5 L10_USER_ATTRIBUTE5, L10_LAST_UPDATE_DATE L10_LAST_UPDATE_DATE, L10_CREATION_DATE L10_CREATION_DATE, SECURITY_GROUP_ID SECURITY_GROUP_ID, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE from "BIM"."EDW_BIM_CMPGNS_M"

View Text - HTML Formatted

SELECT L10_CAMPAIGN_SCHEDULE_PK_KEY L10_CAMPAIGN_SCHEDULE_PK_KEY
, L9_CAMPAIGN_PK_KEY L9_CAMPAIGN_PK_KEY
, L8_CAMPAIGN_PK_KEY L8_CAMPAIGN_PK_KEY
, L7_CAMPAIGN_PK_KEY L7_CAMPAIGN_PK_KEY
, L6_CAMPAIGN_PK_KEY L6_CAMPAIGN_PK_KEY
, L5_CAMPAIGN_PK_KEY L5_CAMPAIGN_PK_KEY
, L4_CAMPAIGN_PK_KEY L4_CAMPAIGN_PK_KEY
, L3_CAMPAIGN_PK_KEY L3_CAMPAIGN_PK_KEY
, L2_CAMPAIGN_PK_KEY L2_CAMPAIGN_PK_KEY
, L1_CAMPAIGN_PK_KEY L1_CAMPAIGN_PK_KEY
, L0_ALL_PK_KEY L0_ALL_PK_KEY
, L0_ALL_PK L0_ALL_PK
, L0_NAME L0_NAME
, L1_CAMPAIGN_PK L1_CAMPAIGN_PK
, L1_CAMPAIGN_DP L1_CAMPAIGN_DP
, L1_NAME L1_NAME
, L1_CAMPAIGN_ID L1_CAMPAIGN_ID
, L1_SOURCE_CODE L1_SOURCE_CODE
, L1_ROLLUP_TYPE L1_ROLLUP_TYPE
, L1_CAMPAIGN_TYPE L1_CAMPAIGN_TYPE
, L1_FORECASTED_PLAN_START_DATE L1_FORECASTED_PLAN_START_DATE
, L1_FORECASTED_PLAN_END_DATE L1_FORECASTED_PLAN_END_DATE
, L1_FORECASTED_EXEC_START_DATE L1_FORECASTED_EXEC_START_DATE
, L1_FORECASTED_EXEC_END_DATE L1_FORECASTED_EXEC_END_DATE
, L1_ACTUAL_PLAN_START_DATE L1_ACTUAL_PLAN_START_DATE
, L1_ACTUAL_PLAN_END_DATE L1_ACTUAL_PLAN_END_DATE
, L1_ACTUAL_EXEC_START_DATE L1_ACTUAL_EXEC_START_DATE
, L1_ACTUAL_EXEC_END_DATE L1_ACTUAL_EXEC_END_DATE
, L1_CAMPAIGN_NAME L1_CAMPAIGN_NAME
, L1_DESCRIPTION L1_DESCRIPTION
, L1_INSTANCE L1_INSTANCE
, L1_USER_ATTRIBUTE1 L1_USER_ATTRIBUTE1
, L1_USER_ATTRIBUTE2 L1_USER_ATTRIBUTE2
, L1_USER_ATTRIBUTE3 L1_USER_ATTRIBUTE3
, L1_USER_ATTRIBUTE4 L1_USER_ATTRIBUTE4
, L1_USER_ATTRIBUTE5 L1_USER_ATTRIBUTE5
, L2_CAMPAIGN_PK L2_CAMPAIGN_PK
, L2_CAMPAIGN_DP L2_CAMPAIGN_DP
, L2_NAME L2_NAME
, L2_CAMPAIGN_ID L2_CAMPAIGN_ID
, L2_SOURCE_CODE L2_SOURCE_CODE
, L2_ROLLUP_TYPE L2_ROLLUP_TYPE
, L2_CAMPAIGN_TYPE L2_CAMPAIGN_TYPE
, L2_FORECASTED_PLAN_START_DATE L2_FORECASTED_PLAN_START_DATE
, L2_FORECASTED_PLAN_END_DATE L2_FORECASTED_PLAN_END_DATE
, L2_FORECASTED_EXEC_START_DATE L2_FORECASTED_EXEC_START_DATE
, L2_FORECASTED_EXEC_END_DATE L2_FORECASTED_EXEC_END_DATE
, L2_ACTUAL_PLAN_START_DATE L2_ACTUAL_PLAN_START_DATE
, L2_ACTUAL_PLAN_END_DATE L2_ACTUAL_PLAN_END_DATE
, L2_ACTUAL_EXEC_START_DATE L2_ACTUAL_EXEC_START_DATE
, L2_ACTUAL_EXEC_END_DATE L2_ACTUAL_EXEC_END_DATE
, L2_CAMPAIGN_NAME L2_CAMPAIGN_NAME
, L2_DESCRIPTION L2_DESCRIPTION
, L2_INSTANCE L2_INSTANCE
, L2_USER_ATTRIBUTE1 L2_USER_ATTRIBUTE1
, L2_USER_ATTRIBUTE2 L2_USER_ATTRIBUTE2
, L2_USER_ATTRIBUTE3 L2_USER_ATTRIBUTE3
, L2_USER_ATTRIBUTE4 L2_USER_ATTRIBUTE4
, L2_USER_ATTRIBUTE5 L2_USER_ATTRIBUTE5
, L3_CAMPAIGN_PK L3_CAMPAIGN_PK
, L3_CAMPAIGN_DP L3_CAMPAIGN_DP
, L3_NAME L3_NAME
, L3_CAMPAIGN_ID L3_CAMPAIGN_ID
, L3_SOURCE_CODE L3_SOURCE_CODE
, L3_ROLLUP_TYPE L3_ROLLUP_TYPE
, L3_CAMPAIGN_TYPE L3_CAMPAIGN_TYPE
, L3_FORECASTED_PLAN_START_DATE L3_FORECASTED_PLAN_START_DATE
, L3_FORECASTED_PLAN_END_DATE L3_FORECASTED_PLAN_END_DATE
, L3_FORECASTED_EXEC_START_DATE L3_FORECASTED_EXEC_START_DATE
, L3_FORECASTED_EXEC_END_DATE L3_FORECASTED_EXEC_END_DATE
, L3_ACTUAL_PLAN_START_DATE L3_ACTUAL_PLAN_START_DATE
, L3_ACTUAL_PLAN_END_DATE L3_ACTUAL_PLAN_END_DATE
, L3_ACTUAL_EXEC_START_DATE L3_ACTUAL_EXEC_START_DATE
, L3_ACTUAL_EXEC_END_DATE L3_ACTUAL_EXEC_END_DATE
, L3_CAMPAIGN_NAME L3_CAMPAIGN_NAME
, L3_DESCRIPTION L3_DESCRIPTION
, L3_INSTANCE L3_INSTANCE
, L3_USER_ATTRIBUTE1 L3_USER_ATTRIBUTE1
, L3_USER_ATTRIBUTE2 L3_USER_ATTRIBUTE2
, L3_USER_ATTRIBUTE3 L3_USER_ATTRIBUTE3
, L3_USER_ATTRIBUTE4 L3_USER_ATTRIBUTE4
, L3_USER_ATTRIBUTE5 L3_USER_ATTRIBUTE5
, L4_CAMPAIGN_PK L4_CAMPAIGN_PK
, L4_CAMPAIGN_DP L4_CAMPAIGN_DP
, L4_NAME L4_NAME
, L4_CAMPAIGN_ID L4_CAMPAIGN_ID
, L4_SOURCE_CODE L4_SOURCE_CODE
, L4_ROLLUP_TYPE L4_ROLLUP_TYPE
, L4_CAMPAIGN_TYPE L4_CAMPAIGN_TYPE
, L4_FORECASTED_PLAN_START_DATE L4_FORECASTED_PLAN_START_DATE
, L4_FORECASTED_PLAN_END_DATE L4_FORECASTED_PLAN_END_DATE
, L4_FORECASTED_EXEC_START_DATE L4_FORECASTED_EXEC_START_DATE
, L4_FORECASTED_EXEC_END_DATE L4_FORECASTED_EXEC_END_DATE
, L4_ACTUAL_PLAN_START_DATE L4_ACTUAL_PLAN_START_DATE
, L4_ACTUAL_PLAN_END_DATE L4_ACTUAL_PLAN_END_DATE
, L4_ACTUAL_EXEC_START_DATE L4_ACTUAL_EXEC_START_DATE
, L4_ACTUAL_EXEC_END_DATE L4_ACTUAL_EXEC_END_DATE
, L4_CAMPAIGN_NAME L4_CAMPAIGN_NAME
, L4_DESCRIPTION L4_DESCRIPTION
, L4_INSTANCE L4_INSTANCE
, L4_USER_ATTRIBUTE1 L4_USER_ATTRIBUTE1
, L4_USER_ATTRIBUTE2 L4_USER_ATTRIBUTE2
, L4_USER_ATTRIBUTE3 L4_USER_ATTRIBUTE3
, L4_USER_ATTRIBUTE4 L4_USER_ATTRIBUTE4
, L4_USER_ATTRIBUTE5 L4_USER_ATTRIBUTE5
, L5_CAMPAIGN_PK L5_CAMPAIGN_PK
, L5_CAMPAIGN_DP L5_CAMPAIGN_DP
, L5_NAME L5_NAME
, L5_CAMPAIGN_ID L5_CAMPAIGN_ID
, L5_SOURCE_CODE L5_SOURCE_CODE
, L5_ROLLUP_TYPE L5_ROLLUP_TYPE
, L5_CAMPAIGN_TYPE L5_CAMPAIGN_TYPE
, L5_FORECASTED_PLAN_START_DATE L5_FORECASTED_PLAN_START_DATE
, L5_FORECASTED_PLAN_END_DATE L5_FORECASTED_PLAN_END_DATE
, L5_FORECASTED_EXEC_START_DATE L5_FORECASTED_EXEC_START_DATE
, L5_FORECASTED_EXEC_END_DATE L5_FORECASTED_EXEC_END_DATE
, L5_ACTUAL_PLAN_START_DATE L5_ACTUAL_PLAN_START_DATE
, L5_ACTUAL_PLAN_END_DATE L5_ACTUAL_PLAN_END_DATE
, L5_ACTUAL_EXEC_START_DATE L5_ACTUAL_EXEC_START_DATE
, L5_ACTUAL_EXEC_END_DATE L5_ACTUAL_EXEC_END_DATE
, L5_CAMPAIGN_NAME L5_CAMPAIGN_NAME
, L5_DESCRIPTION L5_DESCRIPTION
, L5_INSTANCE L5_INSTANCE
, L5_USER_ATTRIBUTE1 L5_USER_ATTRIBUTE1
, L5_USER_ATTRIBUTE2 L5_USER_ATTRIBUTE2
, L5_USER_ATTRIBUTE3 L5_USER_ATTRIBUTE3
, L5_USER_ATTRIBUTE4 L5_USER_ATTRIBUTE4
, L5_USER_ATTRIBUTE5 L5_USER_ATTRIBUTE5
, L6_CAMPAIGN_PK L6_CAMPAIGN_PK
, L6_CAMPAIGN_DP L6_CAMPAIGN_DP
, L6_NAME L6_NAME
, L6_CAMPAIGN_ID L6_CAMPAIGN_ID
, L6_SOURCE_CODE L6_SOURCE_CODE
, L6_ROLLUP_TYPE L6_ROLLUP_TYPE
, L6_CAMPAIGN_TYPE L6_CAMPAIGN_TYPE
, L6_FORECASTED_PLAN_START_DATE L6_FORECASTED_PLAN_START_DATE
, L6_FORECASTED_PLAN_END_DATE L6_FORECASTED_PLAN_END_DATE
, L6_FORECASTED_EXEC_START_DATE L6_FORECASTED_EXEC_START_DATE
, L6_FORECASTED_EXEC_END_DATE L6_FORECASTED_EXEC_END_DATE
, L6_ACTUAL_PLAN_START_DATE L6_ACTUAL_PLAN_START_DATE
, L6_ACTUAL_PLAN_END_DATE L6_ACTUAL_PLAN_END_DATE
, L6_ACTUAL_EXEC_START_DATE L6_ACTUAL_EXEC_START_DATE
, L6_ACTUAL_EXEC_END_DATE L6_ACTUAL_EXEC_END_DATE
, L6_CAMPAIGN_NAME L6_CAMPAIGN_NAME
, L6_DESCRIPTION L6_DESCRIPTION
, L6_INSTANCE L6_INSTANCE
, L6_USER_ATTRIBUTE1 L6_USER_ATTRIBUTE1
, L6_USER_ATTRIBUTE2 L6_USER_ATTRIBUTE2
, L6_USER_ATTRIBUTE3 L6_USER_ATTRIBUTE3
, L6_USER_ATTRIBUTE4 L6_USER_ATTRIBUTE4
, L6_USER_ATTRIBUTE5 L6_USER_ATTRIBUTE5
, L7_CAMPAIGN_PK L7_CAMPAIGN_PK
, L7_CAMPAIGN_DP L7_CAMPAIGN_DP
, L7_NAME L7_NAME
, L7_CAMPAIGN_ID L7_CAMPAIGN_ID
, L7_SOURCE_CODE L7_SOURCE_CODE
, L7_ROLLUP_TYPE L7_ROLLUP_TYPE
, L7_CAMPAIGN_TYPE L7_CAMPAIGN_TYPE
, L7_FORECASTED_PLAN_START_DATE L7_FORECASTED_PLAN_START_DATE
, L7_FORECASTED_PLAN_END_DATE L7_FORECASTED_PLAN_END_DATE
, L7_FORECASTED_EXEC_START_DATE L7_FORECASTED_EXEC_START_DATE
, L7_FORECASTED_EXEC_END_DATE L7_FORECASTED_EXEC_END_DATE
, L7_ACTUAL_PLAN_START_DATE L7_ACTUAL_PLAN_START_DATE
, L7_ACTUAL_PLAN_END_DATE L7_ACTUAL_PLAN_END_DATE
, L7_ACTUAL_EXEC_START_DATE L7_ACTUAL_EXEC_START_DATE
, L7_ACTUAL_EXEC_END_DATE L7_ACTUAL_EXEC_END_DATE
, L7_CAMPAIGN_NAME L7_CAMPAIGN_NAME
, L7_DESCRIPTION L7_DESCRIPTION
, L7_INSTANCE L7_INSTANCE
, L7_USER_ATTRIBUTE1 L7_USER_ATTRIBUTE1
, L7_USER_ATTRIBUTE2 L7_USER_ATTRIBUTE2
, L7_USER_ATTRIBUTE3 L7_USER_ATTRIBUTE3
, L7_USER_ATTRIBUTE4 L7_USER_ATTRIBUTE4
, L7_USER_ATTRIBUTE5 L7_USER_ATTRIBUTE5
, L8_CAMPAIGN_PK L8_CAMPAIGN_PK
, L8_CAMPAIGN_DP L8_CAMPAIGN_DP
, L8_NAME L8_NAME
, L8_CAMPAIGN_ID L8_CAMPAIGN_ID
, L8_SOURCE_CODE L8_SOURCE_CODE
, L8_ROLLUP_TYPE L8_ROLLUP_TYPE
, L8_CAMPAIGN_TYPE L8_CAMPAIGN_TYPE
, L8_FORECASTED_PLAN_START_DATE L8_FORECASTED_PLAN_START_DATE
, L8_FORECASTED_PLAN_END_DATE L8_FORECASTED_PLAN_END_DATE
, L8_FORECASTED_EXEC_START_DATE L8_FORECASTED_EXEC_START_DATE
, L8_FORECASTED_EXEC_END_DATE L8_FORECASTED_EXEC_END_DATE
, L8_ACTUAL_PLAN_START_DATE L8_ACTUAL_PLAN_START_DATE
, L8_ACTUAL_PLAN_END_DATE L8_ACTUAL_PLAN_END_DATE
, L8_ACTUAL_EXEC_START_DATE L8_ACTUAL_EXEC_START_DATE
, L8_ACTUAL_EXEC_END_DATE L8_ACTUAL_EXEC_END_DATE
, L8_CAMPAIGN_NAME L8_CAMPAIGN_NAME
, L8_DESCRIPTION L8_DESCRIPTION
, L8_INSTANCE L8_INSTANCE
, L8_USER_ATTRIBUTE1 L8_USER_ATTRIBUTE1
, L8_USER_ATTRIBUTE2 L8_USER_ATTRIBUTE2
, L8_USER_ATTRIBUTE3 L8_USER_ATTRIBUTE3
, L8_USER_ATTRIBUTE4 L8_USER_ATTRIBUTE4
, L8_USER_ATTRIBUTE5 L8_USER_ATTRIBUTE5
, L9_CAMPAIGN_PK L9_CAMPAIGN_PK
, L9_CAMPAIGN_DP L9_CAMPAIGN_DP
, L9_NAME L9_NAME
, L9_CAMPAIGN_ID L9_CAMPAIGN_ID
, L9_SOURCE_CODE L9_SOURCE_CODE
, L9_ROLLUP_TYPE L9_ROLLUP_TYPE
, L9_CAMPAIGN_TYPE L9_CAMPAIGN_TYPE
, L9_FORECASTED_PLAN_START_DATE L9_FORECASTED_PLAN_START_DATE
, L9_FORECASTED_PLAN_END_DATE L9_FORECASTED_PLAN_END_DATE
, L9_FORECASTED_EXEC_START_DATE L9_FORECASTED_EXEC_START_DATE
, L9_FORECASTED_EXEC_END_DATE L9_FORECASTED_EXEC_END_DATE
, L9_ACTUAL_PLAN_START_DATE L9_ACTUAL_PLAN_START_DATE
, L9_ACTUAL_PLAN_END_DATE L9_ACTUAL_PLAN_END_DATE
, L9_ACTUAL_EXEC_START_DATE L9_ACTUAL_EXEC_START_DATE
, L9_ACTUAL_EXEC_END_DATE L9_ACTUAL_EXEC_END_DATE
, L9_CAMPAIGN_NAME L9_CAMPAIGN_NAME
, L9_DESCRIPTION L9_DESCRIPTION
, L9_INSTANCE L9_INSTANCE
, L9_USER_ATTRIBUTE1 L9_USER_ATTRIBUTE1
, L9_USER_ATTRIBUTE2 L9_USER_ATTRIBUTE2
, L9_USER_ATTRIBUTE3 L9_USER_ATTRIBUTE3
, L9_USER_ATTRIBUTE4 L9_USER_ATTRIBUTE4
, L9_USER_ATTRIBUTE5 L9_USER_ATTRIBUTE5
, L10_CAMPAIGN_SCHEDULE_PK L10_CAMPAIGN_SCHEDULE_PK
, L10_CAMPAIGN_SCHEDULE_DP L10_CAMPAIGN_SCHEDULE_DP
, L10_NAME L10_NAME
, L10_LEVEL_NAME L10_LEVEL_NAME
, L10_CAMPAIGN_SCHEDULE_ID L10_CAMPAIGN_SCHEDULE_ID
, L10_SOURCE_CODE L10_SOURCE_CODE
, L10_FREQUENCY L10_FREQUENCY
, L10_FREQUENCY_UOM_CODE L10_FREQUENCY_UOM_CODE
, L10_DELIVERABLE_ID L10_DELIVERABLE_ID
, L10_ACTIVITY_OFFER_ID L10_ACTIVITY_OFFER_ID
, L10_FORECASTED_START_DATE_TIME L10_FORECASTED_START_DATE_TIME
, L10_FORECASTED_END_DATE_TIME L10_FORECASTED_END_DATE_TIME
, L10_ACTUAL_START_DATE_TIME L10_ACTUAL_START_DATE_TIME
, L10_ACTUAL_END_DATE_TIME L10_ACTUAL_END_DATE_TIME
, L10_INSTANCE L10_INSTANCE
, L10_USER_ATTRIBUTE1 L10_USER_ATTRIBUTE1
, L10_USER_ATTRIBUTE2 L10_USER_ATTRIBUTE2
, L10_USER_ATTRIBUTE3 L10_USER_ATTRIBUTE3
, L10_USER_ATTRIBUTE4 L10_USER_ATTRIBUTE4
, L10_USER_ATTRIBUTE5 L10_USER_ATTRIBUTE5
, L10_LAST_UPDATE_DATE L10_LAST_UPDATE_DATE
, L10_CREATION_DATE L10_CREATION_DATE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM "BIM"."EDW_BIM_CMPGNS_M"