APPS.BIM_EVENT_FACTS dependencies on AS_SALES_LEAD_OPPORTUNITY

Line 751: as_sales_lead_opportunity A,

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

Line 1850: as_sales_lead_opportunity A,

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

Line 3253: as_sales_lead_opportunity A,

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

Line 3737: as_sales_lead_opportunity A,

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

Line 4215: as_sales_lead_opportunity A,

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