[Home] [Help]
MATERIALIZED VIEW: APPS.BIM_I_LP_REGN_MV
Source
SELECT /* Dummy Comment */
a.group_id group_id
,a.resource_id resource_id
,a.lead_country lead_country
,a.update_time_id update_time_id
,a.time_id time_id
,a.update_period_type_id update_period_type_id
,a.period_type_id period_type_id
,a.product_category_id product_category_id
,sum(a.leads) leads
,sum(a.leads_new) leads_new
,sum(a.leads_open) leads_open
,sum(a.leads_changed) leads_changed
,sum(a.leads_converted) leads_converted
,sum(a.conversion_time) conversion_time
,sum(a.leads_dead) leads_dead
,sum(a.leads_closed) leads_closed
,sum(a.leads_qualified) leads_qualified
,sum(a.leads_new_conv) leads_new_conv
,sum(a.leads_new_changed) leads_new_changed
,sum(a.rank_a) leads_a
,sum(a.rank_a) rank_a
,sum(a.rank_b) rank_b
,sum(a.rank_c) rank_c
,sum(a.rank_d) rank_d
,sum(a.rank_z) rank_z
,sum(a.leads_qualified_a) leads_qualified_a
,sum(a.lead_amount) lead_amount
,sum(a.orders_booked_amt) orders_booked_amt
,sum(a.orders_invoiced_amt) orders_invoiced_amt
,count(a.leads) dummy1_fr
,count(a.leads_new) dummy2_fr
,count(a.leads_open) dummy3_fr
,count(a.leads_changed) dummy4_fr
,count(a.leads_converted) dummy5_fr
,count(a.conversion_time) dummy6_fr
,count(a.leads_dead) dummy7_fr
,count(a.leads_closed) dummy8_fr
,count(a.leads_qualified) dummy9_fr
,count(a.leads_new_conv) dummy10_fr
,count(a.leads_new_changed) dummy11_fr
,count(a.rank_a) dummy12_fr
,count(a.rank_a) dummy13_fr
,count(a.rank_b) dummy14_fr
,count(a.rank_c) dummy15_fr
,count(a.rank_d) dummy16_fr
,count(a.rank_z) dummy17_fr
,count(a.leads_qualified_a) dummy18_fr
,count(a.lead_amount) dummy19_fr
,count(a.orders_booked_amt) dummy20_fr
,count(a.orders_invoiced_amt) dummy21_fr
,count(*) dummy22_fr
FROM
bim_i_lp_gensg_t_mv a
GROUP BY
a.group_id
,a.resource_id
,a.lead_country
,a.update_time_id
,a.time_id
,a.update_period_type_id
,a.period_type_id
,a.product_category_id