eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_KNOWLEDGE_PVT dependencies on CS_KB_SETS_TL

Line 1315: update cs_kb_sets_tl set

1311: where set_id = p_set_id;
1312: end if;
1313:
1314: -- touch related sets to update interMedia index
1315: update cs_kb_sets_tl set
1316: positive_assoc_index = 'c',
1317: negative_assoc_index = 'c',
1318: composite_assoc_index = 'c',
1319: composite_assoc_attach_index = 'c' --12.1.3

Line 1414: update cs_kb_sets_tl set

1410: where set_id = p_set_id;
1411: end if;
1412:
1413: -- touch related sets to update interMedia index
1414: update cs_kb_sets_tl set
1415: positive_assoc_index = 'c',
1416: negative_assoc_index = 'c',
1417: composite_assoc_index = 'c',
1418: composite_assoc_attach_index = 'c' --12.1.3

Line 3829: ' select /+ FIRST_ROWS / cs_kb_sets_tl.set_id id, score(10) score, cs_kb_sets_b.set_type_id,'||

3825: l_sql_srows varchar2(30) :=
3826: ' select count(*) ';
3827:
3828: l_sql_s varchar2(500) :=
3829: ' select /*+ FIRST_ROWS */ cs_kb_sets_tl.set_id id, score(10) score, cs_kb_sets_b.set_type_id,'||
3830: ' cs_kb_sets_tl.name, cs_kb_sets_tl.description, '||
3831: ' cs_kb_sets_b.creation_date, cs_kb_sets_b.created_by,'||
3832: ' cs_kb_sets_b.last_update_date, cs_kb_sets_b.last_updated_by, '||
3833: ' cs_kb_sets_b.last_update_login, cs_kb_set_types_tl.name, '||

Line 3830: ' cs_kb_sets_tl.name, cs_kb_sets_tl.description, '||

3826: ' select count(*) ';
3827:
3828: l_sql_s varchar2(500) :=
3829: ' select /*+ FIRST_ROWS */ cs_kb_sets_tl.set_id id, score(10) score, cs_kb_sets_b.set_type_id,'||
3830: ' cs_kb_sets_tl.name, cs_kb_sets_tl.description, '||
3831: ' cs_kb_sets_b.creation_date, cs_kb_sets_b.created_by,'||
3832: ' cs_kb_sets_b.last_update_date, cs_kb_sets_b.last_updated_by, '||
3833: ' cs_kb_sets_b.last_update_login, cs_kb_set_types_tl.name, '||
3834: ' cs_kb_sets_b.set_number ';

Line 3836: ' from cs_kb_sets_tl, cs_kb_sets_b, cs_kb_set_types_tl ';

3832: ' cs_kb_sets_b.last_update_date, cs_kb_sets_b.last_updated_by, '||
3833: ' cs_kb_sets_b.last_update_login, cs_kb_set_types_tl.name, '||
3834: ' cs_kb_sets_b.set_number ';
3835: l_sql_f1 varchar2(100) :=
3836: ' from cs_kb_sets_tl, cs_kb_sets_b, cs_kb_set_types_tl ';
3837:
3838: l_sql_w1 varchar2(200) :=
3839: ' where contains(cs_kb_sets_tl.composite_assoc_index, :a1, 10)>0 ';
3840: l_sql_wrows varchar2(200) :=

Line 3839: ' where contains(cs_kb_sets_tl.composite_assoc_index, :a1, 10)>0 ';

3835: l_sql_f1 varchar2(100) :=
3836: ' from cs_kb_sets_tl, cs_kb_sets_b, cs_kb_set_types_tl ';
3837:
3838: l_sql_w1 varchar2(200) :=
3839: ' where contains(cs_kb_sets_tl.composite_assoc_index, :a1, 10)>0 ';
3840: l_sql_wrows varchar2(200) :=
3841: ' where contains(cs_kb_sets_tl.composite_assoc_index, :a1)>0 ';
3842: l_sql_w varchar2(500) :=
3843: -- 3398078

Line 3841: ' where contains(cs_kb_sets_tl.composite_assoc_index, :a1)>0 ';

3837:
3838: l_sql_w1 varchar2(200) :=
3839: ' where contains(cs_kb_sets_tl.composite_assoc_index, :a1, 10)>0 ';
3840: l_sql_wrows varchar2(200) :=
3841: ' where contains(cs_kb_sets_tl.composite_assoc_index, :a1)>0 ';
3842: l_sql_w varchar2(500) :=
3843: -- 3398078
3844: ' and cs_kb_sets_tl.set_id = cs_kb_sets_b.set_id '||
3845: -- ' and cs_kb_sets_tl.language=userenv(''LANG'') ' ||

Line 3844: ' and cs_kb_sets_tl.set_id = cs_kb_sets_b.set_id '||

