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),
108: new_category_set_id , a.web_status
109: from mtl_system_items_b a ,mtl_system_items_tl b ,mtl_system_items_kfv c
110: where b.INVENTORY_ITEM_ID = a.INVENTORY_ITEM_ID
111: and b.organization_id = a.organization_id
112: and b.INVENTORY_ITEM_ID = new_inventory_item_id
113: and b.ORGANIZATION_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),
136: new_category_set_id , a.web_status
137: from mtl_system_items_b a ,mtl_system_items_tl b ,mtl_system_items_kfv c
138: where b.INVENTORY_ITEM_ID = a.INVENTORY_ITEM_ID
139: and b.organization_id = a.organization_id
140: and b.INVENTORY_ITEM_ID = new_inventory_item_id
141: and b.ORGANIZATION_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),
162: new_category_set_id , a.web_status
163: from mtl_system_items_b a ,mtl_system_items_tl b ,mtl_system_items_kfv c
164: where b.INVENTORY_ITEM_ID = a.INVENTORY_ITEM_ID
165: and b.organization_id = a.organization_id
166: and b.INVENTORY_ITEM_ID = new_inventory_item_id
167: and b.ORGANIZATION_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),
352: new_category_set_id , a.web_status
353: from mtl_system_items_b a ,mtl_system_items_tl b ,mtl_system_items_kfv c
354: where b.INVENTORY_ITEM_ID = a.INVENTORY_ITEM_ID
355: and b.organization_id = a.organization_id
356: and b.INVENTORY_ITEM_ID = new_inventory_item_id
357: and b.ORGANIZATION_ID = new_organization_id
465: --Insert item into ibe_ct_imedia_search;
466: --dbms_output.put_line('Adding Row ;l_item_exists >0');
467:
468: -- ***inserting '' for the concatenated_segment in the clob
469: --as cannot access mtl_system_items_kfv.concatenated_segments value here.
470: --Later on ItemTL_Updated trigger will be called which will update the
471: -- CLOB value ****.
472: -- Above comment is not valid changed below query for bug 6924793 mgiridha
473:
521: --Insert item into ibe_ct_imedia_search;
522: ----dbms_output.put_line('inserting row...: l_item_exists='||l_item_exists);
523:
524: --**** inserting '' for the concatenated_segment in the clob
525: --as cannot access mtl_system_items_kfv.concatenated_segments value here.
526: --Later on ItemTL_Updated trigger will be called which will update the
527: -- CLOB value ****.
528: -- Above comment is not valid changed below query for bug 6924793 mgiridha
529:
607: g.LAST_UPDATE_DATE = sysdate ,
608: g.DESCRIPTION = new_description ,
609: g.LONG_DESCRIPTION = new_long_description ,
610: g.INDEXED_SEARCH = (select ibe_search_setup_pvt.WriteToLob(new_description , new_long_description,a.concatenated_segments)
611: from mtl_system_items_kfv a
612: where a.inventory_item_id = old_inventory_item_id
613: and a.organization_id = old_organization_id
614: )
615: where g.INVENTORY_ITEM_ID = old_inventory_item_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),
725: c.category_set_id , b.web_status
726: from mtl_system_items_kfv a, mtl_system_items_b b, mtl_item_categories c
727: where b.INVENTORY_ITEM_ID = a.INVENTORY_ITEM_ID
728: and b.organization_id = a.organization_id
729: and b.INVENTORY_ITEM_ID = new_inventory_item_id
730: and b.ORGANIZATION_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),
752: c.category_set_id , b.web_status
753: from mtl_system_items_kfv a, mtl_system_items_b b, mtl_item_categories c
754: where b.INVENTORY_ITEM_ID = a.INVENTORY_ITEM_ID
755: and b.organization_id = a.organization_id
756: and b.INVENTORY_ITEM_ID = new_inventory_item_id
757: and b.ORGANIZATION_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),
778: c.category_set_id , b.web_status
779: from mtl_system_items_kfv a, mtl_system_items_b b, mtl_item_categories c
780: where b.INVENTORY_ITEM_ID = a.INVENTORY_ITEM_ID
781: and b.organization_id = a.organization_id
782: and b.INVENTORY_ITEM_ID = new_inventory_item_id
783: and b.ORGANIZATION_ID = new_organization_id