APPS.OE_BULK_ORDER_IMPORT_PVT dependencies on OE_PROCESSING_MSGS

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

409: -- Messages cursor
410: ------------------------------------------------------------
411: CURSOR l_msg_cursor IS
412: -- Oracle IT bug 01/06/2000 1572080
413: SELECT /*+ INDEX (a,OE_PROCESSING_MSGS_N2)
414: USE_NL (a b) */
415: a.order_source_id
416: , a.original_sys_document_ref
417: , a.change_sequence

Line 420: FROM oe_processing_msgs a, oe_processing_msgs_tl b

416: , a.original_sys_document_ref
417: , a.change_sequence
418: , a.original_sys_document_line_ref
419: , nvl(a.message_text, b.message_text)
420: FROM oe_processing_msgs a, oe_processing_msgs_tl b
421: WHERE a.request_id = l_request_id
422: AND a.transaction_id = b.transaction_id (+)
423: AND b.language (+) = oe_globals.g_lang
424: ORDER BY a.order_source_id, a.original_sys_document_ref, a.change_sequence;