97: , LANGUAGE, DESCRIPTION, LONG_DESCRIPTION, INDEXED_SEARCH
98: , CATEGORY_SET_ID, WEB_STATUS)
99: SELECT
100: ibe_ct_imedia_search_s1.nextval,
101: 0, FND_GLOBAL.user_id,
102: SYSDATE, FND_GLOBAL.user_id,
103: SYSDATE, FND_GLOBAL.conc_login_id,
104: new_category_id , new_organization_id ,
105: new_inventory_item_id, b.LANGUAGE,
98: , CATEGORY_SET_ID, WEB_STATUS)
99: SELECT
100: ibe_ct_imedia_search_s1.nextval,
101: 0, FND_GLOBAL.user_id,
102: SYSDATE, FND_GLOBAL.user_id,
103: SYSDATE, FND_GLOBAL.conc_login_id,
104: new_category_id , new_organization_id ,
105: new_inventory_item_id, b.LANGUAGE,
106: b.DESCRIPTION, b.LONG_DESCRIPTION,
99: SELECT
100: ibe_ct_imedia_search_s1.nextval,
101: 0, FND_GLOBAL.user_id,
102: SYSDATE, FND_GLOBAL.user_id,
103: SYSDATE, FND_GLOBAL.conc_login_id,
104: new_category_id , new_organization_id ,
105: new_inventory_item_id, b.LANGUAGE,
106: b.DESCRIPTION, b.LONG_DESCRIPTION,
107: ibe_search_setup_pvt.WriteToLob(b.description , b.long_description ,c.concatenated_segments),
125: , LANGUAGE, DESCRIPTION, LONG_DESCRIPTION, INDEXED_SEARCH
126: , CATEGORY_SET_ID, WEB_STATUS)
127: SELECT
128: ibe_ct_imedia_search_s1.nextval,
129: 0, FND_GLOBAL.user_id,
130: SYSDATE, FND_GLOBAL.user_id,
131: SYSDATE, FND_GLOBAL.conc_login_id,
132: new_category_id , new_organization_id ,
133: new_inventory_item_id, b.LANGUAGE,
126: , CATEGORY_SET_ID, WEB_STATUS)
127: SELECT
128: ibe_ct_imedia_search_s1.nextval,
129: 0, FND_GLOBAL.user_id,
130: SYSDATE, FND_GLOBAL.user_id,
131: SYSDATE, FND_GLOBAL.conc_login_id,
132: new_category_id , new_organization_id ,
133: new_inventory_item_id, b.LANGUAGE,
134: b.DESCRIPTION, b.LONG_DESCRIPTION,
127: SELECT
128: ibe_ct_imedia_search_s1.nextval,
129: 0, FND_GLOBAL.user_id,
130: SYSDATE, FND_GLOBAL.user_id,
131: SYSDATE, FND_GLOBAL.conc_login_id,
132: new_category_id , new_organization_id ,
133: new_inventory_item_id, b.LANGUAGE,
134: b.DESCRIPTION, b.LONG_DESCRIPTION,
135: ibe_search_setup_pvt.WriteToLob(b.description, b.long_description ,c.concatenated_segments),
151: , LANGUAGE, DESCRIPTION, LONG_DESCRIPTION, INDEXED_SEARCH
152: , CATEGORY_SET_ID, WEB_STATUS)
153: SELECT
154: ibe_ct_imedia_search_s1.nextval,
155: 0, FND_GLOBAL.user_id,
156: SYSDATE, FND_GLOBAL.user_id,
157: SYSDATE, FND_GLOBAL.conc_login_id,
158: new_category_id , new_organization_id ,
159: new_inventory_item_id, b.LANGUAGE,
152: , CATEGORY_SET_ID, WEB_STATUS)
153: SELECT
154: ibe_ct_imedia_search_s1.nextval,
155: 0, FND_GLOBAL.user_id,
156: SYSDATE, FND_GLOBAL.user_id,
157: SYSDATE, FND_GLOBAL.conc_login_id,
158: new_category_id , new_organization_id ,
159: new_inventory_item_id, b.LANGUAGE,
160: b.DESCRIPTION, b.LONG_DESCRIPTION,
153: SELECT
154: ibe_ct_imedia_search_s1.nextval,
155: 0, FND_GLOBAL.user_id,
156: SYSDATE, FND_GLOBAL.user_id,
157: SYSDATE, FND_GLOBAL.conc_login_id,
158: new_category_id , new_organization_id ,
159: new_inventory_item_id, b.LANGUAGE,
160: b.DESCRIPTION, b.LONG_DESCRIPTION,
161: ibe_search_setup_pvt.WriteToLob(b.description , b.long_description ,c.concatenated_segments),
341: , LANGUAGE, DESCRIPTION, LONG_DESCRIPTION, INDEXED_SEARCH
342: , CATEGORY_SET_ID, WEB_STATUS)
343: SELECT
344: ibe_ct_imedia_search_s1.nextval,
345: 0, FND_GLOBAL.user_id,
346: SYSDATE, FND_GLOBAL.user_id,
347: SYSDATE, FND_GLOBAL.conc_login_id,
348: new_category_id , new_organization_id ,
349: new_inventory_item_id, b.LANGUAGE,
342: , CATEGORY_SET_ID, WEB_STATUS)
343: SELECT
344: ibe_ct_imedia_search_s1.nextval,
345: 0, FND_GLOBAL.user_id,
346: SYSDATE, FND_GLOBAL.user_id,
347: SYSDATE, FND_GLOBAL.conc_login_id,
348: new_category_id , new_organization_id ,
349: new_inventory_item_id, b.LANGUAGE,
350: b.DESCRIPTION, b.LONG_DESCRIPTION,
343: SELECT
344: ibe_ct_imedia_search_s1.nextval,
345: 0, FND_GLOBAL.user_id,
346: SYSDATE, FND_GLOBAL.user_id,
347: SYSDATE, FND_GLOBAL.conc_login_id,
348: new_category_id , new_organization_id ,
349: new_inventory_item_id, b.LANGUAGE,
350: b.DESCRIPTION, b.LONG_DESCRIPTION,
351: ibe_search_setup_pvt.WriteToLob(b.description , b.long_description ,c.concatenated_segments),
478: , LANGUAGE, DESCRIPTION, LONG_DESCRIPTION, INDEXED_SEARCH
479: , CATEGORY_SET_ID, WEB_STATUS)
480: SELECT
481: ibe_ct_imedia_search_s1.nextval,
482: 0, FND_GLOBAL.user_id,
483: SYSDATE, FND_GLOBAL.user_id,
484: SYSDATE, FND_GLOBAL.conc_login_id,
485: d.category_id , old_organization_id ,
486: old_inventory_item_id, b.LANGUAGE,
479: , CATEGORY_SET_ID, WEB_STATUS)
480: SELECT
481: ibe_ct_imedia_search_s1.nextval,
482: 0, FND_GLOBAL.user_id,
483: SYSDATE, FND_GLOBAL.user_id,
484: SYSDATE, FND_GLOBAL.conc_login_id,
485: d.category_id , old_organization_id ,
486: old_inventory_item_id, b.LANGUAGE,
487: b.DESCRIPTION, b.LONG_DESCRIPTION,
480: SELECT
481: ibe_ct_imedia_search_s1.nextval,
482: 0, FND_GLOBAL.user_id,
483: SYSDATE, FND_GLOBAL.user_id,
484: SYSDATE, FND_GLOBAL.conc_login_id,
485: d.category_id , old_organization_id ,
486: old_inventory_item_id, b.LANGUAGE,
487: b.DESCRIPTION, b.LONG_DESCRIPTION,
488: ibe_search_setup_pvt.WriteToLob(b.description , b.long_description ,a.concatenated_segments),
534: , LANGUAGE, DESCRIPTION, LONG_DESCRIPTION, INDEXED_SEARCH
535: , CATEGORY_SET_ID, WEB_STATUS)
536: SELECT
537: ibe_ct_imedia_search_s1.nextval,
538: 0, FND_GLOBAL.user_id,
539: SYSDATE, FND_GLOBAL.user_id,
540: SYSDATE, FND_GLOBAL.conc_login_id,
541: d.category_id , old_organization_id ,
542: old_inventory_item_id, b.LANGUAGE,
535: , CATEGORY_SET_ID, WEB_STATUS)
536: SELECT
537: ibe_ct_imedia_search_s1.nextval,
538: 0, FND_GLOBAL.user_id,
539: SYSDATE, FND_GLOBAL.user_id,
540: SYSDATE, FND_GLOBAL.conc_login_id,
541: d.category_id , old_organization_id ,
542: old_inventory_item_id, b.LANGUAGE,
543: b.DESCRIPTION, b.LONG_DESCRIPTION,
536: SELECT
537: ibe_ct_imedia_search_s1.nextval,
538: 0, FND_GLOBAL.user_id,
539: SYSDATE, FND_GLOBAL.user_id,
540: SYSDATE, FND_GLOBAL.conc_login_id,
541: d.category_id , old_organization_id ,
542: old_inventory_item_id, b.LANGUAGE,
543: b.DESCRIPTION, b.LONG_DESCRIPTION,
544: ibe_search_setup_pvt.WriteToLob(b.description , b.long_description ,a.concatenated_segments),
714: , LANGUAGE, DESCRIPTION, LONG_DESCRIPTION, INDEXED_SEARCH
715: , CATEGORY_SET_ID, WEB_STATUS)
716: SELECT
717: ibe_ct_imedia_search_s1.nextval,
718: 0, FND_GLOBAL.user_id,
719: SYSDATE, FND_GLOBAL.user_id,
720: SYSDATE, FND_GLOBAL.conc_login_id,
721: c.category_id , new_organization_id ,
722: new_inventory_item_id, new_LANGUAGE,
715: , CATEGORY_SET_ID, WEB_STATUS)
716: SELECT
717: ibe_ct_imedia_search_s1.nextval,
718: 0, FND_GLOBAL.user_id,
719: SYSDATE, FND_GLOBAL.user_id,
720: SYSDATE, FND_GLOBAL.conc_login_id,
721: c.category_id , new_organization_id ,
722: new_inventory_item_id, new_LANGUAGE,
723: new_DESCRIPTION, new_LONG_DESCRIPTION,
716: SELECT
717: ibe_ct_imedia_search_s1.nextval,
718: 0, FND_GLOBAL.user_id,
719: SYSDATE, FND_GLOBAL.user_id,
720: SYSDATE, FND_GLOBAL.conc_login_id,
721: c.category_id , new_organization_id ,
722: new_inventory_item_id, new_LANGUAGE,
723: new_DESCRIPTION, new_LONG_DESCRIPTION,
724: ibe_search_setup_pvt.WriteToLob(new_description , new_long_description ,a.concatenated_segments),
741: , LANGUAGE, DESCRIPTION, LONG_DESCRIPTION, INDEXED_SEARCH
742: , CATEGORY_SET_ID, WEB_STATUS)
743: SELECT
744: ibe_ct_imedia_search_s1.nextval,
745: 0, FND_GLOBAL.user_id,
746: SYSDATE, FND_GLOBAL.user_id,
747: SYSDATE, FND_GLOBAL.conc_login_id,
748: c.category_id , new_organization_id ,
749: new_inventory_item_id, new_LANGUAGE,
742: , CATEGORY_SET_ID, WEB_STATUS)
743: SELECT
744: ibe_ct_imedia_search_s1.nextval,
745: 0, FND_GLOBAL.user_id,
746: SYSDATE, FND_GLOBAL.user_id,
747: SYSDATE, FND_GLOBAL.conc_login_id,
748: c.category_id , new_organization_id ,
749: new_inventory_item_id, new_LANGUAGE,
750: new_DESCRIPTION, new_LONG_DESCRIPTION,
743: SELECT
744: ibe_ct_imedia_search_s1.nextval,
745: 0, FND_GLOBAL.user_id,
746: SYSDATE, FND_GLOBAL.user_id,
747: SYSDATE, FND_GLOBAL.conc_login_id,
748: c.category_id , new_organization_id ,
749: new_inventory_item_id, new_LANGUAGE,
750: new_DESCRIPTION, new_LONG_DESCRIPTION,
751: ibe_search_setup_pvt.WriteToLob(new_description , new_long_description ,a.concatenated_segments),
767: , LANGUAGE, DESCRIPTION, LONG_DESCRIPTION, INDEXED_SEARCH
768: , CATEGORY_SET_ID, WEB_STATUS)
769: SELECT
770: ibe_ct_imedia_search_s1.nextval,
771: 0, FND_GLOBAL.user_id,
772: SYSDATE, FND_GLOBAL.user_id,
773: SYSDATE, FND_GLOBAL.conc_login_id,
774: c.category_id , new_organization_id ,
775: new_inventory_item_id, new_LANGUAGE,
768: , CATEGORY_SET_ID, WEB_STATUS)
769: SELECT
770: ibe_ct_imedia_search_s1.nextval,
771: 0, FND_GLOBAL.user_id,
772: SYSDATE, FND_GLOBAL.user_id,
773: SYSDATE, FND_GLOBAL.conc_login_id,
774: c.category_id , new_organization_id ,
775: new_inventory_item_id, new_LANGUAGE,
776: new_DESCRIPTION, new_LONG_DESCRIPTION,
769: SELECT
770: ibe_ct_imedia_search_s1.nextval,
771: 0, FND_GLOBAL.user_id,
772: SYSDATE, FND_GLOBAL.user_id,
773: SYSDATE, FND_GLOBAL.conc_login_id,
774: c.category_id , new_organization_id ,
775: new_inventory_item_id, new_LANGUAGE,
776: new_DESCRIPTION, new_LONG_DESCRIPTION,
777: ibe_search_setup_pvt.WriteToLob(new_description , new_long_description ,a.concatenated_segments),