APPS.CS_KB_CTX_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 117

    SELECT tl.set_id,
	   tl.LANGUAGE,
	   b.status,
	   tl.content_cache,
	   b.set_number,
	   b.set_type_id
    FROM CS_KB_SETS_TL tl, CS_KB_SETS_B b
    WHERE tl.ROWID = p_rowid
    AND b.set_id = tl.set_id;

Line: 134

    select tl.set_id, tl.language, b.status, tl.content_cache
    into l_solnid, l_lang, l_status, l_clob
    from CS_KB_SETS_TL tl, CS_KB_SETS_B b
    where tl.rowid = p_rowid
      and b.set_id = tl.set_id;

Line: 202

    SELECT name
    FROM Cs_Kb_Sets_tl
    WHERE set_id = p_set_id
    AND LANGUAGE = p_lang;

Line: 212

      SELECT et.name, et.description, eb.element_id, eb.element_number
      FROM CS_KB_ELEMENTS_B eb,
           CS_KB_ELEMENTS_TL et,
           CS_KB_SET_ELES se
      WHERE se.set_id = c_setid
      AND eb.element_id = se.element_id
      AND eb.element_id = et.element_id
      AND eb.status = 'PUBLISHED' --- added 03/16/2004
      AND et.LANGUAGE = c_lang;

Line: 225

      SELECT b.segment1 name,t.description, s.product_id
      FROM mtl_system_items_b b, mtl_system_items_tl t, cs_kb_set_products s
      WHERE t.inventory_item_id = s.product_id
      AND t.organization_id   = s.product_org_id
      AND b.inventory_item_id = s.product_id
      AND b.organization_id   = s.product_org_id
      AND t.LANGUAGE = c_lang
      AND s.set_id = c_set_id;

Line: 235

      SELECT b.segment1 name,t.description, s.platform_id
      FROM mtl_system_items_b b, mtl_system_items_tl t, cs_kb_set_platforms s
      WHERE t.inventory_item_id = s.platform_id
      AND t.organization_id   = s.platform_org_id
      AND b.inventory_item_id = s.platform_id
      AND b.organization_id   = s.platform_org_id
      AND t.LANGUAGE = c_lang
      AND s.set_id = c_set_id;

Line: 245

      SELECT DISTINCT category_id
      FROM CS_KB_SOLN_CATEGORIES_B
      START WITH category_id IN
      (
        SELECT category_id
        FROM cs_kb_set_categories
        WHERE set_id = c_set_id
      )
      CONNECT BY PRIOR parent_category_id = category_id;

Line: 420

     SELECT tl.element_id, tl.LANGUAGE, b.status,
            b.element_number, tl.name, tl.description,
            b.access_level, b.element_type_id
     FROM CS_KB_ELEMENTS_TL tl, CS_KB_ELEMENTS_B b
     WHERE tl.ROWID = p_rowid
     AND tl.element_id = b.element_id;

Line: 544

      SELECT b.set_number, tl.name
      FROM CS_KB_SETS_B b, CS_KB_SETS_TL tl
      WHERE b.set_id = c_set_id
      AND tl.set_id = b.set_id
      AND tl.LANGUAGE = c_lang;

Line: 581

      SELECT set_type_id, set_number
      FROM CS_KB_SETS_B
      WHERE set_id = c_set_id;

Line: 619

      SELECT DISTINCT category_id
      FROM CS_KB_SOLN_CATEGORIES_B
      START WITH category_id IN
      (
        SELECT category_id
        FROM cs_kb_set_categories
        WHERE set_id = c_set_id
      )
      CONNECT BY PRIOR parent_category_id = category_id;

Line: 668

      SELECT b.segment1 name,t.description
      FROM mtl_system_items_b b, mtl_system_items_tl t, cs_kb_set_products s
      WHERE t.inventory_item_id = s.product_id
      AND t.organization_id   = s.product_org_id
      AND b.inventory_item_id = s.product_id
      AND b.organization_id   = s.product_org_id
      AND t.LANGUAGE = c_lang
      AND s.set_id = c_set_id;

Line: 704

      SELECT product_id, product_org_id
      FROM CS_KB_SET_PRODUCTS
      WHERE set_id = c_set_id;

Line: 753

      SELECT b.segment1 name,t.description
      FROM mtl_system_items_b b, mtl_system_items_tl t, cs_kb_set_platforms s
      WHERE t.inventory_item_id = s.platform_id
      AND t.organization_id   = s.platform_org_id
      AND b.inventory_item_id = s.platform_id
      AND b.organization_id   = s.platform_org_id
      AND t.LANGUAGE = c_lang
      AND s.set_id = c_set_id;

