APPS.OE_BULK_ORDER_IMPORT_PVT dependencies on OE_PROCESSING_MSGS

Line 319: SELECT /*+ INDEX (a,OE_PROCESSING_MSGS_N2)

315: -- Messages cursor
316: -----------------------------------------------------------
317: CURSOR l_msg_cursor IS
318: -- Oracle IT bug 01/06/2000 1572080
319: SELECT /*+ INDEX (a,OE_PROCESSING_MSGS_N2)
320: USE_NL (a b) */
321: a.order_source_id
322: , a.original_sys_document_ref
323: , a.change_sequence

Line 326: FROM oe_processing_msgs a, oe_processing_msgs_tl b

322: , a.original_sys_document_ref
323: , a.change_sequence
324: , a.original_sys_document_line_ref
325: , nvl(a.message_text, b.message_text)
326: FROM oe_processing_msgs a, oe_processing_msgs_tl b
327: WHERE a.request_id = l_request_id
328: AND a.transaction_id = b.transaction_id (+)
329: AND b.language (+) = oe_globals.g_lang
330: ORDER BY a.order_source_id, a.original_sys_document_ref, a.change_sequence;