APPS.OE_PREPAYMENT_UTIL dependencies on OE_PROCESSING_MSGS

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

515: -----------------------------------------------------------
516: */
517: CURSOR l_msg_cursor IS
518:
519: SELECT /*+ INDEX (a,OE_PROCESSING_MSGS_N2)
520: USE_NL (a b) */
521: a.header_id
522: , a.order_source_id
523: , a.original_sys_document_ref

Line 528: FROM oe_processing_msgs a, oe_processing_msgs_tl b

524: , a.source_document_id
525: , a.change_sequence
526: , a.source_document_type_id
527: , b.message_text
528: FROM oe_processing_msgs a, oe_processing_msgs_tl b
529: WHERE a.request_id = l_request_id
530: AND a.transaction_id = b.transaction_id
531: AND b.language = oe_globals.g_lang
532: ORDER BY a.order_source_id, a.original_sys_document_ref, a.header_id;