APPS.IBE_SEARCHUPDATE_PVT dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 95: mtl_system_items_b_kfv.concatenated_segments%TYPE INDEX BY BINARY_INTEGER;

91: INDEX BY BINARY_INTEGER;
92: TYPE t_long_description IS TABLE OF
93: ibe_ct_imedia_search.LONG_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
94: TYPE t_concatenated_segments IS TABLE OF
95: mtl_system_items_b_kfv.concatenated_segments%TYPE INDEX BY BINARY_INTEGER;
96: TYPE t_category_set_id IS TABLE OF ibe_ct_imedia_search.CATEGORY_SET_ID%TYPE
97: INDEX BY BINARY_INTEGER;
98: TYPE t_web_status IS TABLE OF ibe_ct_imedia_search.WEB_STATUS%TYPE
99: INDEX BY BINARY_INTEGER;

Line 414: from mtl_system_items_b_kfv a, mtl_system_items_tl b, mtl_item_categories c, ibe_dsp_section_items d

410: FND_GLOBAL.user_id LAST_UPDATED_BY, SYSDATE LAST_UPDATE_DATE,
411: FND_GLOBAL.conc_login_id LAST_UPDATE_LOGIN, c.CATEGORY_ID,
412: b.ORGANIZATION_ID,b.LANGUAGE,b.DESCRIPTION, b.LONG_DESCRIPTION,
413: a.concatenated_segments,c.CATEGORY_SET_ID,a.WEB_STATUS
414: from mtl_system_items_b_kfv a, mtl_system_items_tl b, mtl_item_categories c, ibe_dsp_section_items d
415: where d.inventory_item_id = a.inventory_item_id
416: and d.organization_id = a.organization_id
417: and a.INVENTORY_ITEM_ID = b.INVENTORY_ITEM_ID
418: and a.organization_id = b.organization_id