APPS.BIS_BIA_MSGLOG_PKG SQL Statements

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

Line: 65

SELECT /*+ index(a , fnd_log_messages_u1) */
b.PROGRESS_NAME BIS_LOG_MODULE,
a.MESSAGE_TEXT BIS_LOG_MESSAGE_TEXT,
b.DURATION_TXT BIS_LOG_DURATION,
b.START_DATE_TXT BIS_LOG_START,
b.END_DATE_TXT BIS_LOG_END
FROM FND_LOG_MESSAGES a ,
    (SELECT /*+ ordered */
     max(timestamp)  over( partition by msg.session_id,module)   max_timestamp,
     max(log_sequence) over(partition by msg.session_id,module)   max_seq,
     min(timestamp)  over( partition by msg.session_id,module)   min_timestamp,
     min(log_sequence) over(partition by msg.session_id,module)   min_seq,
     msg.session_id,
     substr(MODULE, instr(MODULE, '''|| bis_prefix ||''') + 4 , instr(MODULE, ''.'', 1, 2 ) - instr(MODULE, '''|| bis_prefix ||''') - 4  ) OBJECT_KEY,
     substr(MODULE, instr(MODULE, '''|| bis_prefix ||''') + 4,  instr(MODULE, ''__'') - instr(MODULE, '''|| bis_prefix ||''') - 4  ) OBJECT_NAME,
     substr(MODULE, instr(MODULE, ''__'', 1, 2) + 2 , instr(MODULE, ''.'', -1, 2) - instr(MODULE, ''__'', 1, 2) -2 ) OBJECT_TYPE,
     substr(MODULE, instr(MODULE, ''.'', -1, 2) + 1, instr(MODULE, ''.'', -1, 1) - instr(MODULE, ''.'', -1, 2) -1 ) PROGRESS_NAME,
     substr(MESSAGE_TEXT, 1, instr(MESSAGE_TEXT,''#'', 1, 1) -1 ) START_DATE_TXT,
     substr(MESSAGE_TEXT, instr(MESSAGE_TEXT,''#'', 1, 1) + 1, instr(MESSAGE_TEXT,''#'', 1, 2) - instr(MESSAGE_TEXT,''#'', 1, 1) -1) END_DATE_TXT,
     substr(MESSAGE_TEXT, instr(MESSAGE_TEXT,''#'', 1, 2) + 1, length(MESSAGE_TEXT)) DURATION_TXT
     FROM FND_LOG_TRANSACTION_CONTEXT ctx, fnd_log_messages msg
         where msg.session_id = :BIS_ICX_SESSION_ID
         and msg.log_level = 6
         and msg.module like &BIS_OBJECT_KEY
         AND ctx.TRANSACTION_CONTEXT_ID = msg.TRANSACTION_CONTEXT_ID
         AND ctx.creation_date > sysdate - 0.5
         AND msg.session_id = ctx.session_id
         and ctx.session_id = :BIS_ICX_SESSION_ID
         and msg.timestamp between sysdate - 0.5 and sysdate
    ) b
where a.session_id = b.session_id
and b.START_DATE_TXT is not null
and b.max_seq >= a.log_sequence
and b.min_seq <= a.log_sequence
and b.max_timestamp >= a.timestamp
and b.min_timestamp <= a.timestamp
and a.module like '''|| bis_prefix ||'''||b.object_key||''.''|| b.PROGRESS_NAME ||''.%''
and substr(MODULE, instr(MODULE, ''.'', -1, 1) +1, length(MODULE) - instr(MODULE, ''.'', -1, 1) ) <> ''TIME''
and upper(a.message_text) like UPPER(:BIS_MSG_CRT)
&ORDER_BY_CLAUSE NULLS LAST';