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 1313: update cs_kb_sets_tl set

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

Line 1411: update cs_kb_sets_tl set

1407: where set_id = p_set_id;
1408: end if;
1409:
1410: -- touch related sets to update interMedia index
1411: update cs_kb_sets_tl set
1412: positive_assoc_index = 'c',
1413: negative_assoc_index = 'c',
1414: composite_assoc_index = 'c'
1415: where set_id = p_set_id;

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

3800: l_sql_srows varchar2(30) :=
3801: ' select count(*) ';
3802:
3803: l_sql_s varchar2(500) :=
3804: ' select /*+ FIRST_ROWS */ cs_kb_sets_tl.set_id id, score(10) score, cs_kb_sets_b.set_type_id,'||
3805: ' cs_kb_sets_tl.name, cs_kb_sets_tl.description, '||
3806: ' cs_kb_sets_b.creation_date, cs_kb_sets_b.created_by,'||
3807: ' cs_kb_sets_b.last_update_date, cs_kb_sets_b.last_updated_by, '||
3808: ' cs_kb_sets_b.last_update_login, cs_kb_set_types_tl.name, '||

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

3801: ' select count(*) ';
3802:
3803: l_sql_s varchar2(500) :=
3804: ' select /*+ FIRST_ROWS */ cs_kb_sets_tl.set_id id, score(10) score, cs_kb_sets_b.set_type_id,'||
3805: ' cs_kb_sets_tl.name, cs_kb_sets_tl.description, '||
3806: ' cs_kb_sets_b.creation_date, cs_kb_sets_b.created_by,'||
3807: ' cs_kb_sets_b.last_update_date, cs_kb_sets_b.last_updated_by, '||
3808: ' cs_kb_sets_b.last_update_login, cs_kb_set_types_tl.name, '||
3809: ' cs_kb_sets_b.set_number ';

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

3807: ' cs_kb_sets_b.last_update_date, cs_kb_sets_b.last_updated_by, '||
3808: ' cs_kb_sets_b.last_update_login, cs_kb_set_types_tl.name, '||
3809: ' cs_kb_sets_b.set_number ';
3810: l_sql_f1 varchar2(100) :=
3811: ' from cs_kb_sets_tl, cs_kb_sets_b, cs_kb_set_types_tl ';
3812:
3813: l_sql_w1 varchar2(200) :=
3814: ' where contains(cs_kb_sets_tl.composite_assoc_index, :a1, 10)>0 ';
3815: l_sql_wrows varchar2(200) :=

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

3810: l_sql_f1 varchar2(100) :=
3811: ' from cs_kb_sets_tl, cs_kb_sets_b, cs_kb_set_types_tl ';
3812:
3813: l_sql_w1 varchar2(200) :=
3814: ' where contains(cs_kb_sets_tl.composite_assoc_index, :a1, 10)>0 ';
3815: l_sql_wrows varchar2(200) :=
3816: ' where contains(cs_kb_sets_tl.composite_assoc_index, :a1)>0 ';
3817: l_sql_w varchar2(500) :=
3818: -- 3398078

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

3812:
3813: l_sql_w1 varchar2(200) :=
3814: ' where contains(cs_kb_sets_tl.composite_assoc_index, :a1, 10)>0 ';
3815: l_sql_wrows varchar2(200) :=
3816: ' where contains(cs_kb_sets_tl.composite_assoc_index, :a1)>0 ';
3817: l_sql_w varchar2(500) :=
3818: -- 3398078
3819: ' and cs_kb_sets_tl.set_id = cs_kb_sets_b.set_id '||
3820: -- ' and cs_kb_sets_tl.language=userenv(''LANG'') ' ||

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

3815: l_sql_wrows varchar2(200) :=
3816: ' where contains(cs_kb_sets_tl.composite_assoc_index, :a1)>0 ';
3817: l_sql_w varchar2(500) :=
3818: -- 3398078
3819: ' and cs_kb_sets_tl.set_id = cs_kb_sets_b.set_id '||
3820: -- ' and cs_kb_sets_tl.language=userenv(''LANG'') ' ||
3821: ' and cs_kb_set_types_tl.set_type_id = cs_kb_sets_b.set_type_id '||
3822: ' and cs_kb_set_types_tl.language=userenv(''LANG'') '; -- ||
3823:

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

