[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_jsp_lov_sql := 'select WF_NOTIFICATION.SubstituteSpecialChars(Meaning) col1_value, lookup_code col2_value from ar_lookups where lookup_type = ''HZ_PARTY_CERT_LEVEL'' ';
select distinct jsp_lov_sql into l_jsp_lov_sql
from jtf_qual_usgs_all
where qual_usg_id = l_in_filter_lov_rec.column1;
SELECT count(*)
INTO l_total_count
from jtf_sources
where UPPER(meaning) like NVL(l_column1, '%');
Select WF_NOTIFICATION.SubstituteSpecialChars(meaning), source_id, null, null, null,
null, null, null, null, null,
null, null, null, null, null,
null, null, null, null, null
from jtf_sources
where UPPER(meaning) like NVL(l_column1, '%')
order by meaning;
SELECT count(*)
INTO l_total_count
from jtf_seeded_qual_usgs_v
where UPPER(seeded_qual_name) like NVL(l_column1, '%') || '%'
-- and source_id = l_column2
and enabled_flag = 'Y';
Select distinct WF_NOTIFICATION.SubstituteSpecialChars(jsquv.seeded_qual_name) sqname, jsquv.qual_usg_id, jsquv.qual_type_id,
jsquv.source_id, jsquv.qual_col1_alias,
null, null, null, null, null,
null, null, null, null, null,
null, null, null, null, null
from jtf_seeded_qual_usgs_v jsquv
where UPPER(seeded_qual_name) like NVL(l_column1, '%') || '%'
and source_id = NVL(l_column2, source_id)
and enabled_flag = 'Y'
order by jsquv.source_id, sqname;
SELECT distinct count(*)
INTO l_total_count
from jtf_terr_resources_v jtrv
where UPPER(resource_name) like NVL(l_column1, '%') || '%'
-- ARPATEL09/08/2003 bug#2966686 fix
or l_column1 = '%';
Select distinct WF_NOTIFICATION.SubstituteSpecialChars(resource_name), resource_id,
resource_type, null, null,
null, null, null, null, null,
null, null, null, null, null,
null, null, null, null, null
from jtf_terr_resources_v jtrv
where (UPPER(resource_name) like NVL(l_column1, '%') || '%'
-- ARPATEL09/08/2003 bug#2966686 fix
or l_column1 = '%')
AND EXISTS ( SELECT NULL
FROM jtf_terr_denorm_rules_all jtdr
WHERE jtdr.source_id = NVL(l_column2, source_id)
AND jtdr.terr_id = jtrv.terr_id
AND JTDR.RELATED_TERR_ID = JTRV.TERR_ID)
order by resource_name;
/* select WF_NOTIFICATION.SubstituteSpecialChars(seeded_qual_name), qual_usg_id, Decode(jsp_lov_sql, null, 'N', 'Y'),
qual_col1_alias, display_type,
seeded_qual_id, null, null, null, null,
null, null, null, null, null,
null, null, null, null, null
from jtf_seeded_qual_usgs_v
where use_in_lookup_flag = 'Y'
and enabled_flag = 'Y'
and source_id = -1001
ARPATEL BUG#3736597 fix
and qual_col1_alias is not null
order by display_sequence;*/ --commented for bug 7237992.
SELECT distinct WF_NOTIFICATION.SubstituteSpecialChars(jsq.name), jqu.qual_usg_id, Decode(jqu.jsp_lov_sql, null, 'N', 'Y'),
jqu.qual_col1_alias, jqu.display_type,
jsq.seeded_qual_id, null, null, null, null,
null, null, null, null, null,
null, null, null, null, null
FROM jtf_qual_usgs_all jqu, jtf_seeded_qual_all_b jsq,jtf_qual_type_usgs_all jqtu,
jtf_qual_types_all jqt ,jtf_sources_all js
WHERE jqu.use_in_lookup_flag = 'Y'
and jqu.enabled_flag = 'Y'
and jqtu.qual_type_id = jqt.qual_type_id
and jqtu.qual_type_usg_id = jqu.qual_type_usg_id
and jsq.seeded_qual_id = jqu.seeded_qual_id
and js.source_id = jqtu.source_id
and js.source_id= -1001
and jqu.qual_col1_alias is not null;
select '--------------', '-------------', ' ', ' ', ' ',
null, null, null, null, null,
null, null, null, null, null,
null, null, null, null, null
from dual;
select trunc(sysdate), null, null, null, null,
null, null, null, null, null,
null, null, null, null, null,
null, null, null, null, null
from dual;
SELECT count(*)
INTO l_total_count
from JTF_TERR_RESOURCES_V
where (end_date_active is null or end_date_active >= sysdate)
and group_id is not null;
Select distinct jtr.group_name, jtr.group_id, null, null, null,
null, null, null, null, null,
null, null, null, null, null,
null, null, null, null, null
from JTF_TERR_RESOURCES_V jtr
where (jtr.end_date_active is null or jtr.end_date_active >= sysdate)
and jtr.group_id is not null
AND EXISTS ( SELECT NULL
FROM jtf_terr_denorm_rules_all jtdr
WHERE jtdr.source_id = -1001
AND jtdr.terr_id = jtr.terr_id
AND JTDR.RELATED_TERR_ID = JTR.TERR_ID )
order by group_name;