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_KB_CTX_PKG dependencies on CS_KB_SETS_B

Line 144: FROM CS_KB_SETS_TL tl, CS_KB_SETS_B b

140: b.status,
141: tl.content_cache,
142: b.set_number,
143: b.set_type_id
144: FROM CS_KB_SETS_TL tl, CS_KB_SETS_B b
145: WHERE tl.ROWID = p_rowid
146: AND b.set_id = tl.set_id;
147:
148: l_set_number VARCHAR2(30);

Line 157: from CS_KB_SETS_TL tl, CS_KB_SETS_B b

153: /*
154: -- Get the solution id and language, based on the rowid
155: select tl.set_id, tl.language, b.status, tl.content_cache
156: into l_solnid, l_lang, l_status, l_clob
157: from CS_KB_SETS_TL tl, CS_KB_SETS_B b
158: where tl.rowid = p_rowid
159: and b.set_id = tl.set_id;
160: */
161: OPEN set_content_csr(p_rowid);

Line 442: FROM CS_KB_SETS_TL tl, CS_KB_SETS_B b

438: b.status,
439: tl.attachment_content_cache,
440: b.set_number,
441: b.set_type_id
442: FROM CS_KB_SETS_TL tl, CS_KB_SETS_B b
443: WHERE tl.ROWID = p_rowid
444: AND b.set_id = tl.set_id;
445:
446: l_set_number VARCHAR2(30);

Line 455: from CS_KB_SETS_TL tl, CS_KB_SETS_B b

451: /*
452: -- Get the solution id and language, based on the rowid
453: select tl.set_id, tl.language, b.status, tl.content_cache
454: into l_solnid, l_lang, l_status, l_clob
455: from CS_KB_SETS_TL tl, CS_KB_SETS_B b
456: where tl.rowid = p_rowid
457: and b.set_id = tl.set_id;
458: */
459: OPEN set_content_csr(p_rowid);

Line 583: AND fad.entity_name = 'CS_KB_SETS_B'

579: WHERE fad.document_id = fd.document_id
580: AND fd.document_id = fdtl.document_id
581: AND fl.file_id = fd.media_id
582: AND fdtl.language = c_lang
583: AND fad.entity_name = 'CS_KB_SETS_B'
584: AND fad.pk1_value = c_setid;
585:
586: l_clob CLOB := NULL;
587: l_clob_len NUMBER;

Line 984: FROM CS_KB_SETS_B b, CS_KB_SETS_TL tl

980: p_temp_clob IN OUT NOCOPY CLOB)
981: IS
982: CURSOR c2(c_set_id IN NUMBER, c_lang IN VARCHAR2) IS
983: SELECT b.set_number, tl.name
984: FROM CS_KB_SETS_B b, CS_KB_SETS_TL tl
985: WHERE b.set_id = c_set_id
986: AND tl.set_id = b.set_id
987: AND tl.LANGUAGE = c_lang;
988:

Line 1021: FROM CS_KB_SETS_B

1017: p_clob IN OUT NOCOPY CLOB)
1018: IS
1019: CURSOR c2(c_set_id IN NUMBER) IS
1020: SELECT set_type_id, set_number
1021: FROM CS_KB_SETS_B
1022: WHERE set_id = c_set_id;
1023:
1024: l_soln_number VARCHAR2(30);
1025: l_type_id NUMBER;

Line 1069: AND fad.entity_name = 'CS_KB_SETS_B'

1065: WHERE fad.document_id = fd.document_id
1066: AND fd.document_id = fdtl.document_id
1067: AND fl.file_id = fd.media_id
1068: AND fdtl.language = c_lang
1069: AND fad.entity_name = 'CS_KB_SETS_B'
1070: AND fad.pk1_value = c_setid; */
1071: -- Changed the cursor for bug 8815880,11739796
1072: CURSOR c1(c_setid IN NUMBER, c_lang IN VARCHAR2) IS
1073: SELECT fdtl.title, fdtl.description, fl.file_name, fd.url, fst.short_text

