APPS.BIM_EVENT_FACTS dependencies on OE_ORDER_LINES_ALL

Line 756: oe_order_lines_all I

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
757: where c.source_code_id = d.source_promotion_id
758: and b.source_code = c.source_code
759: and a.sales_lead_id = d.sales_lead_id
760: and a.opportunity_id = e.lead_id

Line 1855: oe_order_lines_all I

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
1856: WHERE c.source_code_id = d.source_promotion_id
1857: AND b.event_standalone_flag = 'Y'
1858: AND (b.parent_type is null or b.parent_type ='RCAM')
1859: AND b.source_code = c.source_code

Line 3258: oe_order_lines_all I

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
3259: where c.source_code_id = d.source_promotion_id
3260: and c.source_code_for_id = b.event_offer_id
3261: and c.arc_source_code_for in ('EONE','EVEO')
3262: and a.sales_lead_id = d.sales_lead_id

Line 3742: oe_order_lines_all I

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
3743: where c.source_code_id = d.source_promotion_id
3744: and c.source_code_for_id = b.event_offer_id
3745: and c.arc_source_code_for in ('EONE')
3746: and b.event_standalone_flag = 'Y'

Line 4220: oe_order_lines_all I

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
4221: where c.source_code_id = d.source_promotion_id
4222: and c.source_code_for_id = b.event_header_id
4223: and c.arc_source_code_for = 'EVEH'
4224: and a.sales_lead_id = d.sales_lead_id