APPS.CS_KB_CTX_PKG SQL Statements

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

Line: 138

    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: 155

    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: 223

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

Line: 233

      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: 246

      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: 256

      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: 266

      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: 436

    SELECT tl.set_id,
	   tl.LANGUAGE,
	   b.status,
	   tl.attachment_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: 453

    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: 520

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

Line: 530

      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: 543

      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: 553

      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: 563

      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: 574

      SELECT	fdtl.title, fdtl.description, fl.file_name, fad.document_id
	  FROM 	fnd_attached_documents fad,
		fnd_documents fd,
		fnd_documents_tl fdtl,
                fnd_lobs fl
	  WHERE	fad.document_id = fd.document_id
            AND fd.document_id = fdtl.document_id
            AND fl.file_id = fd.media_id
	    AND fdtl.language  = c_lang
	    AND fad.entity_name = 'CS_KB_SETS_B'
	    AND fad.pk1_value = c_setid;

Line: 808

     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: 983

      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: 1020

      SELECT set_type_id, set_number
      FROM CS_KB_SETS_B
      WHERE set_id = c_set_id;

Line: 1060

      SELECT	fdtl.title, fdtl.description, fl.file_name, fl.file_data
	  FROM 	fnd_attached_documents fad,
		fnd_documents fd,
		fnd_documents_tl fdtl,
                fnd_lobs fl
	  WHERE	fad.document_id = fd.document_id
            AND fd.document_id = fdtl.document_id
            AND fl.file_id = fd.media_id
	    AND fdtl.language  = c_lang
	    AND fad.entity_name = 'CS_KB_SETS_B'
	    AND fad.pk1_value = c_setid; */

Line: 1073

      SELECT fdtl.title, fdtl.description, fl.file_name,  fd.url, fst.short_text
      FROM fnd_attached_documents fad,
           fnd_documents fd,
           fnd_documents_tl fdtl,
           fnd_lobs fl,
           fnd_documents_short_text fst
      WHERE fad.document_id = fd.document_id
      AND fd.document_id = fdtl.document_id
      AND fl.file_id(+) = fd.media_id
      AND fst.media_id(+) = fd.media_id
      AND fdtl.LANGUAGE = c_lang
      AND fad.entity_name = 'CS_KB_SETS_B'
      AND fad.pk1_value = c_setid;

Line: 1166

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

Line: 1170

      SELECT fad.document_id
	FROM fnd_attached_documents fad,
	fnd_documents fd
	WHERE fad.document_id = fd.document_id
	AND fad.entity_name = 'CS_KB_SETS_B'
	AND fad.pk1_value = c_setid;

Line: 1212

      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: 1261

      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: 1297

      SELECT product_id, product_org_id
      FROM CS_KB_SET_PRODUCTS
      WHERE set_id = c_set_id;

Line: 1346

      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: 1380

      SELECT platform_id, platform_org_id
      FROM CS_KB_SET_PLATFORMS
      WHERE set_id = c_set_id;

Line: 1426

      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: 1432

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

Line: 1456

      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: 1463

      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: 1499

      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: 1549

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

Line: 1553

      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: 1664

    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: 1712

      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: 1724

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

Line: 1732

      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: 1758

    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: 1925

	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: 1935

	--     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;