APPS.IEM_DIAG_KB_DOC_PVT SQL Statements

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

Line: 43

		SELECT theme,score*10 score
		FROM IEM_THEMES
		WHERE CLASSIFICATION_ID=l_classification_id
		AND QUERY_RESPONSE='R'
		and score>0
		order by score desc;

Line: 52

   JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

Line: 58

   select count(*) into l_account_count from iem_email_accounts
   where UPPER(email_user)=UPPER(c_account) and UPPER(domain)=UPPER(c_domain);

Line: 70

   select count(*) into l_classification_count from iem_email_accounts a, iem_classifications b
   where a.email_account_id=b.email_account_id and upper(a.email_user)=upper(c_account)
   and UPPER(a.domain)=UPPER(c_domain)
   and UPPER(b.classification)=UPPER(c_intent);

Line: 83

   select b.classification_id into l_classification_id from iem_email_accounts a, iem_classifications b
   where a.email_account_id=b.email_account_id and upper(a.email_user)=upper(c_account)
   and UPPER(b.classification)=UPPER(c_intent);

Line: 87

   l_imt_string1 := 'select b.item_id,fl.file_name , cim.channel_category_id , score(1) score from jtf_amv_items_vl b, jtf_amv_attachments a, fnd_lobs fl,  amv_c_chl_item_match cim where contains(file_data,''';

Line: 93

   SELECT count(*) into l_theme_count FROM IEM_THEMES
   WHERE CLASSIFICATION_ID=l_classification_id AND QUERY_RESPONSE='R' and score>0;

Line: 113

	select replace(v1.theme, '''', '') into l_theme from dual;