DBA Data[Home] [Help]

APPS.OE_DELAYED_REQUESTS_UTIL dependencies on OE_ORDER_HEADERS_ALL

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