APPS.CS_KNOWLEDGE_AUDIT_PVT dependencies on CS_KB_SET_PRODUCTS

Line 1686: from cs_kb_set_products

1682: where set_id = p_set_id;
1683:
1684: cursor product_ids_cur (p_set_id IN NUMBER) IS
1685: select product_id, product_org_id
1686: from cs_kb_set_products
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

Line 3973: FROM mtl_system_items_vl it, mtl_item_categories ic, cs_kb_set_products a

3969:
3970: -- Fetch info for all products the solution links to
3971: CURSOR get_product_info(c_set_id IN NUMBER) IS
3972: SELECT it.description,it.concatenated_segments
3973: FROM mtl_system_items_vl it, mtl_item_categories ic, cs_kb_set_products a
3974: where it.inventory_item_id = ic.inventory_item_id
3975: and it.organization_id = ic.organization_id
3976: and it.organization_id = cs_std.get_item_valdn_orgzn_id
3977: and ic.category_set_id = fnd_profile.value('CS_KB_PRODUCT_CATEGORY_SET')