DBA Data[Home] [Help]

APPS.CS_KB_CTX_PKG dependencies on CS_KB_SET_PRODUCTS

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 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 705: FROM CS_KB_SET_PRODUCTS

701: p_clob IN OUT NOCOPY CLOB)
702: IS
703: CURSOR c3(c_set_id IN NUMBER) IS
704: SELECT product_id, product_org_id
705: FROM CS_KB_SET_PRODUCTS
706: WHERE set_id = c_set_id;
707: l_data VARCHAR2(32000);
708: l_amt BINARY_INTEGER;
709: l_setid NUMBER;