298: SECURITY_GROUP_ID)
299: (SELECT
300: ibe_ct_imedia_search_s1.nextval,
301: 1,
302: FND_GLOBAL.user_id,
303: SYSDATE,
304: FND_GLOBAL.user_id,
305: SYSDATE,
306: FND_GLOBAL.conc_login_id,
300: ibe_ct_imedia_search_s1.nextval,
301: 1,
302: FND_GLOBAL.user_id,
303: SYSDATE,
304: FND_GLOBAL.user_id,
305: SYSDATE,
306: FND_GLOBAL.conc_login_id,
307: c.CATEGORY_ID,
308: b.ORGANIZATION_ID,
302: FND_GLOBAL.user_id,
303: SYSDATE,
304: FND_GLOBAL.user_id,
305: SYSDATE,
306: FND_GLOBAL.conc_login_id,
307: c.CATEGORY_ID,
308: b.ORGANIZATION_ID,
309: c.CATEGORY_SET_ID,--bug 6924793
310: b.INVENTORY_ITEM_ID,
338: INDEXED_SEARCH,WEB_STATUS,
339: SECURITY_GROUP_ID)
340: (SELECT ibe_ct_imedia_search_s1.nextval,
341: 1,
342: FND_GLOBAL.user_id,
343: SYSDATE,
344: FND_GLOBAL.user_id,
345: SYSDATE,
346: FND_GLOBAL.conc_login_id,
340: (SELECT ibe_ct_imedia_search_s1.nextval,
341: 1,
342: FND_GLOBAL.user_id,
343: SYSDATE,
344: FND_GLOBAL.user_id,
345: SYSDATE,
346: FND_GLOBAL.conc_login_id,
347: c.CATEGORY_ID,
348: b.ORGANIZATION_ID,
342: FND_GLOBAL.user_id,
343: SYSDATE,
344: FND_GLOBAL.user_id,
345: SYSDATE,
346: FND_GLOBAL.conc_login_id,
347: c.CATEGORY_ID,
348: b.ORGANIZATION_ID,
349: c.CATEGORY_SET_ID,
350: b.INVENTORY_ITEM_ID,
377: INDEXED_SEARCH,WEB_STATUS,
378: SECURITY_GROUP_ID)
379: (SELECT ibe_ct_imedia_search_s1.nextval,
380: 1,
381: FND_GLOBAL.user_id,
382: SYSDATE,
383: FND_GLOBAL.user_id,
384: SYSDATE,
385: FND_GLOBAL.conc_login_id,
379: (SELECT ibe_ct_imedia_search_s1.nextval,
380: 1,
381: FND_GLOBAL.user_id,
382: SYSDATE,
383: FND_GLOBAL.user_id,
384: SYSDATE,
385: FND_GLOBAL.conc_login_id,
386: c.CATEGORY_ID,
387: b.ORGANIZATION_ID,
381: FND_GLOBAL.user_id,
382: SYSDATE,
383: FND_GLOBAL.user_id,
384: SYSDATE,
385: FND_GLOBAL.conc_login_id,
386: c.CATEGORY_ID,
387: b.ORGANIZATION_ID,
388: c.CATEGORY_SET_ID,
389: b.INVENTORY_ITEM_ID,
416: INDEXED_SEARCH,WEB_STATUS,
417: SECURITY_GROUP_ID)
418: (SELECT ibe_ct_imedia_search_s1.nextval,
419: 1,
420: FND_GLOBAL.user_id,
421: SYSDATE,
422: FND_GLOBAL.user_id,
423: SYSDATE,
424: FND_GLOBAL.conc_login_id,
418: (SELECT ibe_ct_imedia_search_s1.nextval,
419: 1,
420: FND_GLOBAL.user_id,
421: SYSDATE,
422: FND_GLOBAL.user_id,
423: SYSDATE,
424: FND_GLOBAL.conc_login_id,
425: c.CATEGORY_ID,
426: b.ORGANIZATION_ID,
420: FND_GLOBAL.user_id,
421: SYSDATE,
422: FND_GLOBAL.user_id,
423: SYSDATE,
424: FND_GLOBAL.conc_login_id,
425: c.CATEGORY_ID,
426: b.ORGANIZATION_ID,
427: c.CATEGORY_SET_ID,
428: b.INVENTORY_ITEM_ID,
455: INDEXED_SEARCH,WEB_STATUS,
456: SECURITY_GROUP_ID)
457: (SELECT ibe_ct_imedia_search_s1.nextval,
458: 1,
459: FND_GLOBAL.user_id,
460: SYSDATE,
461: FND_GLOBAL.user_id,
462: SYSDATE,
463: FND_GLOBAL.conc_login_id,
457: (SELECT ibe_ct_imedia_search_s1.nextval,
458: 1,
459: FND_GLOBAL.user_id,
460: SYSDATE,
461: FND_GLOBAL.user_id,
462: SYSDATE,
463: FND_GLOBAL.conc_login_id,
464: c.CATEGORY_ID,
465: b.ORGANIZATION_ID,
459: FND_GLOBAL.user_id,
460: SYSDATE,
461: FND_GLOBAL.user_id,
462: SYSDATE,
463: FND_GLOBAL.conc_login_id,
464: c.CATEGORY_ID,
465: b.ORGANIZATION_ID,
466: c.CATEGORY_SET_ID,
467: b.INVENTORY_ITEM_ID,
495: INDEXED_SEARCH,WEB_STATUS,
496: SECURITY_GROUP_ID)
497: (SELECT ibe_ct_imedia_search_s1.nextval,
498: 1,
499: FND_GLOBAL.user_id,
500: SYSDATE,
501: FND_GLOBAL.user_id,
502: SYSDATE,
503: FND_GLOBAL.conc_login_id,
497: (SELECT ibe_ct_imedia_search_s1.nextval,
498: 1,
499: FND_GLOBAL.user_id,
500: SYSDATE,
501: FND_GLOBAL.user_id,
502: SYSDATE,
503: FND_GLOBAL.conc_login_id,
504: c.CATEGORY_ID,
505: b.ORGANIZATION_ID,
499: FND_GLOBAL.user_id,
500: SYSDATE,
501: FND_GLOBAL.user_id,
502: SYSDATE,
503: FND_GLOBAL.conc_login_id,
504: c.CATEGORY_ID,
505: b.ORGANIZATION_ID,
506: c.CATEGORY_SET_ID,
507: b.INVENTORY_ITEM_ID,