APPS.ICX_POR_MAP_CATEGORIES dependencies on ICX_CAT_ITEMS_B

Line 77: icx_cat_items_b i

73: SET ci1.rt_category_id = gNewCatIdTab(1)
74: WHERE (ci1.rt_item_id, ci1.rt_category_id) in
75: (SELECT ci2.rt_item_id, ci2.rt_category_id
76: FROM icx_cat_category_items ci2,
77: icx_cat_items_b i
78: WHERE ci2.rt_category_id = v_oldCatId
79: AND ci2.rt_item_id = i.rt_item_id
80: -- only update extracted items
81: AND i.extractor_updated_flag = 'Y' );

Line 149: and exists ( select 'x' from icx_cat_items_b b

145: tl_text_cat_attribute43 = null, tl_text_cat_attribute44 = null, tl_text_cat_attribute45 = null,
146: tl_text_cat_attribute46 = null, tl_text_cat_attribute47 = null, tl_text_cat_attribute48 = null,
147: tl_text_cat_attribute49 = null, tl_text_cat_attribute50 = null
148: where rt_category_id = v_oldCatId --oldCatID
149: and exists ( select 'x' from icx_cat_items_b b
150: where ext.rt_item_id = b.rt_item_id
151: and b.extractor_updated_flag = 'Y' );
152: --end if;
153: xErrLoc := 810;

Line 190: icx_cat_items_b i

186: WHERE language = lang.language_code
187: AND rt_item_id in
188: (SELECT i.rt_item_id
189: FROM icx_cat_category_items ci,
190: icx_cat_items_b i
191: WHERE ci.rt_category_id = gNewCatIdTab(1)
192: AND ci.rt_item_id = i.rt_item_id
193: AND i.extractor_updated_flag = 'Y');
194: p_message := p_message ||'; No: of rows updated in icx_cat_items_tlp for '||lang.language_code ||' :' ||SQL%ROWCOUNT;