APPS.BIM_EVENT_FACTS dependencies on OE_ORDER_HEADERS_ALL

Line 755: oe_order_headers_all H,

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
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

Line 1854: oe_order_headers_all H,

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
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')

Line 3257: oe_order_headers_all H,

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
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')

Line 3741: oe_order_headers_all H,

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
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')

Line 4219: oe_order_headers_all H,

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
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'