APPS.OE_DELAYED_REQUESTS_UTIL dependencies on OE_ORDER_HEADERS

Line 4312: FROM oe_order_headers_all h, oe_order_lines l

4308: x_line_rec => l_orig_line_rec);
4309:
4310: SELECT /* MOAC_SQL_CHANGE */ h.order_number
4311: INTO l_order_number
4312: FROM oe_order_headers_all h, oe_order_lines l
4313: WHERE h.header_id = l.header_id
4314: AND h.header_id = l_orig_line_rec.header_id
4315: AND rownum = 1;
4316:

Line 4694: FROM oe_order_headers_all h, oe_order_lines l

4690: x_line_rec => l_orig_line_rec);
4691:
4692: SELECT /* MOAC_SQL_CHANGE */ h.order_number
4693: INTO l_order_number
4694: FROM oe_order_headers_all h, oe_order_lines l
4695: WHERE h.header_id = l.header_id
4696: AND h.header_id = l_orig_line_rec.header_id
4697: AND rownum = 1;
4698:

Line 5766: FROM oe_order_headers_all

5762: /* getting header record*/
5763: l_header_rec:= OE_Header_UTIL.Query_Row(p_header_id=> p_entity_id_tbl(i).entity_id );
5764: SELECT payment_type_code
5765: INTO l_payment_type_code
5766: FROM oe_order_headers_all
5767: WHERE header_id = l_header_rec.header_id;
5768: -- Bug 8825061: Update the global picture given that the line attribute
5769: -- "tax_value" has undergone an update.
5770: IF l_debug_level > 0 THEN

Line 6018: FROM OE_ORDER_HEADERS

6014:
6015: Cursor ord_hdr_cur (p_header_id in number) is
6016: SELECT created_by
6017: ,org_id
6018: FROM OE_ORDER_HEADERS
6019: WHERE header_id = p_header_id;
6020:
6021: Cursor ord_line_cur (p_header_id in number) is
6022: SELECT line_id

Line 6151: Update OE_Order_Headers

6147: --if it returns success Update the Internal Sales Order with the Req header id and Req line Ids
6148: IF l_int_req_ret_sts = FND_API.G_RET_STS_SUCCESS THEN
6149:
6150: --Update the header with the requisition header id
6151: Update OE_Order_Headers
6152: set source_document_Id = l_req_header_rec.requisition_header_id
6153: ,orig_sys_document_ref = l_req_header_rec.segment1
6154: ,source_document_type_id = OE_GLOBALS.G_ORDER_SOURCE_INTERNAL -- i.e 10 for internal
6155: ,order_source_id = OE_GLOBALS.G_ORDER_SOURCE_INTERNAL --i.e 10 for internal

Line 6417: FROM oe_order_headers

6413:
6414: BEGIN
6415: SELECT order_source_id, orig_sys_document_ref, sold_to_org_id, change_sequence
6416: INTO l_order_source_id, l_orig_sys_document_ref, l_sold_to_org_id, l_change_sequence
6417: FROM oe_order_headers
6418: WHERE header_id=l_header_id;
6419: EXCEPTION
6420: WHEN NO_DATA_FOUND THEN
6421: IF l_debug_level > 0 THEN