VIEW: APPS.BIM_SUMV_SALES_CYCLE

Source

View Text - Preformatted

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

View Text - HTML Formatted

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