339: SECURITY_GROUP_ID)
340: (SELECT
341: ibe_ct_imedia_search_s1.nextval,
342: 1,
343: FND_GLOBAL.user_id,
344: SYSDATE,
345: FND_GLOBAL.user_id,
346: SYSDATE,
347: FND_GLOBAL.conc_login_id,
341: ibe_ct_imedia_search_s1.nextval,
342: 1,
343: FND_GLOBAL.user_id,
344: SYSDATE,
345: FND_GLOBAL.user_id,
346: SYSDATE,
347: FND_GLOBAL.conc_login_id,
348: c.CATEGORY_ID,
349: b.ORGANIZATION_ID,
343: FND_GLOBAL.user_id,
344: SYSDATE,
345: FND_GLOBAL.user_id,
346: SYSDATE,
347: FND_GLOBAL.conc_login_id,
348: c.CATEGORY_ID,
349: b.ORGANIZATION_ID,
350: c.CATEGORY_SET_ID,--bug 6924793
351: b.INVENTORY_ITEM_ID,
379: INDEXED_SEARCH,WEB_STATUS,
380: SECURITY_GROUP_ID)
381: (SELECT ibe_ct_imedia_search_s1.nextval,
382: 1,
383: FND_GLOBAL.user_id,
384: SYSDATE,
385: FND_GLOBAL.user_id,
386: SYSDATE,
387: FND_GLOBAL.conc_login_id,
381: (SELECT ibe_ct_imedia_search_s1.nextval,
382: 1,
383: FND_GLOBAL.user_id,
384: SYSDATE,
385: FND_GLOBAL.user_id,
386: SYSDATE,
387: FND_GLOBAL.conc_login_id,
388: c.CATEGORY_ID,
389: b.ORGANIZATION_ID,
383: FND_GLOBAL.user_id,
384: SYSDATE,
385: FND_GLOBAL.user_id,
386: SYSDATE,
387: FND_GLOBAL.conc_login_id,
388: c.CATEGORY_ID,
389: b.ORGANIZATION_ID,
390: c.CATEGORY_SET_ID,
391: b.INVENTORY_ITEM_ID,
418: INDEXED_SEARCH,WEB_STATUS,
419: SECURITY_GROUP_ID)
420: (SELECT ibe_ct_imedia_search_s1.nextval,
421: 1,
422: FND_GLOBAL.user_id,
423: SYSDATE,
424: FND_GLOBAL.user_id,
425: SYSDATE,
426: FND_GLOBAL.conc_login_id,
420: (SELECT ibe_ct_imedia_search_s1.nextval,
421: 1,
422: FND_GLOBAL.user_id,
423: SYSDATE,
424: FND_GLOBAL.user_id,
425: SYSDATE,
426: FND_GLOBAL.conc_login_id,
427: c.CATEGORY_ID,
428: b.ORGANIZATION_ID,
422: FND_GLOBAL.user_id,
423: SYSDATE,
424: FND_GLOBAL.user_id,
425: SYSDATE,
426: FND_GLOBAL.conc_login_id,
427: c.CATEGORY_ID,
428: b.ORGANIZATION_ID,
429: c.CATEGORY_SET_ID,
430: b.INVENTORY_ITEM_ID,
457: INDEXED_SEARCH,WEB_STATUS,
458: SECURITY_GROUP_ID)
459: (SELECT ibe_ct_imedia_search_s1.nextval,
460: 1,
461: FND_GLOBAL.user_id,
462: SYSDATE,
463: FND_GLOBAL.user_id,
464: SYSDATE,
465: FND_GLOBAL.conc_login_id,
459: (SELECT ibe_ct_imedia_search_s1.nextval,
460: 1,
461: FND_GLOBAL.user_id,
462: SYSDATE,
463: FND_GLOBAL.user_id,
464: SYSDATE,
465: FND_GLOBAL.conc_login_id,
466: c.CATEGORY_ID,
467: b.ORGANIZATION_ID,
461: FND_GLOBAL.user_id,
462: SYSDATE,
463: FND_GLOBAL.user_id,
464: SYSDATE,
465: FND_GLOBAL.conc_login_id,
466: c.CATEGORY_ID,
467: b.ORGANIZATION_ID,
468: c.CATEGORY_SET_ID,
469: b.INVENTORY_ITEM_ID,
496: INDEXED_SEARCH,WEB_STATUS,
497: SECURITY_GROUP_ID)
498: (SELECT ibe_ct_imedia_search_s1.nextval,
499: 1,
500: FND_GLOBAL.user_id,
501: SYSDATE,
502: FND_GLOBAL.user_id,
503: SYSDATE,
504: FND_GLOBAL.conc_login_id,
498: (SELECT ibe_ct_imedia_search_s1.nextval,
499: 1,
500: FND_GLOBAL.user_id,
501: SYSDATE,
502: FND_GLOBAL.user_id,
503: SYSDATE,
504: FND_GLOBAL.conc_login_id,
505: c.CATEGORY_ID,
506: b.ORGANIZATION_ID,
500: FND_GLOBAL.user_id,
501: SYSDATE,
502: FND_GLOBAL.user_id,
503: SYSDATE,
504: FND_GLOBAL.conc_login_id,
505: c.CATEGORY_ID,
506: b.ORGANIZATION_ID,
507: c.CATEGORY_SET_ID,
508: b.INVENTORY_ITEM_ID,
536: INDEXED_SEARCH,WEB_STATUS,
537: SECURITY_GROUP_ID)
538: (SELECT ibe_ct_imedia_search_s1.nextval,
539: 1,
540: FND_GLOBAL.user_id,
541: SYSDATE,
542: FND_GLOBAL.user_id,
543: SYSDATE,
544: FND_GLOBAL.conc_login_id,
538: (SELECT ibe_ct_imedia_search_s1.nextval,
539: 1,
540: FND_GLOBAL.user_id,
541: SYSDATE,
542: FND_GLOBAL.user_id,
543: SYSDATE,
544: FND_GLOBAL.conc_login_id,
545: c.CATEGORY_ID,
546: b.ORGANIZATION_ID,
540: FND_GLOBAL.user_id,
541: SYSDATE,
542: FND_GLOBAL.user_id,
543: SYSDATE,
544: FND_GLOBAL.conc_login_id,
545: c.CATEGORY_ID,
546: b.ORGANIZATION_ID,
547: c.CATEGORY_SET_ID,
548: b.INVENTORY_ITEM_ID,