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_SET_ELES

Line 236: CS_KB_SET_ELES se

232: CURSOR c1(c_setid IN NUMBER, c_lang IN VARCHAR2) IS
233: SELECT et.name, et.description, eb.element_id, eb.element_number
234: FROM CS_KB_ELEMENTS_B eb,
235: CS_KB_ELEMENTS_TL et,
236: CS_KB_SET_ELES se
237: WHERE se.set_id = c_setid
238: AND eb.element_id = se.element_id
239: AND eb.element_id = et.element_id
240: AND eb.status = 'PUBLISHED' --- added 03/16/2004

Line 533: CS_KB_SET_ELES se

529: CURSOR c1(c_setid IN NUMBER, c_lang IN VARCHAR2) IS
530: SELECT et.name, et.description, eb.element_id, eb.element_number
531: FROM CS_KB_ELEMENTS_B eb,
532: CS_KB_ELEMENTS_TL et,
533: CS_KB_SET_ELES se
534: WHERE se.set_id = c_setid
535: AND eb.element_id = se.element_id
536: AND eb.element_id = et.element_id
537: AND eb.status = 'PUBLISHED' --- added 03/16/2004

Line 1167: from CS_KB_SET_ELES se

1163: IS
1164: CURSOR c1(c_setid IN NUMBER) IS
1165: /* (perf11510): functional fix
1166: select se.element_id
1167: from CS_KB_SET_ELES se
1168: where se.set_id = c_setid;
1169: */
1170: SELECT fad.document_id
1171: FROM fnd_attached_documents fad,

Line 1502: CS_KB_SET_ELES se

1498: CURSOR c1(c_setid IN NUMBER, c_lang IN VARCHAR2) IS
1499: SELECT et.name, et.description, eb.element_id, eb.element_number
1500: FROM CS_KB_ELEMENTS_B eb,
1501: CS_KB_ELEMENTS_TL et,
1502: CS_KB_SET_ELES se
1503: WHERE se.set_id = c_setid
1504: AND eb.element_id = se.element_id
1505: AND eb.element_id = et.element_id
1506: AND eb.status = 'PUBLISHED' --- added 03/16/2004

Line 1550: from CS_KB_SET_ELES se

1546: IS
1547: CURSOR c1(c_setid IN NUMBER) IS
1548: /* (perf11510): functional fix
1549: select se.element_id
1550: from CS_KB_SET_ELES se
1551: where se.set_id = c_setid;
1552: */
1553: SELECT se.element_id
1554: FROM CS_KB_SET_ELES se,

Line 1554: FROM CS_KB_SET_ELES se,

1550: from CS_KB_SET_ELES se
1551: where se.set_id = c_setid;
1552: */
1553: SELECT se.element_id
1554: FROM CS_KB_SET_ELES se,
1555: cs_kb_elements_b sb
1556: WHERE se.set_id = c_setid
1557: AND sb.element_id = se.element_id
1558: AND sb.status = 'PUBLISHED';

Line 1715: cs_kb_set_eles c ,

1711: CURSOR c4(c_element_id IN NUMBER) IS
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'

Line 1733: FROM cs_kb_set_eles se,

1729: -- Bug 3455203 - Perf Changes:
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

Line 1761: cs_kb_set_eles c

1757: IS
1758: SELECT NVL(MAX(b.visibility_position), -1)
1759: FROM cs_kb_set_categories a,
1760: CS_KB_CAT_GROUP_DENORM b,
1761: cs_kb_set_eles c
1762: WHERE a.category_id = b.child_category_id
1763: AND a.set_id = c.set_id
1764: AND a.set_id = p_set_id --rec6.set_id
1765: AND b.category_group_id = p_cat_group_id --rec4.category_group_id

Line 1926: FROM cs_kb_set_eles a

1922: p_clob IN OUT NOCOPY CLOB)
1923: IS
1924: CURSOR get_all_stmts(p_element_id IN NUMBER) IS
1925: SELECT a.element_id
1926: FROM cs_kb_set_eles a
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,

Line 1930: FROM cs_kb_set_eles se,

1926: FROM cs_kb_set_eles a
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');

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