Line 1084: AND fad.entity_name = 'CS_KB_SETS_B'

1080: AND fd.document_id = fdtl.document_id
1081: AND fl.file_id(+) = fd.media_id
1082: AND fst.media_id(+) = fd.media_id
1083: AND fdtl.LANGUAGE = c_lang
1084: AND fad.entity_name = 'CS_KB_SETS_B'
1085: AND fad.pk1_value = c_setid;
1086:
1087: rec1 c1%ROWTYPE;
1088: l_data VARCHAR2(32000);

Line 1174: AND fad.entity_name = 'CS_KB_SETS_B'

1170: SELECT fad.document_id
1171: FROM fnd_attached_documents fad,
1172: fnd_documents fd
1173: WHERE fad.document_id = fd.document_id
1174: AND fad.entity_name = 'CS_KB_SETS_B'
1175: AND fad.pk1_value = c_setid;
1176: l_data VARCHAR2(32000);
1177: l_amt BINARY_INTEGER;
1178: l_setid NUMBER;

Line 1465: FROM cs_kb_sets_b a, cs_kb_visibilities_b b

1461: AND a.set_id = p_solution_id;
1462:
1463: SELECT b.position
1464: INTO l_soln_vis
1465: FROM cs_kb_sets_b a, cs_kb_visibilities_b b
1466: WHERE a.visibility_id = b.visibility_id
1467: AND a.set_id = p_solution_id;
1468:
1469: IF l_soln_vis < l_max_cat_vis THEN

Line 1716: cs_kb_sets_b d

1712: SELECT UNIQUE b.category_group_id
1713: FROM cs_kb_set_categories a,
1714: CS_KB_CAT_GROUP_DENORM b,
1715: cs_kb_set_eles c ,
1716: cs_kb_sets_b d
1717: WHERE a.category_id = b.child_category_id
1718: AND a.set_id = c.set_id
1719: AND d.status = 'PUB'
1720: AND c.set_id = d.set_id

Line 1734: cs_kb_Sets_B s,

1730: -- Restrict on PUB
1731: CURSOR c6(c_element_id IN NUMBER) IS
1732: SELECT s.set_id, v.position
1733: FROM cs_kb_set_eles se,
1734: cs_kb_Sets_B s,
1735: cs_kb_visibilities_b v
1736: WHERE se.element_id = c_element_id
1737: AND se.set_id = s.set_id
1738: AND s.status = 'PUB'

Line 1817: -- from cs_kb_sets_b a, cs_kb_visibilities_b b

1813: -- Bug 3455203 - Perf Changes:
1814: -- Posn now retrieved via c6 cursor
1815: -- select b.position
1816: -- into l_soln_vis
1817: -- from cs_kb_sets_b a, cs_kb_visibilities_b b
1818: -- where a.visibility_id = b.visibility_id
1819: -- and a.set_id = rec6.set_id;
1820:
1821: -- perf11510

Line 1931: cs_kb_sets_b s

1927: WHERE a.element_id <> p_element_id --:b1
1928: AND a.set_id IN (
1929: SELECT s.set_id
1930: FROM cs_kb_set_eles se,
1931: cs_kb_sets_b s
1932: WHERE se.element_id = p_element_id
1933: AND se.set_id = s.set_id
1934: AND s.status = 'PUB');
1935: -- select a.element_id

Line 1936: -- from cs_kb_set_eles a, cs_kb_set_eles b, cs_kb_sets_b c

1932: WHERE se.element_id = p_element_id
1933: AND se.set_id = s.set_id
1934: AND s.status = 'PUB');
1935: -- select a.element_id
1936: -- from cs_kb_set_eles a, cs_kb_set_eles b, cs_kb_sets_b c
1937: -- where b.set_id = a.set_id
1938: -- and a.set_id = c.set_id
1939: -- and c.status = 'PUB'
1940: -- and b.element_id = p_element_id