APPS.OE_ORDER_IMPORT_MAIN_PVT dependencies on OE_PROCESSING_MSGS

Line 221: FROM oe_processing_msgs_vl

217: , original_sys_document_ref
218: , change_sequence
219: , original_sys_document_line_ref
220: , message_text
221: FROM oe_processing_msgs_vl
222: WHERE request_id = l_request_id
223: ORDER BY order_source_id, original_sys_document_ref, change_sequence
224: ;
225:

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

225:
226:
227: */
228: -- changed to
229: SELECT /*+ INDEX (a,OE_PROCESSING_MSGS_N2)
230: USE_NL (a b) */
231: a.order_source_id
232: , a.original_sys_document_ref
233: , a.change_sequence

Line 237: FROM oe_processing_msgs a, oe_processing_msgs_tl b

233: , a.change_sequence
234: , a.original_sys_document_line_ref
235: , a.org_id
236: , b.message_text
237: FROM oe_processing_msgs a, oe_processing_msgs_tl b
238: WHERE a.request_id = l_request_id
239: AND a.transaction_id = b.transaction_id
240: AND b.language = oe_globals.g_lang
241: ORDER BY a.order_source_id, a.original_sys_document_ref, a.change_sequence

Line 1128: FROM oe_processing_msgs_vl

1124: fnd_file.put_line(FND_FILE.OUTPUT,'');
1125:
1126:
1127: /* SELECT count(*) INTO l_count_msgs
1128: FROM oe_processing_msgs_vl
1129: WHERE request_id = l_request_id;
1130:
1131: IF l_count_msgs > 0 THEN
1132: fnd_file.put_line(FND_FILE.OUTPUT,'No. of messages: '||l_count_msgs);