APPS.OE_RETROBILL_PVT dependencies on OE_PROCESSING_MSGS

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

4105: Messages cursor
4106: -----------------------------------------------------------
4107: */
4108: CURSOR l_msg_cursor IS
4109: SELECT /*+ INDEX (a,OE_PROCESSING_MSGS_N2)
4110: USE_NL (a b) */
4111: a.order_source_id
4112: , a.original_sys_document_ref
4113: , a.change_sequence

Line 4116: FROM oe_processing_msgs a, oe_processing_msgs_tl b

4112: , a.original_sys_document_ref
4113: , a.change_sequence
4114: , a.original_sys_document_line_ref
4115: , b.message_text
4116: FROM oe_processing_msgs a, oe_processing_msgs_tl b
4117: WHERE a.request_id = l_concurrent_id
4118: AND a.transaction_id = b.transaction_id
4119: AND b.language = oe_globals.g_lang
4120: ORDER BY a.order_source_id, a.original_sys_document_ref, a.change_sequence;