[Home] [Help]
| Product: | BIM - Marketing Intelligence(Obsolete) |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT AMS.CAMPAIGN_SCHEDULE_ID || '-' || INST.INSTANCE_CODE || '-CMP_CSH' CAMPAIGN_SCHEDULE_PK
, AMC.CAMPAIGN_ID || '-' || INST.INSTANCE_CODE || '-CMP' CAMPAIGN_FK
, 'NA_EDW' CAMPAIGN_SCHEDULE_DP
, 'NA_EDW' NAME
, 'CAMPAIGN_SCHEDULE' LEVEL_NAME
, AMS.CAMPAIGN_ID CAMPAIGN_SCHEDULE_ID
, AMS.SOURCE_CODE SOURCE_CODE
, AMS.FREQUENCY FREQUENCY
, AMS.FREQUENCY_UOM_CODE FREQUENCY_UOM_CODE
, AMS.DELIVERABLE_ID DELIVERABLE_ID
, AMS.ACTIVITY_OFFER_ID ACTIVITY_OFFER_ID
, AMS.FORECASTED_START_DATE_TIME FORECASTED_START_DATE_TIME
, AMS.FORECASTED_END_DATE_TIME FORECASTED_END_DATE_TIME
, AMS.ACTUAL_START_DATE_TIME ACTUAL_START_DATE_TIME
, AMS.ACTUAL_END_DATE_TIME ACTUAL_END_DATE_TIME
, INST.INSTANCE_CODE INSTANCE
, AMS.CREATION_DATE CREATION_DATE
, AMS.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM AMS_CAMPAIGN_SCHEDULES AMS
, AMS_CAMPAIGNS_VL AMC
, EDW_LOCAL_INSTANCE INST
WHERE AMS.CAMPAIGN_ID = AMC.CAMPAIGN_ID UNION ALL SELECT BPCD.CAMPAIGN_PK CAMPAIGN_SCHEDULE_PK
, BPCD.CAMPAIGN_PK CAMPAIGN_FK
, BPCD.CAMPAIGN_DP CAMPAIGN_SCHEDULE_DP
, BPCD.NAME NAME
, 'CAMPAIGN' LEVEL_NAME
, TO_NUMBER(NULL) CAMPAIGN_SCHEDULE_ID
, BPCD.SOURCE_CODE SOURCE_CODE
, TO_NUMBER(NULL) FREQUENCY
, NULL FREQUENCY_UOM_CODE
, TO_NUMBER(NULL) DELIVERABLE_ID
, TO_NUMBER(NULL) ACTIVITY_OFFER_ID
, TO_DATE(NULL) FORECASTED_START_DATE_TIME
, TO_DATE(NULL) FORECASTED_END_DATE_TIME
, TO_DATE(NULL) ACTUAL_START_DATE_TIME
, TO_DATE(NULL) ACTUAL_END_DATE_TIME
, BPCD.INSTANCE INSTANCE
, BPCD.CREATION_DATE CREATION_DATE
, BPCD.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM EDW_BIM_CAMP_CMPGNS_LCV BPCD WITH READ ONLY