DBA Data[Home] [Help]

APPS.IBE_SEARCH_SETUP_PVT dependencies on MTL_SYSTEM_ITEMS_TL

Line 287: FND_FILE.PUT_LINE(FND_FILE.LOG,' you have in mtl_system_items_tl table');

283: ----dbms_output.put_line(' Populating search table IBE_CT_IMEDIA_SEARCH');
284:
285: FND_FILE.PUT_LINE(FND_FILE.LOG,' Populating search table IBE_CT_IMEDIA_SEARCH');
286: FND_FILE.PUT_LINE(FND_FILE.LOG,' This may take a while depending on how many rows');
287: FND_FILE.PUT_LINE(FND_FILE.LOG,' you have in mtl_system_items_tl table');
288:
289: l_use_category_search := FND_PROFILE.VALUE_specific('IBE_USE_CATEGORY_SEARCH',671,0,671);
290:
291: /* Profile for fuzzy search is defaulted to 'No' so if found to be null

Line 358: FROM mtl_system_items_b_kfv a ,mtl_system_items_tl b , mtl_item_categories c

354: b.LONG_DESCRIPTION,
355: ibe_search_setup_pvt.WriteToLob(b.DESCRIPTION,b.LONG_DESCRIPTION,a.concatenated_segments),
356: a.web_status,
357: null
358: FROM mtl_system_items_b_kfv a ,mtl_system_items_tl b , mtl_item_categories c
359: WHERE b.INVENTORY_ITEM_ID = c.INVENTORY_ITEM_ID and
360: b.organization_id = c.organization_id and
361: c.INVENTORY_ITEM_ID = a.INVENTORY_ITEM_ID and
362: c.organization_id = a.organization_id and

Line 398: FROM mtl_system_items_b_kfv a,mtl_system_items_tl b,mtl_item_categories c

394: b.LONG_DESCRIPTION,
395: ibe_search_setup_pvt.WriteToLob(b.DESCRIPTION,b.LONG_DESCRIPTION,a.concatenated_segments),
396: a.web_status,
397: null
398: FROM mtl_system_items_b_kfv a,mtl_system_items_tl b,mtl_item_categories c
399: WHERE b.INVENTORY_ITEM_ID = c.INVENTORY_ITEM_ID and b.organization_id = c.organization_id
400: and c.INVENTORY_ITEM_ID = a.INVENTORY_ITEM_ID and c.organization_id = a.organization_id
401: and exists ( select 1
402: from oe_system_parameters_all osp

Line 437: FROM mtl_system_items_b_kfv a ,mtl_system_items_tl b , mtl_item_categories c

433: b.LONG_DESCRIPTION,
434: ibe_search_setup_pvt.WriteToLob(b.DESCRIPTION,b.LONG_DESCRIPTION,a.concatenated_segments),
435: a.web_status,
436: null
437: FROM mtl_system_items_b_kfv a ,mtl_system_items_tl b , mtl_item_categories c
438: WHERE b.INVENTORY_ITEM_ID = c.INVENTORY_ITEM_ID and b.organization_id = c.organization_id
439: and c.INVENTORY_ITEM_ID = a.INVENTORY_ITEM_ID and c.organization_id = a.organization_id
440: and exists ( select 1
441: from oe_system_parameters_all osp

Line 476: FROM mtl_system_items_b_kfv a ,mtl_system_items_tl b , mtl_item_categories c

472: b.LONG_DESCRIPTION,
473: ibe_search_setup_pvt.WriteToLob(b.DESCRIPTION,b.LONG_DESCRIPTION,a.concatenated_segments),
474: a.web_status,
475: null
476: FROM mtl_system_items_b_kfv a ,mtl_system_items_tl b , mtl_item_categories c
477: WHERE b.INVENTORY_ITEM_ID = c.INVENTORY_ITEM_ID and b.organization_id = c.organization_id
478: and c.INVENTORY_ITEM_ID = a.INVENTORY_ITEM_ID and c.organization_id = a.organization_id
479: and exists (select 1
480: from oe_system_parameters_all osp

Line 515: FROM mtl_system_items_b_kfv a ,mtl_system_items_tl b , mtl_item_categories c

511: b.LONG_DESCRIPTION,
512: ibe_search_setup_pvt.WriteToLob(b.DESCRIPTION,b.LONG_DESCRIPTION,a.concatenated_segments),
513: a.web_status,
514: null
515: FROM mtl_system_items_b_kfv a ,mtl_system_items_tl b , mtl_item_categories c
516: WHERE b.INVENTORY_ITEM_ID = c.INVENTORY_ITEM_ID and b.organization_id = c.organization_id
517: and c.INVENTORY_ITEM_ID = a.INVENTORY_ITEM_ID and c.organization_id = a.organization_id
518: and exists (select 1
519: from oe_system_parameters_all osp

Line 555: FROM mtl_system_items_b_kfv a ,mtl_system_items_tl b , mtl_item_categories c

551: b.LONG_DESCRIPTION,
552: ibe_search_setup_pvt.WriteToLob(b.DESCRIPTION,b.LONG_DESCRIPTION,a.concatenated_segments),
553: a.web_status,
554: null
555: FROM mtl_system_items_b_kfv a ,mtl_system_items_tl b , mtl_item_categories c
556: WHERE b.INVENTORY_ITEM_ID = c.INVENTORY_ITEM_ID and b.organization_id = c.organization_id
557: and c.INVENTORY_ITEM_ID = a.INVENTORY_ITEM_ID and c.organization_id = a.organization_id
558: and exists (select 1
559: from oe_system_parameters_all osp