APPS.CS_KB_CTX_PKG dependencies on CS_KB_SET_PLATFORMS

Line 236: FROM mtl_system_items_b b, mtl_system_items_tl t, cs_kb_set_platforms s

232: AND s.set_id = c_set_id;
233:
234: CURSOR c7(c_set_id IN NUMBER, c_lang IN VARCHAR2) IS
235: SELECT b.segment1 name,t.description, s.platform_id
236: FROM mtl_system_items_b b, mtl_system_items_tl t, cs_kb_set_platforms s
237: WHERE t.inventory_item_id = s.platform_id
238: AND t.organization_id = s.platform_org_id
239: AND b.inventory_item_id = s.platform_id
240: AND b.organization_id = s.platform_org_id

Line 754: FROM mtl_system_items_b b, mtl_system_items_tl t, cs_kb_set_platforms s

750: p_temp_clob IN OUT NOCOPY CLOB)
751: IS
752: CURSOR c7(c_set_id IN NUMBER, c_lang IN VARCHAR2) IS
753: SELECT b.segment1 name,t.description
754: FROM mtl_system_items_b b, mtl_system_items_tl t, cs_kb_set_platforms s
755: WHERE t.inventory_item_id = s.platform_id
756: AND t.organization_id = s.platform_org_id
757: AND b.inventory_item_id = s.platform_id
758: AND b.organization_id = s.platform_org_id

Line 788: FROM CS_KB_SET_PLATFORMS

784: p_clob IN OUT NOCOPY CLOB)
785: IS
786: CURSOR c4(c_set_id IN NUMBER) IS
787: SELECT platform_id, platform_org_id
788: FROM CS_KB_SET_PLATFORMS
789: WHERE set_id = c_set_id;
790: l_data VARCHAR2(32000);
791: l_amt BINARY_INTEGER;
792: l_platform_id NUMBER;