APPS.BIM_EVENT_FACTS dependencies on AS_LEADS_ALL

Line 752: as_leads_all E,

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,
755: oe_order_headers_all H,
756: oe_order_lines_all I

Line 775: FROM as_leads_all A,

771: d.event_header_id event_header_id,
772: trunc(a.creation_date) creation_date,
773: COUNT(A.lead_id) nooppor,
774: SUM(convert_currency(nvl(currency_code, 'USD'), nvl(A.total_amount, 0))) opportunity_amt
775: FROM as_leads_all A,
776: ams_event_headers_all_b D,
777: ams_source_codes E
778: where e.source_code = d.source_code
779: and e.source_code_id = a.source_promotion_id

Line 1098: FROM as_leads_all A,

1094: e.source_code_id offer_source_code_id,
1095: trunc(a.creation_date) creation_date,
1096: COUNT(A.lead_id) opportunities,
1097: SUM(convert_currency(nvl(currency_code, 'USD'), nvl(A.total_amount, 0))) opportunity_amt
1098: FROM as_leads_all A,
1099: ams_event_offers_all_b C,
1100: ams_event_headers_all_b D,
1101: ams_source_codes E
1102: where e.source_code = c.source_code

Line 1734: FROM as_leads_all A,

1730: ,0 actual_revenue
1731: ,0 forecasted_revenue
1732: ,0 booked_orders
1733: ,0 booked_orders_amt
1734: FROM as_leads_all A,
1735: ams_event_offers_all_b C,
1736: ams_source_codes E
1737: WHERE e.source_code_for_id = c.event_offer_id
1738: AND c.event_standalone_flag = 'Y'

Line 1851: as_leads_all E,

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,
1854: oe_order_headers_all H,
1855: oe_order_lines_all I

Line 3140: FROM as_leads_all A,

3136: ,0 --actual_revenue
3137: ,0 --forecasted_revenue
3138: ,0 booked_orders
3139: ,0 booked_orders_amt
3140: FROM as_leads_all A,
3141: ams_event_offers_all_b C,
3142: ams_source_codes E
3143: where e.source_code_for_id = c.event_offer_id
3144: and e.source_code_id = a.source_promotion_id

Line 3254: as_leads_all E,

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,
3257: oe_order_headers_all H,
3258: oe_order_lines_all I

Line 3621: FROM as_leads_all A,

3617: ,0 actual_revenue
3618: ,0 forecasted_revenue
3619: ,0 booked_orders
3620: ,0 booked_orders_amt
3621: FROM as_leads_all A,
3622: ams_event_offers_all_b C,
3623: ams_source_codes E
3624: WHERE e.source_code_for_id = c.event_offer_id
3625: AND c.event_standalone_flag = 'Y'

Line 3738: as_leads_all E,

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,
3741: oe_order_headers_all H,
3742: oe_order_lines_all I

Line 4044: FROM as_leads_all A,

4040: ,0 --actual_revenue
4041: ,0 --forecasted_revenue
4042: ,0 booked_orders
4043: ,0 booked_orders_amt
4044: FROM as_leads_all A,
4045: ams_event_headers_all_b C,
4046: ams_source_codes E
4047: where e.source_code_for_id = c.event_header_id
4048: and e.source_code_id = a.source_promotion_id

Line 4216: as_leads_all E,

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,
4219: oe_order_headers_all H,
4220: oe_order_lines_all I