[Home] [Help]
8: /* This is for creating the lines row for 824 */
9:
10: cursor get_header_error_rows is
11: select error_message, error_message_name
12: from po_interface_errors pie
13: where
14: pie.interface_header_id = X_interface_header.header_record.header_interface_id and
15: pie.interface_line_id is null;
16:
15: pie.interface_line_id is null;
16:
17: /* This is for creating the lines row for 824 */
18: /* Bug 2533087 - The nvl on interface_header_id was causing a performance issue as
19: index was not being used which resulted in a full table scan on po_interface_errors.
20: The interface_header_id can be null only in the case of error messages inserted
21: for transactions that are processed thru forms.
22: But we generate Application advices for errors that occur while processing
23: the ROI. Not for errors generated thru forms. So we can remove the nvl condition.
26:
27: cursor get_line_error_rows is
28: select item_num, document_num, document_line_num,
29: barcode_label, error_message, error_message_name
30: from rcv_transactions_interface rti, po_interface_errors pie
31: where pie.interface_line_id = rti.interface_transaction_id and
32: pie.interface_header_id =
33: X_interface_header.header_record.header_interface_id and
34: pie.interface_line_id is not null and
37: /* NWANG 9/4/97 */
38: CURSOR get_receipt_line_rows IS
39: SELECT msi.concatenated_segments, poh.segment1, pol.line_num, rsl.bar_code_label,
40: error_message, error_message_name
41: FROM po_interface_errors pie, rcv_shipment_lines rsl ,
42: mtl_system_items_kfv msi, po_headers poh, po_lines pol
43: WHERE pol.po_line_id = rsl.po_line_id
44: AND poh.po_header_id = rsl.po_header_id
45: AND msi.inventory_item_id (+)= rsl.item_id