DBA Data[Home] [Help]

APPS.IBE_SEARCHUPDATE_PVT dependencies on FND_GLOBAL

Line 258: FND_GLOBAL.user_id,

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

Line 260: FND_GLOBAL.user_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

Line 262: FND_GLOBAL.conc_login_id

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

Line 280: FND_GLOBAL.user_id,

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

Line 282: FND_GLOBAL.user_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,

Line 284: FND_GLOBAL.conc_login_id

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

Line 409: FND_GLOBAL.user_id CREATED_BY,SYSDATE CREATION_DATE,

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

Line 410: FND_GLOBAL.user_id LAST_UPDATED_BY, SYSDATE LAST_UPDATE_DATE,

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

Line 411: FND_GLOBAL.conc_login_id LAST_UPDATE_LOGIN, c.CATEGORY_ID,

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