APPS.CS_KNOWLEDGE_AUDIT_PVT dependencies on CS_KB_SET_PLATFORMS

Line 1700: from cs_kb_set_platforms

1696: where set_id = p_set_id;
1697:
1698: cursor platform_ids_cur (p_set_id IN NUMBER) IS
1699: select platform_id, platform_org_id
1700: from cs_kb_set_platforms
1701: where set_id = p_set_id;
1702:
1703: cursor category_ids_cur (p_set_id IN NUMBER) IS
1704: select category_id

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

3990:
3991: -- Fetch info for all platforms the solution links to
3992: CURSOR get_platform_info(c_set_id IN NUMBER) IS
3993: SELECT it.description,it.concatenated_segments
3994: FROM mtl_system_items_vl it, mtl_item_categories ic, cs_kb_set_platforms a
3995: where it.inventory_item_id = ic.inventory_item_id
3996: and it.organization_id = ic.organization_id
3997: and it.organization_id = cs_std.get_item_valdn_orgzn_id
3998: and ic.category_set_id = fnd_profile.value('CS_SR_PLATFORM_CATEGORY_SET')