APPS.OE_MESSAGE_PURGE_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 41

    SELECT m.transaction_id,
           m.rowid,
           o.order_number,
           o.order_type_id,
           o.sold_to_org_id,
           m.message_status_code
    FROM   oe_processing_msgs m, oe_order_headers_all o
    WHERE  m.header_id = o.header_id (+)
    AND    NVL(m.message_source_code, 'NULL') =
			NVL(p_message_source, NVL(m.message_source_code, 'NULL'))
    AND    TRUNC(m.creation_date) BETWEEN NVL(l_start, TRUNC(m.creation_date))
                                AND NVL(l_end, TRUNC(m.creation_date));

Line: 122

      DELETE oe_processing_msgs_tl
      WHERE  transaction_id = c_msg.transaction_id;

Line: 124

      DELETE oe_processing_msgs
      WHERE ROWID = c_msg.rowid;