APPS.IBE_SEARCHUPDATE_PVT dependencies on IBE_DSP_SECTION_ITEMS

Line 156: from ibe_dsp_section_items idsi

152: l_c_msite_id IN NUMBER, l_c_root_section_id IN NUMBER) IS
153: select /*+ first_rows */ inventory_item_id
154: from (
155: select section_item_id, idsi.inventory_item_id
156: from ibe_dsp_section_items idsi
157: where section_id IN
158: (
159: select child_section_id
160: from ibe_dsp_msite_sct_sects s1

Line 178: from ibe_dsp_section_items i1, ibe_dsp_msite_sct_items i2

174: )
175: and NOT EXISTS
176: (
177: select inventory_item_id
178: from ibe_dsp_section_items i1, ibe_dsp_msite_sct_items i2
179:
180: where i1.section_item_id = i2.section_item_id
181: and i2.mini_site_id = l_c_msite_id
182: and i1.inventory_item_id = idsi.inventory_item_id

Line 186: from ibe_dsp_msite_sct_sects s3, ibe_dsp_section_items i2

182: and i1.inventory_item_id = idsi.inventory_item_id
183: )
184: union
185: select /*ordered use_nl(s3,i2) */ section_item_id, i2.inventory_item_id
186: from ibe_dsp_msite_sct_sects s3, ibe_dsp_section_items i2
187: where i2.section_id = s3.child_section_id
188: and s3.mini_site_id = l_c_msite_id
189: and NOT EXISTS
190: (

Line 263: from ibe_dsp_section_items f ,

259: SYSDATE,
260: FND_GLOBAL.user_id,
261: SYSDATE,
262: FND_GLOBAL.conc_login_id
263: from ibe_dsp_section_items f ,
264: ibe_dsp_sections_b s
265: where (f.end_date_active > sysdate or f.end_date_active is null)
266: and f.start_date_active < sysdate
267: and f.section_id = s.section_id

Line 285: from ibe_dsp_section_items f ,

281: SYSDATE,
282: FND_GLOBAL.user_id,
283: SYSDATE,
284: FND_GLOBAL.conc_login_id
285: from ibe_dsp_section_items f ,
286: mtl_system_items_b g,
287: ibe_dsp_sections_b s
288: where f.inventory_item_id = g.inventory_item_id
289: and (f.end_date_active > sysdate or f.end_date_active is null)

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