254: --sectionIdData.section_id,
255: --distinct g.inventory_item_id,g.organization_id ,sectionIdData.section_id,
256: v_CompoundData.MSITE_ID,
257: 1,
258: FND_GLOBAL.user_id,
259: SYSDATE,
260: FND_GLOBAL.user_id,
261: SYSDATE,
262: FND_GLOBAL.conc_login_id
256: v_CompoundData.MSITE_ID,
257: 1,
258: FND_GLOBAL.user_id,
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
258: FND_GLOBAL.user_id,
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
276: /*
277: select distinct g.inventory_item_id,g.organization_id ,sectionIdData.section_id,
278: v_CompoundData.MSITE_ID,
279: 1,
280: FND_GLOBAL.user_id,
281: SYSDATE,
282: FND_GLOBAL.user_id,
283: SYSDATE,
284: FND_GLOBAL.conc_login_id
278: v_CompoundData.MSITE_ID,
279: 1,
280: FND_GLOBAL.user_id,
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,
280: FND_GLOBAL.user_id,
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
405: t.DESCRIPTION,t.LONG_DESCRIPTION,t.CATEGORY_SET_ID,t.WEB_STATUS,
406: ibe_search_setup_pvt.WriteToLob(t.DESCRIPTION, t.LONG_DESCRIPTION, t.concatenated_segments)
407: from
408: (select distinct b.INVENTORY_ITEM_ID INVENTORY_ITEM_ID,1 OBJECT_VERSION_NUMBER,
409: FND_GLOBAL.user_id CREATED_BY,SYSDATE CREATION_DATE,
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
406: ibe_search_setup_pvt.WriteToLob(t.DESCRIPTION, t.LONG_DESCRIPTION, t.concatenated_segments)
407: from
408: (select distinct b.INVENTORY_ITEM_ID INVENTORY_ITEM_ID,1 OBJECT_VERSION_NUMBER,
409: FND_GLOBAL.user_id CREATED_BY,SYSDATE CREATION_DATE,
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
407: from
408: (select distinct b.INVENTORY_ITEM_ID INVENTORY_ITEM_ID,1 OBJECT_VERSION_NUMBER,
409: FND_GLOBAL.user_id CREATED_BY,SYSDATE CREATION_DATE,
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