[Home] [Help]
MATERIALIZED VIEW: APPS.BIM_I_LD_HEADER_MV
Source
SELECT /* Dummy Comment */
lead_id
,lead_creation_date
,lead_touched_date
,lead_converted_date
,lead_dead_date
,lead_closed_date
,transaction_create_date
,group_id
,resource_id
,channel_code
,cust_category
,lead_rank_id
,lead_source
,lead_status
,lead_region
,lead_country
,qualified_flag
,source_code_id
,object_type
,object_id
,child_object_type
,child_object_id
,object_region
,object_country
,child_object_region
,child_object_country
,sum(lead_amount) lead_amount
,count(lead_amount) dummy_fr1
,customer_flag
,customer_id
,lead_name
,close_reason
,count(*) allc
from
BIM.BIM_I_LEAD_FACTS fact
GROUP BY
lead_id
,lead_creation_date
,lead_touched_date
,lead_converted_date
,lead_dead_date
,lead_closed_date
,transaction_create_date
,group_id
,resource_id
,channel_code
,cust_category
,lead_rank_id
,lead_source
,lead_status
,lead_region
,lead_country
,qualified_flag
,source_code_id
,object_type
,object_id
,child_object_type
,child_object_id
,object_region
,object_country
,child_object_region
,child_object_country
,customer_flag
,customer_id
,close_reason
,lead_name