APPS.CS_KNOWLEDGE_AUDIT_PVT dependencies on CS_KB_SET_PLATFORMS

Line 1691: from cs_kb_set_platforms

1687: where set_id = p_set_id;
1688:
1689: cursor platform_ids_cur (p_set_id IN NUMBER) IS
1690: select platform_id, platform_org_id
1691: from cs_kb_set_platforms
1692: where set_id = p_set_id;
1693:
1694: cursor category_ids_cur (p_set_id IN NUMBER) IS
1695: select category_id

Line 3984: FROM mtl_system_items_vl it, mtl_item_categories ic, cs_kb_set_platforms a

3980:
3981: -- Fetch info for all platforms the solution links to
3982: CURSOR get_platform_info(c_set_id IN NUMBER) IS
3983: SELECT it.description,it.concatenated_segments
3984: FROM mtl_system_items_vl it, mtl_item_categories ic, cs_kb_set_platforms a
3985: where it.inventory_item_id = ic.inventory_item_id
3986: and it.organization_id = ic.organization_id
3987: and it.organization_id = cs_std.get_item_valdn_orgzn_id
3988: and ic.category_set_id = fnd_profile.value('CS_SR_PLATFORM_CATEGORY_SET')