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: EDW_BIM_CAMP_CMPGNS_LCV

Product:	BIM - Marketing Intelligence(Obsolete)
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT AMC.CAMPAIGN_ID || '-' || INST.INSTANCE_CODE || '-CMP' CAMPAIGN_PK
, BCD.PARENT_CAMPAIGN_ID || '-' || INST.INSTANCE_CODE || '-CMP' PARENT_CAMPAIGN_FK
, AMC.CAMPAIGN_NAME CAMPAIGN_DP
, AMC.CAMPAIGN_NAME NAME
, AMC.CAMPAIGN_ID CAMPAIGN_ID
, AMC.SOURCE_CODE SOURCE_CODE
, AMC.ROLLUP_TYPE ROLLUP_TYPE
, AMC.CAMPAIGN_TYPE CAMPAIGN_TYPE
, AMC.FORECASTED_PLAN_START_DATE FORECASTED_PLAN_START_DATE
, AMC.FORECASTED_PLAN_END_DATE FORECASTED_PLAN_END_DATE
, AMC.FORECASTED_EXEC_START_DATE FORECASTED_EXEC_START_DATE
, AMC.FORECASTED_EXEC_END_DATE FORECASTED_EXEC_END_DATE
, AMC.ACTUAL_PLAN_START_DATE ACTUAL_PLAN_START_DATE
, AMC.ACTUAL_PLAN_END_DATE ACTUAL_PLAN_END_DATE
, AMC.ACTUAL_EXEC_START_DATE ACTUAL_EXEC_START_DATE
, AMC.ACTUAL_EXEC_END_DATE ACTUAL_EXEC_END_DATE
, AMC.CAMPAIGN_NAME CAMPAIGN_NAME
, AMC.DESCRIPTION DESCRIPTION
, INST.INSTANCE_CODE INSTANCE
, AMC.CREATION_DATE CREATION_DATE
, AMC.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM AMS_CAMPAIGNS_VL AMC
, EDW_BIM_CMPGNS_DENORM BCD
, EDW_LOCAL_INSTANCE INST
WHERE AMC.CAMPAIGN_ID = BCD.CAMPAIGN_ID
AND BCD.LEVEL_FROM_ROOT >= 8
AND BCD.PARENT_LEVEL_FROM_ROOT = 7 UNION ALL SELECT BPCD.CAMPAIGN_PK CAMPAIGN_PK
, BPCD.CAMPAIGN_PK PARENT_CAMPAIGN_FK
, BPCD.CAMPAIGN_DP CAMPAIGN_DP
, BPCD.NAME NAME
, BPCD.CAMPAIGN_ID CAMPAIGN_ID
, BPCD.SOURCE_CODE SOURCE_CODE
, BPCD.ROLLUP_TYPE ROLLUP_TYPE
, BPCD.CAMPAIGN_TYPE CAMPAIGN_TYPE
, BPCD.FORECASTED_PLAN_START_DATE FORECASTED_PLAN_START_DATE
, BPCD.FORECASTED_PLAN_END_DATE FORECASTED_PLAN_END_DATE
, BPCD.FORECASTED_EXEC_START_DATE FORECASTED_EXEC_START_DATE
, BPCD.FORECASTED_EXEC_END_DATE FORECASTED_EXEC_END_DATE
, BPCD.ACTUAL_PLAN_START_DATE ACTUAL_PLAN_START_DATE
, BPCD.ACTUAL_PLAN_END_DATE ACTUAL_PLAN_END_DATE
, BPCD.ACTUAL_EXEC_START_DATE ACTUAL_EXEC_START_DATE
, BPCD.ACTUAL_EXEC_END_DATE ACTUAL_EXEC_END_DATE
, BPCD.CAMPAIGN_NAME CAMPAIGN_NAME
, BPCD.DESCRIPTION DESCRIPTION
, BPCD.INSTANCE INSTANCE
, BPCD.CREATION_DATE CREATION_DATE
, BPCD.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM EDW_BIM_CAMP_CMPGNS_L1_LCV BPCD

Columns

Name
CAMPAIGN_PK
PARENT_CAMPAIGN_FK
CAMPAIGN_DP
NAME
CAMPAIGN_ID
SOURCE_CODE
ROLLUP_TYPE
CAMPAIGN_TYPE
FORECASTED_PLAN_START_DATE
FORECASTED_PLAN_END_DATE
FORECASTED_EXEC_START_DATE
FORECASTED_EXEC_END_DATE
ACTUAL_PLAN_START_DATE
ACTUAL_PLAN_END_DATE
ACTUAL_EXEC_START_DATE
ACTUAL_EXEC_END_DATE
CAMPAIGN_NAME
DESCRIPTION
INSTANCE
CREATION_DATE
LAST_UPDATE_DATE