APPS.OE_RETROBILL_PVT dependencies on OE_PROCESSING_MSGS

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

4530: Messages cursor
4531: -----------------------------------------------------------
4532: */
4533: CURSOR l_msg_cursor IS
4534: SELECT /*+ INDEX (a,OE_PROCESSING_MSGS_N2)
4535: USE_NL (a b) */
4536: a.order_source_id
4537: , a.original_sys_document_ref
4538: , a.change_sequence

Line 4541: FROM oe_processing_msgs a, oe_processing_msgs_tl b

4537: , a.original_sys_document_ref
4538: , a.change_sequence
4539: , a.original_sys_document_line_ref
4540: , b.message_text
4541: FROM oe_processing_msgs a, oe_processing_msgs_tl b
4542: WHERE a.request_id = l_concurrent_id
4543: AND a.transaction_id = b.transaction_id
4544: AND b.language = oe_globals.g_lang
4545: ORDER BY a.order_source_id, a.original_sys_document_ref, a.change_sequence;