[Home] [Help]
725: ,sum(decode(b.OPP_OPEN_STATUS_FLAG,'Y',decode(a.status_code,'NEW',1,0),0)) leads_new
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
746: nvl(I.unit_selling_price * I.ordered_quantity,0)),0)) booked_orders_amt,
747: i.creation_date creation_date
748: from ams_event_headers_all_b B,
749: ams_source_codes C ,
750: as_sales_leads D,
751: as_sales_lead_opportunity A,
752: as_leads_all E,
753: aso_quote_related_objects F,
754: aso_quote_headers_all G,
1076: ,sum(decode(b.OPP_OPEN_STATUS_FLAG,'Y',decode(a.status_code,'NEW',1,0),0)) leads_new
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
1767: ,0 actual_revenue
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
1845: ,sum(decode(h.flow_status_code,'BOOKED',convert_currency(nvl(H.transactional_curr_code,'USD'),
1846: nvl(I.unit_selling_price * I.ordered_quantity,0)),0)) booked_orders_amt
1847: FROM ams_event_offers_all_b B,
1848: ams_source_codes C ,
1849: as_sales_leads D,
1850: as_sales_lead_opportunity A,
1851: as_leads_all E,
1852: aso_quote_related_objects F,
1853: aso_quote_headers_all G,
3172: ,0 --actual_revenue
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
3248: ,sum(decode(h.flow_status_code,'BOOKED',convert_currency(nvl(H.transactional_curr_code,'USD'),
3249: nvl(I.unit_selling_price * I.ordered_quantity,0)),0)) booked_orders_amt
3250: from ams_event_offers_all_b B,
3251: ams_source_codes C ,
3252: as_sales_leads D,
3253: as_sales_lead_opportunity A,
3254: as_leads_all E,
3255: aso_quote_related_objects F,
3256: aso_quote_headers_all G,
3654: ,0 actual_revenue
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
3732: ,sum(decode(h.flow_status_code,'BOOKED',convert_currency(nvl(H.transactional_curr_code,'USD'),
3733: nvl(I.unit_selling_price * I.ordered_quantity,0)),0)) booked_orders_amt
3734: FROM ams_event_offers_all_b B,
3735: ams_source_codes C ,
3736: as_sales_leads D,
3737: as_sales_lead_opportunity A,
3738: as_leads_all E,
3739: aso_quote_related_objects F,
3740: aso_quote_headers_all G,
4076: ,0 --actual_revenue
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
4210: ,sum(decode(h.flow_status_code,'BOOKED',convert_currency(nvl(H.transactional_curr_code,'USD'),
4211: nvl(I.unit_selling_price * I.ordered_quantity,0)),0)) booked_orders_amt
4212: from ams_event_headers_all_b B,
4213: ams_source_codes C ,
4214: as_sales_leads D,
4215: as_sales_lead_opportunity A,
4216: as_leads_all E,
4217: aso_quote_related_objects F,
4218: aso_quote_headers_all G,