APPS.XDPCORE_OM dependencies on OE_ORDER_HEADERS_ALL

Line 359: oe_order_headers_all h

355:
356: SELECT NVL(l.org_id,h.org_id), h.order_number
357: INTO l_org_id,l_order_number
358: FROM oe_order_lines_all l,
359: oe_order_headers_all h
360: WHERE l.line_id = to_number(l_line_id)
361: AND l.header_id = h.header_id ;
362:
363:

Line 574: FROM oe_order_headers_all

570: header_id ,
571: sold_to_contact_id,
572: sold_to_org_id ,
573: org_id
574: FROM oe_order_headers_all
575: WHERE header_id = p_header_id ;
576: BEGIN
577: x_return_code := 0 ;
578: x_error_description := null;

Line 588: g_order_header.order_source := 'OE_ORDER_HEADERS_ALL' ;

584: g_order_header.jeopardy_enabled_flag := 'N';
585: g_order_header.execution_mode := 'ASYNC' ;
586: g_order_header.due_date := c_header_rec.expiration_date;
587: g_order_header.customer_required_date := c_header_rec.request_date ;
588: g_order_header.order_source := 'OE_ORDER_HEADERS_ALL' ;
589: g_order_header.order_ref_name := 'SALES' ;
590: g_order_header.order_ref_value := c_header_rec.header_id ;
591: g_order_header.order_number := c_header_rec.order_number;
592: g_order_header.order_version := c_header_rec.version_number;

Line 939: oe_order_headers_all h

935: INTO l_order_number ,
936: l_order_version ,
937: l_header_id
938: FROM oe_order_lines_all l ,
939: oe_order_headers_all h
940: WHERE l.line_id = l_line_id
941: AND l.header_id = h.header_id ;
942:
943: BEGIN

Line 1045: oe_order_headers_all h

1041: INTO l_order_number ,
1042: l_order_version ,
1043: l_header_id
1044: FROM oe_order_lines_all l ,
1045: oe_order_headers_all h
1046: WHERE l.line_id = l_line_id
1047: AND l.header_id = h.header_id ;
1048:
1049: BEGIN