DBA Data[Home] [Help]

APPS.CS_KNOWLEDGE_AUDIT_PVT dependencies on CS_KB_SET_PRODUCTS

Line 1695: from cs_kb_set_products

1691: where set_id = p_set_id;
1692:
1693: cursor product_ids_cur (p_set_id IN NUMBER) IS
1694: select product_id, product_org_id
1695: from cs_kb_set_products
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

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

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