Line: 787

      SELECT platform_id, platform_org_id
      FROM CS_KB_SET_PLATFORMS
      WHERE set_id = c_set_id;

Line: 833

      SELECT UNIQUE b.category_group_id
      FROM cs_kb_set_categories a, CS_KB_CAT_GROUP_DENORM b
      WHERE a.category_id = b.child_category_id
      AND a.set_id = c_set_id;

Line: 839

      SELECT visibility_id FROM cs_kb_visibilities_b
			-- (secure) klou
      WHERE position <= c_position
			ORDER BY visibility_id;

Line: 863

      SELECT MAX(b.visibility_position)
      INTO l_max_cat_vis
      FROM cs_kb_set_categories a, CS_KB_CAT_GROUP_DENORM b
      WHERE a.category_id = b.child_category_id
      AND b.category_group_id = rec4.category_group_id
      AND a.set_id = p_solution_id;

Line: 870

      SELECT b.position
      INTO l_soln_vis
      FROM cs_kb_sets_b a, cs_kb_visibilities_b b
      WHERE a.visibility_id = b.visibility_id
      AND a.set_id = p_solution_id;

Line: 906

      SELECT et.name, et.description, eb.element_id, eb.element_number
      FROM CS_KB_ELEMENTS_B eb,
           CS_KB_ELEMENTS_TL et,
           CS_KB_SET_ELES se
      WHERE se.set_id = c_setid
      AND eb.element_id = se.element_id
      AND eb.element_id = et.element_id
      AND eb.status = 'PUBLISHED' --- added 03/16/2004
      AND et.LANGUAGE = c_lang;

Line: 956

      select se.element_id
      from CS_KB_SET_ELES se
      where se.set_id = c_setid;

Line: 960

      SELECT se.element_id
      FROM CS_KB_SET_ELES se,
           cs_kb_elements_b sb
      WHERE se.set_id = c_setid
      AND sb.element_id = se.element_id
      AND sb.status = 'PUBLISHED';

Line: 1071

    SELECT lookup_code
    FROM cs_lookups
    WHERE lookup_type = 'CS_KB_ACCESS_LEVEL'
    AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active, SYSDATE))
    AND TRUNC(NVL(end_date_active, SYSDATE))
    AND TO_NUMBER(lookup_code) <= p_access_level;

Line: 1119

      SELECT UNIQUE b.category_group_id
      FROM cs_kb_set_categories a,
           CS_KB_CAT_GROUP_DENORM b,
           cs_kb_set_eles c ,
           cs_kb_sets_b d
      WHERE a.category_id = b.child_category_id
      AND a.set_id = c.set_id
      AND d.status = 'PUB'
      AND c.set_id = d.set_id
      AND c.element_id = c_element_id;

Line: 1131

      SELECT visibility_id FROM cs_kb_visibilities_b
			-- (secure) klou
      WHERE position <= c_position
      ORDER BY visibility_id;

Line: 1139

      SELECT s.set_id, v.position
      FROM cs_kb_set_eles se,
           cs_kb_Sets_B s,
           cs_kb_visibilities_b v
      WHERE se.element_id = c_element_id
      AND   se.set_id = s.set_id
      AND   s.status = 'PUB'
      AND   s.visibility_id = v.visibility_id;

Line: 1165

    SELECT NVL(MAX(b.visibility_position), -1)
      FROM cs_kb_set_categories a,
             CS_KB_CAT_GROUP_DENORM b,
             cs_kb_set_eles c
	    WHERE a.category_id = b.child_category_id
        AND a.set_id = c.set_id
	    AND a.set_id = p_set_id --rec6.set_id
	    AND b.category_group_id = p_cat_group_id --rec4.category_group_id
	    AND c.element_id = p_statement_id;

Line: 1332

	SELECT a.element_id
	FROM cs_kb_set_eles a
	WHERE a.element_id <> p_element_id --:b1
	AND   a.set_id IN (
	SELECT s.set_id
	FROM cs_kb_set_eles se,
	     cs_kb_sets_b s
	WHERE se.element_id = p_element_id
	AND se.set_id = s.set_id
	AND s.status = 'PUB');

Line: 1342

	--     select a.element_id
	--     from cs_kb_set_eles a, cs_kb_set_eles b, cs_kb_sets_b c
	--     where b.set_id = a.set_id
	--     and  a.set_id = c.set_id
	--     and c.status = 'PUB'
	--     and b.element_id = p_element_id
	--     and a.element_id <> p_element_id;