APPS.CS_KB_CTX_PKG dependencies on CS_KB_SET_PRODUCTS

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

243: rec1 c1%ROWTYPE;
244:
245: CURSOR c6(c_set_id IN NUMBER, c_lang IN VARCHAR2) IS
246: SELECT b.segment1 name,t.description, s.product_id
247: FROM mtl_system_items_b b, mtl_system_items_tl t, cs_kb_set_products s
248: WHERE t.inventory_item_id = s.product_id
249: AND t.organization_id = s.product_org_id
250: AND b.inventory_item_id = s.product_id
251: AND b.organization_id = s.product_org_id

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

540: rec1 c1%ROWTYPE;
541:
542: CURSOR c6(c_set_id IN NUMBER, c_lang IN VARCHAR2) IS
543: SELECT b.segment1 name,t.description, s.product_id
544: FROM mtl_system_items_b b, mtl_system_items_tl t, cs_kb_set_products s
545: WHERE t.inventory_item_id = s.product_id
546: AND t.organization_id = s.product_org_id
547: AND b.inventory_item_id = s.product_id
548: AND b.organization_id = s.product_org_id

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

1258: p_temp_clob IN OUT NOCOPY CLOB)
1259: IS
1260: CURSOR c6(c_set_id IN NUMBER, c_lang IN VARCHAR2) IS
1261: SELECT b.segment1 name,t.description
1262: FROM mtl_system_items_b b, mtl_system_items_tl t, cs_kb_set_products s
1263: WHERE t.inventory_item_id = s.product_id
1264: AND t.organization_id = s.product_org_id
1265: AND b.inventory_item_id = s.product_id
1266: AND b.organization_id = s.product_org_id

Line 1298: FROM CS_KB_SET_PRODUCTS

1294: p_clob IN OUT NOCOPY CLOB)
1295: IS
1296: CURSOR c3(c_set_id IN NUMBER) IS
1297: SELECT product_id, product_org_id
1298: FROM CS_KB_SET_PRODUCTS
1299: WHERE set_id = c_set_id;
1300: l_data VARCHAR2(32000);
1301: l_amt BINARY_INTEGER;
1302: l_setid NUMBER;