3816: ' where contains(cs_kb_sets_tl.composite_assoc_index, :a1)>0 ';
3817: l_sql_w varchar2(500) :=
3818: -- 3398078
3819: ' and cs_kb_sets_tl.set_id = cs_kb_sets_b.set_id '||
3820: -- ' and cs_kb_sets_tl.language=userenv(''LANG'') ' ||
3821: ' and cs_kb_set_types_tl.set_type_id = cs_kb_sets_b.set_type_id '||
3822: ' and cs_kb_set_types_tl.language=userenv(''LANG'') '; -- ||
3823:
3824: l_sql_o varchar2(100) := ' order by score desc ';

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

4009: l_sql_srows varchar2(30) :=
4010: ' select count(*) ';
4011:
4012: l_sql_s varchar2(500) :=
4013: ' select /*+ FIRST_ROWS */ cs_kb_sets_tl.set_id id, score(10) score, cs_kb_sets_b.set_type_id,'||
4014: ' cs_kb_sets_tl.name, cs_kb_sets_tl.description, '||
4015: ' cs_kb_sets_b.creation_date, cs_kb_sets_b.created_by,'||
4016: ' cs_kb_sets_b.last_update_date, cs_kb_sets_b.last_updated_by, '||
4017: ' cs_kb_sets_b.last_update_login, cs_kb_set_types_tl.name ' ||

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

4010: ' select count(*) ';
4011:
4012: l_sql_s varchar2(500) :=
4013: ' select /*+ FIRST_ROWS */ cs_kb_sets_tl.set_id id, score(10) score, cs_kb_sets_b.set_type_id,'||
4014: ' cs_kb_sets_tl.name, cs_kb_sets_tl.description, '||
4015: ' cs_kb_sets_b.creation_date, cs_kb_sets_b.created_by,'||
4016: ' cs_kb_sets_b.last_update_date, cs_kb_sets_b.last_updated_by, '||
4017: ' cs_kb_sets_b.last_update_login, cs_kb_set_types_tl.name ' ||
4018: ' cs_kb_sets_b.set_number ';

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

4016: ' cs_kb_sets_b.last_update_date, cs_kb_sets_b.last_updated_by, '||
4017: ' cs_kb_sets_b.last_update_login, cs_kb_set_types_tl.name ' ||
4018: ' cs_kb_sets_b.set_number ';
4019: l_sql_f1 varchar2(100) :=
4020: ' from cs_kb_sets_tl, cs_kb_sets_b, cs_kb_set_types_tl ';
4021:
4022: l_sql_w1 varchar2(200) :=
4023: ' where contains(cs_kb_sets_tl.composite_assoc_index, :1, 10)>0 ';
4024: l_sql_w varchar2(500) :=

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

4019: l_sql_f1 varchar2(100) :=
4020: ' from cs_kb_sets_tl, cs_kb_sets_b, cs_kb_set_types_tl ';
4021:
4022: l_sql_w1 varchar2(200) :=
4023: ' where contains(cs_kb_sets_tl.composite_assoc_index, :1, 10)>0 ';
4024: l_sql_w varchar2(500) :=
4025: -- 3398078
4026: ' and cs_kb_sets_tl.set_id = cs_kb_sets_b.set_id '||
4027: ' and cs_kb_set_types_tl.set_type_id = cs_kb_sets_b.set_type_id '||

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

4022: l_sql_w1 varchar2(200) :=
4023: ' where contains(cs_kb_sets_tl.composite_assoc_index, :1, 10)>0 ';
4024: l_sql_w varchar2(500) :=
4025: -- 3398078
4026: ' and cs_kb_sets_tl.set_id = cs_kb_sets_b.set_id '||
4027: ' and cs_kb_set_types_tl.set_type_id = cs_kb_sets_b.set_type_id '||
4028: ' and cs_kb_set_types_tl.language=userenv(''LANG'') ';
4029:
4030: l_sql_o varchar2(100) := ' order by score desc ';