APPS.FND_CP_OPP_IPC SQL Statements

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

Line: 126

    stmt := 'select count(*) from ' ||
	        Q_Schema || '.aq$' || QUEUE_NAME || 'TBL_S qtab, ' ||
	        'fnd_concurrent_processes fcp ' ||
	        'where qtab.queue = ''' || QUEUE_NAME ||
	        ''' and fcp.node_name = :1 ' ||
	        ' and fcp.process_status_code in (''A'',''Z'') ' ||
	        ' and qtab.name = ''' || OPPPREFIX || ''' || fcp.concurrent_process_id';

Line: 145

function select_random_subscriber return varchar2 is

stmt         varchar2(512);

Line: 153

  stmt := 'select * ' ||
          'from ' ||
          '( ' ||
          'select name from ' || Q_Schema || '.aq$' || QUEUE_NAME || 'TBL_S ' ||
          'ORDER BY DBMS_RANDOM.VALUE ' ||
          ') where rownum = 1';

Line: 187

	  'select name from ' || Q_Schema || '.aq$' || QUEUE_NAME || 'TBL_S ' || ' where QUEUE = ''' || QUEUE_NAME || '''';

Line: 212

	    'select name from ' || Q_Schema || '.aq$' || QUEUE_NAME || 'TBL_S' || ' where QUEUE = ''' || QUEUE_NAME || '''';