APPS.CS_KB_CTX_PKG dependencies on MTL_SYSTEM_ITEMS_B

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

253: AND s.set_id = c_set_id;
254:
255: CURSOR c7(c_set_id IN NUMBER, c_lang IN VARCHAR2) IS
256: SELECT b.segment1 name,t.description, s.platform_id
257: FROM mtl_system_items_b b, mtl_system_items_tl t, cs_kb_set_platforms s
258: WHERE t.inventory_item_id = s.platform_id
259: AND t.organization_id = s.platform_org_id
260: AND b.inventory_item_id = s.platform_id
261: AND b.organization_id = s.platform_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 554: FROM mtl_system_items_b b, mtl_system_items_tl t, cs_kb_set_platforms s

550: AND s.set_id = c_set_id;
551:
552: CURSOR c7(c_set_id IN NUMBER, c_lang IN VARCHAR2) IS
553: SELECT b.segment1 name,t.description, s.platform_id
554: FROM mtl_system_items_b b, mtl_system_items_tl t, cs_kb_set_platforms s
555: WHERE t.inventory_item_id = s.platform_id
556: AND t.organization_id = s.platform_org_id
557: AND b.inventory_item_id = s.platform_id
558: AND b.organization_id = s.platform_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 1347: FROM mtl_system_items_b b, mtl_system_items_tl t, cs_kb_set_platforms s

1343: p_temp_clob IN OUT NOCOPY CLOB)
1344: IS
1345: CURSOR c7(c_set_id IN NUMBER, c_lang IN VARCHAR2) IS
1346: SELECT b.segment1 name,t.description
1347: FROM mtl_system_items_b b, mtl_system_items_tl t, cs_kb_set_platforms s
1348: WHERE t.inventory_item_id = s.platform_id
1349: AND t.organization_id = s.platform_org_id
1350: AND b.inventory_item_id = s.platform_id
1351: AND b.organization_id = s.platform_org_id