Product: | BIM - Marketing Intelligence(Obsolete) |
---|---|
Description: | Joins the summary table to the dimension views. |
Implementation/DBA Data: | APPS.BIM_SUMV_SALES_CYCLE |
SELECT BSA.CAMPAIGN_ID CAMPAIGN_ID
, BSA.PERIOD_NAME PERIOD_NAME
, BSA.PERIOD_START_DATE START_DATE
, BSA.PERIOD_END_DATE END_DATE
, BSA.MEDIA_ID MEDIA_ID
, BMC.MEDIA_NAME MEDIA_NAME
, BMC.MEDIA_TYPE_CODE MEDIA_TYPE
, BMC.MEDIA_TYPE_NAME MEDIA_TYPE_NAME
, BSA.CHANNEL_ID CHANNEL_ID
, BMC.CHANNEL_NAME CHANNEL_NAME
, BSA.MARKET_SEGMENT_ID MARKET_SEGMENT_ID
, BMS.MARKET_SEGMENT_NAME MARKET_SEGMENT_NAME
, BSA.GEOGRAPHY_CODE
, BSA.SALES_CHANNEL_CODE SALES_CHANNEL_CODE
, BSC.SALES_CHANNEL_NAME SALES_CHANNEL_NAME
, BSA.LEAD_TO_ORDER_CYCLE LEAD_TO_ORDER_CYCLE
, BSA.LEAD_TO_OPPR_CYCLE LEAD_TO_OPPR_CYCLE
, TO_NUMBER(NULL) OPPR_TO_ORDER_CYCLE
FROM BIM_SALES_CYCLE_SUMM BSA
, BIM_DIMV_MEDIA_CHANNELS BMC
, BIM_DIMV_MARKET_SGMTS BMS
, BIM_DIMV_SALES_CHANNELS BSC
WHERE BSA.MEDIA_ID = BMC.MEDIA_ID
AND BSA.CHANNEL_ID = BMC.CHANNEL_ID
AND BSA.MARKET_SEGMENT_ID = BMS.MARKET_SEGMENT_ID
AND BSA.SALES_CHANNEL_CODE = BSC.SALES_CHANNEL_CODE UNION SELECT BOP.CAMPAIGN_ID CAMPAIGN_ID
, BOP.PERIOD_NAME PERIOD_NAME
, BOP.PERIOD_START_DATE START_DATE
, BOP.PERIOD_END_DATE END_DATE
, BOP.MEDIA_ID MEDIA_ID
, BMC.MEDIA_NAME MEDIA_NAME
, BMC.MEDIA_TYPE_CODE MEDIA_TYPE
, BMC.MEDIA_TYPE_NAME MEDIA_TYPE_NAME
, BOP.CHANNEL_ID CHANNEL_ID
, BMC.CHANNEL_NAME CHANNEL_NAME
, BOP.MARKET_SEGMENT_ID MARKET_SEGMENT_ID
, BMS.MARKET_SEGMENT_NAME MARKET_SEGMENT_NAME
, BOP.GEOGRAPHY_CODE
, BOP.SALES_CHANNEL_CODE SALES_CHANNEL_CODE
, BSC.SALES_CHANNEL_NAME SALES_CHANNEL_NAME
, TO_NUMBER(NULL) LEAD_TO_ORDER_CYCLE
, TO_NUMBER(NULL) LEAD_TO_OPPR_CYCLE
, BOP.OPPR_TO_ORDER_CYCLE OPPR_TO_ORDER_CYCLE
FROM BIM_OPPR_CYCLE_SUMM BOP
, BIM_DIMV_MEDIA_CHANNELS BMC
, BIM_DIMV_MARKET_SGMTS BMS
, BIM_DIMV_SALES_CHANNELS BSC
WHERE BOP.MEDIA_ID = BMC.MEDIA_ID
AND BOP.CHANNEL_ID = BMC.CHANNEL_ID
AND BOP.MARKET_SEGMENT_ID = BMS.MARKET_SEGMENT_ID
AND BOP.SALES_CHANNEL_CODE = BSC.SALES_CHANNEL_CODE WITH READ ONLY