DBA Data[Home] [Help]

APPS.IBE_SEARCH_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 109: from mtl_system_items_b a ,mtl_system_items_tl b ,mtl_system_items_kfv c

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

Line 137: from mtl_system_items_b a ,mtl_system_items_tl b ,mtl_system_items_kfv c

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

Line 163: from mtl_system_items_b a ,mtl_system_items_tl b ,mtl_system_items_kfv c

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

Line 353: from mtl_system_items_b a ,mtl_system_items_tl b ,mtl_system_items_kfv c

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

Line 469: --as cannot access mtl_system_items_kfv.concatenated_segments value here.

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:

Line 525: --as cannot access mtl_system_items_kfv.concatenated_segments value here.

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:

Line 611: from mtl_system_items_kfv a

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

Line 726: from mtl_system_items_kfv a, mtl_system_items_b b, mtl_item_categories c

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

Line 753: from mtl_system_items_kfv a, mtl_system_items_b b, mtl_item_categories c

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

Line 779: from mtl_system_items_kfv a, mtl_system_items_b b, mtl_item_categories c

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