APPS.CS_KNOWLEDGE_AUDIT_PVT dependencies on CS_KB_SET_CATEGORIES

Line 1705: from cs_kb_set_categories

1701: where set_id = p_set_id;
1702:
1703: cursor category_ids_cur (p_set_id IN NUMBER) IS
1704: select category_id
1705: from cs_kb_set_categories
1706: where set_id = p_set_id;
1707:
1708:
1709: BEGIN

Line 3947: cs_kb_visibilities_vl v, cs_kb_set_categories sc

3943: CURSOR get_solution_info_pub(c_category_id IN NUMBER)
3944: IS
3945: select /*+ index(sc) */a.set_id, a.set_number, c.name, v.name, b.name, a.status
3946: from cs_kb_sets_b a, cs_kb_sets_tl b, cs_kb_set_types_vl c,
3947: cs_kb_visibilities_vl v, cs_kb_set_categories sc
3948: where a.set_type_id = c.set_type_id
3949: and a.set_id = sc.set_id and sc.category_id = c_category_id
3950: and a.set_id = b.set_id and b.language = userenv('LANG')
3951: and a.visibility_id = v.visibility_id

Line 3960: cs_kb_visibilities_vl v, cs_kb_set_categories sc

3956: CURSOR get_solution_info_all(c_category_id IN NUMBER)
3957: IS
3958: select /*+ index(sc) */ a.set_id, a.set_number, c.name, v.name, b.name, a.status
3959: from cs_kb_sets_b a, cs_kb_sets_tl b, cs_kb_set_types_vl c,
3960: cs_kb_visibilities_vl v, cs_kb_set_categories sc
3961: where a.set_type_id = c.set_type_id
3962: and a.set_id = sc.set_id and sc.category_id = c_category_id
3963: and a.set_id = b.set_id and b.language = userenv('LANG')
3964: and a.visibility_id = v.visibility_id

Line 4005: from cs_kb_set_categories a

4001:
4002: -- Fetch all category ids associated with this solution
4003: CURSOR get_category_ids(c_set_id IN NUMBER) IS
4004: Select a.category_id
4005: from cs_kb_set_categories a
4006: where a.set_id = c_set_id;
4007:
4008: -- Declare some local temporary variables
4009: l_category_name CS_KB_SOLN_CATEGORIES_TL.NAME%TYPE;

Line 4156: cs_kb_visibilities_vl v, cs_kb_set_categories sc

4152: IF (p_sol_status = 'ALL')
4153: THEN
4154: SELECT /*+ index(sc) */ count(a.set_number) INTO l_soln_count
4155: from cs_kb_sets_b a, cs_kb_sets_tl b, cs_kb_set_types_vl c,
4156: cs_kb_visibilities_vl v, cs_kb_set_categories sc
4157: where a.set_type_id = c.set_type_id
4158: and a.set_id = sc.set_id and sc.category_id = l_category_id
4159: and a.set_id = b.set_id and b.language = userenv('LANG')
4160: and a.visibility_id = v.visibility_id

Line 4166: cs_kb_visibilities_vl v, cs_kb_set_categories sc

4162: and a.latest_version_flag = 'Y';
4163: ELSE
4164: SELECT count(a.set_number) INTO l_soln_count
4165: from cs_kb_sets_b a, cs_kb_sets_tl b, cs_kb_set_types_vl c,
4166: cs_kb_visibilities_vl v, cs_kb_set_categories sc
4167: where a.set_type_id = c.set_type_id
4168: and a.set_id = sc.set_id and sc.category_id = l_category_id
4169: and a.set_id = b.set_id and b.language = userenv('LANG')
4170: and a.visibility_id = v.visibility_id