3840: l_sql_wrows varchar2(200) :=
3841: ' where contains(cs_kb_sets_tl.composite_assoc_index, :a1)>0 ';
3842: l_sql_w varchar2(500) :=
3843: -- 3398078
3844: ' and cs_kb_sets_tl.set_id = cs_kb_sets_b.set_id '||
3845: -- ' and cs_kb_sets_tl.language=userenv(''LANG'') ' ||
3846: ' and cs_kb_set_types_tl.set_type_id = cs_kb_sets_b.set_type_id '||
3847: ' and cs_kb_set_types_tl.language=userenv(''LANG'') '; -- ||
3848:

Line 3845: -- ' and cs_kb_sets_tl.language=userenv(''LANG'') ' ||

3841: ' where contains(cs_kb_sets_tl.composite_assoc_index, :a1)>0 ';
3842: l_sql_w varchar2(500) :=
3843: -- 3398078
3844: ' and cs_kb_sets_tl.set_id = cs_kb_sets_b.set_id '||
3845: -- ' and cs_kb_sets_tl.language=userenv(''LANG'') ' ||
3846: ' and cs_kb_set_types_tl.set_type_id = cs_kb_sets_b.set_type_id '||
3847: ' and cs_kb_set_types_tl.language=userenv(''LANG'') '; -- ||
3848:
3849: l_sql_o varchar2(100) := ' order by score desc ';

Line 4038: ' select /+ FIRST_ROWS / cs_kb_sets_tl.set_id id, score(10) score, cs_kb_sets_b.set_type_id,'||

4034: l_sql_srows varchar2(30) :=
4035: ' select count(*) ';
4036:
4037: l_sql_s varchar2(500) :=
4038: ' select /*+ FIRST_ROWS */ cs_kb_sets_tl.set_id id, score(10) score, cs_kb_sets_b.set_type_id,'||
4039: ' cs_kb_sets_tl.name, cs_kb_sets_tl.description, '||
4040: ' cs_kb_sets_b.creation_date, cs_kb_sets_b.created_by,'||
4041: ' cs_kb_sets_b.last_update_date, cs_kb_sets_b.last_updated_by, '||
4042: ' cs_kb_sets_b.last_update_login, cs_kb_set_types_tl.name ' ||

Line 4039: ' cs_kb_sets_tl.name, cs_kb_sets_tl.description, '||

4035: ' select count(*) ';
4036:
4037: l_sql_s varchar2(500) :=
4038: ' select /*+ FIRST_ROWS */ cs_kb_sets_tl.set_id id, score(10) score, cs_kb_sets_b.set_type_id,'||
4039: ' cs_kb_sets_tl.name, cs_kb_sets_tl.description, '||
4040: ' cs_kb_sets_b.creation_date, cs_kb_sets_b.created_by,'||
4041: ' cs_kb_sets_b.last_update_date, cs_kb_sets_b.last_updated_by, '||
4042: ' cs_kb_sets_b.last_update_login, cs_kb_set_types_tl.name ' ||
4043: ' cs_kb_sets_b.set_number ';

Line 4045: ' from cs_kb_sets_tl, cs_kb_sets_b, cs_kb_set_types_tl ';

4041: ' cs_kb_sets_b.last_update_date, cs_kb_sets_b.last_updated_by, '||
4042: ' cs_kb_sets_b.last_update_login, cs_kb_set_types_tl.name ' ||
4043: ' cs_kb_sets_b.set_number ';
4044: l_sql_f1 varchar2(100) :=
4045: ' from cs_kb_sets_tl, cs_kb_sets_b, cs_kb_set_types_tl ';
4046:
4047: l_sql_w1 varchar2(200) :=
4048: ' where contains(cs_kb_sets_tl.composite_assoc_index, :1, 10)>0 ';
4049: l_sql_w varchar2(500) :=

Line 4048: ' where contains(cs_kb_sets_tl.composite_assoc_index, :1, 10)>0 ';

4044: l_sql_f1 varchar2(100) :=
4045: ' from cs_kb_sets_tl, cs_kb_sets_b, cs_kb_set_types_tl ';
4046:
4047: l_sql_w1 varchar2(200) :=
4048: ' where contains(cs_kb_sets_tl.composite_assoc_index, :1, 10)>0 ';
4049: l_sql_w varchar2(500) :=
4050: -- 3398078
4051: ' and cs_kb_sets_tl.set_id = cs_kb_sets_b.set_id '||
4052: ' and cs_kb_set_types_tl.set_type_id = cs_kb_sets_b.set_type_id '||

Line 4051: ' and cs_kb_sets_tl.set_id = cs_kb_sets_b.set_id '||

4047: l_sql_w1 varchar2(200) :=
4048: ' where contains(cs_kb_sets_tl.composite_assoc_index, :1, 10)>0 ';
4049: l_sql_w varchar2(500) :=
4050: -- 3398078
4051: ' and cs_kb_sets_tl.set_id = cs_kb_sets_b.set_id '||
4052: ' and cs_kb_set_types_tl.set_type_id = cs_kb_sets_b.set_type_id '||
4053: ' and cs_kb_set_types_tl.language=userenv(''LANG'') ';
4054:
4055: l_sql_o varchar2(100) := ' order by score desc ';