APPS.CS_KB_CTX_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 226: FROM mtl_system_items_b b, mtl_system_items_tl t, cs_kb_set_products s

222: rec1 c1%ROWTYPE;
223:
224: CURSOR c6(c_set_id IN NUMBER, c_lang IN VARCHAR2) IS
225: SELECT b.segment1 name,t.description, s.product_id
226: FROM mtl_system_items_b b, mtl_system_items_tl t, cs_kb_set_products s
227: WHERE t.inventory_item_id = s.product_id
228: AND t.organization_id = s.product_org_id
229: AND b.inventory_item_id = s.product_id
230: AND b.organization_id = s.product_org_id

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 669: FROM mtl_system_items_b b, mtl_system_items_tl t, cs_kb_set_products s

665: p_temp_clob IN OUT NOCOPY CLOB)
666: IS
667: CURSOR c6(c_set_id IN NUMBER, c_lang IN VARCHAR2) IS
668: SELECT b.segment1 name,t.description
669: FROM mtl_system_items_b b, mtl_system_items_tl t, cs_kb_set_products s
670: WHERE t.inventory_item_id = s.product_id
671: AND t.organization_id = s.product_org_id
672: AND b.inventory_item_id = s.product_id
673: AND b.organization_id = s.product_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