APPS.OE_XML_PROCESS_UTIL dependencies on OE_PROCESSING_MSGS

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

387:
388: )
389: IS
390: CURSOR l_msg_cursor_hdr IS
391: SELECT /*+ INDEX (a,OE_PROCESSING_MSGS_N2)
392: USE_NL (a b) */
393: a.order_source_id
394: , a.original_sys_document_ref
395: , b.message_text

Line 396: FROM oe_processing_msgs a, oe_processing_msgs_tl b

392: USE_NL (a b) */
393: a.order_source_id
394: , a.original_sys_document_ref
395: , b.message_text
396: FROM oe_processing_msgs a, oe_processing_msgs_tl b
397: WHERE a.request_id = p_request_id
398: AND a.order_source_id = p_order_source_id
399: AND a.original_sys_document_ref = p_orig_sys_document_ref
400: AND (a.org_id is null or a.org_id = p_org_id)

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

402: AND a.transaction_id = b.transaction_id
403: AND b.language = oe_globals.g_lang;
404:
405: CURSOR l_msg_cursor_line IS
406: SELECT /*+ INDEX (a,OE_PROCESSING_MSGS_N2)
407: USE_NL (a b) */
408: a.order_source_id
409: , a.original_sys_document_ref
410: , a.original_sys_document_line_ref

Line 412: FROM oe_processing_msgs a, oe_processing_msgs_tl b

408: a.order_source_id
409: , a.original_sys_document_ref
410: , a.original_sys_document_line_ref
411: , b.message_text
412: FROM oe_processing_msgs a, oe_processing_msgs_tl b
413: WHERE a.request_id = p_request_id
414: AND a.order_source_id = p_order_source_id
415: AND a.original_sys_document_ref = p_orig_sys_document_ref
416: AND a.original_sys_document_line_ref = p_orig_sys_line_ref