[Home] [Help]
726: ,sum(decode(b.OPP_OPEN_STATUS_FLAG,'N',decode(a.status_code,'CONVERTED_TO_OPPORTUNITY',1,0),0)) leads_converted
727: ,sum(decode(b.OPP_OPEN_STATUS_FLAG,'Y',decode(a.lead_rank_id,10000,1,0),0)) leads_hot
728: ,sum(decode(b.OPP_OPEN_STATUS_FLAG,'Y',decode(a.status_code,'NEW',convert_currency(nvl(a.currency_code,'USD'),nvl(a.budget_amount,0)),0),0)) leads_new_amt
729: FROM as_sales_leads A,
730: as_statuses_b B,
731: ams_event_headers_all_b C,
732: ams_source_codes E
733: WHERE a.status_code = b.status_code
734: AND e.source_code = c.source_code
1077: ,sum(decode(b.OPP_OPEN_STATUS_FLAG,'N',decode(a.status_code,'CONVERTED_TO_OPPORTUNITY',1,0),0)) leads_converted
1078: ,sum(decode(b.OPP_OPEN_STATUS_FLAG,'Y',decode(a.lead_rank_id,10000,1,0),0)) leads_hot
1079: ,sum(decode(b.OPP_OPEN_STATUS_FLAG,'Y',decode(a.status_code,'NEW',convert_currency(nvl(a.currency_code,'USD'),nvl(a.budget_amount,0)),0),0)) leads_new_amt
1080: FROM as_sales_leads A,
1081: as_statuses_b B,
1082: ams_event_offers_all_b C,
1083: ams_source_codes E
1084: WHERE a.status_code = b.status_code
1085: AND e.source_code = c.source_code
1768: ,0 forecasted_revenue
1769: ,0 booked_orders
1770: ,0 booked_orders_amt
1771: FROM as_sales_leads A,
1772: as_statuses_b B,
1773: ams_event_offers_all_b C,
1774: ams_source_codes E
1775: WHERE e.source_code_for_id = c.event_offer_id
1776: AND c.event_standalone_flag = 'Y'
3173: ,0 --forecasted_revenue
3174: ,0 booked_orders
3175: ,0 booked_orders_amt
3176: FROM as_sales_leads A,
3177: as_statuses_b B,
3178: ams_event_offers_all_b C,
3179: ams_source_codes E
3180: WHERE e.source_code_for_id = c.event_offer_id
3181: and e.source_code_id = a.source_promotion_id
3655: ,0 forecasted_revenue
3656: ,0 booked_orders
3657: ,0 booked_orders_amt
3658: FROM as_sales_leads A,
3659: as_statuses_b B,
3660: ams_event_offers_all_b C,
3661: ams_source_codes E
3662: WHERE e.source_code_for_id = c.event_offer_id
3663: AND c.event_standalone_flag = 'Y'
4077: ,0 --forecasted_revenue
4078: ,0 booked_orders
4079: ,0 booked_orders_amt
4080: FROM as_sales_leads A,
4081: as_statuses_b B,
4082: ams_event_headers_all_b C,
4083: ams_source_codes E
4084: WHERE e.source_code_for_id = c.event_header_id
4085: and e.source_code_id = a.source_promotion_id